Online Tutorials & Training Materials | STechies.com
Register Login

SAP FI-CO & Project Material

|| || 0 Download

SAP FI-CO & Project Material
Stechies

Project implementation flow:

Go live date: Date on which actual postings will be made in production server client

Roll outs: Activating the same customization in different locations.
The above process is called end to end Implementation .

Implementation of new project from beginning to end ASAP Methodology: (Accelerated SAP Methodology)

Phase

1 : Project preparation
2 : Business blue print
3 : Realization
4: Final preparation
5: Go live and support

Clients:

Development sever

1. Sand Box

2.Configuration/Golden

3. Development

client

Customization client

Testing client

1.To test out configuration

1.Recreate the

1. Testing of data unit

Ideas and theories at

customization option once

testing some projects

Any time / configure the

we satisfy in sand box

They do integration

options available in

2. Transport request will

testing

system

be activated

 

Eg: Bill discount

 

 

Transport request will

 

 

not be activated

 

 

QUALITY ASSURANCE SERVER

Q/A SERVER

QUALITY ASSURANCE SERVER

Q/A SERVER

1. Q/A testing client

1. Training client

A. Final testing user acceptance

2. give training to company employees

Testing (UAT)

 

B. Integration testing user acceptance

 

Testing to take the signature on the

 

Document tested by company core

 

Team members stating that the

 

Documents are posted as per their

 

Requirement and satisfied with

 

Result.

 

PRODUCTION SERVER

< >CLIENT

 

TESTING ACTUAL DATA

SAP R/3 Architecture

 

R stands for real time processing

 

3 tire Architecture

 

1. Presentation layer

F-02 document posting

2. Application layer

SAP programs

3. Data case layer

Stored in data base

SAP landscape: Arrangement of servers

Development – production

Development – Quality – Production

ASAP METHODOLOGY:

Phase 1: Project preparation:

Big bang implementation: Implementation of all modules at a time

Phased implementation: Implementation of some modules now once the system is set implement the balance modules afterwards.

Project steering committee :It consists of senior employees of consulting Company and SAP implementing company. They fix the roles and responsibilities of company core team members and consultants they meet at regular intervals, say every 15 day’s. In each meeting they check whether the project implementation is taking place as per schedule or not they give solutions for the issues arise in the project. Resolve the differences among consultants and core team members.

OSS: OSS stands for online client support service
When we purchase SAP package from SAP India, they give OSS user ID and password Through OSS, we can send to SAP Issues in the implementation when we send issues we have to give priority of the issue High/ Medium / Low. We can down load OAD patches (programs) through OSS Generally in live environment company project manager will be given authorization for OSS.

Solution Manager: Dedicated server
Phase 2: Business Blue print:
Testing cycle:

Purchase cycle

Sales Cycle

(procure to pay p to p cycle)

(order to cash O to C cycle)

Purchase order creation

sales order creation

Goods Receipt

Delivery

Invoice verification

Sales billing

Payment to party

Receipt from customer

Release strategy:

In purchase SAP has given a release procedure it will work through work flow it is optional

1. If purchase order value is less than

To be release by manager purchases

10000

 

2. If purchase order values is 10000

To be released by GM purchases

and above less than 100000

 

3. If purchase order values is 100000

To be released by Director

and above

 

Once the purchase order is saved based on the value, it goes to the inbox of the authorised person till he releases we can not take goods receipt

Phase 3: Realization:

Inter face: Pay roll (Existing package Fox pro) SAPFi employee’s salaries posting / wages/ PF transfer data from other packages to SAP package.

28-7-2011
Stress test: We have asked the ABAPer to create a report. In the report we require company code.
F-02 -- keep the cursor on company code field press Fi select technical information button
Table BKPF direct table Field name : BUKRS
Go to table BKPF and take field
BUKRS BKPF—BUKRS
When we generate a report time it take will be less,
FS10N – keep the cursor on company code field press F1 select technical information button Table SKC1C clustered table
Field name BUKRS
Go to table SKC1C and take field BUKRS
SKC1C - - BKPF - - BUKRS
When we generate a report time it takes will be more

Phase 4: Final preparation:

i)Cut off date:
A Company is working on tally to go live in SAP from 1st July 2011 decided to close the accounts in tally up to 30th June 2011 accounts will be closed in tally on 2-7- 2011.

ii)Cut over plan and cut over activities:
Planning data for actual transfer of balance and creation of masters in SAP production server data 5-7-2011

  • GL Masters up loading
  • Vendor Masters up loading
  • Customer Masters up loading
  • Asset Masters uploading
  • Material Masters uploading
  • Tax codes uploading
  • GL Balances uploading
  • Vendor open items uploading
  • Customer open items uploading
  • Asset acquisition cost and accumulated depreciation uploading
  • Material quantities uploading
  • To transport requests from development to production
  • Giving no. Range interval for document types

iii)Go live date: Entering the actual data in SAP from 6-7-2011 transactions will be entered from 1st of July.

Phase 5: Go Live and Support:
Project creation in SAP

We can plan which activities are to be completed in SAP with dates and once we complete the activity the actual date will be updated the advantage is we can see what activities have been completed and what activities are pending

Path: SPRO

From the menu bar Select Go to ---------- > Project Management
Select create project button (F5)
Project name : VSLFI
Enter
Title : VSL FI project
Plan data
Start : 1-7-2011
End : 30-9-2011
Actual data
Start : 1-7-2011
Save
Select scope tab
Select specify project scope by making manual Selection in reference IMG radio button
Select specify scope button
Select enterprise structure check box Select financial accounting check box Enter
Select general project IMG button
Ignore the warning message press enter € enter
Select specify project scope by choosing application components and countries radio button
Select include all countries in project scope radio button Select general project IMG button
Ignore the messages press enter Save
Select back arrow 2 times Select add to work list button Select project VSLFI check box Enter
Double click on project VSLFI
Select enterprise structure folder, Definition folder, Financial accounting folder Keep the cursor on define company
Under Plan data
Start : 27-7-2011
End : 27-7-2011
Save
Actual data:
Start : 28-7-2011
Select memo tab Fi consultant is on leave Save.
Select IMG activity button – Define Company
Ignore the message press enter
Select new entries button
Company : ZZZ
Company name : ZZZ Group, street : Ameerpet, P.O.Box: 500000 Save
Create request
Save request
Select back arrow
Status : 03 finished (end date automatically comes under actual data) Save.

To view the project analysis:
Path: SPRO ---------- > Project VSLFI
From the menu bar select Go to -------------- > Project Analysis
Project : VSLFI
Execute.

One company code can have how many charts of accounts? Max 3 chart of accounts.

  • Optional chart of accounts – chart of accounts assigned to company code in the beginning.
  • Group chart of accounts
  • Country chart of accounts or Legacy chart of accounts

Group chart of accounts:

In a group they have 3 company codes VSL/VCL/VIL each company code is following its own chart of accounts we want to compare or consolidated directly it is not possible by creating group chart of accounts it is possible

i)Creation of group chart of accounts: (OB13)

Select new entries button
Chart of accounts : VGP
Description : Group chart of accounts for Videocon
Maintain language : EN
Length of GL account no. : 6
Save
Press enter save in your request.

ii)Assign group chart of accounts in operational chart of accounts: (OB13)

Select chart of accounts : VSL
Select details button
Group chart of accounts : VGP
Save

iii)Define account group for group chart of accounts: (OBD4)

Select new entries button

Chart of A/cs.

A/c Group

Name

From Account

To Account

VGP

LIAB

Liabilities

200000

299999

VGP

ASST

Assets

100000

199999

VGP

INCO

Income

400000

499999

VGP

EXPD

Expenditure

300000

399999

Save, Enter

iv)Define retained earnings account for group chart of account: (OB53)

Chart of account : VGP

Enter

P&L statement X
Account : 200100
Save
Ignore the warning message press enter Press enter save in your request.

v)Creation of GL accounts at chart of accounts level: (FSP0)

Path: Accounting ------------ > Financial Accounting -------------- > General ledger -------------
- > Master records ---------------- > G/L Accounts ----------------- > Individual processing ------
------- > In chart of accounts (FSP0)
GL account : 200100
Chart of account : VGP
From the menu bar select GL account ----------- > Create
Account group : Liabilities
Select balance sheet account radio button
Short text : Surplus in Profit & Loss A/c
G/L account long text : Surplus in Profit & Loss A/c
Save
G/L account : 200000
Select with template button
GL account : 200100
Enter
Change short text : Equity share capital
G/L account long text : Equity share capital
Save
GL account : 100000
Select with template button
GL account : 200100
Enter
Account group : Assets
Change short text : SBI CA a/c
G/L account long text : SBI CA a/c
Save
Country chart of accounts or Legacy chart of accounts:

Option 1:

Country chart of accounts:

  • In client 000 for India SAP has given chart of accounts called CAIN
  • Assign country chart of accounts CAIN for company code VSL (OB62) – Assign for country chart of accounts column
  • When we create an account for operational chart of accounts VSL in FS00 – for alternative account no field under control data tab enter equivalent number of CAIN

Option 2:

Legacy chart of accounts:

A company is going live in SAP earlier they have used in house FoxPro accounting package their account numbers are different. Initially users will be comfortable with their legacy account number.
When we create an account for operational chart of accounts VSL in FS00 – for alternative account no. field under control data tab -- enter equivalent number of Legacy chart of accounts.

Assign group account number and Legacy account number in operational chart of accounts number (FS00)
GL A/c : 100000 (equity share capital)
Co. Code : VSL
From the menu bar select GL account ----------- > Change.
Group account number : 200000
Select control data tab
Alternative account no. : 500000
Save
Ignore the warning message press enter
GL account no : 200105 (SBI Current A/c)
Co. Code : VSL
From the menu bar select GL account ----------- > Change.
Group account number : 100000
Select control data tab
Alternative account no. : 600000
Save
Ignore the warning message press enter

To view account transactions: (FBL3N)

GL account no. : Blank
From the menu bar select Edit ------------- > Dynamic selections
Double click on group account number
Double click on Alternative account number
Group account no : 200000
Select execute button
Select back arrow
Group account no : Blank
Alternative account no. : 500000
Select execute button

Why accounts are to be created at chart of accounts level and company Code level:

Company code VSL VIL VCL
  IN US UK

All company codes use same chart of accounts VSL
Chart of accounts level data should be same
Company code level data can be same or different

