SAP FICO Running Material
SAP FICO Running Material
SAP FICO Running Material
1
INTRODUCTION-FINANCIALS
The FI module is used for external reporting purpose where we can generate the financial statements like P&Ls
statements, Bal sheet, cash flow/funds flow statements etc.
CO: Stands for Controlling i.e., in normal terminology, it is nothing but Costing
The CO module is used for internal reporting purpose, which helps the organization for planning & monitoring the
costs, budgeting, etc.
Log on to SAP.
Client 800
Username SAPUSER(Not Case Sensitive)
Password india123 (Case Sensitive)
Client
Normally the client means a customer to whom we implement SAP. But, when it is
defined technically, the client is a highest node in the system/server where it contains a
self-contained set of tables and transactional data.
Overview: When a company (ex. PENNAR) intends to start SAP for their business
applications, it purchases the SAP software from SAP-India. The Price of software is
based on the number of Users in the production client. Once company purchased the
software, it recruits / engages another Company (ex., WIPRO) for implementation
purpose. Both the purchaser and implementer will delegate/ recruit some employees for
implementation of SAP.
2
Core Team from Purchaser analyzes the present situation in the Company and
prepares the Process Document for SAP Implementation.
Basis Consultant will install/set up the SAP servers and create the client numbers.
By default SAP-India is allotting 000 (or) 001 (or) 067 (or) 800 as Development
Client #
Number of Production Clients will be given by Basis Consultant after discussing
with
purchaser. There will be minimum of 2 clients. Some companies are creating 3
clients.
1. Development Client ------> for Customization purpose
2. Testing Client ------> for testing purpose
3. Production Client ------> for Live Data i.e, entering day to day activities
Once all the customization done as per client requirement in development client,
the changes needs to be copied to production client. All the customization will
only be done in development client not in production client.
Once we enter User Name and Password and press enter, system will log on to
SAP. On Screen
1st Row ====> Menu Bar
2nd Row ====> Standard Tool Bar
3rd Row ====> Title Bar
4th Row ====> Application Tool Bar
Last Row ====> Status Bar
In 2nd Row there is . It is for Enter symbol. Beside+A954 There is one box called command
field.
3
If, any user login into sap with same user name more than once, system will
prompt you to select one the 3 below options.
Action will be depending on the option we select.
If any user wants to work on different screens at a single time, he can open up to a
max of 6 windows or Sessions.
WHAT IS SESSION?
A session is a window or screen where SAP user will do day to day
activities like create master records, post transactional data and MIS
reports etc. One user can open and work maximum of 6 sessions at a time.
4
After Posting the Document in F-02, to change the session and see the account
balance
display, instead of going back to Easy Access and press new code FS10N in
command
window, we can type" /NFS10N" to go directly to the new window of FS10N. If
we
want to change the session we have to give \N before the New Command TC in
Command Window.
Use /OFS10N in command window for creating new session directly with
New TC /N ----> for change the session and /O for Creating the session
UNLOCKING SCREENS:
Tools---->Administration---->Monitor---->Lock Entries (TC=SM12)---->List Buttons
PROJECT CREATION:
Normal Organization Structure will be as follows
Company Comp Code Pennar Steel Pennar Pennar
Ltd CementsLtd Ind. Ltd
Units Business Areas HYD BGL HYD BGL HYD BGL
Company Code is the Legal Entity. FICO Consultant will do customization at Company
Code Level. Company /Group is only for information purpose.
5
Consultant will do customization for one company code and copies the
customization to
including Accounting to other Company Codes and makes modification wherever
required.
PENNAR .
Company PENNAR
Company Name Pennar Group
Street Ameerpet
Postal Code 500000
City Hyderabad
Country IN ( Select IN from Dropdown/ Pulldown
Button for India)
Language EN ( Select EN from Dropdown/ Pulldown
Button for English)
Currency INR ( Select INR from Dropdown/ Pulldown
Button for Indian Rupee)
Select Save Button ( or) Ctrl + S Buttons for saving the Company Information.
Once the Company information is saved, SAP will generate one Transport Request.
Every
time it saves 2 files. One in Client 800 and 2nd one in Transport Request with Key
Number.
SPRO option will be activated only for Consultants. End User Job is without SPRO
Option. So Path for defining the Company Code is as follows:
6
SPRO--->Enterprise Structure----> Definition ----> Financial Accounting---->Edit,
Copy,
Delete,Check Company Code( Select IMG Activity Button here)--->Double click
on Edit
Company Code Data---->Select New Entry Button ( Screen like below will
open)
Select Save Button or CTRL + S for saving. Once Saved New Screen Will open.
Title Company
Name PENNAR STEELS LIMITED
Street Ameerpet
PinCode 500000
City Hyderabad
Country IN
Once Completed all the data, press Enter Button. System will generate Transport
Request. To Choose our request select it from Drop Down Button. Beside Request#
Select your request# .Press enter to save in your request.
Assign Company Code to Company:--> ( Creating Link between Company Code to Co)
Assigning Business area to Company Code is not required. Reason is explained below.
Same Business are can be used for number of Company Codes in Client
800. When we see the report or we want to see the report, we have to give
the Combination of company code and business areas.
CHART OF ACCOUNTS
OPTION 2 ::
Each Company code have their own
set of accoutns . They dont want to
follow the common coding and at
the same time they want to compare
and consolidate. Which is possible
only
by creating Group Chart of Accounts
Normally all companies will follow option 1 i.e, SAP SET OF ACCOUNTS as
consultant will do Customization in 1 company and copy customization along with
accounts to all Other Company Codes. It is Easy process.
Account Groups:
If we create Account Codes without Groups like below:
Equity Share Capital 100000
Cash Account 100001
Pref. Share Capital 100002
SBI Current A/c 100003
If we want to see the Current Assets Balances or Transactions of Current Assets, it is not
possible to get directly without Group Creation. We have to verify each and every
account and go on adding the respective accounts. In the above example, we have to add
100001 and 100003 which takes much time in practical.
(OR)
9
When we prepare Balance Sheet, in the balance sheet we have items like Share Capital,
Reserves & Surpluses, Fixed assets, Current Assets etc., We have to verify each and
every account and assaign to the account to the respective item.
To get the Balances directly or assaigning accounts to items easily, SAP has given
Account Groups. Structure of Account Groups in SAP will be as under.
When we create Cash Account it can be with any number within Range of 200000 to
200099. When we create SBI C/A , it can be within 200000 to 200099. When we
prepare Balance Sheet for Current assets, we give range 200000 to 200099.
In Live Environment, we take the Client's Balance Sheet and Create Account Groups.
After Implementation also Client wants to see the Balance Sheet the way he used to get.
At the time of Posting Document for Expenses by user, he can search all the Expneses
accounts by pressing *4 and select the required account from the list of Expenses
Accounts. If he typed *4 , only Expenses Accounts List will display , not other groups.
ASSETS
PSL FAST Fixed Assets 200000 200099
PSL CAST Current Assets& Loans and
Advances 200100 200199
10
INCOMES
PSL SALE Sales 300000 300099
PSL OTHR Other Income 300100 300199
PSL INCR Increase / Decrease in Stock 300200 300299
EXPENDITURES
PSL RMEM Raw Material Consumption 400000 400099
PSL PRSN Personnel Cost ( Manpower) 400100 400199
PSL MFRG Manufacturing 400200 400299
PSL ADMN Administration 400300 400399
PSL INTR Interest 400400 400499
PSL DEPR Depreciation 400500 400599
Select Save Button or CTRL+S. Select your request and press enter to save your request.
If we created Account Groups for Liabilities upto 1599 ( as Liabilities will start with 1
series and coding is 4 digits) , We can not create morethan 4 another groups 1999-
1599=400/100 ( as we are assaiging 100 accounts to each group)
Suppose if we are using 6 digit number for group, we can create 199999-
100599=99400/100 994 groups. SO WE SUGGESTED TO GO FOR 6 DIGIT
ACCOUNT GROUPS.
We can specify any Account Number within the Range of Given for Reserves & Surplus
i.e., 100100 to 100199. Generally we specicy A/c # 100100. When we start crating
account the first account to be created is 100100, surplus in P&L Account.
11
Chart of A/c PSL press Enter
FISCAL YEAR
If Fiscal Year period is from April '08 to March '09, in SAP it is called as Fiscal Year
2008
If Fiscal Year period is from July 2008 to June 2009, in SAP it is called as Fiscal Year
2008
If Fiscal Year period is from Oct 2008 to Sept 2009, in SAP it is called as Fiscal Year
2009
Logic behind this is besed on Numbe of Months covered in Next Calender Year. If in
next Calender Year Period is above 6 months , call it as Next Year , otherwise call with
the
same year. So , in above example
No.of Months in
Period 2008 2009 SAP Year ( Fisc.Year)
April 08 to March 09 9 3 2008
July 08 to June 09 6 6 2008
Oct 08 to Sept 09 3 9 2009
Month No. in FY
April 1} Normal Periods
March 12 }
March 13 }
March 14 } 4 Special Periods
March 15 }
March 16 }
Specail periods are part of last period in that Fiscal Year. In this example March 2009.
USAGE OF SPECIAL PERIODS IS OPTIONAL
12
WHY SPECIAL PERIODS REQUIRED:
Why SAP has allowed Special period is explained below with the example.
Date Status of Accounting
on 20.03.09 Accounts department released profitability upto the Feb'09 to the Mgt.
Figures upto Feb'09 can not be changed as profitability is finalised
upto
Feb 09. In that sence, We open period for March 2009 to March 2009
for
data entry purpose so as to not to change the previous data by any one.
So End user can entere transactions only for the month of March 2009.
on 30.03.09 New accounting year April 2009 to March 2010 ( Fisc. Year 2009) will
start after 2 days. So to open the period for Fisc.Year 2009, we have to
open period from March 2009 to March 2010 as , for Fisc. Year 2008
B/S is not finalised and still some entries have to make for March
2009. So period to open would be 12.2008 to 12.2009
on 16.04.09 Accounts Department has closed the Balance Sheet and declared
Profitability for the Fisc. Year 2008 to the Management. Management
has suggested to make some adjustments for which adjustment entries
hast to be passed by A/c Dept. This Adjustments may be for
increase / decrease the profitability.
Conversion for A/c Year from Apr 2009 to March 2010 ( Fisc. Year 2009)
Month Days Period in Year Shift
SAP
Jan 1 31 10 -1 For Accounting Year 2009-2010,
Feb 2 29 11 -1 April will be the 1st Month
Mar 3 31 12 -1 For April Calender year =2009
Apr 4 30 1 0 For April Fiscal Year = 2009
May 5 31 2 0 So, Year Shift is "0" ( 2009-2009)
June 6 30 3 0
July 7 31 4 0 But for Jan to March , Cal Year =2010
August 8 31 5 0 Fiscal Year = 2009
Sept 9 30 6 0 So, Year Shift = "-1" ( 2009-2010)
Oct 10 31 7 0 When we post document for Jan-2010
Nov 11 30 8 0 it should updated the FY. 2009 ledger
Dec 12 31 9 0 But not the 2010, so Year shift= -1.
14
Scenario -II
Conversion for A/c Year from Oct 2009 to Sept 2010 ( Fisc. Year 2010)
FV Description
1A April to March + 4 special Periods---> Deselect Year Dependent--Deselect
Calender Year Check Box----> No of Posting Periods =12 ----> No of
Spl. Periods =4 Select Save Button or CTRL+S
Select F.Year Variant as 1A. Double click on Periods folder---> Select New Entries
15
Why to De-select Year Dependent Check Box: If we select the Year Dependent Check
Box, at the time of Saving , SAP will ask for Which Fiscal Year. If we gave 2009 as FY,
Conversion is applicable to that FY only. We have to do the Same process of Conversion
for each and every year. If we de select, converion is applicable to all the years.
Why to De-select Calender Year Check Box: If we select this check box, System
will
consider January as Period 1 in the Fiscal Year and April will be as 4th period. But
we
require April will be treated as 1st period and January will be 10th in Periods.
POSTING PERIODS: Here we define , which periods are to be open for posting
purpose.
In all other Softwares, Closing of the period is there. Once we selected closing the
periods,
end user cannot enter any documents before to that period. But in SAP Open period is
there. If we open period for entering documents, the periods before to that and after that
periods, end user is not able to enter any document. Once we open the period,
automatically
other periods will be closed. We can enter any document between the dates of the open
periods only.
Fro example, if we declared profitability upto June'09 and we want to open periods
from July '09 to March'2010. In SAP we call it as 4.2009 to 12.2009.
For Opening and Closing of periods we have 2 options in SAP which is explained below
16
Options Company Codes
PSL PCL PIL
Option 1.
All the Company codes will
open and close periods at the
same time and same period
there are 3 steps in opeing &
closing of periods.
A) Define Posting Period Variant
"X" to PP Variant option
B) Assaign Company code to X to PSL X to PCL X to PIL
PP Variant
C) Define Open and Closing
periods for Variant
Practically this option is not possible as all the company codes are not able to close books
at the same time. For that purpose SAP has given Option # 2.
After declaring results upto June'09 to the managemen. We want to open period from
July'09 to March'10. We also want to open for March'09 as Audit is not completed. In
this scenario SAP has given 2 Options.
From Period 1 which is MANDATORY IN SAP
July-2009 to March 2009
4.2009 to 12.2009
At the time of Opening Posting Periods , Authorisation Group is kept as Blank. When
June
Profitability is declared period to be open will be July'09 to March'2010. After July'09
profitability Period to be open will be Aug'09 to March'10. So Opening and Closing of
periods Screen is regularly used in SAP. As this screen is widely used, SAP has given the
access of
this screen at the End User level also. It may be Misused by End User. To resctrict the
misuse Authorization Group is Helpful.
Basis Consultant will create Authorization Group Say "X" and assaign user ID's say
Manager Dy.Manager of Accounts to this Group. Hence these 2 people only can access
the screen and make changes in opening periods.
18
Path for Posting Periods Entry at End User Area:
Accounting---->Financial Accounting---->General Ledger----
>Environment---->
Current Settings---->Open & Close Posting Periods(TC= S_ALR_87003642)
Select Position Button Posting Period Variant------> PSL
Press Enter to save.
In Normal Accounting all entries are made by Accounts Persons. So Voucher Number
will be contineous.
Purchase Voucher 1
Payment Voucher 2
Sales Voucher 3
Receipt Voucher 4
In the above example , Voucher Number is contineously coming for all the
departments.
So, which document raised in Which Department or How many Documents raised in
One
Department is not able to get. To Get document number contineously SAP has given
Document Types
Document Type RE SA RV
(Purchase) (Gen.Ledger) (Sales)
Number Range 02 01 03
Number Range Interval 100001 to 1 to 200001
200000 100000 300000
If we give the Document Numbe Range like above, we will get Document Number
Contineously in Department wise. So, by seeing the Document number itself we can
say in which department the Document is generated.
If in any year, 100000 documents are consumed for SA, System will warn with Error
Message
when we post a new document of SA. At that time we have to give available Number
range
to the Number Range Interval. In the above example , availabel Numbe is from 300001
to
400000
Number Range 01
Year 2009
From Number 1
To Number 100000
Current Number 0
External Chk Box De select it Press Enter
Select Save or CTRL+S Ignore Warning Message Press Enter
1. Consultant is outsider. He does not know how many Docs. are required for each type.
2. All the Deparment pepole want to have the number range from 1 to 100000
which is not possible in practical.
IN live environment before going to live Production Clients all Department Heads
will sit together and decide the Document Numbering.
What ever we have given in Client 800 are applicable only for Development Client for
testing of documents.
Why to De-select External Check Box: If we select the External Check Box, at the time of
Posting end user has to give the Document Number manually. If we deselct, System will
generate Numbering automatically.
Option 1 Option 2
Year Specific Numbers used Year Specific Numbers used
01-2008-1-100000 49000 01-9999-1-100000 50000
01-2009-1-100000 1000
20
In Option 1, last number in 2008 is 49000 and in 2009 is 1000. When we posted
document
on 11.07.2009 for the date of Posting 11.07.2009 ( FY2009) New Document Number
will be
1001. If we post the document on 11.07.2009 for Posting Date 31.03.2009, New
document
number will be the next number of last years last number i.e, 49001 only, but not 1001.
document relates to which Fiscal Year. Hence Most of Companies will choose
OPTION-1.
When We select Supress Field will not be visible on Screen at the tiem of Posting
Field selection is not commone to all accounts. It varies Account to Account. So For
Purchase accounts/ Sales Accounts Field "Qty" is required but Not for Equity Share
Capital Account. If we have 1000 Accounts in Chart of accounts, We have to create 1000
Scenarios for each account separately. This is very difficult in Practical. To overcome this
problem, SAP has given Shortcut method called " Field Status Group"
For the above acounts , we make the above fields are as Compulsory ( REQUIRED)
wether
client inform to make them compulsory or not . Other fields are based on client
information.
Select FstV= PSL Double Click on --> Field Status Group Folder
Value Date means Effective Date. Suppose if we took a Loan from IDBI on
11.07.09 Cheque Date of IDBI is 11.07.2009.
On 13.07.2009 we are postin the document and depositing the cheque in
Bank. At the time of Posting
Document Date-------> 13.07.09 Once date is entered in Document Dated
Posting Date-----------> 13.07.09 and Posting Dated column, it can not be
Modifiable. We have to reverse the entry only.
IDBI Calculate Interest from 11.07.2009, whereas SAP will calculate interest from
13.07.2009 as posting date is 13.07.2009. So In interest amount , there will be a
differene between IDBI and Systems calculation. To overcome this problem,
SAP has given Effective Date i.e, Value Date ( in SAP Terminalogy) . IF we
select the Value Date option Compulsory and enter it at the time of posting.
SAP will
calculate interest from Value Date entry. Value date can be modifiable if
necessary but not Document Date or Posting Date.
Sale Tax is required for Both Accounts Payable and Accounts Receivbale.
But system will not allow to enter any transactions in India ( for Country
Code IN) withou Sales Tax Procedures even for General Accounts.
So, we assaign some Tax Procedure which is available in system
temporarily. Afterwards, when we go for Accounts Payable , or Receivable
we make our own Tax Procedures.
For Country IN--> Assaign Tax Procedure TaxUS( Sales Tax USA) or
TaxINN (Sales Tax India)---> as Temporary assaignment.
23
PATH: SPRO---->Financial Accounting---->Financial A/c Global Settings---->Tax on
Sales/
Purchases---->Basic Settings---->Assaign Country to Calculation Procedure---->
Select Position Button Country----> IN Press Enter
For Counry IN Assaign Procedure ----> TaxUS-Sales Tax
Groups
If we see the account in the Month End,we will have Number of Credit items and
Number of Debit Items. We dont know which item is pending and How much is
Pending. IN SAP, if we select Open Item Management, at the time of payment , system
will ask against which item the payment is made. When we specify the payment is made
against Rent that item will be cleared upto the extent we paid.
If we paid 25000 against Rent A/c , We can see accounts in 3 ways.
Once we selected Open Item Management, we can see Bill Wise Payable of Vendors,
Billwise Receivbales of Customers.
As discussed earlier, SAP has given Tolerance Groups. Tolerance means Pament
Diffrence. It can be " Amount Tolerance" to "Percentage Tolerance". It can be Debit or
Credit
24
We create Tolerance for Tolerance Groups
A 100
B 2%
C 0 0
1. Create Tolerance group and give the tolerance amount or Percentage or both
2. Tolerance group will be specified in General Ledger A/c.
Ex: Salaries 500000
Wages 400000 Outstanding Expneses as on 31.07.09
Rent 25000
Commission 100005
IN General Ledger a/c for Outstanding Expenses account we have specified Tolerance
Group " A". When we make payment of 100000 to Commission , System check
Howmuch is payable 100005
Howmuch is Paid 100000
Difference 5
If the difference amount is withing the Tolerance Group Amount ( 100 Rs for "A"
Tolerance) The difference will be transferred to Sundry Balances Written off account
and clear the
Item-Commission automatically.
If the Tolerance amount is within the Tolerence Group Limit, system will
automatically transfer the Difference amount to Sundry Balances Written Off account.
It should ask the end user before Transferring. In Live Environment, we use
Tolerance Group "C" in which Tolerance amount and Tolerance Percentage both are
ZERO.
If we specify Tolerance Amount (or) Tolerance Percentage as ZERO, system will show
the
balance "5" as Outstanding in Account. It the Customer or Enduser decision to Pay or
not
to Pay.
If we want to Pay Rs. 5------> we show 100000 paid as part payment and balance
show as
outstanding amount.
If we dont want to pay Rs.5 -----> Transfer this amount to Sundry Balances Written
off A/c
and clear Tranaction.
Say we have 1000 General Ledger A/c , 1000 Vendors and 1000 Customers. In all
Accounts we have to assaign Tolerance Group "C" which is highly difficult. So we
keep Tolerance Group as Blank and Amount "ZERO"
25
For Company Tolerance Tolerance Tolerance
Code Group Amount Percentage
When we create the account, Tolerance Group will be " Blank". System expects we
have created Blank Tolerance Group and Assaigned in the Account.
If we have 1000 users we have to create 1000 Scenarios. So SAP has given short cut to
Tolerance as Groups. We create 3 Groups "A", "B" & "C" and assaign to Users.
If we have following people in Accounts Dept we can assaign Tolerance Groups to them like
26
PATH: SPRO---->Financial Accounting---->General Ledger Accounting---->Business
Transactions---->Open Item Clearing---->Clearing Differences--->Define
Tolerance Group for Employees----> Select Position Button
Select New Entries Button
27
IMPORTANT STEPS IN BASIC SETTINGS
Following are the steps to follow for compleating the Basic Settings in Financials
28
GENERAL LEDGER CONCEPTS:
1ST STEP: Checking the A/c Groups to see the A/c Numbers to allot
Accoun Group---->Select Reserves & Surplus Short Text Will appear at the time of
Select Balance Sheet Account Radio Button Document Display
Short Text----> Surplus in P& L A/c Long Text will appear at the time of
Long Text----> Surplu in P& L A/c for PSL Ledger Display
29
tab Select Only Balances in Local Currency Chk Box
Select Control Data
Keep it Blank
Tolerance Group
Line Item Display ON Posting Date
Sort Key 001
tab
Select Create/Bank/Interest
for General Select Save or CTRL+S
Field Status Group G001
For Creating 2nd Account ----> Equity Share Captial ( A/c # 100100)
GL A/c 100100
Company Code PSL
Select With Template Button
GL A/c 100100
Company Code PSL Press Enter
30
POSTING OF TRANSACTIONS:
Path: Accounting---->Financial Accounting---->General Ledger Accounting ---->
Posting--->General Posting(TC=F02)
On screen we get a window For Posting Document
Document Date: Normally Document Date and Posting Date will be same. IN
case
of Purchases i.e., Document Date will be the Party's Bill Date. For Date we can
enter
like 16.07.2009 ( or ) Press F4 to get the calendar and select the date (or) press F2
for current date.
Posting Date: Posting Date comes automatically from Server. Ledger update will
be
based on Posting Date. Period comes automatically based on the date of posting.
SAP has given to differentiate between Debit and Credit 2 Different Posting Keys.
for Credit :
Select Save or Ctrl+S. We will get a message "Document 1 was posted in Company Code
Document # 1 Enter
Comp. Code PSL Double Click on 1st line item ( Cash Account)
Fiscal Year 2009
* We can change Value Date, Assaignment Numb, Text Fields only, but not other ****
32
To View Contineous Transactions ( Range of A/c)
Press " Select Intervals" Tab and give
Lower Limit Upper Limit
100000 100099
To Exclude One account from the Range:
Select Exclude Single Values tab
Under Single Value give A/c # 100500. It will not come in the list
Select Copy Button.
To Exclude a Range of accounts from Range of accounts Display: Select Interval Tab
Lower Limit Upper Limit
100050 100059 Select Copy Button
To View only one A/c Transactions: Select Drop down button beside GL A/c
Comp Code PSL Enter Select A/c # 100000 Eq. Share Capital
Comp Code PSL Seleclt Execute Button
Fiscal Year 2009
Business Area PSLH
DoubleClick on Cum.Balance 400000
DoubleClick on Document# 1
Select call up document overview button (F9) Select Back Arrow
Option 1 Option 2
User Specific- Available to only Common to all users
Specific Users
A) Select User Specific check Box A) Deselect User specific Check Box
B) Save with any number or name B) Save with any number or name
For our purpose, Select Option 2 and save with PSL. Deselect the User specific Chk Box.
Description: GL A/c Standard for PSL Enter. We can see Report in our Lay Out.
33
How to Choose our Layout: Press Select Layout Button ( Ctrl + F9)
Select /PSL we can see Report in our Layout.
SAMPLE DOCUMENT:
This is used for Month End Provisions. For this purpose we create Sample Doc.
Sample Document template will not update the ledger . Everymonth end we copy
the template and change the amount and post the Document.
34
Path: SPRO---->Financial Accounting--->Financial Accounting Global Settings--->
Document---->Document Number Ranges---> Define Doc. No Range
( FBN1) Press Enter
No Year From # To #
Range
X2 2009 5000001 5100000 Enter and Save
2. Creation of Masters.
GL A/c Group Name
A) Salaries A/c Under Personell Cost
B) Rent A/c Under Adminstration Cost
C) O/S. Exp Under Current Liabilities & Provisions
After Note down the Number Range for Required GL A/c to create, create GL accoutns
from FS00
1st Account
GL A/c # 400100 Salaries Account
Comp. Code PSL Click on With Template Button
GL A/c # 100000
Comp. Code PSL Press Enter
35
2nd Account
GL A/c # 400300 Rent account
Comp. Code PSL Click on With Template Button
GL A/c # 400100
Comp. Code PSL Press Enter
GL A/c # 100000
Comp. Code PSL Press Enter
36
4. Display Sample Document Posted ( FBM3):
Document # 5000001
Company Code PSL ENTER
We can see the Sample Document Stored in SAP. We can check the Ledger
A/c's of 400100 (Salaries), 400300( Rent) or 100500( O/S. Exp) because of this
Sample Document Storage, Ledgers are not updated ( FS10N)
Document # 5000001
Comp. Code PSL
F.Year 2009
Select Display Line Item Check Box ENTER ENTER
If Rent Provision is not required for the month of July Change the Amount to "0"
ENTER Ignore message for " Amount is Zero, Line Item Ignored"
ENTER
Amount *
Text Add July ENTER
37
Steps to Cover this Topic :
1 Entering Document and Parking by Cashier/Accountant
2 Display G L A/c to check wether Ledgers updated or Not.
3 Sending Message to Senior for Releasing Parked Document
4 Display Parked Documents, Make Corrections in Amount, Head of Account, Date
and Releasing by Sr. Person
5 Display G L A/c to check wether Ledgers updated or Not.
6 Sending Message to Cashier regarding the Releasing of Document by Sr. Person
7 Display changes made by Senior Person in Parked Document for Cashier
38
4 Display Parked Document and Release after corrections:
PATH: Accounting---->Financial Accounting---->General Ledger---->Document---->
Park Documents---->Post/Delet ( FBV0)
Select Documents List Button
Company Code: PSL
Entered by: Use id of Cashier Press Execute Button
Double Click on Document# 3
HOLD DOCUMENTS: This is used for the purpose of Adjustment Entries. Hold
Documents are for Debit and Credit or only Credit also. When we hold the document,
it will ask for a Temporary Document Number which can be anything. We have the
option to
delet the hold document also. Hold document will not update the ledger until it is
posted as normal Document.
If we made Hold document for Cash Account, then Physical Cash Balance
will be SAP Balance + Hold Documents amount.
39
Steps for Hold Documents :
1 Run Program "RFTMPBLU" for conversion of Hold Documents.
2 Creation of Hold Document
(A) One document with Debit and Credit Entries
(B) One document with Credit entry only
3 Display Hold Documents, Delet document ( A) in Point 2, and Complete 2 (B)
Step 1. Run Program "RFTMPBLU" for conversion of Hold Documents. This Option is for
converting the Documents of older version SAP4.7 to New Version ECC6.0
This is given at Client Level but not at Company Code level. This is one time
Exercise for each client.
PATH: Tools----> ABAP Work Bench---->Development---->ABAP Editor ( SE38)--->
Program RFTMPBLU Select Execute Button
Select No termination for Read Error Check Box----> Select Execute
Step 3. Display Hold Documents, Delet document ( A) in Point 2, and Complete 2 (B) ( F-02)
40
Double Click on Document 12345
Post Key: 40 Account No: 400100 ENTER
Amount * Bussiness Area: PSLH
Text: +
Menu---> Document----> Simulate SAVE
Press Enter when we get message.
Check the Document List again by pressing Back Arrow to see Held document
was released from there or not. Once Held Document was posted, it will
disappear from Held Documents List.
No Year From No To No
X1 2009 5100001 5200000 ENTER
Ignore the Warning Message and press Enter
41
Step 3. Display & Posting Recurring Document
Display: Accounting---> Fianancial Accounting---->General Ledger---->Periodic Processing
----->Recurring Entries----> Lists( F.15)
To View the Document Posted use the Transction Code FB-03 ENTER
Once we follow one Conversion Factor , follow contineously for all the years. Dont Change
in between. If we change in between, it gives wrong Results.
Conversion Factors are given at Client Level but not at Company Code Level.
PATH: Same as above ignore the warning message and press Yes. Select New Entries
Button
42
Ex. Rate From To Valid Ratio
Type From From : To
G US$ INR 01.07.09 1: 1
B US$ INR 01.07.09 1: 1
M US$ INR 01.07.09 1: 1 Save
Enter Exchange Rates: This is called Forex Table. We can enter Foreign Exchange
Rates Daily, Weekly, Monthly. For Each Type we can enter only one rate in a day.
PATH: Same Path as above ( Next Step to last Path)
Foreign Currency Postings : There are two typs of options for Foreign currency postings.
OPTION -1 OPTION-2
When Exchange Rate is not entered When Exchange Rate is entered
at the time of Posting the Document at the time of Posting the Document
In Option 1, system take the Ex. Rate Rates are entered by End User , but not
from Forex Table the System.
43
To Enter Default Exchange Rate type based on Document Type.
Doc. Nature of Document Type of
Type Ex. Rate
SA General Ledger Posting B
KR FI Purchases B
RE MM Purchases B
DR FI Sales B
RV SD Sales B
NOTE: If we do not specify the Ex Rate Type , system will take automatically"M"( Average)
To Enter Default Ex. Rate Type "B"(Bank Selling Rate) for Document "SA"
(OBA7)
GL Document----> Select Details Button
Under Default Values:
Ex Rate Type for foreign currency document "B" Select Save or Ctrl+S
Press Enter to Save in your Request.
To View Document in INR Select Display Currency Button(F8). Select Save or Ctrl+S
44
MONTH END PROVISONS: We have 2 options for Month End provisions
When we reverse the transaction it reduces from the same side instead of
Showing it on credit Side. Ex.
Period Debit Credit Balance Cum.Bal
4 100000 ---- 100000 Dr 100000 Dr
5 -100000 ---- - -
When we reverse the Salaries Provison on 1st of of August, it shows on
Debit Side as Negative Balance instead of on Credit Side. If it shows
on
Credit Side, in Cash Flow Statement, it shows as " Cash Incoming "
from
Salaries, which seems to be awkward in reports. If it shows on Debit
Side
as Negative Balance, Net Effect will come in Cash Flow Statement.
We get a Message that Documents Were reversed with another Document Number
will ask about the payment is against which provision. Once we selected
payement
agaisnt Rent Provison, that item will be cleared from Open Items List.
48
4th Step: Checking Open Item Managed A/c after payment (FBL3N)
If we want to see the Open Items under GL A/c Number 100500 ( O.S. Exp)
Select Open Items Radio Button
Select Noramal Items Check Box Select Execute Button (F8)
B) Partial Payment of 2000 by using Partial B) Partial Payment of 3000 by using Partial
Clearing Method Clearing Method
O/S. Exp A/c Dr 2000 O/S. Exp A/c 80000
To Bank/ Cash A/c 2000 To Bank/ Cash A/c 3000
To O/S Exp A/c 77000
O/S. Exp A/c at the end of the period
Open Items 70000 Cr Open Items 77000 Cr
Cleared Items 2000 Dr Cleared Items 80000 Cr
Open Items 68000 Cr 80000 Dr
In Residual Clearing Method, if we make part payment against any provision, System
will
clear all the earlier provison and for the difference amount ( i.e., Balance payable)
generate
another provision entry with new reference number. Residual means Balance payable.
In Live Environment, Companies will follow Partial Clearing Method instead of Residual
Clearing. Reason is at the time of every payment in Residual a New Reference is
generated. It gives practical problems in case of Vendors / Customers Bills Clearing. We
may not know the actual bill amount after 2 or 3 partial payments. Both the Options are
available in SAP, it depends on the company to choose which option to follow.
49
Scenario2: Partial Clearing
Step 1: Making Rent Provison (F-02)
Doc.Date 24.07.09 Company Code: PSL
Post Date 24.07.09 Currency : UINR
Document Type: SA
Reference # : 6789 ( Normally in Vedors/ Customers it is Bill Number)
Post Key: 40 Account No: 400300 ENTER
Amount 70000 INR Bussiness Area: PSLH
Double Click on Amount under Payment Amount Column and Change the
amount to Actual Payable Amount of Rs. 2000.
From Menu----> Document----> Simulate
System will warn with a message " Correct the Marked Line
Items" Double Click on the Line Item which is in BLUE
COLOUR
Enter Text + or type " Out going payment " in Text Column. SAVE
50
To View Bill Wise Outstanding :
In Account View Screen, Go to Change Layout Button
From Hidden Fields Column Select---> Reference Field
Select Amoutn in Local Currency Field under Column
Content Select Left Arrow or Show Selected Fields Button
Select Copy Button . Keep Curson on Reference and Select Sub Total Button on Top
We can see the Outstanding amounts in each Bill in the Outstanding Exp. A/c
51
Step 2: Making Part Payment using Residual Method ( F-07)
Doc.Date 24.07.09 Type SA Company Code: PSL
Post Date 24.07.09 Currency : UINR
Clearing Text: Outgoing Payment
Bank Data:
Account : 200100 ( Cash Account)
Bus. Area: PSLH
Amount : 3000
Text: Part Payment for Rent Prov
Open Item Selection:
Account : 100500 Process Open Item Button / Tab
** XXXX****
53
Type 3: Mass Reversal
To reverse more than one document at at time, we use Mass Reversal
Method.
The documents to be reversed can be contineous numbers or random
numbers. PATH: Accounting ---->Financial Acconting---->General Ledger----
>Document---->
Reverse----> Mass Reversal ( F.80)
If we have given Stop Payment Letter to the Bank agaisnt the Document # 13, it
should be reversed then Account will be
O/S. Exp A/c
Doc # 13 60000 Dr. Doc # 12 600000 Cr
in Cleared Items List Document # 12 60000 Cr
System Shows that Document # 12 under Cleared List. When we have given
stop
payment Letter to Bank and reversed document# 13, then Document # 12
should
come under Open Item Category. To make this in SAP we have to follow 2
Steps
A/C # 100500
Comp.Code: PSL
Select Open Items Radio Button
Select Noramal Items Check Box Select Execute Button (F8)
We can see that Document # 12 is appearing in Open Items List.
XXXXX
INTEREST CALCULATIONS:
Method 2.
On 100000 from 15.04.09 to 15.07.09 @ 10% 4000
On 90000 from 15.07.09 to 31.03.10 @ 10% 8000
Balance Interest Payable 12000
If both are Different ie., When Loan acount is having Credit Balance 10%
When Loan account is having Debit Balance 8%
56
Step 1. Define Interest Rates:
PATH: SPRO---->Financial Accounting--->Gen Ledger a/c--->Business Transactions---->
Bank A/c Interest Calculation--->Interest Calculation---->Reference Int. Rates
(OBAC) Select New Entries Button
Define Time Dependent Terms: Same Path ( Next Line to Last Path)
Select New Entries Button 1
Int. Cal Indicator P1
Currency Key INR
Effective From 01.04.09
Sequential No 1
Term Select Cr. Interest : Balance Interest Calculation
Ref. Int. Rate P2
Select Save or Ctrl +S-----> press Enter to Save in your request.
Enter Interest Values: Same Path ( next line to last path) ( TC=OB83)
Select New Entries Button
Reference Interest Rate P2 P3
Valid From 01.04.09 01.04.09
Interest Rate 10% 8%
Select Save or Ctrl +S-----> press Enter to Save in your request.
57
Step 2. Creation of GL Masters: ( FS00)
As we have not created GL Masters for SBI Term Loan and Interest Account ,
we have to create now. Before Creating the GL Master check the Available
A/c Nos in OBD 4 and see the Number Ranges for Account Groups. Select the
available Account Number from that Range
2nd A/c
GL A/c# 400400 Comp.Code: PSL F.Year: 2009
Select With Template Button
GL A/c# 400300
Comp.Code: PSL Press Enter
58
Interest A/c Debit 002 Assaign to 400400
SBI Rupee Term Loan A/c Credit 2000 Assaign to 100300
If More than One Term Loan in Against 2000 '++++++++++ ( 10 Times)
Suppose if we give 6 times + Symbol for SBI Rupee Term Loan . It takes
000010 which it cannot post.
100300 SBI Rupee Term Loan A/c
100301 IDBI Rupee Term Loan A/c
100302 IFCI Rupee Term Loan A/c
At the time of Interest Calculations, we have to specify for which Loan
Account Interest to be calculated and when.
in this case, SBI Calculate Interest from 15.04.09 but SAP calculate Interest from
17.04.09. So to match the Interest, SAP Has given the option of Value Date.
Value date is 15.04.09. So system will calculate interest from Value Date but
not
from Posting Date. Value date is modifiable after positng the document also.
INTEREST CALCULATIONS:
PATH: Accounting---->Financial Accounting ---->General Ledger---->Periodic
Processing---->Interest Calculations---->Balance Interest Calculation( F.52)
Come Back to 1st Session : Select Execute Button . We can see New Interest
Calculation on Screen with 10% and 12% rates.
60
Select Back Arrow
Cal.Period 01.04.09 to 30.04.09
Post Interest Check Box
Update Master Records
Session Name PSL
Posting to Buss Area PSLH
Posting Dt. Of Session 30.04.09
Document Dt. Of Session 30.04.09
Posting Segment Text Interest of April 2009
Execute ( F8) it shows the interest amount calculated
Key Date of Last Int. Cal 30.04.09 (Upto which date we have calculated interest)
Date of Last Run 31.07.09 (ON which date we have run the Interest Cal)
61
3 Int. Calculation from 15.04.09 to 14.05.09 ( instead of 01.04.09 to
30.04.09) SPRO--->Prepare A/c Balance Interest Calculation ( OBAA)
Enter Settlement Day 14.
2nd A/c
GL A/c# 300100 Comp.Code: PSL F.Year: 2009
Select With Template Button
GL A/c# 400300
Comp.Code: PSL Press Enter
3rd A/c
GL A/c# 400301 Comp.Code: PSL F.Year: 2009
Select With Template Button
GL A/c# 400300
Comp.Code: PSL Press Enter
63
Step 4. Define Valuation Methods:
SPRO---->Financial Accounting(New)---->GL A/c ( New)---->Periodic Processing---->
valuate--->Define Valuating Methods
Select New Entries Button
Valuation Method PSL1 (Text Field)
Description FC Valuation for PSL (Bank Selling Method)
Select Always Evaluate Radio Button
Document Type SA
Ex Rate type for Dr. Balance B (Bank Selling Rate)
Ex Rate type for Cr. Balance B (Bank Selling Rate)
select Determine Exchange Rate Type for A/c Balance Radio Button
SAVE Enter to save in your request.
Step 5. Define Valuation Areas:
Same Path ( Next Line to Old path)
Select New Entries Button
64
Step 8. Assaign Exchange Rate Difference Key in Loan A/c ( FS00)
GL A/c : 100301
Comp. Code : PSL
From Menu----> GL Account----> Change
Select Control Data Tab
Exchange Rate
Difference Key
USD SAVE
{3} FC Valuation:
Accounting ----> Financial Accounting---->Gen Ledger---->Periodic Processing---->
Closing--->Valuate---> FC Valuation(New) ( TC=FAGL_FC_VAL)
65
There are 2 types of FC Valuations.
1) Month End Valuation
2) Year End Valuation
IN FAGL_FC_Val Screen
Comp. Code: PSL Valuation Key Date: 31.08.09 ( Every Month End)
Valuation Area: PA
Select Create Posting Check Box
Post.Date: 31.08.09 Reverse Posting Date: 01.09.09
select Reverse Posting check Box
Select GL Balance Tab
Select valuate GL A/c Balance Check Box
GL A/c: 100301 Select Execute Button ( F8)
IN FAGL_FC_Val Screen
Comp. Code: PSL Valuation Key Date: 31.03.10 (F.Y.End Date)
Valuation Area: PA
Select Create Posting Check Box
Post.Date: 31.03.10 Reverse Posting Date: Blank
De select Reverse Posting check Box
Select GL Balance Tab
Select valuate GL A/c Balance Check Box
GL A/c: 100301 Select Execute Button ( F8)
In Normal Accounting for Raw Material Purchases accounting entry would be like below:
Purchases A/c Dr
To Party A/c ( Supplier Account ) Cr
Where as in SAP Entry would be like below:-
Inventory Raw Material A/c Dr ( General Ledger )
To Party A/c ( Supplier Account ) Cr ( Subsidery Ledger)
If the Entry will be like above, Trial Balance will not match as in Trial Balance only
Balances
of General Ledgers will affect but not the Subsidery ledgers. To overcome this problem,
SAP
automatically passes one more entry internally as and when we pass the first entry .
SAP passes Internal Entry to Sundry Creditors RM A/c ( General Ledger ) which is a
Reco Account or Control Account. If I want to see , One party account we can go to
party account. If I want to see all subledgers, we can go to Sundry Creditors RM a/c
Select SAVE or CTRL+S----> Select Create Request Button and save in your request.
Short Description : AP Customization for PSL ENTER
Press Enter to Save in your request.
Select Next Entry Button to create one more Group of MM Vendors for PSL
69
Step 3. Assaign No Range Group to Vendor Account Group:
SPRO----> Financial Accounting---->Account Receivable & Accounts
Payable----> Vendor Accounts---> Master Data---->Preparation for Creating
Vendor Master Data---->Assaign Number Range for Vendor A/c
Select Position Button
GL A/c 200100
Comp. Code PSL ENTER
Change Short Text and GL A/c Long Text to "Inventory RM"
Select Create/Bank/Interest tab
Select Field Status G001
De Select Relevant to Cash Flow Check Box SAVE
GL A/c 100500
Comp. Code PSL ENTER
Change Short Text and GL A/c Long Text to "Sundry Creditors for RM"
Select Control Data tab
Select Field Status G001
De Select Only Balances in Local Currencies Check Box
Recon A/c for Account Type: Vendor
Deselect Optimum Management Check Box
Sort Key 012 ( Vendor Account Number)
Select Create/Bank/Interest tab
Select Field Status G067 ( Recon A/c ) SAVE
70
Step 6. Creation of Vendor Masters:
PATH: Accounting ----> Financial Accounting ---->Accounts Payable----> Master
Records--->Maintain Centrally---->Create ( TC=XK01)
Company Code: PSL
A/c Group: PSL1 FI Vendors for PSL ENTER
Title : Company ( Select from Drop Down Box)
Name : Godrej Steel Limited
Street /House #: Ameerpet Postal Code: 500000
Country: IN Communication: EN ( English)
Telephone: 66611983
71
Select Back Arrow 3 Times
Doc.3 Select Type KA ( Vendor Document)
Select Details Button
Number Range 17
Select No Range Information Button
Company Code PSL
Select Change Interval Button
Select Interval Button
Give No Range 17
Year 2009
From No 300001
To No 400000 ENTER SAVE
Ignore Warning Message and Press Enter .
HOUSE BANKS :-
Scenario 1:
SBI Main Branch
A/c Ids C. A/c 1 C. A/c 2 C. A/c 3
Scenario 2:
SBI Main Branch SBI Begumpet Branch
Bank St. Hyd Hyd
Current A/c #1 Current A/c #1
1 House Bank 1 House Bank
1 A/c Id 1 A/c Id
House Banks will be created Branch wise
Step 1. Creation of GL Master( FS00): SBI Current account under Current Assets and
Loans and Advances
GL A/c : 200105 Comp.Code: PSL Select With Template Button
GL A/c : 200100
Comp.Code : PSL ENTER
Change Short Text & Long Text to SBI Current Account and Save
72
Step 2 Define House Bank:
SPRO---->Financial Accounting--->Bank A/c---->Define House Bank ( TC=FI12)
PAYMENT METHODS :
Manual Payment Method Automatic Payment Method
1 Check Lot can be Sequential or 1 Check Lot should be only Sequential
Non Sequential
2 We can issue any cheque any time 2 First Cheque will be 500001 and 2nd
Check should be 500002. It should be
In sequential
73
END USER AREA:
Step 1. Purchase Invoice Posting :
Accounting ---> Financial Accounting--->Accounts Payable---->Document Entry--->
Invoice General ( F-43)
While at the time of Creating the Vendor Master, We mentioned Sort Key
012
(Vendor Number). Sort Key update the Assaignment Fields Automatically
74
Under Bank Data
Step 8. Check Encashment Date Updation: Here we specify on which date the check
is debited in our Bank Account, Based on Bank Statement .
Advantages:
A) If party says payment was not received , we can say on which date
payment was debited to our account easily.
B) BRS can be done easily
75
Go and see Check Register ( FCHN) :
Paying Comp. Code: PSL -----> Execute ( F8)
We can see Report Showing Check Encashed Date
Once the Check Lot is over , Keep the Curosor on Check No From To Select
Sorting Ascending Order Button. We can see all the chek details in Sr. No of
Checks If any chck Number is missing in order, it means Chck is misused.
78
Step 4. Purchase Invoice Posting agaisnt Advance Amount (F-43):
Doc.Date: 07.08.09 Comp. Code: PSL TYPE: KR
Post. Key: 31 A/c # 4400001 ENTER
Amount: 15000 Buss.Area: PSLH
Text: Purchase Invoice Posting
Post Key: 40 Account No: 200120 ENTER
Amount: * Buss.Area: PSLH Text : +
Menu Document Simulate & Save
We can see Rs. 15,0000 ( Dr) and Rs. 15,000 ( Cr). Net Effect will be Zero , but
presentation in Balance Sheet will be Wrong. As 15,000 ( Dr.) Balance will appear
on Assets Side and 15,000 Cr will appear on Liabilities Side.
Step 5. Transfer of Advance from Special GL A/c to Normal by Clearing Special Clearing
Items ( F-54):
79
SAVE
Double Clik on 15000 ( Cr) and 15,000 ( Dr)
We can see report showing 15,000 Debit and Credit under Cleared items
1 Creation of GL Master " Cash Discount Received" under Other Income( FS00)
GL A/c: 300101 Comp Code: PSL Select With Template
GL A/c: 300100
Comp Code: PSL ENTER
Change Short Text & Long Text to "Cash Discount Received" SAVE
81
2 Assaignment of Accounts for Automatic Postings:
PATH: SPRO---->Financial Accounting---->Accounts Receivble & Accounts
Payable--->Business Transactions---->Outgoing Payments----> Outgoing
Payments Global Settings---->Define A/c's for Cash Discounts taken(OBXU)
Select Change Layout Button : From Hidden Fields Column Select " Currnet Cash
Discount Amount"
Select Amount in Local Document in Currency under Column Contents Side
Select Left Arrow or Show Selected Fields Button
Select Copy Button
82
3 Outgoing Payment with Clearing ( F-53)
Doc.Date 08.08.09 Type: KZ Comp. Code: PSL
Clearing Text: Outgoing Payment
A/c Under Bank Data:
A/c# 200105 (SBI Current Account)
Bus.Area PSLH
Amount: 97000 (* Amount Paid is 97000 only as 3% CD
Text: Outgoing Payment can be availed as payment is below 10days)
The Checks will be issued from the Lots specified for APP. Check Lot should
be Sequential. This APP will be used normally by Cash Rich Companies not
by all Companies. They run Every Week (or) 10 days ( or) 15days once. We
are not
Programmers. We use system Given Payment Programme, Check Format and
Payment advice Format.
Before Run we have to give Bank Wise Ranking wit available amounts.
Bank Rank Available
Amount
SBI 1 1000000
ICICI 2 500000
IDBI 3 300000
System will issue checks first from Rank 1 Bank , then it will go to Rank 2.
Like that it issues checks based on ranks upto available amount.
When we run the programme. It first give a Proposal . In the proposal it shows
for which parties, for which invoices for which amount and from which bank
it is going to issued checks. We can Edit the proposal by Blocking some
invoices for payment or by changing banks for payment.
Blocking of Invoices Means: If we have funds for payment of 8 Bills , but as per
the Programme Payable Bills came 12, we can drill down the gross amount
payable to any party and block some bills for payment from that proposal.
Changing of Bank can be done when any Vendor requested to make payment
from specific bank, and as per programme, system allotted another bank, we can
make changes in Bank for issuance of Check.
83
Customization of APP:
Step1. Set up Payment Methods per Country for Payment Transactions:
PATH: SPRO---->Financial Accounting ----> Accounts Receivable&
Accounts
Payable---->Business Transactons--->Outgoing Payment----
>Automatic
Outgoing payament---->Payment Method/Bank Selection for
payemnt
Programme---->Set up payment Methods per country for payment
transactions
Step2. Set up Payment Methods per Company Code for Payment Transactions:
PATH: SPRO---->Financial Accounting ----> Accounts Receivable&
Accounts
Payable---->Business Transactons--->Outgoing Payment----
>Automatic
Outgoing payament---->Payment Method/Bank Selection for
payemnt
Programme---->Set up payment Methods per Company Code for
payment transactions
Select New Entries Button
Paying Company Code: PSL Minimum Amount 100
Payment Method: M Max. Amount : 9999999999
Select Payment Per Due Date Check Box
Select Form Data Button
Form for Payment Medium F110_PREMIUM_CHECK ( SAP Script)
Authorised Signatory
SAVE ENTER to save in your request.
84
Step4. Setup paying Company Codes for Payment Transactions
Same Path ( Next Line to last path)
Select New Entries Button
Paying Company Code: PSL
Select Forms Button
Form for the Payment Advice: SAP script F110_D_AVIS
Select Sender Details Button
Text ID: Select ST ( ST stands for Standard Text)
Letter Header: F_0001_Header
Footer: F_0001_Footer
Sender: F_0001_Sender SAVE
ENTER to save in your request.
I. Payment Block: If we dont want to issue any cheks in APP, we can select * ( Skip A/c)
Option and Select payment Block
II.Alternative Payee PSL has to pay GSL. GSL has to make payment to XYZ. GSL
requested
to issue check in the name of XYZ instead of GSL. Here Clearing
Party
will be GSL and check will be issued in the name of XYZ.
III. House Bank: If PSL and GSL both are having Bank Account in ICICI and GSL
requested to make payment from ICICI then House Bank will be ICICI
IV. Individual Pay: If 5 Bills are due to GSL. System will generate 1 check for all the 5 bills
If GSL asked to issue a separate check for each bill , we select this
option. So System will Generate individual payment
85
END USER AREA :
86
? Importance of Next Payment Date:
If purchase Terms of Payment are like below
Within 15 days ----> 3% Cash Discount
Morethan 15 days ----> No Discount
If we make payment on 11.08.09 we get 3 % cash
Discount
If we make payment on 21.08.09 we get 3% cash
discount
So, system will not make payment on 11.08.09 as we are getting same 3%
cash discount on 21.08.09 also . System automatically controlling cash
flow.
Select Edit Proposal Button :
Double Click on Vlaues # System Sbows outgoing bills details
We can see that Chck was posted against the outstandign amount
89
Sr. No Nature of Transaction TC
44 To see the steps saved in our request SE09
To view Path for any TC: in Commad Field enter Search_Sap_Menu --->
45 ENTER Type TC for Search Text
Entry Field
46 Posting Key for General Ledger Debit Posting in F-02 40
47 Posting Key for General Ledger Credit Posting in F-02 50
48 Creation of Vendor Account Groups SPRO
49 Create Number Ranges for Vendor Accounts XKN1
50 Assaign Number Range to Vendor Account Groups SPRO
51 Creation of Tolerance group for Vendor Accounts SPRO
52 Creation of Vendor Master XK01
53 Document Types and Number Ranges OBA7
54 Defining House Bank F112
55 Creation of Check Lots F110
56 Purchase Invoice Posting F-43
57 How to View Vendor Account Transactions FBL1N
58 Outgoing Vendor Payment with Clearing F-53
59 Manual Check Creation FCH5
60 Display Check Register FCHN
61 Check Encashment Date Updation FCH6
62 Cancellation of Unissued Checks FCH3
63 Creation of Void Reason for Check Cancellation FCHV
64 Deletion of Encashment Date of Check FCHG
65 Cancellation of issued Checks before encashment FCH8
66 Creating Link between Sundry Cr and Advances to Vendors OBYR
67 Advance Payment Postings to Vendors F-48
Transfer of advances from Spl.GL to Normal by Clearing Sppecial Clearing
68 Items F-54
69 Clearing of Normal Items under Accounts Payable F-44
70 Assaignment of Account for Automatic Payment OBXU
71 Setup Payment methods per country for payment transactions SPRO
72 Setup Payment methods per Comp. Code for payment transacts SPRO
73 Setup all Company Codes for payment Transactions SPRO
74 Setup Paying Company Codes for payment Transactions SPRO
75 Creation of Sequential Check Lots FCHI
76 Assaign Payment Methods in Vendor Masters XK02
77 Setup Bank Determination for Payment Transactions FBZP
78 Automatic Payment Programme Run F110
79 Credit Memo Posting F-41
80 Posting Key for Vendor Credit 31
81 Posting Key for Vendor Debit 25
90
ACCOUNTS RECEIVABLE
This is also subledger ( Subsidary Ledger) . This is used when Sales & Distribution
Module is not implemented for all types of Sales. Ex: for Product Sales / Scrap Sales/
Asset Sale When SD Module is implementing , this is used for Scrap Sale / Asset Sales,
Other than Product Sales. Product Sales will be used in SD Module.
in case of Sales:
Customer A/c Dr. Sub Ledger Sundry Dr. A/c
(General Ledger)
To Sales A/c Gen. Ledger A/c Reconciliatino Account
or control account.
When we make net payment or when we receive Net amount , we have to clear
Vendor as well as Customer Transactions.
91
Customization :
Step 1. Creation of Customer Account Groups
PATH: SPRO---->Financial accounting ---->Accounts Receivable &
Accounts
Payable----> Customer Accounts ---->Master Data---->Preparations
for
Creating Customer Master Data---->Define Account Groups with
Screen Lay Out ( Customers)
Select New Entries Button
Account Group: PSL1 ( Text Field)
Name : FI Customers for PSL
Double Click on Company Code Data
92
Step 4 Creation of 2 GL Masters ( FS00)
A/c #1 GL A/c: 200110 Comp. Code: PSL Select With Template Button
GL A/c: 200150
Comp. Code: PSL ENTER
A/c #2 GL A/c: 300000 Comp. Code: PSL Select With Template Button
GL A/c: 300100
Comp. Code: PSL ENTER
93
Select DZ Customer Payment
Select Details Button
Number Range: 14
Select Number Range information Button
Company Code: PSL
Select Change Intervals Button
Select Intervals Button
No. Range 14 Year : 2009
From No: 500001 To No 600000 ENTER &
Ignore Warning Message and Enter SAVE
Press Back Arrow 3 Times
Select DA Customer Document
Select Details Button
Number Range: 16
Select Number Range information Button
Company Code: PSL
Select Change Intervals Button
Select Intervals Button
No. Range 16
From No: 600001 To No 700000 Year : 2009
Ignore Warning Message and Enter ENTER & SAVE
We can see report that 200000 receivable . If We select Vendor Items Check Box also
we can see Vendor A/c & Customer transactions Together.
94
Incoming Payment and Clearing Vendor & Customer Transactions:
Step A: Document Type DZ( Customer Payment should allow Vendor Trnasactions also
A: Assets A: Assets
D: Customers---> Selected D: Customers---> to be Selected
K: Vendors----> to be selected K: Vendors----> Selected
M: Materials---> M: Materials--->
S: GL Masters---> Selected S: GL Masters---> Selected
95
Advance Receipt from Customers ( Down Payments Received ) :
Normally after sales we receive payment from Customer. In this case, we
received advance from Customer and after that sales were made.
Step 1. Creation of Advance from Customers under Current Liabilities and Provisions
FS00
GL A/c # 100502
Comp.Code: PSL Select With Template Button
GL A/c # 200110
Comp.Code: PSL
Under Bank:
A/c# 200105 Buss. Area: PSLH
Amount: 30000 Text: Advance Receipt Pisting
ENTER
Amount : * Buss. Area: PSLH Text : +
Menu----> Document -----> Simulate & SAVE
96
Step 4 Go and See Customer Account Transactions ( FBL5N)
97
Step 9 Clearing of Normal Itmes: ( F-32)
Accounting --->Financial Accounting ---->Accounts
Receivable---> Accounting ---> Clear ( F-32)
BILL DISCOUNTING :
Normally Banks are offering 2 Types of Facilities.
1. Fund Based Banking Facilities
2. Non Fund Based Banking Facilities
Step 2. Link Between Sundry Debtors and Sundry Debtors Bills of Exchange:
Step 3
Define Banks of Sub Accounts:
Upto Bills of Exchange Receivable Path is same----> Present Bill of
Exchange Receivable Bank---->Define Bank sub Account ( TC=OBYK)
Select New Entries Button
COA Bank A/c Usage SGL Ind Customer Bank Sub A/c
Recon A/c for Liability
PSL 200105 DiscountingW 200110 100302
( SBI Bill Discounting A/c)
SAVE ENTER to save in your request
100
END USER AREA:
101
Step 4Report to View Customer wise, Bill Wise, Due Date Wise and Bank Wise O/s:
Path: Accounting ---> Financial Accounting --->Accounts Receivable ---> Periodic
Processing--->Bills of Exchange Processing --->Korea---->B/E Management
( TC= S_ALR_87012213)
COA : PSL GL A/c: 200111 Comp. Code: PSL
Special GL Indicator : W Usage: D ( Discounting )
select Discounted/ Collected Radio Button Execute ( F8)
Select Change Layout Button
Keep fields Due Date, Doc # , Customer No, Received from, Doc Dt,
Domicile, Amount in Local Currency Select Copy Button
REVERSE OF CONTINGENT LIABILITY:
Accounting --->Financial Accounting---->Accounts Receivable--->
Document Entry--->Bills of Exchange--->Reverse Contingent Liability
( TC=F-20)
Doc.Dt: 11.09.09 Type: DA Comp. Code: PSL
Bills of Exchange
Selection Usage: Discounting
GL A/c : 200111 Due By: 30.09.09
Customer: 3000001 Ignore Warning Message Press ENTER
Select Edit Line Items Button
Command: + ( Set Items to Active) SAVE
MENU----> Document ---->
Display If the Bill is Dishonour by
Customer :
The Contingent Liability Becomes Actual Liability when the Bill is
dishonoured by Customer. We have to Reverse Contingent Liability and Pass
Customer A/c Dr.
To SBI C/A
If customer paid to Bank for Bill Nos 2,3 & 4, then we can select like below
Bill No {OR} {OR}
1 - If we are using "++" or "--" it
2 + ++ should be marked from and to
3 + Bill. In between the marks all bills
4 + ++ will be active or inactive.
5 -
Dunning means Reminder. If the customer does not make the payment as per the
payment terms, we can issue Dunning ( Reeminder) Letter to Customer from SAP.
In Case of Big Companies Separate Marketing Head from Each Region wants to
issue
Dunning Letters to his Area Customers. In this Case Dunning area will be Region
In Case of Small Companies, One Marketing Head for all the Regions . In this case
Dunning area will be Company Code as a whole
Dunning Levels: Dunning Levels means Types of Letters. There are Maximum
9 levels in SAP. But we are using 4 levels.
Dunning Charges: For Sending the letters we can collect Dunnig Charges from
Customers. Dunning Charges can be a Fixed Amount or Percentage Basis
Amount or Percentage can be based on Levels of Dunning .
Dunning Charges will be levied only in the Letters and will not be posted to
Accounts. It will be Done to Threaten the Customer to make the Payment
with in Due Date. If the Customer paid Dunning Charges in Real, then only
posting will be done to " Dunning Charges A/c " as Other Income.
103
Step 2. Define Dunning Procedure: Upto Dunning Path is same--->Dunning Procedure
---->Define Dunning Procedure( FBMP)
Select New Procedure Button
Dunning Procedure: PSL1 ( Text Field)
Name: Dunning Procedure for PSL
Dunning Interval in Days: 10
No. of Dunning Levels: 4
Line Item Grace Period: 3
Interest Indicator 01 ( Standard Item Interest Calculator)
Select Standard Transaction Dunning Check
Box Select Dunning Texts Button
Ignore Warning Message and Press Enter
Company Code: PSL
Select Customer Radio Button
Pres Enter and Select New Company Code Button
Company Code: PSL Press Enter
De-select Dunning by Dunning Area Check Box. If Area is
Blank. Select Separate Notice for Dunning Level Check Box
Select Back Arrow 2 times
Select "Yes" Button Press Enter to save in your request.
104
Step3. Assaign Dunning Procedure in Customer Master:
Accounting ---->Financial Accounting ---->Accounts Receivable--->Master records
---->Maintain Centrally--->Change ( XD02)
105
Select Dunning History Button
Comp. Code: PSL Execute ( F8)
Keep the Cursor on Amount 9999
Select Display Dunning Notice Button
Keep the Cursor on Doc #
Select Print Preview Button ,
Output Device : LP01
Select Contineu Button
SALES TAX
Sales Tax is part of CIN in SAP. CIN mans Country India Version.
If we made Local Purchases or Local Sales i.e., Within State Purchases / Sales
VAT is applicable ( VAT Purchases
/ Vat Sales}
If we made Out of State Purchases/ Sales Central Sales Tax( CST Purchases/ Sales)
Purchases Sales
Local Outside Local Outside
Purchase Purchase Sales Sales
Basic Price 100 100 Basic Price 200 200
Excise Duty ( 6%apx) 6 6 Excise Duty ( 8%apx) 16 16
106 106 216 216
VAT 4% {*} 4.24 VAT 12.5% {?} 27
CST 2 % {**} 2.12 CST( 2%) ( ??) 4.32
Vendor account 110.24 108.12 Customer Account 243 220.32
Note *: will go to VAT Receivable A/c Note ?: Will go to VAT Payable Account
Note **: to be added to Inventory only, No Note??: will go to CSTG Payable Account
adjustment is possible for CST.
106
Payment to Sales Tax Dept: Payable
A) Local Sales - Local Purchases (27 - 4.24) 22.76
B) Local Sales - CST Sales (27-0) 27
C)CST Sales - Local Purchases (4.32-4,24) 0.08
D)CST Sales - CST Purchases (4.32-0) 4.32
Customization :
Step 1: Define Tax Procedure:
PATH: SPRO---->Financial Accounting ---->Finanial Accounting Global
Settings---> Tax on Sales / Purchases----> Basic Settings--->Check Calculation
Procedure
Double Click on Define Procedure
Select New Entries Button
Procedure Description
PSL Tax Sales Tax India SAVE
( Text Field)
ENTER to save in your request.
Select PSL Tax
Double Click on Control Data Folder
Select New Entries Button
Step Contition From To A/c Key
Type Description
10 BASB Base Amount - - -
20 MWVS Input Tax 10 10 VST ( Input Tax)
30 MWAS Output Tax 10 10 MWS(Output tax)
SAVE
107
Tax Code: V0 ENTER
Description : 0% Input Tax
Tax Type: V ( Input Tax) ENTER
Tax %
Input Tax 0%
Output Tax Keep cursor on Out Put tax % and select Deactivate
Button SAVE
Enter TC=FS00
1st a/c GL A/c : 200155 Comp. Code : PSL Select with template
GL A/c : 200120
Comp. Code : PSL ENTER
Change Short Text and GL A/c Long Text to " VAT Receivable Account"
Select Control Data tab
Tax Category: * ( All Tax types allowed)
108
select Posting Without Tax Allowed Check
Box select Create/ Bank/ Interest tab
Change Field Status group to G041 ( tax office clearing account )
SAVE
2nd a/c GL A/c : 100505 Comp. Code : PSL Select with template
GL A/c : 200155
Comp. Code : PSL ENTER
Select Type / Description Tab
Change Account Group to Current Liabilities & Provisions
Change Short Text & Long Text to " VAT Payable A/c" SAVE
In Live Environment:
FI Consultants Job: 1. Define Tax Procedure
2. Define Tax Codes
3. Creation of GL Accounts
4. Assaign GL Accounts
109
In MM Module:
Purchase Order Material 1
Vendor 1234
Qty 1 Kg
Rate 100 Rs
Tax Code: V1 ( Input Tax)
Procedure:
Base Amount( 1kg x 100) = 100 Inventory Account
Tax Input V1 ( 4%) = 4 Vat Receivable account
Vendor Credit 104
IN SD Module:
Sales Order Material 1000
Vendor 4567
Qty 1 Kg
Rate 200 RS
Tax Code: A1 (Output Tax)
Procedure:
Base Amount( 1kg x 200) = 200 Sales Account
Tax Input A1 (12.5%) = 25 Vat Payable account
Customer Debit 225
IN FI Module :
Customer A/c Dr. 225
To Sales 225 once we save the entry systme will pass
entry like below
Customer A/c dr 225
To Sales A/c 200
To VAT Payable 25
These entries will pass automatically when MM Module is activated and
documents posted in MM Module. But for our example Now, we are testing
only in FI.
Not in MM Module
110
WITH HOLDING TAX ( TDS)
TDS is part of CIN ( Country India Version)
TDS stands for Tax Deducted at Source
TCS stands for Tax Collected at Source
Upto SAP Version 4.7C , SAP has given 2 packages in India. SAP +CIN
from Version 4.7EE on wards CIN is part of SAP
There are 2 types of Withholding tax in SAP
As Procedure is same, we are Testing only " TDS on Contractors" for Testing
Purpose ( IT Sec 194C)
111
6. TDS Deducted should be deposited within 7 days from the month end.
in case of Year End credits, to be deposited within 2 months from the end of the
year.
7. If 7th day come on Holiday choice to make payment 1 day before or after.
8. If the Bill amount includes material cost and conversion charges, we have
the option to deduct TDS on Full Amount or only on Conversion Charges
9 Issue TDS Certificates in Form 16A should be issued within 1 month or
we can issue consolidated certificate for the whole year within 1 month from the
end of Closing Financial Year.
10. File Quarterly Return in form 26Q
11. Tax deducted at source can be obtained at company code level/ Business Area
Level/Business Place Level.
CUSTOMIZATION:
112
Step 2: Check Withholding Tax Countries:
SPRO--->Financial Accounting--->Financial A/c Global Settings--->
Withholding Tax---->Extended Withholding Tax---->Basic Settings--->
Check withholding tax countries
Select New Entries Button
Country : IN
W/Tax Country: IN
Description : India SAVE
Save in AP Customization Request
Code Code ID
PSL PSLF PS Day Before ( Select from Dropdown Button)
113
Step 6: Define Business Places:
Menu-->System-->Services-->Table Maintenance--->Extended Table
Maintenance ( SM30)
Country : IN ENTER
Select New Entries Button
Withhold Tax Type P1
Description : Sec194C Contractors Invoice Posting
Under Base Amount
Select Gross Amount Radio Button
Select Withhold Tax Commercial Rounding Radio Button
Select Post Withhold Tax Amount Check Box
Select No Accumulation Radio Button
Save ----> Press Enter to save in your Request.
114
Select No Accumulatio Radio Button
** Select Central Invoice Proportionate Radio Button
SAVE ENTER to save in your request
115
Step11: Check Receipient Types :
Upto Extendted Withholding Tax Path is same--->Basic Settings--->
Check Recipient Types
Country Key: IN ( India) Enter
Select New Entries Button
Withholding Tax Type: P1
Receipient Type: CO ( Text Field)
Text : Company
2nd : Withholding Tax Type: P2
Receipient Type: CO ( Text Field)
Text : Company
SAVE Enter to save in your request.
116
Step15: Creation of 2 GL Masters ( FS00)
a) Conversion Charges under Manufacturing Group
b) TDS on Contractors under Current Liabilities& Provisions
FS00 Enter
Select With Template
1st A/c GL A/c: 400200 Comp.Code: PSL
GL A/c: 400100
Comp.Code: PSL Enter
117
At the time of making payment We seelct receipt type = CO
Bills to select 1,2,4== 7000
118
Step22 Maintain Numbe Groups & SAP Script Forms( for TDS Certificates)
Upto Extended W/Tax Path is same--->Postings--->India---->W/Tax
Certificates for Vendors & Customers--->Maintain No. Groups & SAP
Script Forms
Select New Entries Button
Co.Code Sect. Code Off. Key Form
PSL PSLF 194C J_1IEWT_CERT
SAVE Enter to save in your request.
119
END USER AREA:
Option1 : If the Bill amount is less than 20,000 and in the whole year contracts gross
value is less than 50000, No TDS to be deducted . Remove P1 from PA
Option2 :If the Bill includes Material Value of Rs. 30,000 and Conversion Charges
are Rs. 70,000. TDS should be deducted on 70,000 but not on
100,000. Withholding Tax Base is 70,000 for P1. and Remove PA
Option3 :If the Bill is only for Conversion charges of Rs. 100,000, TDS should be
deducted on 100,000. Remove PA
120
Step 3: Enter Bank Challan : Same Path ( J1INBANR)
from 2009 New Quarterly Return ( Form 26Q) introduced which is not
in the learning package for which TC=J1INQEFILE
CASH JOURNAL
We can get Daily Cash positions by Opening Balance+Receipts-
Payments Some Companies will use this for Petty Cash purpose
Cash Journal will not accept Negative Cash Balance
Change Short Text & GL A/c Long Text to "Hyd City Office Cash A/c"
Select Create/Bank/Interest Tab
Select Post Automatically only Check Box SAVE
Enter to save in your request.
121
Step2: Define Number Range Intervals for Cash Journal Documents:
SPRO--->Financial Accounting --->Bank Account--->Business Transactions
--->Cash Journal--->Define No Range Interval for --->Cash Journal Doc
122
END USER AREA:
BANK RECONCILIATION
Sales Scenario:
123
2. Check Deposit
A) Bank Key E) Customer Number
B) Bank A/c No F) Ref. Bill No
C) Transactions G) Amount
D) Group
SAVE
IDBI Check Deposit A/c Dr 200000
to Customer A/c with Clrg 200000
124
2nd a/c GL A/c: 200131 Comp. Code: PSL Select With Template
GL A/c: 200130
Comp. Code: PSL ENTER
Change ST & LT to IDBI Check Issue A/c
Selct Control Data Tab
Select Open Items Management Check Box SAVE
3rd a/c GL A/c: 200132 Comp. Code: PSL Select With Template
GL A/c: 200131
Comp. Code: PSL ENTER
Select Type/ Description Tab
Change ST & LT to IDBI Check Deposit A/c SAVE
4th a/c GL A/c: 400304 Comp. Code: PSL Select With Template
GL A/c: 400300
Comp. Code: PSL ENTER
Select Type/ Description Tab
Change ST & LT to Bank Charges Account SAVE
125
Step 4: Define Posting Keys and Posting Rules for Check Deposit:
SPRO--->Financial Accounting--->Bank Accounting--->Business
Transactions--->Check Deposit--->Define Positng Keysand Posting Rules
for Check Deposits
Chart of Accounts: PSL ENTER
Select New Entries Button
Account Text
( Text Field)
PSLA Main Bank
PSLB Check Issue
PSLC Check Deposit
PSLD Bank Charges SAVE
ENTER to save in your request
Double Click on Accounts to Assaign A/c Symbols Folder
Select New Entries Button
A/c Symbol Currency GL A/c
PSLA INR +++++ ++++0
PSLB INR +++++ ++++1
PSLC INR +++++ ++++2
PSLD INR 400304 SAVE
126
Select New Entries Button
Post. Rule : PSL4 Post Area 1 ( Bank a/c)
Doo. Post Key: 40 Cr. Posting Key : 50
DrA/c Symbol PSLD Cr. A/c Symbol" PSLA
Doc. Type: SA
Post Typ:: 1 ( Posting SAVE
Step 7: Create and Assaign Business Transactions for Manual Bank Statement
Upto Business Transactions Path is same--->Payment Transactions--->
Manual Bank Statement---->Credit and Assaign Business Transactions
Select New Entries Button
127
Purchase Scenario:
1. Purchase Invoice Posting ( F-43) Doc #
Inventory Raw Material A/c Dr 50000 100001
to Party Account 50000
To Make Text Field Optional for Field Status Group G-001 and G-005
TC= OBC4 ENTER
Field Status Variant PSL
Double Click on Field Status Group Folder
Double Click on G-001
Double Click on General Date
Make Text Optional Field SAVE
ENTER to SAVE In Your request.
Double Click on G-005
Double Click on General Date
Make Text Optional Field SAVE
ENTER to SAVE In Your request.
128
Step 2 Manual Check Deposit ( FF68)
Accounting ---->Financial Accounting ---->Banks--->Incomings---->Check
Deposit---->Manual Entry
From Menu---> Settings---> Specifications
129
Step 5 Enter Manual Bank Statement ( FF67)
Accounting --->Financial Accounting ---->Banks---->Incomings--->Bank
Statement---->Manual Entry( FF67)
From Menu---->Settings---->Specifications
Short Variant: PSL2 ENTER
Bank Key: PSLIDBI1
Bank A/c: IDBI12345
Currency: INR
Settlement No: 1
Statement DT: 28.08.09
Opening Balance: 0
Closing Balance: 200000
Posting Date: 28.08.09 ENTER
Ignore Warning Message ENTER
Purchase Scenario:
Step 1. Purchase Invoice Posting (F-43)
Doc.Dt: 29.08.09 Type: KR Comp. Code: PSL
Post Key: 31 A/c # 4400001 ENTER Amount : 50000
Buss.Area: PSLH Text: Purchase Invoice Posting
Post Key: 40 A/c # 200120 ENTER Remove TDS Codes
Amount : * Buss.Area: PSLH Text: +
Menu----> Document ----> Simulate & SAVE
130
Step 4. Enter Manual Bank Statement ( FF67)
131
ASSET ACCOUNTING
This is also a Sub Ledger ( Subsidery Ledger)
Chart of Depreciaion: Asset Customization steps will be made for Chart of
Depreciation and Chart of Depreciation will be assaigned to Company Code
/Comp.
Codes.
In SAP we dont have option of creating the Chart of Depreciation for our own
company But SAP has given the option to copy the Existing Chart of Accounts of
Germany or Indian. We have to copy either Germany Chart of Depreciation or
Indian Chart of
Depreciation and make changes according to our company Porocedure.
Depreciation Keys: Depreciation Keys are nothing but Rate+ Method say
5% SLM or 5%WDV
Posting Keys: We use the Following Posting Keys in Asset Accounting
[A] Sub Asset Master is to be created with reference to the Main Asset Master
[B] Main Asset Master is to be created with Asset Class
[C] Account Determination is specified in Asset Class
[D] For Account Determination we Assaign G L Account based on Nature of
Transaction
132
We will create the Accounts and Determine Accounts like below for Asset
Accounting Testing Purpose
CUSTOMIZATION :
134
Step 4. Create Screen Layout rules :
Same Path
Select Layout 1000, 1100,2000,2100,2500,3000
Select Copy as Button
135
Step 6. Define Asset Class:
Path is Same (TC=OAOA)
Select New Entries Button
1st Asset: Asset Class: PSL1000 ( Text Field)
Description : Free Hold Land
Short Text: Free Hold Land
A/c Determination: Select PSL10000 (LAND)
Screen Layout Rule: Select PSL1 (LAND)
No. Range: 01
** Select Include Asset and Inventory Data Check Box
Select No AUC or Summary Management of AUC Radio Button
(AUC Stands for Asset Under Construction)
Select SAVE or Ctrl +S ENTER to save in your request.
136
5th Asset: Asset Class: PSL3000 ( Text Field)
Description : Furniture & Fixtures
Short Text: Furniture & Fixtures (FUNITURE &
A/c Determination: Select PSL30000 FIXTURES)
Screen Layout Rule: Select PSL4 (FUNITURE &
No. Range: 04 FIXTURES)
Select Include Asset and Inventory Data Check
Box
138
Step 9. Define Screen Layout for Asset Depreciation Areas:
Same Path
Select Screen Layout 2000- Depreciation on Asset Sub No
Level Double Click on Field Group Rules Folder
Dep Key make it Required Entry Field
Deselect Class Check Box
Select Main No Check Box
Select Sub No Check Box
Select Copy Check Box
SAVE-----> Selecgt Back Arrow 2 Times
Why we have to De-select Deactivation Check Box for Land and Capital WIP even though
there is no Depreciation on Land and Capital WIP. At the time of Creating Land Master we
give Capitalization Date which would be Purchase Date of Land or Registration Date and
Rate of Depreciation as "0%"
Layout of 2000 - Depreciation on Asset Sub No Level will be like
below Asset No Main No Sub No Captalization
Date
Mach.1 1 0 20.04.2005
Motor 1 1 02.09.2009
Sub Number for Main Asset No will always be ZERO. Depreciation will be calculated based on
Capitalization Date. Depreciation will be calculated at Sub Number Level.
139
Step 11. Creation of 15 GL Masters ( FS00)
Create 15 GL Masters as mentioned below under the TC=FS00
140
Double Click on Account Determination Folder
Select Account Determination PSL11000 ( Buildings
) Double Click on B/S Accounts Folder
A/c to Determine
Acquisition: Acquisition & Production Costs 200005 ( Buildings)
Loss Made on Asset Retirement w/o Revenue 400303 ( Loss due to Scrap)
Clearing Account Revenue from Asset Sale 300102 ( Asset Sale A/c)
Gain from Asset Sale 300103 ( Profit on Asset Sale)
Loss from Asset Sale 400302 ( Loss on Asset Sale)
ENTER & SAVE Ignore Warning Message and Press Enter
Double Click on Depreciation Folder
Accumulated Dep A/c for Ordinary Depr. 100200 (Acc. Dep Buildings
Exp. A/c for Ordinary Depreciation 400500 A/c) ( Depreciation
SAVE--> Ignore the Warning Message A/c)
141
Double Click on Account Determination Folder
Select Account Determination PSL31000 (Vehicles
) Double Click on B/S Accounts Folder
A/c to Determine
Acquisition: Acquisition & Production Costs 200020 (Vehicles)
Loss Made on Asset Retirement w/o Revenue 400303 ( Loss due to Scrap)
Clearing Account Revenue from Asset Sale 300102 ( Asset Sale A/c)
Gain from Asset Sale 300103 ( Profit on Asset Sale)
Loss from Asset Sale 400302 ( Loss on Asset Sale)
ENTER & SAVE Ignore Warning Message and Press Enter
Double Click on Depreciation Folder
Accumulated Dep A/c for Ordinary Depr. 100215 (Acc. Dep Vehicles A/c)
Exp. A/c for Ordinary Depreciation 400500 ( Depreciation A/c)
SAVE--> Ignore the Warning Message
Step 14. Specify Intervals and Posting Rules: Same Path (TC== OAYR)
Select Company Code: PSL
Doubel Click on Posting Rules Folder
Select Monthly Posting Radio Button
SAVE ENTER to save in your request.
Step 15. Specify Rounding Off Net Book Valeu and/ or Depreciation:
PATH: SPRO---->Financial Accounting---->Asset Accounting----
>Valuation---->
Amount Specifications(Comp.Code/Dep.Area)---->Specify Rounding off Net
Book
Value and /or Depreciation (TC===OAYO)
Ignore Message and Press Enter
Company Code: PSL
Double Click on Rounding Specifications Folder
Select Area: 01 ( Book Depreciation)
Select Details Button
Select Automatically Calculated Depreciation Check Box
Select Rounding Radio Button
SAVE ENTER to save in your request.
144
Note: Some of the Fields in above steps are briefed below for information.
Point 1. Validity Start From : Ordinary Depreciation Start Date
Here Ordinary Depreciation Date means , the date from which system should calculate
depreciation. Normally it should be the Capitalization Date. In some Countries it will be
from 1st of Next month of Capitalization .
Asset Master in India Some other Countries
A. Capitalization DT: 05.09.2009 05.09.2009
B. Ordinary Dep DT: 05.09.2009 01.10.2009
Point 2. Levels
Acquisition Year: 9999 . If we give Acquisition Year as 2009. 5% depreciation
Rate is applicable to only for the assets purchased in 2009. If we mention 9999 ,
5% is applicable to any asset acquired in any year.
Years: 999 (Maximum No. of Years)
If the Depreciation Method is Straight Line Method and Dep Rate is 5% - Life of
asset
can be assuemed as 20 Years, if rate is 1% Life would be 100 Years. But in Written
Down value Method Life of the Asset is difficult to calculate as there would
always be
some remining value. If we select 999 for Years, it will calculate upto any number
of
Years.
Period: 12 Means the number of Months
Basic Value: 01 - Acquisition Value-- it is applicable to Straight Line Method.
In SLM, Dep will be calculated always on Acquisition Value
24- Net Book Value-- it is applicable to Written Down
Method. in WDV dep will be calculated on the Net Book
value.
Percent: Rate of Depreciation
Reduction: Ex: Acquisition Value of the Asset: 100000
Less: Estimated Scrap Value at the end of the
Life of the Asset. 1000
Actual Asset Value for Depreciation Purpose 99000
If we are following 5% Dep Rate in Reduction Method, Dep will be
calculated
on 99,000 but not on 100,000. In India this method is not applicable.
Rem Life: Depreciation will be calculated in 2 ways. One is Percentage Method
Second One is Useful Life Method. In India at Present 2nd Method is not
using by most of the Companies. For Example. If an Asset is Purchased in
2004 for Rs. 100,000 which is having Useful Life of 20 Years. So
Depreciation
Per Anum is Rs. 5,000. If this Company is Implementing SAP from 2009
onwards. Already 5years accounting was done in Other Accounting
Software.
AT the time of Creation of Asset Master in SAP we should mention like
Acquisiton Value : 100,000 , Acc. Depreciation : 25,000. Select Remaining
Life check Box. System will Know Raining Life of Asset is 15 years.
System will calculate depreciation for 15 years only. This system is
applicable
if Depreciation Method is Straight Line Method in which life of asset can
be
assumed. In WDV it is not possible.
145
Step 4. Maintain Period Control Methods: Same Path (TC== AFAMP)
Chart of Depreciation: PSL ENTER
Select New Entries Button
Period Description Acq. Additions Retirement Transfers
Control Year
Method
006 PSL Period Control 01 01 01 01
Method ( Prorata at Period Start Date)
SAVE ENTER to save in your request.
146
( Select from DD Button)
Class: Declining Balance Depr.
SAVE Select Back Arrow 4 times
Select Depreciation Key: PSL2
Select Activate Button SAVE
Select First Page/ Control +Page Up Button on Top Right Side
147
Step 3. Posting of Main Asset Purchase :
Accounting----->Financial Accounting---->Fixed Assets---->Posting---->Acquisition---->
External Acquisition---->With Vendor (TC==F-90)
Note 1st Rule: Sub Asset Master is to Create with reference to the Main Asset
Master. 200001-1 created with reference to Main Asset 200001 Machine No 1.
The other Rules 2nd, 3rd & 4th are same as above .
148
Report1: Report to view Each Sub Asset Wise , Year-wise Values:
Accounting---->Financial Accounting---->Fixed Assets---->Asset---->Asset Explorer
(TC==AW01N)
Give Asset No: 200001-0 ENTER
To view Depreciation Calculations
Select Display Dep. Calculation Button
Select Period Information Button
We can see the Report of Depreciation
Calculation Select Back Arrow
Select Comparisions Tab
Change the Asset to 200001-1
We can see the Depreciation for Sub Number 1
Select Planned Values Tab
Change the Fiscal Year to 2010 ENTER
Select Display Dep. Calculation Button
We can see the Report of Depreciation
Calculation Select Back Arrow
Report2: Report to view All Assets for a Particular Period
Accounting---->Financial Accounting--->Fixed Assets--->Information Systems--->
Report on Asset Accounting --->Asset Balances---->Balance Lists--->Asset Balances--->
By Business Area (TC==S_ALR_87011965)
149
Deselect Test Run Check Box
From Menu---->Program Execute in Background
Output Device: LP01 ENTER ENTER once again
150
Period for which Repeat Run is going on should be in Open .
In the Present Example. When we Selected Repeat Run System will calculate
Depre.
for Machine No 200002-0 from 25.04.09 to 30.04.09 and post in April Month
When we run for May , we have to choose Planned Posting then system will
consider
For Asset 200001-0: Dep from 01.05.09 to 31.05.09
For Asset 200002-0: Dep from 01.05.09 to 31.05.09
3.Restart :
This Option is useful when we have Scheduled Depreciation Run and because of
any
Reasons ( Either Technical or Power Problems) the scheduled Job is not Finished,
System gives a Message that Job is not Completed. Select the Restart Radio
Button
4 Unplanned Posting :
This option is to be selected when the Depreciation Posting is not as per Planned one
In Live Environment, monthly we pass a Provisional Entry in F-02 in stead of
Running Depreciation Programme in SAP. Entry will be like below
SALE OF ASSET: When we sale the Asset , we will transfer the Acc. Depreciation to the
Particular Asset and transfer the Proft or Loss on sale of Asset to P& L A/c
Ex: Suppose if we sold Asset No: 200001-0
Acquistion Value 500000
Less: Accumulated Dep upto 30.04.09 1438
Net Book Value as on 30.04.09 498562
Asset Sale on 01.05.09 501000
Profit on Sale of Asset ( 501000-498562) 2438
Step 1. To Make Asset Retirement Field as Required Field for Field Status Group G052
( Accounts for Fixed Assets Retirement ) (TC==OBC4)
TRANSFER OF ASSET:
We have Asset No 200001-0, we want to transfer this asset from Hyd unit to
Bangalore
Unit. In this type of Transfers we have to transfer the Asset at Cost price. There will
be
no change in the Life of the Asset as it is transferred within the Company Code
Level.
When we are transferring the Asset within 2 units of the same Company
Code,there
will be No PROFIT or NO LOSS. We have to transfer both Acquisition
Value(Gross
Value) and Accumulated Depreciation on that Asset. Eventhough Dep Programme
is
not run, upto the date of transfer depreciation will be considered in sending unit.
From the date of Transfer Depreciation will be considered in Receiving Unit.
152
There are 2 types in Asset Transfers
Two Step Transfer Procedure One Step Transfer Procedure
In this Method first we have to In this method we will create Asset
1 Create Asset Master in Receiving Master and Transfer Values in One
Unit (AS01) Step only
2 Transfer the Asset Values
SCRAPPING OF ASSET:
We have so many assets, out of that Asset Motor 200000-1 is one Asset. If we are not
able to Use/Sold/Trnasfer the asset, we will Scrap it. The Net Book Value of Asset
will be charged to P& L Account.
As per Accounting Standard 28-Impairment of Assets: If the realisable value of the
assets are less than the Net Book Value, and Future Cash Flows are Negative, then
we have to Impair the Asset.
Ex: Acquisition Value: 100000
Acc. Depreciation 20000
Net Book Value 80000
Expected Sale Price 70000
Future Cash Losses Partial Impairment 10000
153
To View Motor Values as on 31.10.2009
( S_ALR_87011965) Press All Selections Button
Company Code: PSL
Buss. Area: PSLH
Report Date: 31.10.09
Select Execute Button ( F8)
Double Click on Dept-A
We can see Assets in Dept-A
ENTER
Amount: 50000 Buss. Area: PSLH
Text: Machinery Purchase Posting
Post Key: 70 ( Asset Debit) A/c No: 500001-0
T. Type: 100 (External Acquisition of Asset) ENTER
Remove TDC Codes and ENTER
Amount: * Text: +
From Menu----->Document----->Simulate & SAVE
155
Step 4: Creation of Machinery Asset Master( AS01)
Asset Class: PSL2000
Comp. Code: PSL ENTER
Description: Machine No 16
Capitalized on : 16.08.09
Select Time Dependent Tab
Business Area: PSLH
Select Depreciation Tab
Dep. Key: PSL1
Useful Life: 16 Years
Period: 6 Months
Ord. Dep Start Dt: 16.08.09 SAVE
We will get the message that Asset Number : 200004-0 Created
NOTE: Before Transfering the CWIP Settlement, We have to Assaign Settlement Document
Number Ranges in Controlling for Posting the Settlement Document. Othewise System
will give Error
156
DATA TAKEOVER (LSMW)
Masters Uploading:
IN masters we have GL Masters : FS00
Vendor Masters : XK01
Customer Masters : XD01
Asset Masters : AS01
Material Masters : MM01
In Live Environment , if we have Number of Masters it is Difficult to Create in SAP
One by One. So we first Create all Fields in Excel. Flow of Masters Uploading will
be like
Below
As LSMW is the Job of Functional Consulatant, we are covering this topic for learning
purpose
157
Step 1 : Open a New Excel File and Note Down the Values to be Uploaded
GLA/c# Comp. A/c P& L St B/S Short Text Long Text A/c
Code Group A/c A/c Currency
{1} {2} {3} {4} {5} {6} {7} {8}
100001 PSL SCPL X Pref.Share Cap Pref.Share Cap INR
200125 PSL CAST X Inventory Stores Inventory Stores INR
300001 PSL SALE X Sales Trading Sales Trading INR
400101 PSL PRSN X Wages A/c Wages A/c INR
Step 2. Open a New Excel File and Note Down the Technical Name of EachField. It should be
in the same order of fields in Text File. To Check the Technical Names go to the Screen
of FS00. In FS00 Screen keep the Cursor on GL A/c and Press F1. Select Technical
Information Button . Double Click on Field Name SAKNR. Like that we can see
technical names of other fields.
Component Data type Length Field Name
SAKNR C 10 GL A/c
BUKRS C 4 Comp.Code
KTOKS C 4 A/c Group
XPLACCT C 1 P& L A/c
XBILK C 1 B/S A/c
TXT_20ML C 20 Short Text
TXT_50ML C 50 Long Text
WAERS C 5 A/c Currency
XSALH C 1 Only Bal. in Local Currency
XKRES C 1 Line Item Display
ZUAWA C 3 Sort Key
FSTAG C 4 Field Status
Save the File in Excel Format as PSL Excel
158
Step 3. Masters Uploading:
Use TC= LSMW in SAP
Ignore the Warning Message
Project: PSL
Sub Project: FI
Object: GL Masters
Select Create Entry Button
Give Project Description: PSL Project ENTER
Sub Project Description: FI Area ENTER
Object Name: GL Masters Uploading ENTER
Select Contineu or Execute Button
Select Execute Button
Select Batch Input Recording Radio Button
MENU----->GOTO----->RECORDINGS
OVERVIEW select Create Recording Button
Recording Name: PSLGL
Description: PSLGL Masters Uploading ENTER
159
Copy Component Column in Excel File in SAP Field Name
Column Copy Data Tyep Column in Excel File in SAP Type
Column
Copy Length in Excel File in SAP Length Column SAVE
Select Back Arrow SAVE
Select Back Arrow
Select Execute Button SAVE
Select Back Arrow
Select Execute Button
Menu---->Extras---->Auto Field Mapping ENTER
Select Accept Proposal Button till we get the Message
"Auto Field Mapping Completed" ENTER & SAVE
Select Back Arrow
SKIP Maintain Fixed Values , Translation User Defined
Routines Select Specify Files Radio Button
Select Execute Button
Keep the Cursor on the PC(Front End)
Select Add Entry Button ( Ctrl+F2)
File : PSLText.txt ( The same Text File Earlier created)
Name: PSLGL Masters
Select Tabulator Radio Button ENTER & SAVE
Select Back Arrow
Select Execute Button SAVE
Select Back Arrow
Select Execute Button Select Execute Button once again
Select Back Arrow 2 times
SKIP Display Read Data
Select Conver Data Radio
Button Select Execute Button Select Execute Button once again
Select Back Arrow 2 times
SKIP Display Converted Data
Select Create Batch Input Session
Button Select Execute Button Select Execute Button once again
We will get a message " 1 Batch Input Folder with 4 Transactions Created" ENTER
Select Execute Button for Run Batch Input Selection
Select Session Name: GLMasters Select Process Button
Select Display Errors Only Radio Button
Select Process Button
Ignore the Message and Select Exit Batch Input Button
NOTE: Reasons given by SAP for suggesting the Uploading of Balances not Transactions for
some Masters :
A. In Normal Accounting Vendors, Customers and Asset Balances are part of GL
A/c's
where as in SAP we have them as SUB Ledgers
B. In Normal Accounting for Vendors and Customers, we keep Payables/ Receivables
and
Advances in One Account. But in SAP Payables/ Receivables will be shown under
Normal Items and Advances will be shown under Special GL Items
C. In Normal Accounting we show Accountwise Gross Block and Accumulated
Dep.
Ex: P& M Wise, Where as in SAP we maintain each Sub Asset Wise Gross Block
and
Accumulated Depreciation.
D. In Normal Accounting Depreciation is a Provisional Figure, where as in
SAP
Depreciation is Actually Calculated figure.
E. In Normal Accounting Consumption is a Balance Sheet Figure. Where as in SAP
Actual
Consumption entries will be passed.
Ex: Raw Material Consumption in Normal Accounting
Opening Stock xxxxx
Add: Purchases xxxxx
Less: Closing Stock xxxxx
RM Consumption xxxxx
F. In Normal Accounting for Closing Stock only One Entry will be passed
Closing Stock Dr. ( B/S Account)
To Closing Stock Cr (P& L Account)
IN SAP Closing Stock will be Maintained Each Material wise-Quantity,
Rate and Closing Amount
G. In Normal Accounting Production Entries and Delivery Entries will not be
passed.
The Difference between Production and Delivery is Increase/Decrease In
Stock.
in SAP Production Entries and Delivery Entires will be passed at Product Cost.
161
5 Create 5 Dummy GL Accounts . It can be under any Account Group. Generally we
create under Liabilities.
a) GL Clearing A/c b) Vendor Clearing A/c c) Customer Clearing A/c
d) Asset Clearing A/c e) Stock Taking A/c
6 If Balances Uploaded is Correct, Balances of 5 Dummy Accounts will become ZERO.
If in Any Dummy Account Balance is not become ZERO, it means there is some
mistake in uploading that Balances. Balances of the Masters will Upload but with
Mistakes.
We have to Check manually the Balances to identify the Mistake and make the
Rectification Entry .
7 We should not allow users to enter day to day transactions until the Balances are
uploaded.
Example of Simple Normal Trial Balance
162
Why The above 2 Entries are Requrired?
As we discussed in Point No 6 of Procedure above, First We will Transfer the Total
Amount to the Particular Clearing Account in the 5 Dummy Accounts Created.
When
we transfer the Individual Balances of Customers/ Vendors/Assets/Materials line
item
wise we will make programming to transfer the total to the particular Clearing
Account
Whne Debit amount and Credit Amount equals automatically that Particular
Clearing
Account ( Dummy) will become ZERO. If any Clearing Account shows balance , it
means there is some mistake in uploading the balances in that partcular category. We
can easily check the balances manually to sort out the difference and make the
adjustment Entry. Point to be noted is that, even if the Balances total does not match
with the amount existing in that Clearing Accoount also, at the time of uploading
line itemwise, data will automatically upload. We can not revert it back. We have to
Step 4A. Prepare a Statement showing each Vendor Bill Wise Open Items and Advances
Ex: Party A account as in Trial Balance
Bill No 1 50000
Bill No 2 40000
Bill No 3 30000
Advance 20000
NOTE:
Like the Above we have to Transfer the Item wise Balances of all the Vendors. In Live, as the
Data Base would be more, it is difficult to upload the Data through TC=F-43. Like what we had
done in GL Masters uploading, we will prepare an Excel Sheet and Upload the data from there in
One Lot. For this, ABAP Programmer is required.
163
Step 5A. Prepare a Statement Showing Each Customerwise, billwise open items and Advances
Party X A/c :
The Debit Balance in Customer Clearing A/c what we transferred through the Entry
in Step 3 is Rs. 250,000 which was equal to the Credit Entry in the above Entry. So
in Customer Clearing Account Balance would be ZERO ( Dr. 250000 - Cr 250000)
Step 6A To Enter the Fixed Assets Balances, we have to Enter Plant & Machinery GL A/c and
Acc. Dep on P & M GL A/c with the below Entry
Post. Key 40 Plant & Machinery A/c 500000
50 To Acc. Dep on P & M A/c 200000
50 Asset Clearing Account 300000
For Uploading the Fixed Assets Item Wise, first we have to Remove the Reconciliations Accounts
for Assets.( See Step 6C for further Details) USE TC= OAMK { OR}
SPRO---->Financial Accounting--->Preparing for Production Start up---->
Set or Reset Reconciliations Account
Comp. Code: PSL
Double Click on Change Control of Reconciliation A/c Folder
From Menu----> Edit---->Selections---->Select All
Select Delect Reconciliation Indicator for All Account SAVE
ENTER to save in your request.
164
Step 6C To Upload Acquisition Value and Acc. Depreciatio Values
This will not update the GL A/c as we have earlier Removed the Reconciliation
A/c for
Account Type Assets. It will updated only the SubLedger of Asset .
PATH: SPRO---->Financial Accounting---->Asset Accounting---->Asset Data
Transfer ----->Manual Online Transfer---->Create/Change/Display Legacy Asset
Step 6D To Make Fixed Assets P& M A/c and Acc. Dep P& M GL A/c as Reconciliation A/c
After Uploading the Balances for Assets, again change the Assets as Reconciliation A/c
USE TC= OAMK ENTER
Comp. Code: PSL
Double Click on Change/Control of Reconciliatio of A/c
Folder From Menu---->Selections---->Select All ( F7)
Select Set Reconciliation Indicator for Accounts Button
SAVE ENTER to save in your request.
Data Take over regarding the Stock is the Job of MM Consultant . But we are
briefly explaining the Procedure
Step 7A Prepare a Statement showing the Each Materialwise , Quantity, Rate and Amount.
The
Total should match with the Trial Balance Amount.
Ex. Statement of Stock
Step 7B Create Material Masters and In Accounting View Enter Moving Avg Price ( TC=MM01)
Item Mvg. Price
RM 1 50
RM 2 20
RM 3 30
165
Step 7C Use TC=MBIC Movement Type =561
Plant: Hyd
Storage Location: RM Storage Location
Material No Qty
RM 1 200
RM 2 3000
RM 3 1000 SAVE
Once We saved the Data, Accounting Entries will be Generated Automatically. Entries
will be Like below
Inventory RM Local Dr 100000
To Stock Taking A/c 100000
( Value = Qty x Material Master Price)
CLOSING PROCEDURE
Closing Procedure is used at the Year End. It will explain what steps we have to do in the
year
end.
If the Current Accounting Year is April 2009 to March 2010 Fiscal Year 2009
Next A/c Year would be April 2010 to March 2011 Fiscal Year 2010
Closing Procedure will be followed in the last week of March 2010 for the Fiscal Year
2009. Like that every Fiscal Year in the Last Week of March we will follow the Closing
Procedure.
To Close Any Fiscal Year for Asset Accounting , We have to Post Depreciation for all
Assets for all the Periods in that Fiscal Year.
PATH: Upto Periodic Processing Path is Same----> Fiscal Year Change (TC=AJRW)
Comp. Code: PSL
New Fiscal Year : 2010
De-Select Test Run Check Box
Menu--->Programme--->Execute----> Background
Output Device: LP01 ENTER ENTER Again
Select Immediate Button SAVE
We will get a Message " Background Job was Scheduled for Programm RAJAWE00"
167
To Check weather the JOB is processed or not :
Menu--->System---->Services--->Jobs--->Job
Overview Execute(F8)-----> We can see that JOB is
Finished
Select Job " RAJAWE00" Check Box
Select Spool Button
Select Sppl No Check Box-----> Select Display Contents
Button We can see the Report of Assets in Summary in
Quantity
WE have 4 Special Periods for each Fiscal Year which are part of March to make
adjustments. 13, 14,15,16 part of Period 12.
USE TC=OB52
for Variat PSL Frm.Prd 2 F.Yr To Prd.2 F.Yr
13 2009 13 2009 SAVE
How to Post to Special Periods ( F-02)
169
Some Important Topics & Reports in SAP
Go the The Asset Balances Report (Any Report which we want on Desktop)
Select Generate a Shortcut Button On Right Top
Description: Select ECC Server ENTER
Select OK to the Message --->SAP will Create Desktop Short cut of the Report
Log Off the SAP
Double Click on Asset Balances Icon on Desktop
Give the Login Password ENTER
We can see that System will Go directly in to the Asset Balances Report.
171
Point 10 How to View the Outstanding List of Vendors:
Upto Reports for Accounts Payable Accounting Path is Same--->Vendors Items--->
List of Vendor Open Items for Printing (TC=S_ALR87012083)
Comp. Code: PSL EXECUTE
Assets Reports
Point 14 Depreciation Forecast:
Accounting --->Financial Accounting --->Fixed Assets---->Information System---->
Reports on Asset Accounting ---->Depreciation Forecast---->Depreciation on
Capitalized Assets ( Depreciation Simulation ) (TC=S_ALR_87012936)
Comp. Code: PSL
Report Date: 31.03.2012 EXECUTE
( Report for FY. 2009,2010,2011)
172
FINANCIAL STATEMENT VERSIONS ( F S V )
CREATION:
In this Chapter we create Format for Balance Sheet and P& L Account . Each
Company
had its own Format. In India we have Companies Act Schedule VI format.
In Client 000 for India SAP has given BAIN--- Balance Sheet and P& L A/c
format
FORMAT:
Level 1 Level 2 Level 3
Summary:
Liabilities
Share Capital Equity Share Capital 100000
Pre. Share Capital 100001
Reserves & Surplus Surplus in P& L A/c 100100
General Reserve 100101
Capital Reserve 100102
Secured Loans TL From Institutions 100310
TL From Banks 100311
Unsecured Loans Fixed Deposits 100400
Sales Tax Dept 100401
By using 0 to 9 lelvels we can get all 3 versions. In Live Environment we create 2
versions.
1st Version --------> Summary
2nd Version--------->Schedules
CUSTOMIZATION:
SPRO---->Financial Accounting---->General Ledger A/c----->Business Transactions----
>Closing Document---->Define Financial Statement Versions.
Select New Entries Button
Financial Statement Version: PSL ( Text Field)
Name: Balance Sheet and P& L
Maintenance language: A/c
Select Item Keys Automatic Check EN
Box Chart of Accounts
Save in your request (or) Create your PSL SAVE
request. Select Financial Staatement Items
Button Keep the Cursor on PSL
Select Create Items Button
Give the Itmes Like : Balance Sheet
Profit & Loss Account
Surplus/Loss Carried to Balance Sheet ENTER
Double Click on NO Text Exists against Liability & Equity
Give the Item Liabilities ENTER
Double Click on NO Text Exists against Assets
Item: Assets ENTER
Press Select Button
Keep the Cursor on Balance Sheet
Select Re Assaign Button
173
Select Subordinate Radio Button ENTER
keep the Cursor on Liabilities
Press Select Button (F9)
Keep the Cursor on Balance Sheet
Select Re Assaign Button ( Shift +F6)
Select Subordinate Radio Button ENTER
Keep the Cursor on P& L Account
Select Create Items Button
Give the Heads Like Income
Expenditure ENTER
Administration
Exp
Interest
Depreciation ENTER
Assaignment of Accounts:
We have to assaign to the Last Node. Keep the Cursor on Share Capital Select
Assaign Accounts Button
From A/c To A/c Debit Credit
100000 100099
100101 199999 ENTER
Here we are assaigning only Share Capital. But in Live we have to assaign Respective Accounts
to the Nodes
Keep the Cursor on Net Fixed Assets
From A/c To A/c Debit Credit
200000 299999 ENTER
175
We are going to Create the Format for Liabilities Like Below
Liabilities :
Sources of Funds:
Share Capital
100000 Equity Share Capital xxxxx
100001 Pre.Share Capital xxxxx
100002 Redeem Share Capital xxxxx xxxxx
Reserves & Surplus
100100 Surplus in P& L A/c xxxxx
100101 General Reserve xxxxx
100102 Capital Reserve xxxxx xxxxx
Secured Loans
100300 SBI Rupee Term Loan xxxxx
100301 SBI FC Term Loan xxxxx xxxxx
Unsecured Loans
100400 Fixed Deposits xxxxx
100401 Sales Tax Department xxxxx xxxxx
TOTAL LIABILITIES XXXXX
176
Double Click on P& L A/c
Start of Groups: P& L A/c
End of Group Profit /Loss for the Year
Select Display Total Check Box ENTER
Double Click on Income
Start of Groups: Income
End of Group Total Income
Select Display Total Check Box ENTER & SAVE
Double Click on Sales
End of Group Sales
Select Display Total Check Box ENTER
Double Click on Expenditure
Start of Groups: Expenditure
End of Group Total Expenditure
Select Display Total Check Box ENTER
Double Click on RM Consumption
End of Group RM Consumption
Select Display Total Check Box ENTER
Double Click on Surplus / Loss Carried to B/S
Start of Groups: Surplus/ Loss Carried to B/S
End of Group Surplus/ Loss Carried to B/S
Select Display Total Check Box ENTER
Double Click on No Text Exist against P& L Result
Give the Item: Surplus / Loss Carried to B/s
End of Group Surplus / Loss Carried to B/s
Select Display Total Check Box ENTER & SAVE
ENTER to SAVE in your Request
** Scaling: Scale
A) Full Rupee with Paise 0/2
B) Full Rupee without Paise 0/0
C) Rupees in Lakhs withoud Decimals 5/0
D) Rupees in Millions Without Decimals 6/0
E) Rupees in Crores Without Decimals 7/0
F) Rupee in Lakhs Thousands in Decimals 5/2
Ex: If Sales = 987654321.55
Rupees In Lakhs 5= 9876.5432155
Thousands in 2 Dec= 9876.54
178
ECC 6.0 New Features
New General Ledger ( Multiple Ledgers): This is the Concept given in ECC6.0 by SAP.
For Indian Companies Financial Year is April to March. If an Indian Company is
Registered in
US Stock Exchange, it has to Submit Reports to Stock Exchange according to the Financial
Year
there in US ( ie., Jan to Dec). If The Same Company had its Group HeadQuarters in UK, it
has
to Submit Reports according to the Financial Year there ( i.e., July to June). So For One
Company
we are Creating Reports according to the Financial Year. In India Period of April is 01 but in
US
it is '04' and in UK it "10". So When we are posting a Transaction in the Period "04" for the
Fiscal Year Variant V3( which is for India), it has to update the Posting Period '01'
for the
Fiscal Year Variant K4 ( for US) and Posting Period '10' for the PP Variant V6(for
UK).
Here we have the Concept of Leading Ledger and Non Leading Ledgers.
Example:
Company Location Financial Year FYVariant Ledger Group
In India 1st April to31st March V3 0L Leading Ledger
In US 1St Jan to 31st Dec K4 J1 Non Leading Led
IN UK 1st July to 30th June V6 J2 Non Leading Led
When we Create Ledger J1, Automatically Ledger Group J1 will be created and J1 ledger
will be
assaigned . At the Time of Posting , if we do not give any Ledger Group it will updates all
the
Ledgers.
For Example, Gain on FC Revaluation in India and US it will be Trnasferred to P& L
A/c as
Other Income. But in UK it will Add to the Fixed Assets and calculate Depreciation
Over the
Life of Asset.
We create a New Ledger Group J3 and assaign Ledgers 0L and J1. At the Time of Posting
When
we give Leder Group J3, and Post , it updates Ledgers 0L and J1. In Ledger Group One Ledger
will be Representative Ledger and others will be Non Representative Ledgers. We have to
Open the Periods in which Posting is done in Representative Ledgers. Eventhough the Periods
for Non Representative Ledgers is not open, it will update the records. When the Ledger
Group
is Consisiting of Ledgers 0L an J1 always 0L will be the Leading Ledger or Representative
Ledger
When we Post a Document, System will generate Documents in non leading ledgers. In Live
Environment, for All document types we will give only One Number Range for No range
interval
to post in Non Leading Ledgers.
Customization:
179
Ledger Description
J2 (Text Field) Non Leading Ledger 2 for PSL
Totals Table: FAGLFLEXT
SAVE ENTER to SAVE in your Request
Ignore the Warning Message ENTER Once Again
Ignore the Warning Message ENTER
Step 3. Define Ledger Groups: Same Path ( Next Level to Last path)
Select New Entries Button
Ledger Group: J3
Description: Ledger Group for PSL SAVE
ENTER to SAVE in your
Request Select Ledger Group J3
Double Click on Ledger Assaignment
Folder Select New Entries Button
Ledger : 0L
Select Representative Ledger Check Box
Ledger: J1
De-select Representative Ledger Check Box SAVE
180
Select Back Arrow
Ledger: J2 ENTER
Select New Entries Button
Type No. Range Type No. Range Type No. Range
SA 62 ER 62 RE 62
AA 62 WA 62 RV 62
KR 62 WE 62 WL 62 SAVE
ENTER to SAVE in your Request
IN Live Environment We have to Give Number Range for all 51 Document Types
Select Back Arrow
Step 5 Define Document Types for General Ledger Group:
Same Path ( Next Level to Old Path)
Ledger: J1 ENTER
Select New Entries Button
Type No. Range Type No. Range Type No. Range
SA 63 ER 63 RE 63
AA 63 WA 63 RV 63
KR 63 WE 63 WL 63 SAVE
ENTER to SAVE in your Request
Ledger: J2 ENTER
Select New Entries Button
Type No. Range Type No. Range Type No. Range
SA 64 ER 64 RE 64
AA 64 WA 64 RV 64
KR 64 WE 64 WL 64 SAVE
ENTER to SAVE in your Request
181
Step 7 Define Document Number Ranges for General Ledger View:
Upto Document Path is Same---->Document Number Range---->Doc. In General Ledger
View---->Define Document Number Ranges for General Ledger View
Comp. Code: PSL
Select Change Interval Button
No. Range Year From.No To No
63 2009 1 100000ENTER
Select Inteval Button
64 2009 100001 200000ENTER & SAVE
Ignore Warning Message and Press Enter
182
END USER AREA:
Step 1. Posting to New General Ledger:
Accounting ---->Financial Accounting --->General Ledger---->Posting --->Enter
GL Posting for Ledger Group (TC=FB01L)
1st Doc. Doc. Dt: 15.08.09 Type: SA Comp. Code: PSL
Ledger Group: Keep Blank (to Update all Ledgers)
Post Key: 40 A/c: 200105 ENTER
Amount: 200000 Buss.Area: PSLH
Text: Equity Share Capital Receipt
Post.Key: 50 A/c: 100000 ENTER
Amount: * Buss.Area: PSLH
Text: +
Menu----->Document----->Simulate & SAVE
END OF FINANCIALS
183