Currency INR USD GBP
Field status groups G001 G001 G001

How to transfer net profit or loss to different accounts or why we are
using P/L statement a/c type X for retained earnings account.

sap-fico(1)

The balance in 300000 a/c will go to an account assigned for X200105
SBI ca a/c
P&L a/c
Balance sheet select
The balance in 200105 a/c will go to the same account as opening balance

Other countries:

A manufacturing company profit from manufacturing activity should go to one account profit from non operating activity should go to different account
Operating profit = operating income – operating expenses Product sales – Raw material consumption
Non operating profit = Non operating Income – Non operating Expenses Profit on sale of shares – Brokerage for sale of shares.
P&L statement a/c type account no.

X 100100 operating profit
Y 100101 Non operating profit
300000 sales account
P&L a/c select
P&L a/c type X
Balance sheet a/c – 300110 (profit on sale of shares)
P&L a/c select
P&L a/c type Y
Balance sheet a/c

One company code can have how many currencies?
Maximum 3 currencies

1)Company code currency: Currency given at the time of company code creation
2)Group currency: Company code VSL group is in Germany they want to see our result in EUR since group currency is in EUR
3)Hard currency or Index based currency:

i)Hard currency:

  • Country specific second currency
  • Used in countries with high inflation

ii)Index based currency:

  • Country specific fictitious currency
  • Required for external reporting income countries with high inflation

1)Assign group currency for client:

Path: Tools ---------- > Administration ------------ > Administration ----------- > Client administration ---------- > Client maintenance (SCC4)
From the menu bar select Table view ------------ > Display -> Change
Ignore the message press enter Select client 800
Select details button
Std currency : EUR
Save

2)Assign hard currency for country India:

Path: SPRO € SAP Net weaver ----------- > General settings ------------- > Set countries -----
-------- > Define countries In my SAP systems

Select country IN Select details button
Hard currency : USD
Save
Enter

3)Assign currencies to company code:

Path: SPRO -------------- > Financial accounting (New) -------------- > Financial Accounting
global settings (New) ------------ > Ledgers ------------- > Ledger ----------- > Define currencies of leading ledger.

Select new entries button Company code : VSL
Enter

2nd local currency

Currency type : 30 group currency (select)
Exchange rate type : B
Source currency : 2 (select)
Transaction date type : 2

3rd locl currency

Currency type : 40 Hard currency
Exchange rate type: B
Source currency : 2 (select)
Transaction date type : 2
Save
Ignore the warning message press enter
Save request

END USER AREA

1)Enter exchange rates in forex table (OB08)
Select new entries button
Ex rate type : B
Valid from : today’s date
From : INR
Dir. Quo : 0.02
To : USD
Ex rate type : B
Valid from : today’s date
From : INR
Dir. Quo : 0.0167
To : EUR
Save
Enter

2)Posting of transaction: F-02
Document date & posting date : today’s date
Type : SA
Company code : VSL
Posting key 40
Account : 200105
Enter
Amount : 100000
Business area : VSLH
Text : Equity share capital receipt
Pstky 50
Account : 100000 (equity share capital)
Enter
Amount : *
Business area : VSLH
Text : +
Document ------------- > Simulate
Select display currency button Select group currency radio button Enter
Select display currency button Select hard currency radio button Enter
Save

We have created a GL account without selecting line item display we have posted entries how to activate line item display for the old transactions
Or
What is program for activating line item display for already posted transactions?

1)Creation of GL masters without selecting line item display (FS00)

2)Posting of transaction to a/c no 100001 (F-02)

3)Display account balance a/c no 100001 (FS10N)

4)GL master change and select line item display for a/c no 100001 (FS00)

GL account : 100001
Company code : VSL
From the menu bar select GL account --------- > Change
Select control data tab
Select line item display check box
Save
Ignore the warning message press enter

5)Block GL account 100001 for posting before program (FS00)

GL account no : 100001
Company code : VSL
Form the menu bar select GL account ----------- > Block
Select all check boxes
Save

6)Run program: RFSEPA01 (SE38)

Run program : RFSEPA01
Select execute button Company
code : VSL
GL account : 100001
Select execute button

7)Display account balance a/c 100001 (FS10N)

8)Unblock GL account 100001 for postings FS00

GL account : 100001
Company code : VSL
From the menu bar select GL account --------- > Block
Deselect all check boxes
Save

How to activate open item management check box after posting to the account:

i)For old version up to 4.6C

  • Use transaction code SE38 Run program RFSEPA02

ii)From 4.7 EE onwards

  • Create a new account transfer the transactions from old account to new Account (F-02)
  • Reverse all the transactions in the old account change message Control – SAP standard error we make it warning

1)Creation of GL master 100506 salary payable without selecting open item management check box (FS00) G/L A/c -- 100506

2)Posting of transaction to a/c no 100506 -- (F-02)

Dr -- 400100 posting key 40
Cr -- 100506 posting key 50

3)Go to GL master 100506 select open item management check box FS00

GL account : 100506
Company code : VSL
From the menu bar select GL account ----------- > Change
Select control data tab
Select open item management check box
Save
Select long text exists button
Message no: FH087

4)Reverse the transactions (FB08)

5)Go to change message control make SAP standard error to warning

Path: SPRO ----------- > Controlling ------------ > General Controlling ------------ > Change message control
Application area : FH
Enter
Select new entries button
Message no. 190
User name : SAPUSER
Online : W (warning)
Batch input : W (warning)
Save € Enter

6)Go to GL Master 100506 select open item management check box (FS00)

GL account : 100506
From the menu bar select GL account ----------- > Change
Select control data tab
Select open item management check box
Save
Ignore the warning message press enter.

AS IS DOCUMENT

This will be prepared by company core team members here he will specify what is the existing process and what is required from SAP

TO BE PROCESS DOCUMENT

This is called business blue print
This will be prepared by consultants.
This will be prepared after going through the as is process and after understanding the requirements of company core team members.

CUSTOMIZATION DOCUMENT

This will be prepared by consultants
Here he will specify what customization he has done for each business process
This will be used as a reference for any process change after wards / upgradation / support

END USER DOCUMENT

This will be prepared by company core team members this is a reference for users at the time of postings.

SAP USER MANUAL

Company code VSL VCL VIL

All company codes are using the same chart of accounts VSL for each and every expenditure items we will not create separate accounts
Eg: 400100 salaries account
400110 staff welfare account
We have to post incentives given to employees
VSL will post to account no 400100 salaries
VCL will post to account no 400110 staff welfare account
Eg: 400105 Md remuneration A/c
400300 rent account
We are paying Rent for MD accommodation
VSL will post to 400105 MD remuneration
VCL will post to 400300 Rent account
Expenditure is not comparable account wise among company codes
Use T/code: FS00
GL account : 400100
Company code : VSL
From the menu bar select GL account ------------- > Change
Select information (C/A) tab
Select account assignment check box
Select editor button
Items to include:

i)City office salaries
ii)Factory staff salaries
iii)Branch staff salaries
iv)Incentives given to staff

Select back arrow
Save
GL account : 400300
Company code : VSL
From the menu bar select GL account ------------- > Change Select account assignment check box
Select editor button
Items to include:

i)City office rent
ii)Factory rent
iii)Branch office rent
iv)Godown rent
v)Rent free accommodation provide to employees

Select back arrow
Save
To view user manual:
Path: Accounting --------- > Financial Accounting ------------ > General ledger ------------ >
Information system -------------- > General ledger reports --------------- > Master data -------
------ > Account assignment manual ------------ > Account assignment manual (S_ALR_ 87012330)

Chart of accounts : VSL
Select execute button

TRANSPORT REQUEST: 2 Types of Transport Requests:

1)Work bench transport request :--
A)Cross client – available to all clients in the server
B)Client independent objects Eg: Check deposit variant (OT45)
2)Customizing Transport request:---
A)Client level available only to this client
B)Client dependent objects Eg: SPRO Configuration

How to view Transport Request T/C SE09:---

Path: Tools € ABAP Work bench € Overview € Transport
Organizer Enter
Select customizing folder
Select local change register folder
Select Modifiable folder
Select request number folder (our company)
One request will have 2 parts:--

1)Transport request number

2)Customizing task number – this is part of transport request number Select customizing task sub folder
Double click on assign company code to chart of accounts
Select back arrow

To change the description of the request number

Double click on request number
Select properties tab
From the menu bar € request/task € display € change Change the short description: FI Basic settings for VSL Save
Select back arrow

How to Make our request as default request

Keep the cursor on request number
From the menu bar € utilities € standard request € Set
We get a message our request number set as standard request Up to 11.08.2011

To change the dates keep the cursor on the request number

From the menu bar € utilities € standard request € validity period Change the date to 08.08.2011
Save

How to reset default request

Keep the cursor on request number
From the menu bar € utilities € standard request € reset

How transportation takes place

In development sever – FI consultant job:--
Keep the cursor on customizing task sub folder
Select release directly button
Keep the cursor on Request number
Select release directly button

In development server – FI consultant job:

Development client Quality client Transport client
Development client Transport client

In Production server—Basis consultant job (STMS)

Path: Tools € Administration € Transports € Transport management System Use T/C STMS _ IMPORT
Keep the cursor on the request number symbol Select Import request button

How to activate request screen :-- (SCC4)

Path:Tools € Administration € Administration € Client administration
-€ Client maintenance
From the menu bar € Table view € Display € Change Ignore the message enter
Select client – 800
Select details
Select automatic recording of changes radio button
Save

SAP TABLES:

1. How to view Table name and field name use T/C F-02

Keep the cursor on Company Code

Press F1

Select technical information button
Table Name BKPF
Field name BUKRS
Company code field (BUKRS) is stored in BKPF Table

2. FI TABLES

  • In BKPF Table:-- Header data will be stored
  • In BSEG Table:-- segment data ( item data )will be stored
  • In SKB1 : GL master (Company code) data will be stored
  • In LFA1 : Vendor master data will be stored
  • In KNA1 : Customer master data will be stored

3.To view what fields are stored in BKPF Table

Path: Tools € ABAP work bench €
Development € ABAP Dictionary T/C SE11
Select data base table radio button
Database Table name BKPF
Select display button

4.To view data posted in BKPF Table for our company code

Select contents button
Company Code VSL
Select Execute button
Select Back arrow 3 times
Change the data base table to BSEG
Select display button
Select back arrow
Data base Table TSTCT
Select display button
Select contents button
Language EN
Maximum Number of hits 100000
Select execute button

TYPES OF TABLES : 3 TYPES OF TABLES

1.Transparent Table:

  • Same structure in ABAP dictionary and data base table
  • Table that stored data directly

2.Cluster Table :

  • Logical tables to assign a table cluster when defined
  • This will be used to store control data

3.Pooled Table:

  • Logical table to assign a table pool when defined
  • This will be used to store control data

TERMS USED IN PROJECT

1..Business Process Re-engineering (BPR) :

  • SAP suggests before going for ERP – go for BPR
  • Big Companies will go for BPR – separate consultants for BPR
  • BPR consultants will study the existing organization

process and Give solutions for:

  • Streamlining the business process
  • To optimize business process
  • Strict controls can be enforced and monitored
  • Best practices to follow
  • Time and cost saving as a result of eliminated redundant tasks

Eg: Stores Department after material receipt – Invoice verified by stores Person – regarding delivery terms
They send bill to accounts – accounts person also will verify regarding Payment terms.

SOLUTION:

Keep Accounts person in stores verify invoice for delivery terms and Payment terms - report to accounts manager

Difference between Upgrade project and end to end project:

1.Upgrade project is a project where already SAP is in place
2.Only version change from lower version to higher versions

Eg: 4.7 EE version to ECC 6
End to end project is a project where SAP is implemented for first time.

TYPES OF TESTING

1.Integration Testing: This test makes sure that organization business process working together with other business processes.

2.Functional Testing: This test makes sure that configuration data working as per specifications

3.Unit Testing : This test makes sure that individual part of the program are working properly

Eg:ABAPER is creating a Report – The report data is not coming each and every line of the program he does the debugging
In short dump € BSEG € GSBER line 40

4.Regression Testing: This test makes sure that any new code added to the program does not have adverse impact on the already existing functionality.
Eg: For SAP programs SAP has given Hooks -- we can attach our
program to SAP program. It is called user exists (Functional enhancements)

VALIDATIONS

Checking at the time of entry
Requirement: Company code VSL is having 2 business area – Hyderabad, Bangalore. Separate document numbers for Hyderabad and Bangalore

Document Type

SA

SB

 

Number Range

01

02

 

Number Range Interval

1 - 100000

100001 - 200000

Hyderabad User should not use document type SB and post
Bangalore User should not use document type SA and post
We can give a validation rule stating that if Hyderabad business area
Person posts with SB give error/warning/information/cancel.
If Bangalore business area person posts with SA give error/warning/ Information/cancel
It can be activated at Header level/line item level/after completing The document.

1..Maintain Validation: T/C GBB0

Path: SPRO € Financial Accounting € Special purpose Ledger € Tools
€ Maintain validation/Substitution/Rules € Maintain validation
Select Financial accounting folder
Keep the cursor on line item folder
Select validation button
Validation name : VSLBA/ BA checking
Save
Keep the cursor on VSLBA folder
Select Step button
Validation step : 001/ Hyderabad business area checking
Keep the cursor on prerequisite folder
Double click on accounting document header
Double click on document type
Select = (equal to) button
Select constant button
Document type SA
Enter
Keep the cursor on check folder
Double click on accounting document segment
Double click on business area
Select = (equal to ) button
Select constant button
Business Area VSLH
Enter
Keep the cursor on message folder
Select maintain messages button
Select next free number button
Select individual maintenance button
Description: Document type SA to use Business Area VSLH (O33)
Save
Select back arrow
Message type : E (error)
Message Number 033 (select)
Under message variables
For 1.BKPF – BLART (document type)
For 2.BSEG – GSBER (Business Area)
Save
Keep the cursor on VSLBA folder
Select step button
Validation step : 002/ Bangalore business area checking
Keep the cursor on prerequisite folder
Double click on accounting document header
Double click on document type
Select = (equal to ) button
Select constant button
Document type SB
Enter
Keep the cursor on check folder
Double click on accounting document segment
Double click on business area
Select = (equal to ) button
Select constant button
Business Area VSLB
Enter
Keep the cursor on message folder
Select maintain messages button
Select next free number button
Select individual maintenance button
Description: Document type SB to use Business Area VSLB(O34)
Save
Select back arrow
Message type : E (error)
Message Number 034 (select)
Under message variables
For 1.BKPF – BLART (document type)
For 2.BSEG – GSBER (Business Area)
Save

2.Define validations for posting T/C OB28

Path: SPRO € Financial accounting € Financial accounting global Settings € document € Line item € Define validations for posting Select New entries button
Company Code VSL
Call up point : 2 (Line Item) (select) (000)
Validation : VSLBA (Business Area checking)
Activation level : 1 (active)
Save
Enter

END USER AREA:

1.Posting of transaction with SA for Bangalore business area T/C F-02

Document date: 8.8.2011
Type SA
Company Code VSL
Posting key 40
A/c 200105
Enter
Amount : 50000/-
Business area VSLB
Text : Equity Share capital receipt
Posting key 50
A/c 100000
Enter
It gives error message document type SA to use Business area VSLH

SUBSTITUTION

Replace the field with some text/value:-- Requirement
1.. An existing Company is going for SAP – we have to upload the balances In SAP.

Cash account Debit (Balance uploading)

200000.00

SBI Current A/c Debit ( --- Do ----)

300000.00

To SBI Rupee Loan ( --- Do ----)

250000.00

To Equity Share Capital ( --- Do----)

250000.00

We make text field optional - we create a substitution rule – for text field Business area and Business place

2. In TDS we have Business area and Business place. If we use Business area – VSLH – replace business place field with VSLF

1.Maintain substitution :-- T/C GGB1

Path: SPRO € Financial Accounting € Special purpose Ledger € Tools
€ Maintain validation/Substitution/Rules € Maintain substitution
Select Financial accounting folder
Keep the cursor on line item folder
Select substitution button
Substitution : VSL1
Description: Text field substitution
Save
Keep the cursor on VSL1 folder
Select Step button
Select BSEG – SGTXT check box
Enter
Select constant value radio button
Enter
Step(001) : Text substitution
Keep te cursor on prerequisite folder
Double click on accounting document header
Double click on company code
Select = (equal to ) button
Select constant button
Company code: VSL
Enter
Keep the cursor on substitutions folder
For text -- constant value / Balances take over
Save

2.Define Substitution in accounting documents: T/C OBBH

Path: SPRO € Financial accounting € Financial accounting global Settings € document € Line item € Define substitution in accounting Documents
Select New entries button
Company code : VSL
Call up point : 002 (Line Item) (select)
Substitutions : VSL1
Activation level : 1 (active)
Save
Enter

3.To make text field and value date field optional for field status group G001 and G005:-- T/C OBC4

4.Posting of transaction :-- T/C F-02

Document date: 9.8.2011
Type : SA
Company Code: VSL
Currency : INR
Select Fast data entry button

Posting key

Account

Amount

Business Area

40

200100

150000

VSLH

40

200120

50000

VSLH

50

100000

100000

VSLH

50

100300

100000

VSLH

Save
(We have to deactivate after completion of practice)

ISSUES IN IMPLEMENTATION (GAPS):

1.It s called GAPS

2.Before going live in production server all issues should be resolved Ways to resolve issues:--

1.ABAP Programs

2.Write to SAP the issue

3.Work Arounds (indirect method) (Reversal of reverse document)

4.User Exits ( Functional Enhancement)

For some programs SAP has given hooks – our Abaper can write a Program and attach to SAP program.

1.Work list creation for getting cash and bank balances

Path: Accounting € Financial accounting € General Ledger € Environment
€ Current settings €Maintain work list for display balances T/C OB55 or S_ALR_87005056
Double click on object SAKNR – GL Accounts
Select create button
Work list : VSL Banks
Name VSL cash and bank balances
Enter
Values 200100, 200101, 200105, 200130, 200131, 200132
Save

2.To view account balances FS10N

Select activate work list button
GL accounts work list VSL Banks
Company Code or values ; VSL
Fiscal year : 2011
Select execute button
Double click on cumulative balance

REVERSAL OF REVERSED DOCUMENTS: --

Option – 1:--Use T/C – FBR2 – post with reference
Option - 2:-- As per SAP standard error make it to warning and reverse Use T/C FB08 – Reversal
Give the document number which is to be reversed
Company Code : VSL
Fiscal Year : 2011
Reversal reason – 01
Save
It gives a error message document was already reversed Double click on error message – Message Number F5361 Path for changing Message Control
Path: SPRO € Controlling € general controlling € change message Control T/C OBA5
Application Area – F5 Enter
Select new entries button
Message number : 361
User name : SAPUSER
Online : W (warning )
Batch input : W (warning)
Save
Enter

Use T/C FB08

Document number – 19
Company code : VSL
Fiscal Year : 2011
Reversal reason : 01
Save
Ignore the warning message enter

Cash payments in excess of Rs.20000
10.08.2011 Freight payment

Freight A/c Debt

36000.00

To cash A/c

36000.00

We get a list of payments in excess of 20000 by way of cash

09.08.2011

Vendor Special GL(A) Dr

19000.00

To cash A/c

19000.00

10.08.2011 Reversal of Freight payment

Cash A/c Dr

36000.00

To Freight A/c

36000.00

10.08.2011 Posting of transaction

Freight A/c Dr

36000.00

To cash

17000.00

To vendor special GL (A)

19000.00 cleared

UseT/C FBL3N
GL account : 200100 cash account
Company code VSL
From Menu € Edit € Dynamic selections
Double click on debit /credit indicator
Double click on amount in local currency
For debit /credit indicator : select H (credit)
For amount in local currency: select multiple selection button/right arrow
Select maintain selection options button
Select > (greater than or equal to symbol)
Single value : 20000
Select copy button
From Menu € Goto € Variants € Save as
variant Variant name : VSL
Meaning Cash payments in excess of 20000/-
Save
Use T/C FBL3N
Select get variant button
Select variant VSL
Select execute button

Bills sent for collection tracking or noted Items

1.VSL has made sale to a customer on 13.07.2011
2.Terms of payment 30 days redit
3.They give the bill to their Bank for collection on 10.08.2011. Bank will collect from customer and credit to VSL current A/c.
4.We want to track which bill is given to which bank and due date of the of the bill OR.

Noted item – noted item means one line item

It will not update the Records
It is only for information/Reporting purpose

NOTED ITEMS:--

Letter of Credit (LC) opened with our bank for a vendor. OR Bank guarantee (BG) given to APSEB

Steps:

1. Creation of GL Master :-- Bills sent for collection – Current Assets
Loans and advances T/C FS00

GL a/c No. 200112
Company code VSL
Select with template button
GL a/c 200110 sundry debtors
Company code VSL
Enter
Change short text and long text to bills sent for collection Save

2.Link between sundry debtors and bills sent for collection T/C OBXY

Path: SPRO € Financial accounting € Accounts Receivables/payables
€ Business transactions € Postings with alternative reconciliation account
€ Other Special GL transactions € Define alternative Reconciliation account for customers
Select create button
A/c Type : D
Special GL indicator 7
Name : B/C
Description: Bills sent for collection
Enter
Select noted items check box
Save
Enter
Select accounts button
Chart of accounts VSL
Enter
Reconciliation account 200110
Special GL Account 200112
Save
Enter

3.Sales Invoice posting with 13.07.2011 date T/C F- 22

Payment terms NT 30 – 30 days credit

4.Path for Bills sent for collection Entry T/C F-49

Path: Accounting € Financial accounting € Accounts receivable €
Document Entry € Other € Noted items Doct.dt. 10.08.2011
Type DA
Company code VSL
Reference : 3456
Special GL Indicator 7
A/c 3000601 (customer a/c)
Business area VSLH
Amount 100000
Due 12.08.2011
Assignment SBI
Text bills sent for collection
Save
Ignore message press enter
Menu € Document €
display
We can see only one line item – There is no Debit/Credit

5.To view bills sent for collection Report T/C S_ALR_87012173

Path: Accounting € Financial accounting € Accounts receivable € Information system € Reports for Accounts receivable accounting € Customers: Items € List of customer open items for printing Company code VSL
Select Noted Items Check box
Execute

6.Reversal of noted item: FB08

Doct.No. 600004
Company code VSL
Fiscal year 2011
Reversal Reason 01
Save

SUPPORT ISSUES

Issues in support is called tickets

1.After implementation, Company has given for support also to the same consulting company.

2.Support services will be performed from consulting company’s place

3.There will be a support group consists of functional consultants and technical consultants

4.The company’s core team member will send issue to support group

In the issue he has to specify priority of the issue

a) High b) Medium c) Low

5.Billing also based on issues solved and based on priority of the issue

6.Once the issue is received by support group, they send an Initial Response (IR)

7.After issue is solved they will inform to Company core team member and after testing by company core team member it will be transported to production server client.

8.The consultant has to specify how many hours he has taken to solve the issue.

How to make reference field required for document type KR – Vendor Invoice T/C OBA7

Select KR – Vendor Invoice
Select details
Select Reference number
check box
Save
Enter

Posting of purchase Invoice T/C F-43

Here we must and should give reference number otherwise it won’t Accept to finish the transaction.

To open periods differently for Vendors and Customers

Eg: Sales Tax Returns for June - to file on or before 20th of July Profitability for June is not finalised up to 30th of July.
If we open June periods after 20th of July – someone posts for Vendors And Customers sales tax data will change. Every month we can’t file Revised return.
For Vendor and customer – open periods from July to August for GL A/c Open periods from June to August.

Use T/C OB52

Select position button

Enter
For variant VSL
From period 3
Year 2011
To period 12
Year 2011
Save
Enter

Select variant VSL
Select copy as button
Change the account type K
From account 100501 sundry creditors RM
To account 100501
From period 4
Enter
Save

Posting of purchase invoice T/C F-43

Doct. Dt:11.06.2011
Postg.dt. 11.06.2011
Type : KR
Company Code VSL
Posting key : 31
Account : 400201
Enter
Error period 003/2011 is not open for A/c type K for GL account
(If we give posting key 40 – It will accept)
Business area trial balance not matching
Debit SBI Current A/c 200000 VSLH
Credit Equity Share Capital 200000 VSLB
Save

Trial Balance Business area wise will not match. We have to run the Business Area clearing.: Automatic entry:

Business Area clearing debit

200000.00 VSLB

To Business area clearing

200000.00 VSLH

Manual entry: in Hyderabad books

Hyderabad account debit

200000.00

To Business area clearing account

200000.00

In Bangalore Books:

Business Area clearing debit

200000.00

To Bangalore Account

200000.00

1.Creation of GL Masters – Business Area clearing – Current Assets, Loans And Advances T/C FS00

GL A/c 200140
Company Code VSL
Select with template button
GL A/c 200120
Company Code VSL
Enter
Change short text and long text to Business area clearing
Select create/bank/interest Tab
Field status group G067
Save

2.Define Accounts for subsequent adjustment:-

Path : SPRO € Financial Accounting € GL Accounting € Business Transactions
-€ Closing € Reclassify € Define accounts for subsequent
adjustment Double click on clearing A/c
Chart of accounts VSL
Enter
A/C 200140
Save
Enter

3.Posting of Transaction T/C F-02

Doct.dt.12.08.2011
Type SA
Company Code VSL
Posting key 40
A/C 200105 (SBI current account)
Enter
Amount : 200000
Business Area : VSLH
Text : Equity share capital receipt
Posting key : 50
A/c : 100000 (Equity share capital)
Enter
Amount *
Business Area VSLB
Text +
Document € Simulate € Save

4.Calculate Balance Sheet adjustment account: T/C F.5D

Path: Accounting € Financial Accounting € General Ledger € Period processing €
Closing € Reclassify € Balance Sheet adjustment €
Calculate Company code VSL
Execute

5.Post Balance Sheet adjustment T/C F.5E

Path: Accounting € Financial Accounting € General Ledger € Period processing €
Closing € Reclassify € Balance Sheet adjustment € Post Balance Sheet adjustment
Company code VSL
Key date: 31.08.2011 (month ending date)
Select generate postings check box
Document type SA
Select log at line item level check box
Select log of distributed documents check box
Execute
Ignore the message press enter
Issue: We have vendor Mr.x – He is also a customer – In APP we have to clear vendor and customer receivables and issue check for the next amount.
Vendor payable 200000
Customer Receivable 50000
To adjust in APP and issue check only for 150000 T/C XD02 (Customer change)
Customer 3000601
Company Code VSL
Enter
Select Company code data button
Select payment transactions tab
Select clearing with vendor check box
Save
Ignore the message press enter
Change in reconciliation A/c for vendor/customer master:--
Vendor 4000201 ABC India ltd – Assigned 100501 Sundry Creditors RM
Instead of assigning 100503 Sundry creditor stores by mistake we have assigned
100501 Sundry creditors Raw material.

3Scenarios:--

1.Wrong account assignment in vendor master – No postings in vendor master A/c Use T/C – XK02 – change Vendor – change reconciliation A/c from 100501 to 100503 save.

2.Wrong A/c assignment in Vendor Master – payables are there in Vendor master A/c Use T/C – XK02 – Change vendor – change Reconciliation A/c from 100501 to
100503 save.

For old purchase payments – It takes 100501 – Sundry Creditors Raw material- 100501 Sundry creditors Raw material will be zero.
For new purchases it takes – 100503 – Sundry creditors stores

3.Wrong A/c assignment in vendor master – payables are there in vendor A/c The balance is carried forward to next year (we have not made payment for old Purchases – It will be shown under Sundry Creditors Raw material

a)Use T/C – XK02 – Change vendor – change reconciliation A/c from 100501 to 100503 save.

b)Create 2 accounts:
100503 – Sundry Creditors Stores (Reconciliation A/c)
100504 – Sundry Creditors Stores provisional (Non reconciliation A/c)

c)Link between Sundry Creditors Raw material and Sundry Creditors Stores
Provisional 100501 – Sundry Creditors Raw material 100504 Sundry Creditors Stores Provisional

d)In the year end reconciliation A/c Run: Balance in Sundry Creditors Raw Material account on 31.03.2012 will go to 100504 Sundry Creditors Stores Provisional.

e)In the Balance Sheet presentation on 31.03.2012
Sundry Creditors stores = Sundry Creditors stores + Sundry Creditors stores Provl.

f)Automatic reversal of (d) entry on 01.04.2012

g)When we make payment in the next year for the old purchase. It debits 100501 Sundry Creditors Raw Material – Sundry Creditors Raw Material will be zero.

g)STEPS:

1.Creation of 2 GL Masters T/C FS00

A)Sundry Creditors Stores
B)Sundry Creditors Stores Provisional
GL A/c 100503
Company Code VSL
Select with template button
GL A/c 100501
Company Code VSL
Enter
Change short text and long text to Sundry Creditors Stores
Save
GL A/c 100504
Company Code VSL
Select with template button
GL A/c 100501
Company Code VSL
Enter
Change short text and long text to Sundry Creditors Stores Provisional
Select Control data Tab
Reconciliation A/c for A/c type blank
Save

2.Define screen layout per activity (Vendors):

Path: SPRO € Financial Accounting € Accounts Receivable and Accounts payable
€ Vendor Accounts € Master data € Preparations for creating Vendor Master data
€ Define screen layout per activity (Vendors)
Double click on change vendor (accounting)
Double click on Company code data
Double click on Account Management
Reconciliation A/c – Optional entry radio button
Save
Enter
Select back arrow
Double click on change vendor (centrally)
Double click on Company code data
Double click on Account Management
Reconciliation A/c – Optional entry radio button
Save

3.Change Reconciliation Account in Vendor Master XK02

Vendor 4000201
Company Code VSL
Select accounting information check box under Company code data
Enter
Reconciliation A/c 100503 (Sundry Creditors Stores)
Save & Enter to ignore the message

4.Define adjustment accounts for changed reconciliation A/c T/C OBBW

Path: SPRO € Financial Accounting € General Ledger Accounting
€ Business Transactions € Closing € Reclassify € Transfer and sort receivables and payables € Define adjustment accounts for changed reconciliation accounts Chart of Accounts VSL
Enter
Reconciliation A/c 100501
Adjustment A/c 100504
Save & Enter

5.Sorting/Reclassification T/C FAGLF101

Path : Accounting € Financial Accounting € Accounts payable € Period processing
-€ Closing € Reclassify € Sorting/Reclassification (New)

UPGRADATION STEPS

It means version change – upgrading from old version to new version – SAP support Will not be available for old versions after some period – Companies will have to Go for up gradation within the specific period.

2 STAGES:

1st Stage: Technical Upgrade:--

This is mandatory. Basis person plays an important role – he transfers data and ABAP reports from old version to New version.
Functional consultant role:--

  • SAP releases delta in that it shows what changes have been made from old Version to new version – Go through the delta.
  • Tally A/c Balances with old version balances.
  • Tax Codes are working properly in new version.
  • Number of ABAP Reports will not work in new version due to tables change by SAP Run the Report and ask the Abaper to change table in new version ABAP Programs .
  • Activate depreciation keys from migration status to active status.
  • In ECC6 – for depreciation posting document type AF – for number range Interval deselect external check box.

Functional Upgrade:

This is optional Customizing new features given in the new version

  • New General Ledger
  • Online Reconciliation Ledger
  • Document splitting
  • Segments creation
  • Foreign currency balances revaluation valuation area wise.

DATA TAKEOVER

  • Master Uploading -- 1st stage
  • Balances uploading – 2nd stage I)

Master Uploading:--

  • G/L Masters T/C FS00
  • Vendor Masters T/C XK01
  • Customer Master T/C XD01
  • Asset Master T/C AS01
  • Material Master T/C MM01

Create an Excel File and note down the values to be loaded -- Convert the file to Text File € Upload to SAP

  • Legacy System Migration Work Bench (LSMW)
  • Batch Data Communication (BDC)
  • Extended Computer Aided Testing TooL (ECATT)
  • LSMW:--- for uploading masters -- Functional Consultant Job
  • BDC:--- Require Programming Knowledge – ABAPER Job
  • Testing of Data

LSMW STEPS:

1. Open new Excel File and note down the values to be uploaded.
Also Open SAP FS00

GL.A/c.No

Co.Code

A/c.group

P/L A/c

 

B/S  A/c

Sh.Text

Long Text

100310

VSL

SCLN

 

IDBI Loan

IDBI Loan

200106

VSL

CAST

 

SBH A/c.

SBH A/c.

300001

VSL

SALE

 

 

Sales Trd.

Sales Trd

400101

VSL

PRSN

 

 

Wage A/c

Wage A/c

A/c.Currency

Bal.in Local Currency

Line item Display

Sort Key

 

Field status Group

Relevant to Cash flow

INR

001

 

G005

 

INR

001

 

G005

INR

001

G001

 

INR

001

G001

 

1)Remove Column Headings

2)No Gap should be there in between rows

3)We have to delete the other sheets except we are using

4)Select the sheet
press right click on mouse Select format cells
Select text
Select O.k button

5)From Menu € File € Save As File name VSLTEXT
Save as type text (Tab delimited) Select save button
Select no button Select cancel button
From Menu € File € Close €
Select no button

2) Open a new excel file and note down the technical name of each field. It should be in the same order of point No.1. Also open SAP FS00

Sl.No.

Component

Data Type

Length

1

SAKNR

C

10

2

BUKRS

C

4

3

KTOKS

C

4

4

XPLACCT

C

1

5

XBILK

C

1

6

TXT20-ML

C

20

7

TXT50-ML

C

50

8

WAERS

C

5

9

XSALH

C

1

10

XKRES

C

1

11

ZUAWA

C

3

12

FSTAG

C

4

13

XGKON

C

1

1)Keep the cursor on G/L A/c No. in FS00

  • Press F1 – Select Technical information button
  • Double click on Field name SAKNR
  • Copy component SAKNR i.e. G/L A/c No.in Excel component column

2)Copy component BUKRS i.e. Company code in Excel component Column.

3)Select Back arrow in SAP FS00

  • Keep Cursor on A/c Group
  • press F1
  • Select Technical information button
  • Double click on Field name KTOKS
  • Copy component KTOKS i.e.G/L A/c Group in excel component column

4)Copy component XPLACCT i.e. P/L statement a/c in excel component Column.

5)Copy component XBILK i.e. whether it is a balance sheet A/c in excel Component column

6)Copy Component TXT20 - ML i.e. short text in excel component column

7)Copy component TXT50 - ML i.e. long text in excel component column

8)Select back arrow in SAP FS00.

  • Keep the cursor on A/c currency
  • Press F1.
  • Select Technical information button.
  • Double click on Field name WAERS.
  • Copy component WAERS i.e. A/c currency in excel component column

9)Copy Component XSALH i.e. only balances in local currency in excel Component column.

10)Copy component XKRES i.e Line item display in excel component column

11)Copy ZUAWA i.e. Sort Key in excel component column

12)Copy FSTAG i.e. field status group in excel component column

13)Copy XGKON i.e. Relevant to cash flow in excel component column Save as an excel file

3) Use T/C LSMW in SAP.

Ignore message press enter
Project : VSL
Sub project : FI (FI Area)
Object : GL (GL Masters uploading)
Select create entry button
Project : VSL
Description: : VSL Project
Enter
Project : VSL
Sub project : FI
Description : FI Area
Enter
Project : VSL
Sub project : FI (FI Area)
Description : FI Area
Object : GL
Name : GL masters uploading
Enter
Select continue button
Always It should be in double click is equals to change mode
(Double click = change) click on that
Select execute button
Select Batch input recording radio button
From the menu € Goto € Recordings over view
Select Create recording button
Recording : VSLGL
Description : GL Recording
Owner : SAPUSER
Enter
T/C FS00
Enter
GL A/c 200107
Co.Code VSL
From Menu € GL A/c € Create
A/c Group – Current Assets loans and advances
Select Balance sheet A/c radio button
Short text and long text ICICI current Account
Select Control data tab
Select Only balances in local currency check box
Select Line Item display check box
Sort Key : 001
Select Create/Bank/Interest Tab
Field status group : G005
Select Relevant to cash flow check box
Save
Keep the cursor on FS00
Select default all button
Save
Select back arrow 2 times
Recording VSLGL
Save
Select back arrow
Select execute button
Select create a structure button
Source structure VSLSTR
Description: VSLGL Structure
Enter
Save
Select back arrow
Select execute button
Keep the cursor on VSLSTR
Select Table Maintenance button
Copy excel component column to SAP field name column
Copy excel data type column to SAP type column
Copy excel length column to SAP length column
Save
Select back arrow
Save
Select back arrow
Execute
Save
Select back arrow
Execute
Keep the cursor on VSLGL
From Menu € Extras € Auto Field mapping
Enter
Go on select accept proposal button
Till we get the message Auto Field mapping complete
Enter
Save
Select back arrow
Skip maintain field values, Translations, user – defined routines
Select specify files radio button
Execute
Keep the cursor on the PC (Front end)
Select Add entry button
File : VSLTEXT (select)
Name : GL Masters uploading
Select Tabulator radio button
Enter
Save
Select back arrow
Select execute button
Save
Select back arrow
Select execute button once again execute button
Select back arrow 2 times
Skip display read data
Select convert data radio button
Select execute button once again execute button
Select back arrow 2 times
Skip display converted data
Select create batch in put session radio button
Select execute button once again execute button
We get a message 1 batch in put folder with 4 transactions created
Enter
Select execute button
Select session Name GL
Select process button
Select display errors only radio button
Select process button
We get a message processing of batch in put session completed
Select Exit batch input button

4) To view the Accounts created FS00

Select Drop down button beside GL A/c No.

Enter
Sundry Creditors -- Reconciliation A/c – Vendors K

Sundry Debtors -- Reconciliation A/c – Customers D

Assets – plant & machinery -- Reconciliation A/c A

Balances uploading:--

If the company is going live from 1.4.2011

A Take only Balance sheet account balances as on 31.03.2011
B In case of vendors and customers – Take all open items as on 31.3.2011

If the company is going live in the middle of the year say from 1.8.2011

A Take profit and loss account balances and Balance sheet account
Balances as on 31.07.2011
B In case of vendors and customers – Take all open Items as on 31.07.2011

Why SAP suggests to take balances instead of transactions:--

1)In normal accounting Vendors, Customers and Assets are part of general ledger where as in SAP we have sub ledger concept

2)In normal accounting for Vendors and Customers, payables/ Receivables and advances will be shown in one A/c – In SAP Vendors/ Customers. Payables/receivables will be shown under normal items and Advances will be shown under special GL Items.

3)In normal accounting Assets will be shown A/c head wise like plant & Machinery wise . In SAP Assets will be shown each sub asset wise Purchase cost/ accumulated depreciation and net book value.

4)In normal accounting depreciation is a provisional figure where as in SAP It is actually calculated figure for each Sub asset wise.

5)In normal accounting Raw material consumption is a balancing figure. Opening stock + purchases - closing stock = consumption
Balance figure is Raw material consumption.
In Sap at the tome of consumption for each material accounting, Entries Will be generated automatically.

6)In normal accounting closing stock is a lump sum figure. Debt closing stock --- Balance Sheet
Credit closing stock --- profit and loss account
In SAP for closing stock each material wise quantity/rate and amount. Will be captured.

7)In normal accounting no production and delivery entries will be passed. Difference between production and delivery is closing stocks.
In SAP at the time of production and delivery accounting entries will be passed automatically at production cost.

PROCEDURE FOR BALANCES UPLOADING

1.Prepare a statement showing each vendor wise bill wise payables and advances -- The total should match with trial balance figure.

2.Prepare a statement showing each customer wise/bill wise/ receivables and advances -- The total should match with trial balance figure.

3.Prepare a statement showing each sub-asset wise acquisition value, accumulated depreciation and net book value. The total should match With trial balance figure.

4.Prepare a statement showing each material wise quantity rate and amount The total should match trial balance figure.

5.Create 5 dummy accounts. It will be Non-reconciliation A/c. It can be under Any group. Generally we create under current liabilities & provisions group.

  • GL clearing account
  • Vendor clearing account
  • Customer clearing account
  • Asset clearing account
  • Stock taking account

6.Our data take over is correct after up loading the balances our 5 dummy Accounts become zero.

7.We should not allow users to enter day to day data in production server client till the balances are uploaded and tallied.

TRIAL BALANCE

Particulars

Debit

Credit

Equity share capital

 

500000.00

Party X account

 

100000.00

Accumulated depreciation
Plant and machinery No.5

 

200000.00

Fixed Assets pl/machinery

300000.00

 

Sales

 

400000.00

Party A account

150000.00

 

SBI Current account

275000.00

 

Inventory Raw material

100000.00

 

RM.consumption

375000.00

 

 

1200000.00

1200000.00

5. – Dummy Accounts

  • GL clearing account : 0
  • Vendor clearing account : 5000 0
  • Customer clearing account : 0
  • Asset clearing account : 0
  • Stock taking account : 0

STEPS:

1) GL Credit balances take over F-02 Fast data entry screen

GL clearing account

Debit

1200000.00

To Equity share capital

Credit

500000.00

To Vendor clearing

Credit

100000.00

To Asset clearing

Credit

200000.00

To Sales

Credit

400000.00

GL Debit balances take over - F-02 Fast data entry screen

Asset clearing account

Debit

300000.00

Customer clearing

Debit

150000.00

SBI Current account

Debit

275000.00

Stock taking

Debit

100000.00

RM consumption

Debit

375000.00

To GL Clearing account

Credit

1200000.00

3(I) Prepare a statement showing each vendor wise bill wise payables/ and advances and the total should match with Trial Balance figure.

Party X account

Debit

credit

Purchase Bill No. 1

 

70000.00

Purchase Bill No. 2

 

20000.00

Purchase Bill No. 3

 

50000.00

Advances

40000.00

 

Balance

100000.00

 

 

140000.00

140000.00

Balance Credit 10000.00
3(II) To take vendor transactions F-43

Vendor clearing account

Debit

95000.00

Party X special GL (A)

Debit

40000.00

To party X a/c bill 1

Credit (Sundry Debtors)

70000.00

To Party X a/c bill 2

Credit (Sundry Debtors)

20000.00

To Party X a/c bill 3

Credit (Sundry Debtors)

45000.00

3(III) To pass rectification entry F – 43

Vendor clearing account

Debit

5000.00

To Party X A/c bill 3

Credit

5000.00

4(A) Prepare a statement showing each customer wise bill wise receivables and advances the total should match with trial balance figure

Customer A account

 

 

Sale Bill No. 1

Debit

120000.00

Sale Bill No. 2

Debit

50000.00

Advance

Credit

20000.00

Balance

Debt

150000.00

4(B) Customer transaction take over F-22

Party A A/c - Bill No. 1

Debit

120000.00

Party A A/c - Bill No. 2

Debit

50000.00

To Party A spl GL a/c

Credit

20000.00

To Customer clearing a/c

Credit

150000.00

5(A) To make Fixed Assets Plant & Machinery GL account and accumulated depreciation GL account as non reconciliation a/c and post  T/C F-02

Posting key 40

Plant & Machinery

Debit

300000.00

Posting key 50

Accumulated dep.

Credit

200000.00

Posting key 50

Asset clearing

Credit

100000.00

Non Reconciliation account means --- in FS00 Reconciliation account for Account type Assets remove.
Path: SPRO € Financial accounting € Asset Accounting preparing for production start up € Production start up € Set or reset reconciliation Accounts T/C OAMK
Select Company Code VSL
Double click on change control of reconciliation accounts folder From Menu € Edit € Selections € Select All
Select delete reconciliation indicator for all accounts button
Save
Enter

5(B) Creation of Asset Master AS01 or LSMW € in live use T/C AS01

Asset class VSL 2000 (Dept A)
Company Code VSL
Enter
Description: Machine No.5
Capitalized on : 15.06..2005
Select Time dependent Tab
Business Area : VSLH
Select depreciation areas tab
Depreciation key : VSL1
Useful life :15
Period : 04
Ordinary depreciation start date 1.4.2011
Save

5(C) To take over each sub--asset wise acquisition value and accumulated depreciation. It will not update our GL accounts. Since we have removed reconciliation a/c for a/c type - Assets.

Path: SPRO € Financial Accounting € Asset Accounting € Asset data transfer
€ Manual online transfer € Create/change/display legacy asset T/C AS92 Double click on change legacy Asset
Asset No.200003
Sub NO. 0
Company Code VSL
Select Takeover values button
Ignore the message press enter
Cumulative acquisition value 300000
Accumulated ordinary depreciation 200000
Save

5(D) To make fixed assets plant and machinery and accumulated depreciation plant and machinery as reconciliation a/c T/C OAMK

Select Company Code VSL
Double click on change control of reconciliation account folder From Menu € Edit € Selections € Select all
Select set reconciliation indicator for all account button
Save
Enter

6(A) Prepare a statement showing each material wise Quantity/Amount/Rate The total should match with trial balance figure.

Material No.

Quantity

Rate

 

Amount

Raw Material 1

2000

25

 

50000

Raw Material 2

1000

30

30000

Raw Material 3

2000

10

20000

 

 

 

100000

6(B) Creation of Material Master (MM01) in accounting view enter Moving Average Price.
Raw Material No.1 - 25/-, Raw Material No.2- 30/-, Raw Material No. 3 – 10/-

6(C)  Use T/C  MB1C

Movement Type : 561 Plant – HYD Factory Plant
Storage – Location HYD RM storage location Material Nos. and quantity
RM1 – qty 2000, RM2 – qty.1000, RM3 – qty.2000
Save
Accounting Entry will be generated automatically

Inventory RM local Debt BSX

100000.00

To Stock Taking Credit GBB BSA

100000.00

REPORTS

  1. Standard Reports
  2. ABAP Reports
  3. Report Painter
  4. SAP Query

1. Report Painter: We have 3 Company Codes VSL, VCL, VIL

All Company Codes are using same chart of accounts –VSL. We want to Compare or consolidate.

SAP Standard Report: 400100 Salaries A/c 

VSL 500000
VCL 300000
VIL 200000
Total 1000000 Company requirement
400100 salaries A/c: VSL-500000, VCL-300000, VIL-200000  Total 1000000/-
Eg: 2:Company wants Account balance debit separately and credit separately

STEPS:

  1. Define Variables
  2. Define Set
  3. Define Library
  4. Creation of Report
  5. Creation of Report group
  6. Create Transaction code for the Report
  7. Assign Report in SAP Menu

1.Define Variables: T/C GS11

Path: Accounting € Financial accounting € Special purpose ledger €
Tools € Set Maintenance € Variables €
Create Variable V1
Table : Select Reporting Tables radio button
Enter
Table Select GLT0
Field name select BUKRS Company code
Select Value radio button
Enter
Default values VSL
Save
Variable V2
Table GLT0
Field name RPMAX period select Select
Value radio button
Enter
Default value 01
Save
Variable V3
Table GLT0
Field name select RPMAX
Select Value radio button
Enter
Default value 16
Save
Variable V4
Table GLT0
Field name select RYEAR – fiscal year
Select formula radio button
Enter
Keep the cursor on formula row
Select formula exit button
Select S001 year
Save

2.Define Set: T/C GS01

Path: Accounting € Financial accounting € Special purpose ledger €
Tools € Set Maintenance € Sets €
Create Set Name : VSL
Table : GLT0
Select basic set radio button
Select Header button
Field Name : RACCT Account number select
Enter
Basic Set : VSL
Description : VSL/VSL set
Select Values button

From Value

Short Text of set line

100000

Equity Share Capital

200105

SBI Current account

300000

Sales account

400100

Salaries account

Save

3.Define Library:

Path: Path: Accounting € Financial accounting € Special purpose ledger €
Tools € Report Painter € Report writer € Library € Create
GR21 Library : V1
Table : GLT0
Select header button
Description : Library for VSL
Select Characteristics button
Select RACCT account number check box
Select DRCRK debit/credit indicator check box
Select Basic key figures button
Select Key figures button
Save

4.Creation of Report: T/C GRR1

Path: Path: Accounting € Financial accounting € Special purpose ledger €
Tools € Report Painter € Report €
Create Library : V1
Report : VSL/VSL Report
Select create button
Section 0001/ VSL Report
Double click on Lead column
Short text : Accounts
Select copy short text button
Enter
Double click on Row 1
From available characteristics
Select account number
Select left arrow button
For account number select set or Hierarchy node on off check box
From select VSL
Text : VSL set
Select confirm button
Keep the cursor on VSLSET
From Menu € Edit € Rows € Explode
For account number select expand radio button
Enter
Double click on column 1
Select key figures with characteristics radio button
Enter
Basic key figure local currency
From the available characteristics
Select Ledger
Select record type
Select debit/credit
Select left arrow
Name : Ledger From : 0
Record type : 0 (actual data)
Debit/credit : S debit
0 – GL A/c transaction figures
Select change short, middle and long text button
Short : debit
Select copy short text button
Enter
Select confirm button
Double click on column 2
Select key figures with characteristics radio button
Enter
Basic key figure – local currency
Name Ledger from : 0
Name Record type : 0
Name Debit/credit H (credit)
Select change short, middle and long text button
Short Credit
Select copy short text button
Enter
Select confirm button
From Menu bar € Edit € general data selection
From available characteristics
Select Company code
Select fiscal year
Select period
Select left arrow

Name

Variable

 

From

 

Variable on/off

TO

Company code

 

V1

 

X

 

Fiscal year

 

V4

 

X

 

Period

 

V2

 

V3

Select confirm button

5.Creation of Report group T/C GR51

Path: Path: Accounting € Financial accounting € Special purpose ledger €
Tools € Report Painter € Report writer € Report group € Create Report group
VSL1 (4 characters)
Library V1
Enter
Description Report group for VSL
Select Reports button
Select Report VSL
Save
Select generate button
Select execute
Report group VSL1
Execute
Once again Execute
Keep the cursor on Accounts column
From Menu bar € settings € column attributes
Width 35
Enter

6.Create transaction code for the Report T/C SE93

Path :Tools € Abap workbench € Development € Other Tools €
Transactions
Transaction code ZVSL Report
Select create button
Short text : VSL Report
Select Transaction with parameters (parameter transaction) radio button
Enter
Transaction – start-- Report
Select skip initial screen check box
Select inherit GUI attributes check box
Name of screen field Value
Select D-SREPOVARI- Report type RW
Select D-SREPOVARI-Report VSL1
Save
Select local object button
Select text button

7.Assign Report in SAP Menu T/C SE43

Path: up to other Tools same path €
Area Menus Area Menu : S000
Select change area menu button
Select change button
Select German button
Ignore the message press enter
Select RECHNUNGSWESEN folder (Accounting)
Select FINANZWESEN folder (Financial Accounting)
Select HAUPTBUCH folder (GL)
Select Info system folder
Keep the cursor on Info system
Select add entry as sub note button
Text VSL Report
T/C/Menu ZVSL Report
Enter
Save

SAP QUERY

This is one more way to create a Report
Requirement:
We want to see Account balance – Debit and credit separately also Period wise.
Steps:

1.Create Info set T/C SQ02

Path: Tools € Abap workbench € Utilities € SAP Query €
Info sets Info set : VSL
Select create button
Name : VSL Info set
Select Logical database radio button
Select Table SDF GL A/c database
Enter
Select BSISEXT check box
Enter
From Menu € Edit € Field Group € Create field group FG : Description
VS : VSL field group Enter
Keep the cursor on VS – VSL field group
Select secondary index & additions section up table BSISEXT
Keep the cursor on Company Code
Select Insert fields in field group button
Keep the cursor on GL Account
Select Insert field in fields group button
Keep the cursor on fiscal year
Select insert field in fields groups button
Keep the cursor on accounting document number
Select insert field n fields group button
Keep the cursor on posting date in document
Select insert field in fields group button
Keep the cursor on fiscal period
Select Insert field in fields group button
Keep the cursor on item text
Select insert field in fields groups button
Keep the cursor on debit amount in local currency
Select insert field n fields group button
Keep the cursor on credit amount in local currency
Select insert field in fields group button
Save € Save
Select local object button
Select generate button
Ignore message press enter

2.Assign Info set to user group T/C SQ03

Path: Tools € Abap workbench € Utilities € SAP Query € User
Groups User group VSL FI Users
Select create button
Description: VSL FI Users
Save
Select local object button
Select assign users and info sets button
User name : SAPUSER
Select assign info sets button
Select VSL info set check box
Save
Select back arrow
Save again

3.Creation of SAP Query T/C SQ01

Path: Tools € Abap workbench € Utilities € SAP Query €
Queries Query V1
Select create button
Select info set VSL
Title GL Balances Report
Select next screen button
Select VSL field group check box
Select next screen button
Select all fields check box
Select next screen button
Select basic list button
For Company code select selection fields check box
Select GL A/c – section fields check box
Select Fiscal year selection fields check box
Select accounting document number list fields check box
Select posting date in the document list fields check box
Select Fiscal period selection fields check box
Select Item text list fields check box
Select debit amount in local currency list fields check box
Select credit amount in local currency list fields check box
Save
Select Text button
Enter
Company code VSL
Fiscal year 2011
GL A/c 100000 (Equity share capital)
Fiscal period 1 to 6
Execute

SCHEDULE MANAGER

We can schedule any activity to run on a particular date and time Ex: On 5th of every moth Balance Sheet to run automatically.

1.Go to Balance sheet Report : Create variant and note down the program
Name F.01
Company Code : VSL
Business Area : VSLH
Financial statement version VSL
Reporting year 2011
Reporting periods 1 to 4
Comparison year 2011
Comparison periods 1 to 3 Select classical list radio button
Select special evaluations tab
Balance sheet type 1 (standard financial statement)
Select output control tab
Company Code summarization 1
Business area summarization 1
Summary report 3
Comparison type 1
Scaling 5/2
From Menu bar € Go to € Variants € Save as variant Variant name VSL
Meaning VSL Balance sheet
Save
From Menu € System € Status Variant name : VSL
Program : RFBILA00

2.Path for Schedule Manager T/C SCMA

Accounting € Financial accounting € General Ledger € Periodic Processing € Schedule Manager
From Menu € Task list € Create Task List VSL
Enter
Task List : VSL/VSL Schedule Manager
Save
Enter
Select back arrow
Keep the cursor on VSL schedule manager
Press mouse right click
Select create task
Description :VSL Balance Sheet transaction Code
Task Owner SAPUSER
Select Transaction radio button
Transaction F.01
Enter
Once again Keep the cursor on VSL schedule manager
Press mouse right click
Select create task
Description :VSL Balance Sheet program
Task Owner SAPUSER
Program : RFBILA00
Variant name : VSL
Enter
Save
Enter
Select return to scheduling button
Keep the cursor on VSL Balance Sheet program
Press mouse right click
Select schedule
Select immediately radio button
Execute
From Menu € Environment € Job Management
Execute
Select Job check box (RFBILA00/VSL)
Select Spool button
Select spool number check box
Select display contents button

PARTIAL PAYMENT IN APP

By creating payment request as noted item we can make partial Payment in APP

1.Creation of GL Masters – payment request – Current Loans and Advances T/C FS00
GL A/c 200151
Company code VSL
Select with template button
GL A/c 200150 (Advance o vendors)
Company code VSL
Enter
Short & Long Text : payment request
Save

2.Link between Sundry Creditors & payment request T/C OBXT

Path : SPRO Financial Accounting € Accounts receivable & payable
€ Business transactions € Posting with alternative reconciliation A/c Other special GL Transactions € Define alternative reconciliation
A/c for vendors
Double click on special GL indicator D
Chart of accounts VSL
Enter
Reconciliation A/c 100503
Special GL A/c 200151
Save
Enter

3.Assign payment request in APP Customization T/C FBZP

  • Select all Company Codes button
  • Select position button
  • Select VSL
  • Select details button

4.Posting of purchase invoice and Block invoice for payment T/C F-43

Document date: 24.08.2011
Type KR
Company Code VSL
Posting key 31
A/c 4000201
Enter
Amount 100000
Business Area VSLH
Payment. Block A (blocked for payment)
Text: Purchase invoice posting
Posting key 40
A/C 200120 (Inventor Raw material)
Enter
Remove the TDS codes Enter
Amount *
Business Area VSLH
Text +
Document € Simulate € Save Document Number 100009

5.Creation of payment request T/C F-59

Document number 100009
Company Code VSL
Fiscal Year 2011
Enter
Again enter
Amount 20000
Save
Enter to ignore message

6.APP Run T/C F110 INSTALMENT PAYMENT TERM
Payment term:--

1.10% payable immediately
2.40% payable with in 30 days
3.50% payable with in 45 days
SPRO€ Financial Accounting € Accounts receivable & payable
€ Business transactions € incoming invoices/credit memos €
Maintain terms of payment
Select New entries button
Payment terms VSL5
Select customer and vendor check box
Select posting date radio button under default for baseline date
Select next entry
Payment term VSL6
Select customer & Vendor check box
Select posting date radio button under default for baseline date
For Term : 1 e number of days 30
Select next entry
Payment term VSL7
Select customer & Vendor check box
Select posting date radio button under default for baseline date
For Term 1 number of days 45
Select next entry
Payment term VSL8
Sales text VSL Instalment payment term
Select customer & Vendor check box
Select posting date radio button under default for baseline date
Select instalment payment check box
Save
Enter

2.Define terms of payment for instalment payments T/C OBB9

SPRO€ Financial Accounting € Accounts receivable & payable
€ Business transactions € incoming invoices/credit memos €
Define terms of payment for instalment payments Select new entries button

Terms of payment

Instalment

Percent

Payment terms

VSL 8

1

10

VSL5

VSL 8

2

40

VSL6

VSL 8

3

50

VSL 7

Save Enter

3.Purchase invoice posting T/C F-43

Document date 24.08.2011
Type KR
Company Code VSL
Posting key 31
A/C 4000201
Enter
Amount 200000
Business Area VSLH
Payment terms VSL8
Text purchase invoice posting
Posting key 40
A/C 200120
Ignore message press enter
Remove the tax codes
Enter
Amount *
Business Area VSLH
Text +
Document € Simulate € Save

4.To View Vendor Account transactions T/C FBl1N

Vendor account 4000201
Company Code VSL
Select open items radio button
Select normal items check box
Execute
Select change layout button
From the hidden fields select net due date
Select amount in document currency under column content
Select left arrow
Select copy button

One Time Vendor Account

With number of parties we have only one purchase instead of creating Separate accounts we can use one time Vendor account. At the time of Purchase invoice posting. It will ask vendor name and address.

1.. Creation of one time vendor account group

SPRO€ Financial Accounting € Accounts receivable & payable € Vendor accounts € Master data € Preparations for creating vendor Master data € Define account groups with screen lay out (Vendors) Select VSL1(group)
Select copy as button
A/c group VSL3
Name One time vendor group for VSL
Select one time account check box
Enter
Save
Enter

2 Create number ranges for vendor accounts

SPRO€ Financial Accounting € Accounts receivable & payable €
Vendor accounts € Master data € Preparations for crating
vendor Master data € Create number ranges for vendor accounts
Select change intervals button
Select interval button
Number range 30
From number 2000401 To number 2000500
Enter
Save
Ignore the message press enter

3.Assign number ranges to vendor account groups

SPRO€ Financial Accounting € Accounts receivable & payable € Vendor accounts € Master data € Preparations for crating vendor Master data € Assign number ranges to vendor account groups Select position button
A/c Group VSL3
Enter
For group VSL 3 assign Number range 30
Save
Enter

4.Creation of Vendor Master T/C XK01

Company Code VSL
A/c Group VSL3
Enter
Name : One time vendor A/c
Select next screen button 3 times
Reconciliation A/c 100503
Sort Key 012 (vendor number)
Select next screen button
Payment terms 0001
Save

5.Posting of purchase invoice T/C F-43

Document date: 26.08.2011
Type : KR
Company Code : VSL
Posting key: 31
A/c 2000401 (one time vendor A/c)
Enter
Name : XYZ Ltd
City : Hyderabad
Country : IN
Enter
Amount : 10000
Business Area : VSL
Text : purchase invoice posting
Posting key : 40
A/c : 200120 (inventory Raw material)
Enter
Amount *
Business Area VSLH
Text +
Document € Simulate € Save

TOLERANCE GROUPS

1.Creation of GL master – payment difference account T/C FS00

GL Account 400306
Company Code VSL
Select with template button
GL A/c 400300 (Rent A/c)
Company code VSL
Enter
Change short text and long text to Payment differences
Save

2.Define Tolerance groups for GL accounts

Path: SPRO € Financial accounting € General ledger accounting € Business transactions € Open tem clearing € clearing differences € Define tolerance groups for GL accounts
Select New entries button
Company Code VSL
Tolerance Group A/tolerance group for VSL
Debit posting 100 Percentage 5%
Credit posting 100 Percentage 5%
Save
Enter

3.Define Tolerance groups for employees

Path: SPRO € Financial accounting € General ledger accounting € Business transactions € Open tem clearing € clearing differences € Define Tolerance groups for employees
Select New Entries button
Group A
Company Code VSL
Amount per document 9999999999
Amount per open Account item 9999999999
Cash discount per line tem 10%
Revenue - amount 100 - Per cent 5%
Expense - amount 100 – Per cent 5%
Save
Enter

4.Assign Users to Tolerance groups:

Path: SPRO € Financial accounting € General ledger accounting € Business transactions € Open tem clearing € clearing differences € Assign Users to Tolerance groups
Select New Entries button
User name : SAPUSER
Tolerance group A
Save
Enter

5.Create Accounts for clearing differences:

Path: SPRO € Financial accounting € General ledger accounting € Business transactions € Open tem clearing € clearing differences € Create Accounts for clearing differences
Chart of Accounts VSL
Enter
Save
Account 400306
Save
Enter

6.Assign Tolerance group in GL Master T/C FS00

GL Account 100500 (outstanding expenses)
Company Code VSL
From Menu € GL Account €
Change Select control data tab
Tolerance group A
Save

END USER AREA

1.Posting of Rent Provision T/C F-02

Doct.dt. 26.08.2011
Type SA
Company Code VSL
Posting Key : 40
Account : 400300
Enter
Amount : 99990
Business Area : VSLH
Text : Rent Provision
Posting Key : 50
A/c 100500
Enter
Amount *
Business Area VSLH
Text : +
Document € Simulate € Save

2.Outgoing Payment with clearing T/C F-07

Doct.dt. 26.08.2011
Type : SA
Company code : VSL
Clearing text : Outgoing payment
Bank data:
A/c 200105
Business Area : VSLH
Amount : 100000
Text : Out going payment
Open item Selection:
A/c 100500
Select process open items button
Double click on payable Amount 99990
Document € Simulate € Save

PROVISON FOR DOUBTFUL DEBTS

1. Sales entry

 

 

Customer A/c

Debit

Sundry debtors

To Sales A/c

Credit

 

2. Transfer sundry debtor to doubtful

Customer special GL (E)

Debit

Sund.debtors -doubtful

To Customer

Credit

Sundry debtor

3. Provision for doubtful debts

Provision for Bad debts

Debit

P/L A/c

To Prov.for doubtful debts

Credit

B/S

4. Written off of provision for doubtful debts

Provision for doubtful debts Debit With

To Customer special GL (E) Credit With

1.Creation of GL Master

Sundry debtors doubtful and provision for doubtful debts T/C FS00
GL A/c 200130
Company code ; VSL
Select with template button
GL A/c 200110
Company code : VSL
Enter
Change short text and long text to Sundry debtors doubtful
Save
GL A/c 400307
Company code : VSL
Select with template button
GL A/c: 400300
Company Code : VSL
Enter
Change short text and long text to provision for doubtful debts
Save
Write off of provision for doubtful debts: T/C FS00
Provision for doubtful debts with clearing
To customer special GL (E) with clearing
GL A/c 100530
Company code: VSL
Select with template button
GL A/c 100500
Company code : VSL
Enter
Change short text and long text to Provision for doubtful debts
Save

2.Define methods T/C OB04

Path: SPRO € Financial Accounting € Accounts Receivable & Payable
€ Business Transactions € Closing € Valuate € Reserve for bad debt
€ Define methods
Select new entries button
Provision : VSL
Month : 1
Percentage 1 : 10%
Month : 2
Percentage 2 : 20%
Month : 3
Percentage 3 : 30%
Month : 4
Percentage 4 : 100%
Save
Enter

3.Define Accounts for Reserve for Bad debts T/C OBXD

Path: SPRO € Financial Accounting € Accounts Receivable & Payable
€ Business Transactions € Closing € Valuate € Reserve for bad debt
€ Define Accounts for Reserve for Bad debts Chart of accounts : VSL
Enter
Select Debit/Credit check box
Select Provision Method check box
Save
Provision method : VSL
Debit : 400307
Credit : 100530
Save
Enter

4.Use T/C FBKP (Automatic A/c Assignments)

Select special GL Folder
Double click on E
Chart of Accounts : VSL
Enter
Reconciliation A/c : 200110
Special GL A/c : 200113
Save
Enter

END USER AREA

1.Sales Invoice posting T/C F-22

Doct.dt. & Postg.dt; 15.07.2011
Type : DR
Company code: VSL
Posting key : 01
A/c : 3000601 (Customer A/c)
Enter
Amount : 100000
Business Area : VSLH
Text : Sales invoice posting
Posting key : 50
A/c : 300000
Enter
Amount *
Business Area : VSLH
Text : +
Document € Simulate € Save

2.Transfer Receivable posting T/C F103

Path: Accounting € Financial Accounting € Accounts Receivable € Period processing € Closing € Valuate € Receivables
Transfer Posting (Gross)
Customer A/c : 3000601
Company Code : VSL
Provision method : VSL
Execute
From Menu € System € Services € Batch Input €
Sessions Select SAPF103 session name
Select process button
Select process/foreground radio button
Select process button
Go on press enter till we get the message processing of batch input
Session completed
Select exit batch input button

3.Reserve for Bad debts (Gross) T/C F104

Path: Accounting € Financial Accounting € Accounts Receivable € Period processing € Closing € Valuate € Reserve for Bad debts Customer A/c : 3000601
Company Code : VSL
Provision method : VSL
Special GL Indicator : E
Select generate posting check box
Posting mode : E (display errors only)
Execute

4.Write – off of provision for doubtful debts T/c F-21

Path: Accounting € Financial Accounting € Accounts Receivable €
Document entry € Other € Transfer without clearing
Doct.dt. 2708.2011
Type : DA
Company Code : VSL
Postg.key: 40
A/c : 100530
Enter
Amount : 10000
Business Area : VSLH
Text : Write off of doubtful debts
Postg.key : 19 (special GL A/c)
A/c : 3000601 (customer a/c)
Special GL indicator E
Enter
Amount : *
Business area : VSLH
Text : +
Document € Simulate € Save

ITEM NTEREST CALCULATION

Steps: 1. Creation of GL Master – Interest received T/c FS00
GL A/c : 300110
Company Code : VSL
Select with template button
GL A/c : 300100 (exchange gain)
Company Code : VSL
Enter
Change short text and long text to interest received
Save

2.Define interest calculation types

Path : SPRO € Financial Accounting € Accounts receivable & accounts Payable € Business Transactions € Interest calculation € Interest Calculation global settings € Define interest calculation types
Select new entries button
Interest indicator : V5
Name : 18% monthly
Interest calculation type : P (item interest calculation)
Save
Enter

3.Define Number ranges for interest forms:

Path : SPRO € Financial Accounting € Accounts receivable & accounts Payable € Business Transactions € Interest calculation € Interest Calculation global settings € Define number ranges for interest forms Company code : VSL
Select change intervals button
Select interval button
Number range : 25
Year : 2011
From number : 800001
To number : 900000
Enter
Save
Ignore the message press enter

4.Prepare item interest calculation

Path : SPRO € Financial Accounting € Accounts receivable & accounts Payable € Business Transactions € Interest calculation € Interest Calculation global settings € Prepare item interest calculation
Interest indicator : V5
Select open items check box
Select no cleared items radio button
Reference date : 4 (payment base line date)
Calendar type : G
Number Range : 25
Select post interest check box
Save
Enter

5.Define Reference interest rates : T/C OBAC

Path : SPRO € Financial Accounting € Accounts receivable & accounts Payable € Business Transactions € Interest calculation €
Define Reference interest rates
Select new entries button
Reference interest rate : V5
Long text : 18% monthly interest
Description : 18% interest
Date from : 1.04.2011
Currency : INR
Save
Enter

6.Define Time based terms

Path : SPRO € Financial Accounting € Accounts receivable & accounts Payable € Business Transactions € Interest calculation €
Define Time based terms
Select new entries button
Interest calculation indicator : V5
Currency key : INR
Effect from : 01.04.2011
Sequential number : 01
Term : Debit interest : arrears interest calculation
Reference interest rate : V5
Select next entry button
Interest calculation indicator : V5
Currency key : INR
Effect from : 01.04.2011
Sequential number : 2
Term – credit interest : Arrears interest calculation
Reference interest : V5
Save
Enter

7.Enter Interest values T/C OB83

Path SPRO € Financial Accounting € Accounts receivable & accounts Payable € Business Transactions € Interest calculation €
Enter Interest values
Select new entries button
Reference interest : V5
Interest rate : 18%
Valid from 1.04.2011
Save
Enter

8.Calculation of interest on arrears T/C OBV1

Path SPRO € Financial Accounting € Accounts receivable & accounts Payable € Business Transactions € Interest calculation € interest Posting € A/R calculation of interest on arrears
Select symbols button
Select accounts button
Chart of accounts : VSL
Enter
Account symbol : 0001 (interest received)
Currency Inr
GL Account 300110
Account symbol : 1000 (interest received)
Currency Inr
GL Account ++++++++++ Save
Enter

9.Assign interest indicator in customer master T/C XD02

Path: Accounting € Financial Accounting € Accounts receivable €
Master Records € Maintain centrally €
Change Customer : 3000601
Company code : VSL
Enter
Select Company code data button
Interest indicator : V5
Save
Enter to ignore the message

END USER AREA:

1.Sales Invoice posting T/C F-22

Doct.dt:10.06.2011
Postg.dt:10.06.2011
Type : DR
Company Code : VSL
Posting key : 01
A/c : 3000601
Enter
Enter to ignore the message
Amount : 400000
Business Area : VSLH
Text : Sales invoice posting
Posting key : 50
A/c : 300000
Enter
Amount : *
Business Area : VSLH
Text : +
Document € Simulate € Save

2.Interest calculations T/C FINT

Path SPRO € Financial Accounting € Accounts receivable € Period Processing € Interest calculation € Item interest calculation € Item
Interest calculation
Customer A/c : 3000601
Company code : VSL
Interest calculation to 31.08.2011
Select Test Run check box
Select posting button
Posting date : 31.08.2011
Document date : 31.08.2011
Text : Interest up to August
Business area : VSLH
Execute
Select back arrow
Deselect Text run check box
Execute
SPECS
Specs means specifications 2 types of specifications

A.Functional specifications:

Functional consultant job It describes what is needed by the system This is business oriented
Eg: Cash voucher receipt/payment printing

1.Input
2.Output

B.Technical specifications

Technical consultant
This is system oriented
Prepare a program

User Exits

GAP : One of the methods to solve implementation issues is user exits


 Download attached file.

You must be Logged in to download this file

Related Articles