This document provides instructions for configuring basic SAP settings including:
1. Creating a company code for L Airlines in India with the code LAP.
2. Assigning the LAP company code to the LAIR company.
3. Creating business areas for L Airlines' north and south zones.
4. Assigning the standard fiscal year variant V3 and posting period variant LAPP to the LAP company code.
5. Maintaining the posting periods in the LAPP variant to open periods 1-12 of 2011.
6. Creating a field status variant LAFS for the LAP company code.
Overview of SAP FICO including its practical use as a configuration guide, and its evolution from tutorials.Explanation of SAP as an ERP product, its advantages, architecture, and its use in data management.
Roles of admins, functional consultants, end-users, and project consultants in the SAP implementation.
Instructions on how to log in to SAP, navigate the environment, and understand the client structure.
Company and company code setup, transport requests, and basic configuration settings in financial accounting.
Configurations for field status variants and posting periods, as well as managing GL accounts and their settings.
Details on creating tax configurations and managing GL account settings for various accounting principles.
Setup and management of vendor accounts, including tolerances, invoice postings, and payment processes.
Explanation of controls around documenting payments, managing conditions across various financial transactions.
Paying bills including posting and clearing processes, managing discounts, and dunning for collections.
Introduction
This book isvol-1 of 2 volumes
This book was initially a set of tutorials taught by me during class room training. After gradual
development over the years, now it has become a complete configuration guide/ end-user
manual for SAP FICO module. Obviously this book is more a practical guide than a reference
book even though some info stuff has been inserted at some places.
Having taught the SAP FICO course to hundreds of beginners and experienced at various
institutions, I know the kind of problems and questions you will have when learning this module.
This book is full of detailed step-by-step procedures with necessary screen shots and sample
configurations.
Having worked as a SAP Consultant at various organizations, I know the kind of requirements
that may arise at clients. To this end, most of the business processes and underlying concepts
have been explained thoroughly through out the book.
By understanding the how and whys, you will start gaining basic knowledge which reaches to
advanced level with in no time .
As you go through the material, if you have problems or questions please do mail me. If you
find an error in this book, or suspect there may be an error, kindly notify .
I hope you will find using this book as enjoyable.
Conventions Used in This Book
‘’ indicates a next thing in navigation or next action
‘----- button’ means to press the button . For example ‘ Position button’ means ‘to press
Position button’
‘:’ is followed by the value/text to be entered
Multiple inputs/input values in a single screen are shown in the form of table.
How to use the book
Just read line by line and follow the instructions. Referring to screen shots make your job
easy . Please refer to Info boxes for additional info.
The configuration described in this document is not specific to any particular country. However,
some
of the data that appears within the document is specific to India, In cases where this country-
specific
data appears, you must replace the data valid for India by data valid for your country.
SrinivasaKasireddy+91-9959765211
1. Intro
SAP :Systems Applications & Products in Data Processing
Whose product is SAP ?
SAP belongs to a company called SAP AG headquartered in Walldorf, Germany.
What kind of product is SAP ?
SAP is an ERP product.
ERP stands for Enterprise Resource Planning .
ERP is a single system to store and process the data of all the departments in an
integrated
manner . In simple terms, it can be described as an Integrated Data Management tool
.
Application Departments
SAP
FI
HR
Sales
Purchasing
Production
---etc
Advantages of an ERP system :
1. Multiple data entry points.
2. No redundancy of data (because of one centralized Database)
3. Upto date information at any point of time.
4. Scalabilty
+91-9959765211 9
8.
SrinivasaKasireddy+91-9959765211
Architecture of SAP:
SAP works on client /Server mechanism.
SAP‘s architecture is called 3 tier (Layer) architecture. The 3 layers are
1.DB layer
Backend
2.Aplication layer
3.Presentation Frontend
DB and Application layers are called Backend layers where as presentation layer is
called front end layer. We can represent the 3 layers in the following way.
Backend Frontend
DB Application
PC1
Carporate Office
PC2
PC3 Regnl office1
PC3
Regnl office2
PC4
PC5 Plant
PC6 Wearhouse
PC7 Home
Project:
C C++ Java SAP
Customized solution Generic Application
DB : To be developed Ready
Application : To be developed Ready
Resources :
Programmers,
DB experts
Sys admins
Consultants
Consultants Techincal consultants: ABAP programmers
Basis Consultants
+91-9959765211 10
9.
SrinivasaKasireddy+91-9959765211
(Admins)
1.Installation
2.User management
3.Monitoring
…etc
Functional consultants:
Business process , Domain knowledge
Bcom , MBA and experienced in Domains
Basic responsibility :Configuration (Making
settings in the system)
FI, CO , SD ,MM etc
XYZ Pharama-----
Outsourcing
TCS
Client Consultancy
Endusers :
Production(Live)
Data entry
(Eg: Posting a GL entry
Posting a inv)
Consultants:
Dev(Config) stage
Config
FI dept FI Consultant
Costing CO Consultant
Sales SD Consultant
HR HR Consultant
Purchase MM Consultant
+91-9959765211 11
2. Log-in &Navigation
After you complete this chapter, you will be able to log-in to SAP system and navigate
in
SAP environment.
Client : 800
User : SAPUSER
Password : XXXXXXXXXX
Enter
In layman’s terms client can be called as an independent environment in which you can
operate.
Each client can be given code of choice like ‘001’ ‘630’ etc . In IDES we have only
one client ie 800 . In live project , you have to enter the client in to which you want to
log in . A separate set of username and password will be required for each client .
Most of the time consultants will be operating in Development client. Production client
is the environment where the actual business data(live data) is entered by end users.
12.
SrinivasaKasireddy+91-9959765211
Client (Environment)
Sandbox client
ConsultantsDevelopmentclient
Testing client
Training client
End user
Production (or Live) client
Navigating in SAP
/N Takes you to SAP Easy Access screen from any screen
/NF-02 Takes you to the F-02 screen from any screen
/O Opens a new Session with SAP Easy Access screen
/OF-02 Open new session with f-02 screen
/I Ends a session
+91-9959765211 14
SrinivasaKasireddy+91-9959765211
3. Basic Settings
Company& Company Code:
General SAP
Group = Company
Company = Company Code(Legal entity)
Company Company Code Country Currency
L Airlines
LAP IN IN INR
LAC IN IN INR
LAP US US USD
LAC US US USD
P - Passenger Div , C – Cargo Div
1. Creating Company
SAP Easy AccessToolsCustomizing IMGExecute Project
Tcode: SPRO
SAP Reference IMG button
+91-9959765211 16
SrinivasaKasireddy+91-9959765211
Company Name :L Airlines
City : Hyderabad
Country : IN
Language Key : EN
Currency : INR
Save button
Create Request button ( ) (In the Prompt for Customizing request window)
Short Description : Basic settings for LAP
+91-9959765211 18
17.
SrinivasaKasireddy+91-9959765211
Save (or Enter)
Continuebutton (or Enter)
Back button twice
Transporting : In the live project we do our configuration in Development client and copy the
configuration from Development client to Testing client. If everything is ok in testing, we copy
configuration from Development client to Production (Live) client. This procedure is called
‘Transporting’. For transporting we need to create a Transport Request number. We include
the configuration settings in the request no.
For example all Basic settings in one transport request, AP settings in one transport request
and so on. All basic settings can be transported at a time and all AP settings can be
transported at a time.
2. Creating Company Code
Same Path up to Definition
Financial AccountingEdit, Copy, Delete, Check Company code
+91-9959765211 19
18.
SrinivasaKasireddy+91-9959765211
Double click onEdit company code data
New Entries button
Company code : LAP
Company Name : Lair (p) Div
City : HYD
Country : IN
Currency : INR
Language : EN
Save
Name : L air ways
Country : IN
Region : 01
Copy (or Enter)
Continue
3. Assigning Company Code to Company
Up to Enterprise structure same path
AssignmentFinancial AccountingAssign Company code to company
Position button
Company Code : LAP
Enter
+91-9959765211 20
19.
SrinivasaKasireddy+91-9959765211
CoCd Company
LAP LAIR
Save
Continue
4.Creating Business Area
Up to Enterprise Structure same path
DefinitionFinancial AccountingDefine Business area
New Entries
Business Area Description
LANZ L Air North Zone
LASZ L Air South Zone
Save
+91-9959765211 21
20.
SrinivasaKasireddy+91-9959765211
Continue
Info :
Business Areais a cross company code organizational unit.
We do not assign business areas to any company code.
We enter business area while posting transactions.
Business area can be
1. Geographical area Ex: South Zone, North Zone
2. Product Line Ex: Business area TVs, Refrigerators
Company codes Business Area
LAP P-Division
LAC C-Division
LANZ-North
LASZ-South
Revenue from P Division
Company Code : LAP
Business Area : LANZ+LASZ
Revenue from P Div in South Zone
Company Code : LAP
Business Area : LASZ
Revenue from North Zone
Company Code : LAP +LAC
Business Area : LANZ
5. Assign Fiscal Year Variant to Company code
SAP terminology General terminology
Fiscal year Financial Year
Current Fiscal yr in India 2011 2011-2012
2012 2012-2013
Fiscal Year is specific to a country.
India US
Month Period Month Period
April 1 Jan 1
March 12 Dec 12
Fiscal Year ≠ Calendar Year Fiscal year = Calendar Year
+91-9959765211 22
21.
SrinivasaKasireddy+91-9959765211
Standard FYV= V3Standard FYV = K4
FYV : V3 FYV :K4
Apr-March
12+4 Periods
12-Regular Periods (1 to
12)
4 Spl Period (13 to 16)
Jan-Dec
12+4 Periods
12-Regular Periods
4 Spl Period
SPROFinancial AccountingFinancial Accounting Global SettingsFiscal
YearAssign
Company Code to a Fiscal Year Variant
Position button
Company Code : LAP
Enter
CoCd Fiscal Yr. Variant
LAP V3
Save
Enter (to ignore warning messages if any)
Continue
6. Creating Posting Period Variant
Period
Open Closed
Can post to any date in the open period Can’t post to a closed period
Path: Up to Financial Accounting Global Settings same path
DocumentPosting PeriodsDefine Variants for open posting periods
TCode : OBBO
New Entries
Variant Name
LAPP PPV for LAP
Save
Continue
+91-9959765211 23
22.
SrinivasaKasireddy+91-9959765211
7. Assign PPVto Company Code
Same Path
Assign Variants to company code
TCode: OBBP
Position
Company code : LAP
Enter
CoCd Variant
LAP LAPP
Save
Continue
8. Maintain PPV
Same path
Open and Close Posting Periods
TCode : OB52
New Entries
Vari A From acct To account From
per.1
Year To period Year
LAPP + -- -- 1 2011 12 2011
Save
Continue
+91-9959765211 24
23.
SrinivasaKasireddy+91-9959765211
9. Define FieldStatus Variant
FSV is a list of Field Status Groups
Field Status Group is a list Fields(70 fields) along with status
Eg: FSG ‘G001’
Suppressed Req.Entry Opt.Entry
Text
Value date
Business Area
We assign FSV to company code.
We assign FSG to GL Accounts at the time of creation
Eg:- FSG ‘G001’ for GL account 400500 (Salaries)
Path:- Up to Documents same pathLine ItemControlsDefine Field status
Variants
Tcode : OBC4
Select FStV ‘1000’
+91-9959765211
Scenario
Variant A
Fro
m
A/c
To
A/C
Fro
m
Per1
Year
To
Period
Year
Fro
m
Per 2
Year
To
Period
year
Open
Current
Period
only
(Live &
Periodic)
LAPP + - - 8 2011 8 2011
Open all
periods
in the
current
fiscal
year
(Lab)
LAPP + - - 1 2011 12 2011
Open
first
period of
new year
& spl
period of
previous
year
(Yr end
setting)
LAPP + - - 1 2012 1 2012 13 2011 13 2011
25
24.
SrinivasaKasireddy+91-9959765211
Copy as button
Changethe FStV to ‘LAFS’
Field Status name to ‘FSV for LAP’
Enter
Copy all button
Enter to confirm the message
Save
Continue
10. Assign Company Code to FSV
Same path next line
TCode : OBC5
Position
Company Code : LAP
Enter
CoCd FStV
LAP LAFS
Save
Continue
11. Changing Field Status Group
+91-9959765211 26
25.
SrinivasaKasireddy+91-9959765211
Same Path DefineField Status Variant
TCode : OBC4
Select FSV ‘LAFS’
Double Click on ‘Field status groups’ folder
Double Click on FSG ‘G001’
Double Click on ‘General Data’
Suppressed Req Entry Opt Entry
Text
+91-9959765211 27
26.
SrinivasaKasireddy+91-9959765211
Back button
DoubleClick on ‘Additional Account Assignments’
Suppressed Req Entry Opt Entry
Business Area
Save
12. Changing Number Range to 01 for Doc type SA
All business transactions in SAP are stored in the form of Documents
Every business transaction has a Document type associated with it.
Every Document type has a default number range
Global Settings:
Transaction Doc. Type Default No. Range
GL Entry SA 01
Customer Inv. DR 18
Vendor inv KR 19
We create number interval for every number range at company code level
Company Code level and Year wise settings
Company Code : LAP
No Range Year From No. To No.
01 2011 0100000000 0199999999
01 2012 0100000000 0199999999
18 2011 1800000000 1899999999
Company Code : LAC
No Range Year From No. To No.
01 2011 1 0100000000
01 2012 0100000000 0199999999
18 2011 1800000000 1899999999
Yr independent no range
No Range Year From No. To No.
45 2020 4500000000 4599999999
2011 1000 doc 4500000000-45000000999
2012 1500 docs 4500001000-450000002499
+91-9959765211 28
27.
SrinivasaKasireddy+91-9959765211
Path : Upto Document same path
Document Header Define Document types
Tcode : OBA7
Position button
Document Type : SA
Enter
Double Click on Document type ‘SA’
Note Down the No. Range ie 01
13. Creating Number Range 01
TCode :FBN1
In the Same ScreenNumber range Information button
Company Code : LAP
Change Intervals button
Interval button
No Year
From
number
To number
01 2011 0100000000 0199999999
+91-9959765211 29
28.
SrinivasaKasireddy+91-9959765211
Enter
Save
Continue
14. DefineTolerance Groups for G/L Accounts
Open item management (Item wise clearing)
Open Item(Pending) × Cleared Item
Open Items:
1. Vender Items like invoices , Down payments etc
2. Customer Items like invoices, Credit-memos , Down payments etc
( Vendor Invoices & Customer Invoices are open items until they are paid for.)
3. TDS : TDS deducted from Vendor payment is a open item until you remit it to
tax
Authority.
4. Check Clearing Accounts : Checks issued A/C and Checks deposited A/C
(Checks that are not en-cashed are open items in the above accounts)
5. Expenses payable accounts (Salary payable , Rent payable )
6. GR/IR Clearing A/C
Info : For vendor and customer accounts clearing procedure is available by default.
For GL accounts clearing procedure is optional. We select Open item management for the
above GL accounts to activate the clearing procedure .
+91-9959765211 30
29.
SrinivasaKasireddy+91-9959765211
Tolerance: The amountof difference that is accepted when clearing an open item
Open item 5000
Pymnt amount 4990
---------------------------------------
Difference 10
--------------------------------------
GL Account Tolerance Group:
T group name Debit posting Percentage Credit posting Percentage
Tg1 1000 1% 1000 1%
Tg2 500 0.5% 500 0.5%
Blank
(Default Tgrp)
0 0 0 0
Each GL account belongs to a TGroup
Eg:
GL Account T Group
Rent Payable Tg1
Salary Payable Tg1
TDS payable Blank
For Tgroup ‘Tg1’ the deference can be either 1000 or 1% , what ever is small
Open Item 5000
Clearing amount 4000
--------
Deference 1000 X 1% 0f 5000 = 50 √
--------
Open Item 500000
Clearing amount 495000
----------
Deference 5000 = 1% of 500000 X 1000 √
---------
+91-9959765211 31
30.
SrinivasaKasireddy+91-9959765211
Path:
Upto Financial AccountingSame Path
General Ledger AccountingBusiness TransactionsOpen Item ClearingClearing
DifferencesDefine Tolerance group for G/L accounts
TCode : OBA0
New Entries button
Company Code : LAP
Tolerance Group : Blank Default Tolerance Group for LAP
Save
Continue
15. Define Tolerance Groups for Employees
Employee Tolerance Group:
T
group
name
Amount per
Document
Amount for
Open item
Account
item
Revenue
Amount
Revenue
Percent
Expenses
Amount
Expenses
Percent
Tg1 10,00,000 500,000 1000 1 1000 1
Tg2 500,000 200,000 500 0.5 500 0.5
Blank 100,000 100,000 0 0 0 0
Every user(employee) is assigned to a TGroup
Eg:
Employee Tgroup
Account Clerk 1 Blank
Account Clerk 2 Blank
Accounts Manager Tg 2
+91-9959765211 32
31.
SrinivasaKasireddy+91-9959765211
General Manager Tg1
Note:
In the above scenario:
Accounts clerk 1 & 2 can post only a document worth Rs. 100000/- or less
And Accounts clerk 1 & 2 can clear a open item worth Rs. 50000/- or less
Path: Same path next line
TCode :OBA4
New Entires
Group : Blank
Company Code : LAP
Amount per document : 100000
Amount per open Item account item : 100000
Save
Continue
16. Assign Tax Procedure to Country IN
Note :Tax Procedure is configured at country level and not at company code level. Please
skip this setting if already a Tax Procedure is assigned to the country of your company
+91-9959765211 33
32.
SrinivasaKasireddy+91-9959765211
code. This isonly a temporary setting. We have a dedicated chapter for Tax in Volume 2 .
Up to Financial Accounting Same Path
Financial Accounting Global SettingTax on Sales/PurchasesBasic
SettingsAssign
Country to Calculation Procedure
Position button
Country : IN
Enter
Country Tax Procedure
IN TAXUS (or any procedure)
Save
Continue
17. Enter Global Parameters
Up to Financial Accounting Global Setting Same Path
Company CodeEnter Global Parameters
Position button
Company Code : LAP
Enter
Double Click on Company Code ‘LAP’
√ Business Area Financial Statement
√ Propose Fiscal Year
√ Define Default Value Date
√ Negative Postings Permitted
Save
Continue
18. Creating Chart of Accounts
Up to Financial Accounting Same Path
General Ledger AccountingG/L Accounts Master DataPreparationsEdit Chart
of
Accounts List
New Entries
Chart of Accounts : LACA
Description : COA for LAP
Language : EN
Length of GL Account Number : 6
+91-9959765211 34
33.
SrinivasaKasireddy+91-9959765211
Save
Continue
Info:
Chart of accountsis a list of G/L accounts.
We assign Chart of accounts to Company code(s)
Group COA is another Chart of accounts.
Group G/L account is the common identity given to G/L accounts across the company
codes
CoCd COA
LAP
LACA
LAC
LXY LXCA
COA Group COA
LACA
LCA
LXCA
GL Account LAP LAC LXY Group GL
Salaries 400500 400500 300700 500400
Rent 400600 400600 300800 500500
Sales 300700 300700 - -
Total Salaries Paid in LAP & LAC
Company Code : LAP+LAC
GL Account : 400500
Total Salaries Paid in LAP+LAC+LXY
Company Code : LAP+LAC+LXY
GL Account : 400500+300700 X
Group GL account : 500400 √
Types of Chart of Accounts :
1. Operating Chart of Accounts
2. Group Chart of Accounts
3. Country Chart of Accounts : Is mandatory to use in some countries .
+91-9959765211 35
34.
SrinivasaKasireddy+91-9959765211
19. Assigning CompanyCode to Chart of Accounts
Same path next line
Position button
Company Code : LAP
Enter
CoCd COA
LAP LACA
Save
Continue
20. Define Account Group
GL Accounts
Balance Sheet
Assets 2*
Liabilities 1*
P & L Account
Income 3*
Expenditure 4*
Path:Same path next line
New Entries button
Chrs/Accts Acct Group Name From acct To account
LACA LIAB Liabilities 100000 199999
LACA ASTS Assets 200000 299999
LACA INCO Income 300000 399999
LACA EXPN Expenses 400000 499999
+91-9959765211 36
35.
SrinivasaKasireddy+91-9959765211
Save
Continue
21. DefineRetained Earnings Account
In the year end:
All Balance Sheet Accounts carry their balances into next year.
We transfer all P&L Account balances into a Liability account called Retained earnings
Account .
PATH:
Same Path next line
Chart of Accounts : LACA
Enter
P&L Statmt acct type Account
X 100100
Y 100000
Save
Enter twice to ignore the warning message
Continue
+91-9959765211 37
36.
SrinivasaKasireddy+91-9959765211
4. General LedgerAccounting
1. Settings
1. Creating 1st
G/L Account
Tcode: FS00
SAP Easy AccessAccountingFinancial AccountingGeneral LedgerMaster
RecordsG/L AccountsIndividual ProcessingCentrally
(Please turn of the Hierarchy display before creating first GL Account)
Turning off the Hierarchy display :
Settings menuHierarchy display
Do not display navigation tree
Enter twice.
Restart the transaction using T Code /NFS00
G/L Account :100100
Company Code : LAP
Create Button
+91-9959765211 38
37.
SrinivasaKasireddy+91-9959765211
Account Group :Liabilities
Balance Sheet Account
Short Text : Retained earnings
G/L Acct Long Text : Retained earnings
Control Data Tab
√ Only balances in local crcy
√ Line item display
Sort Key : 001
Create Bank/Interest tab
Field Status Group : G001
Save
(Please turn on the hierarchy display after creating 1st
GL account)
Turning on the Hierarchy display:
Settings MenuHierarchy Display
Display accounts in navigation tree
EnterEnter
Restart the transaction using T Code /NFS00
2. Creating Second GL Account (ICICI term loan)
Select GL account ‘100100’ [Retained Earnings]
Copy button
+91-9959765211 39
38.
SrinivasaKasireddy+91-9959765211
GL Account :100200
Company Code : LAP
Enter
Change the Description to ‘ICICI term loan’
Save
3. Creating ICICI Current Account
Tcode : FS00
Create Button
GL Account : 200790
Company Code : LAP
Enter
Account Group : Assets
Balance Sheet account
Short Text : ICICI Current Account
+91-9959765211 40
39.
SrinivasaKasireddy+91-9959765211
Long Text :ICICI Current Account
Control Data Tab
√ Only Balance in Local Currency
√ Line Item Display
Sort Key : 001
Create Bank/Interest Tab
Field Status Group : G005
√ Relevant to cash flow
Save
4. Creating ICICI Check Deposit account
Select 200790 ICICI Current A/C
Copy Button
GL Account : 200791
Enter
Description : ICICI Check Deposit A/C
Control Data Tab:
√ Open item management
Sort Key : 000 (Assignment number)
Save
5. Creating ICICI Check Issue account
Select 200791 ICICI Check Deposit A/C
Copy Button
G/L Account : 200792
Enter
Description : ICICI Check Issue Account
Save
6. Define House Bank
SPROFinancial AccountingBank AccountingBank AccountsDefine House
Banks
TCode : FI12
Company Code : LAP
Enter
New Entries button
House Bank : ICICI
+91-9959765211 41
40.
SrinivasaKasireddy+91-9959765211
Bank Country :IN
Bank Key : 345464
Enter
Create Button
Bank Name : ICICI
Street : Bank Street
City : Hyderabad
Branch : Tarnaka
Enter
Save
Continue
Double Click on Bank Accounts folder
New Entries
Account ID : ICICI
Description : ICICI Current Account
Bank Account Number : 123456
G/L : 200790
Currency : INR
Save
+91-9959765211 42
41.
SrinivasaKasireddy+91-9959765211
2. End User
1.Posting Term loan Receipt
Path: SAP Easy AccessAccountingFinancial Accounting General
LedgerDocument EntryGeneral Posting
T Code: F-02
Document Date :14-11-2011 Type :SA CompanyCode : LAP
Posting Date :14-11-2011 Currency : INR
(Note: F4 F2 to enter today’s Date)
Pstky : 40 Account : 200791 (ICICI Check receiving
account)
Enter
Amount : 90,000
Bus Area : LANZ
Text : Term loan Receipt
PstKy : 50 Account : 100200
+91-9959765211 43
42.
SrinivasaKasireddy+91-9959765211
Enter
Amount : *(Amount is calculated automatically)
Bus Area : LANZ
Text : + (Text is copied from previous line item)
Enter [Amount and Text will be updated automatically].
Document MenuSimulate
+91-9959765211 44
SrinivasaKasireddy+91-9959765211
Error : Thereis no item category ………………….
Solution: Inactivate Document splitting
Tcode : SM30
Table/View :V_FAGL_SPLIT_ACT
No Restrictions
Maintain button
Position button
Company Code : LAP
Enter
Company Code Inactive
LAP √
Save
Continue
Re enter the document.
Info:
Posting Key Determines:
1. Which Account Type you are posting to
2. Whether Dr. or Cr side you are posting to
Ex: PKey A/C type Dr/Cr
40 GL A/C Dr
50 GL A/C Cr
The following table explains about which side to post for a particular GL account.
Assets Liabilities
Dr : Increase
Cr : Decrease
Dr : Decrease
Cr : Increase
Expenses Income
Dr : Increase
Cr : Decrease
Dr : Decrease
Cr : Increase
2. Displaying the Document
Up to General Ledger Same Path
DocumentDisplay Document
T Code: FB03
+91-9959765211 46
45.
SrinivasaKasireddy+91-9959765211
Document Number :100000000
Company Code : LAP
Fiscal Year : 2011
Enter
Double Click on item to display
Changing the Document:
In the same screen
Change Display/Change Mode button [ Ctrl+F1 ]
Alternatively use T Code: FB02 to change the document
3. Displaying GL Account Balances
Up to General Ledger same path
AccountDisplay Balances
T Code: FS10N
G/L Account : 200791
Company Code : LAP
Fiscal Year : 2011
Execute (or F8)
+91-9959765211 47
46.
SrinivasaKasireddy+91-9959765211
4. Display orChange Line Item
Double Click on amount in debit column to display line items.
Alternatively use the following path to display or change line items
Up to Account Same PathDisplay/Change Line Items
T Code: FBL3N
G/L Account : 200791
Company Code : LAP
All items
Execute
Make a note of ‘St’ column . Red colour indicates open item.
Clrng doc will be blank for open items
+91-9959765211 48
47.
SrinivasaKasireddy+91-9959765211
3. Reference Documents[Template
Docs]
Reference Documents make end-users job easy.
With Reference Documents, document entry can be faster and mistakes can be
avoided .
Sample Document If the text or amount or any other field need to be changed Eg:
Salary
Recurring
Document
If the amount is fixed and text need not be changed
Eg: Fixed Instalments,
Fixed Insurance premium
Standing orders given to bank
1. Creating Number Ranges X1, X2
SPROFinancial AccountingFinancial Accounting Global SettingsDocument
Document Number rangesDefine Document number ranges
T Code: FBN1
Company Code : LAP
Change Intervals button
Insert Interval button
No. Year From
number.
To number
X1 2011 500000000 5000000099
Enter
Insert Interval button
No. Year From number To number
+91-9959765211 49
48.
SrinivasaKasireddy+91-9959765211
X2 2011 50000001005000000199
Enter
Save
Continue button
2. Creating GL Account Rent
T Code: FS00
Change Company Code button
Company Code : LAP
Enter
Create Button
GL Account : 400600
Company Code : LAP
Enter
Account Group : Expenses
P & L statement Acct
P&L statmt acct type : X
Short Text : Rent
Long Text : Rent
Control Data Tab:
√ Line item display
Sort key : 001
Field status group : G001
Save
3. Creating GL Account Salaries
Select G/L account 400600 (Rent Account)
Copy button
GL Account : 400500
Company Code : LAP
Enter
Change Description to ‘Salaries’
Save
4. Creating Sample Document
T Code: F-01
+91-9959765211 50
49.
SrinivasaKasireddy+91-9959765211
SAP Easy AccessAccountingFinancialAccountingGeneral Ledger Document
Entry Reference DocumentsSample Documents
Document Date : 15.11.2011 Type :SA CoCd : LAP
Posting Date : 15.11.2011
PstKy : 40 Account : 400500 [Salaries]
Enter
Amount : 1
Bus area : LANZ
Text : Salary Payment
PstKy : 50 Account : 200792 [Check Issue Account]
Enter
Amount : *
Bus area : LANZ
Text : +
Display Document Overview Button
Post
Note down the Document No. ( 5000000100)
5. Posting Salary Payment Using Sample Document as
Template
T Code: F-02
Document MenuPost with Reference
Document No. : 5000000100
Company Code : LAP
Fiscal Year : 2011
√ Do not propose amounts
√ Display Line Item
Enter
Change Document Date , Posting Date Accordingly
Enter
Amount : 36000
Enter
Amount : *
Document menu Simulate
Post
Check the balance using T Code: /NFS10N
+91-9959765211 51
50.
SrinivasaKasireddy+91-9959765211
GL Account :400500
Company Code : LAP
Fiscal Year : 2011
Execute
6. Creating Recurring Document
T Code: FBD1
Up to General Ledger Same PathDocument EntryReference
DocumentRecurring Document
Company Code : LAP
First Run on : 18.11.2011
Last Run on : 18.10.2012
Interval in Month : 01
Run Date : 18
Document Type : SA
Currency : INR
PstKy : 40 Account : 400600
Enter
Amount : 18000
Bus area : LANZ
Value Date : 18.11.2011
Text : Rent Payment
PstKy : 50 Account : 200792 (ICICI check issue
account)
Enter
Amount : *
Bus area : LANZ
Text : +
Display Document Overview button
Post
Note down the document No. 5000000000
7. Posting Rent Payment Using Recurring Document
T Code: F.14
Up to General Ledger Same Path
Periodic ProcessingRecurring EntriesExecute
Company Code : LAP
Document No. : 500000000
+91-9959765211 52
51.
SrinivasaKasireddy+91-9959765211
Fiscal Year :2011
Document Type : SA
Settlement Period : 01.11.2011 to 30.11.2011
Batch input session name : Rent_ Pymnt
Execute
Message: Session Rent_ Pymnt was created.
8. Processing the Session:
TCode : SM35
System MenuServicesBatch Input Sessions
Select Session ‘Rent_Pymnt’
Process Button
Process/foreground
Enter
Keep on Pressing Enter until the ‘Processing of batch input Session Completed ‘
Exit Batch Input button
Check the GL Balance using Tcode FS10N
4. Holding a Document
Scenario:
Travelling Advance 9000
Amount Returned 2000
Actual Expense that incurred 7000
1. Creating GL Account Travelling Expenses
T Code - FS00
Select GL account 400500 [Salaries]
Copy Button
GL Account : 400591
Enter
Change the Description to ‘Travelling expenses ‘
Save
2. Creating GL Account Cash
Select GL account 200790 ICICI current a/c
Copy button
GL account : 200691
+91-9959765211 53
52.
SrinivasaKasireddy+91-9959765211
Enter
Change the Descriptionto ‘Cash’
Save
3. Holding a Document
Tcode: F-02
Document Date:18.11.2011 Type : SA Company Code : LAP
Posting Date : 18.11.2011
PstKy : 40 Account : 400591
Enter
Amount : 9000
Bus area : LANZ
Text : Travelling Advance
PstKy : 50 Account : 200691
Enter
Amount : *
Bus area : LANZ
Text : +
Document MenuHold
Temporary Document No. : 6363
Hold document button
Converting held documents:
Error Msg : ‘Held documents must be converted; read long text’
Solution :
Tcode : SE38
Program : RFTMPBLU
Execute
√ No termination for read error
Execute
Msg: Held documents successfully converted
4. Posting the Held Document
Tcode: F-02
Document MenuGet Held Document
+91-9959765211 54
53.
SrinivasaKasireddy+91-9959765211
Temporary document number: 6363
Enter
Double Click on item Travelling Exp
Change Amount to ‘7000’
Change Text to ‘Travelling Exp’
Next item button
Change the Amount to *
Text : +
Enter
Document MenuSimulate
Post
5. Parking Document
User 1 enter the Document and Park
User 2 will edit the Document and Post
Workflow : Set up is to be done by ABAP programmers . If workflow has been setup when
user 1 enters the doc and park it , automatically a msg goes to User2 . User 2 can
release/reject the doc from his/her inbox directly.
1. Parking the Document by User1
Tcode : F-02
Document Date : 18.11.2011 Type :SA Company Code: LAP
Posting Date : 18.11.2011
PstKy : 40 Account : 400500
Enter
Amount : 90000
Bus area : LANZ
Text : Salary Payment
PstKy : 50 Account : 200792
Enter
Amount : *
Bus area : LANZ
+91-9959765211 55
54.
SrinivasaKasireddy+91-9959765211
Text : +
DocumentMenuPark
Message: Document 100000005 Parked
2. Posting the Document by User2
Up to Document Entry Same PathEdit or Park GL Document
Tcode: FV50
DocumentSelect Parked Document
Company Code : LAP
Document No. : 100000005
Fiscal Year : 2011
Continue
Edit Document If necessary.
Post
6. Month End Accrual
Salary of Nov and Rent of Nov is paid in Dec.
On Month end we generate balance sheet.
While generating Balance Sheet at the end of Nov we need to show these items in
Liabilities.
1. Creating GL Account Expenses Payable
Tcode: FS00
Select G/L account ‘100100’ Retained earnings
Copy button
GL Account : 100800
Enter
Change the Description to ‘Expenses payable’
Control Data Tab:
√ Open item management
Create /bank /interest tab:
Field status group : G012 ie Receivables/payables clearing
Save
2. Posting Month End Provision
Tcode : F-02
Document Date : 30.11.2011(Month end date) Type : SA
+91-9959765211 56
55.
SrinivasaKasireddy+91-9959765211
Posting Date :30.11.2011
PstKy : 40 Account : 400500
Enter
Amount : 36000
Bus area : LANZ
Text : Salary Provision for Month of Nov
PstKy : 50 Account : 100800
Enter
Amount : *
Bus area : LANZ
Text : +
Document MenuSimulate
Post
(Post one more document for Rent Provision like below)
Tcode : F-02
Document Date : 30.11.2011 Type : SA
Posting Date : 30.11.2011
PstKy : 40 Account : 400600
Enter
Amount : 18000
Bus area : LANZ
Text : Rent Provision for Month of Nov
PstKy : 50 Account : 100800
Enter
Amount : *
Bus area : LANZ
Text : +
Document MenuSimulate
Post
3. Displaying Open Items
Tcode :FBL3N
GL Account : 100800
Company Code : LAP
All Items
Execute
+91-9959765211 57
56.
SrinivasaKasireddy+91-9959765211
‘St’ column willbe in red colour for open items and ‘ Clrng doc ‘column will be empty
4. Clearing Outstanding Rent
Tcode: F-07
SAP Easy AccessAccountingFinancial AccountingGeneral Ledger
Document EntryOutgoing Payments
Document Date: 1.12.2011(1st
of next month) Type :SA CoCd : LAP
Posting Date : 1.12.2011
Bank data
Account : 200792 Bus area : LANZ
Amount : 1
Text : Outgoing Payment
Open Item Selection
Account : 100800
Enter
Enter to ignore the wrng msg
Double click on 36000 to deselect it.
+91-9959765211 58
57.
SrinivasaKasireddy+91-9959765211
(Deselect the itemsthat you don’t want to clear by double clicking on amount .
Selected items will be in blue colour and Deselected items will be in black colour)
Charge of diff button
Double Click on 1.00/-
Change the amount to *
Process Open Items Button
(‘Amount entered’ should be equal to ‘Assigned’)
+91-9959765211 59
SrinivasaKasireddy+91-9959765211
Status is ingreen colour for cleared items
7. Reversing Documents
Reversing a Clearing Document: Cleared items will be reset to open items
Reversing a Normal Document: When you reverse a document a reversing document
is generated
Displaying Cleared items
Tcode: FBL3N
GL Account : 100800
Cleared items
Execute
Note down the Document No (1000000005)and Clrng doc [100000007]
1. Reversing a Clearing Document
Upto General Ledger Same path
DocumentReset Cleared items
Tcode : FBRA
Clearing Document : 1000000007
Reset cleared items button (Save button)
Resetting and revers button
Reversal Reason : 01
Enter 3 times
2. Display item status
T Code: FBL3N
GL Account : 100800
+91-9959765211 61
SrinivasaKasireddy+91-9959765211
4. DataBase
DB :DB is a Set of tables
Table: Table is a combination of Rows & Columns
Rows are horizontal and Columns are vertical
Rows are also called “Records”
Columns are also Called “Fields”
Key Field
Key field is a column in which values are always unique. (Can not be repeated)
Eg :- Roll No in a class ,
Customer No in SAP system,
Vendor No in SAP system
(Roll No is unique in a class
Vendor No is unique in SAP system across company codes)
Key field combination
In a school Roll No is not enough to select the correct student.
We use both Class & Roll No combination to select the right student
Eg: Class & Roll No.(General)
CoCd, Document No &Year (SAP)
(In Tcode FB03 , You have to enter all the three inputs ie CoCd , Doc no , Year to
select the correct document )
Key fields Non key fields
Class Roll no Students
Name
Fathers
name
Fathers
phone no
city Hno
1 1 Johnson John 76678---- New york 7687-67
1 2 Laxman venkat 7676 Mumbai 7878
1 3 Venky Hari 5656 Banglore 7767
1 4 Rama Badri 6767666 Hyd 54
2 1 Rahim Ahmad 725436 Delhi 8217
2 2 Preethy Sridhar 819045 9072
2 3 Laxman --- -- -- --
Always use Key field or Key combination to select the correct record.
Non key fields take long time to select the records.
+91-9959765211 63
62.
SrinivasaKasireddy+91-9959765211
Data Types
Transaction DataBusiness data
(Generated , changed on regular basis as part of business
transactions)
Master Data Vendor Master Data, GL master data, Customer master data (We
do not change often)
Displaying / Changing the Structure of Table
Tcode : SE11
SAP Easy AccessToolsABAP workbenchDevelopmentABAP Dictionary
Database table : T001
Display Button
Note the 2nd
column ie ‘Key’
+91-9959765211 64
SrinivasaKasireddy+91-9959765211
Client dependent/ Clientindependent tables
Client Specific Data (Client dependent) Cross Client Data (Client independent )
First Field of table “MANDT”
(MANDT=Client)
MANDT IS Part of key Combination
Eg: Table T001
No “MANDT” field
Eg: Table TCURX
Cross client settings do not need
Transporting
TCode : SE11
+91-9959765211 66
65.
SrinivasaKasireddy+91-9959765211
Database table :TCURX
Display
Make a note that there is no ‘MANDT’ field
Cross Client Settings
Ex: SPROSAP Net WeaverGeneral SettingsCurrenciesSet decimal places for
currencies
Message: ‘Caution: The table is cross-client’
+91-9959765211 67
66.
SrinivasaKasireddy+91-9959765211
The Currency Decimalsis Server level setting(Affects all clients in the server)
Finding Out Table and Field names
Tcode:F-02
Keep the cursor in ‘Document Date’ field
F1 button
Technical information button
Note the table name ie ‘BKPF’
and Field name ie ‘BLDAT’
Double click on table name to display the table
+91-9959765211 68
67.
SrinivasaKasireddy+91-9959765211
TCode : F-02
DocumentDate :
Posting Date :
Company Code : LAP1
Posting Key : 40 Account : 200691
Enter
Keep the cursor in Amount field
F1 button on keyboard
Technical info button
Note The table name ‘BSEG’and Field Name ‘WRBTR’
Double click on table name BSEG
+91-9959765211 69
68.
SrinivasaKasireddy+91-9959765211
Contents button
Company code(BUKRS): LAP
Document No.(BELNR) : 010000000
Fiscal year(GJAHR) : 2011
Execute
List of Tables :
Header data Items data Open items Cleared items
GL items BKPF BSEG BSIS BSAS
Customer items BKPF BSEG BSID BSAD
Vendor items BKPF BSEG BSIK BSAK
Master data tables
General Bank details
Vendor Master LFA1 LFBK
Customer Master KNA1 KNBK
Relation ship between tables: SAP database is RDBMS.
Eg:
All address’ are stored in table ADRC.
Table ADRC is connected with other tables like LFA1, KNA1 etc
Tcode : SE11
Database table : LFA1
Display button
+91-9959765211 70
69.
SrinivasaKasireddy+91-9959765211
Contents button
Vendor (LIFNR) : LAPGNVNDR
Execute
Double click on LAPGNVNDR
Make note of ADRNR field ( 53445)
Open Tcode SE11 in another session.
Database table : ADRC
Display button
Contents button
ADDRNUMBER : 53445
Execute
Standard tables/ Customized tables
Standard tables Customized tables
Name starts with any character except Z and Y
Eg: T001, BKPF
Name starts Z or Y
Eg: ZT001, YBKPF
+91-9959765211 71
70.
SrinivasaKasireddy+91-9959765211
5. Cash Journal
Cashjournal is used to maintain Petty cash account , Branch level cash accounts etc
1. Settings
1. Creating GL Accounts
Tcode : FS00
Petti Cash
Select GL account 200691 Cash
Copy button
GL Account : 200692
Enter
Description : Petti Cash
Create/Bank/Interest tab:
√ Post automatically only
Save
Sales a/c
Create button
GL Account : 300510
Company Code : LAP
Enter
Account Group : Income
P&L statement acct
P & L stat acct type : X
Short Text : Sales
Long Text : Sales
Control Data Tab:
√ Line Item Display
Sort Key : 031 Customer No.
Create Bank Interest Tab:
Field Status Group : G001
Save
2. Define Number Range Intervals for Cash Journal
Documents
SPROFinancial AccountingBank AccountingBusiness TransactionsCash
JournalDefine Number Range Intervals for Cash Journal Documents
+91-9959765211 72
71.
SrinivasaKasireddy+91-9959765211
Company Code :LAP
Change intervals button
Insert Interval button
No. From number To number
01 100000000 199999999
Enter
Save
Continue
3. Set Up Cash Journal
Same path
New Entries
CompanyCode CJ Number G/L Account Cur DT G/L act
LAP 1 200692 INR SA
DT Disb D.tpe :Vept D.tpe :Vept D.tpe :Cupt Doc: Cus.pt Cash journal name
- KZ KZ DZ DZ Petti Cash
Save
Create request button
Short description : CJ settings for LAP
Enter
Continue.
4. Create, Change, Delete Business Transactions
Same Path
New Entries
Company
Code
Bus. tran
.type
G/L
Account
Cash journal business
trans.
Acct
Mod
LAP B 200790 Cash Deposit in bank √
LAP C 200790 Cash Receipt from bank √
LAP E 400591 Expenses √
LAP R 300510 Revenue -
+91-9959765211 73
72.
SrinivasaKasireddy+91-9959765211
Save
Continue
5. Set UpPrint Parameters for Cash Journal
Same Path Next line
New Entries
CoCd
Cash jour print
program
Report variant
LAP RFCASH00 DEMOEN
Save
Continue
2. End User
1. Posting Cash Journal
SAP Easy Access AccountingFinancial AccountingGeneral LedgerDocument
EntryCash Journal Posting
Tcode : FBCJ
Change Cash Journal button
Company Code : LAP
Cash journal : 1
Enter
Today button
+91-9959765211 74
73.
SrinivasaKasireddy+91-9959765211
Cash receipts tab:
(CashJournal do not allow –ve balances , so we post cash receipts first )
Business Transaction : CASH RECEIPT FROM BANK
Amount : 63000
Enter
Text : Cash receipt from bank
Business transaction : REVENUE
Amount : 9000
Enter
Text : Sales revenue
Business area : LANZ
+91-9959765211 75
74.
SrinivasaKasireddy+91-9959765211
Save button (Doc.stat changes to Yellow colour)
Post button (Doc. stat changes to Green colour )
Cash payments tab:
Business Transaction : EXPENSES
Amount : 18000
Enter
Change the GL Account to ‘400600’
Text : Rent Payment
Business Transaction : CASH DEPOSIT IN BANK
Amount : 36000
Enter
Text : Cash Deposit in bank
+91-9959765211 76
SrinivasaKasireddy+91-9959765211
6. Accounts Payable
AccountsPayable is a sub ledger connected to main ledger (GL) with a reconciliation
account called Sundry creditors.
3. Settings
1. Creation of Vendor Account Groups
SPROFinancial AccountingAccounting Receivable and Accounts
PayableVendor
AccountsMaster DataPreparations for Creating Vendor Master DataDefine
Account
Groups with Screen Layout (Vendors)
New Entries
Account Group : LAGN
Name : General vendors (LAP)
Double Click on Company code data
Double Click on Account management
Suppressed Req Entry Opt Entry
Reconciliation account
Save
Create request button
Short description : AP settings for LAP
Enter
Continue button
Back button
Select Account Group LAGN
Copy as button
Change Account Group to ‘LARM’
Change Name to ‘RM Vendors (LAP)’
Enter
Save
Back button
Select Account Group LAGN
Copy as button
Change Account Group to ‘LAOT’
Change Name to ‘One time Vendors (LAP)’
+91-9959765211 78
77.
SrinivasaKasireddy+91-9959765211
One-time account √
Enter
Save
2.Create Number Ranges for Vendor Accounts:
Same Path 11th
line
Create Number Ranges for Vendor Accounts
Change Intervals button
Insert interval button
No. From number To number Ext
XX A ZZZZZZZZZ √
Insert button
Save
Continue
(Vendor number ranges are global. Please skip this step in the lab if Num Range ‘XX’
already exists)
3. Assign Number Ranges to Vendors Account Groups
Same Path Next Line
Position button
Account Group : LA*
Enter
Group Number range
LAGN XX
LARM XX
LAOT XX
Save
Continue
4. Create Tolerance Group for Vendor Account
Up to Accounts Receivable and Accounts Payable same path
Business TransactionsOpen Item ClearingClearing DifferencesDefine tolerances
for Customers/Vendors
New Entries button
Company Code : LAP
Tolerance Group : Blank
+91-9959765211 79
78.
SrinivasaKasireddy+91-9959765211
Description : DefaultTgroup for LAP
Save
Continue
5. Creating Number Ranges for Document Types KA, KR,
KZ
T Code OBA7
Position Button
Document type : KA
Enter
Double click on Document Type KA
Note down the No. Range ie 17
Back button
Double Click on Document Type KR
Note down the No. Range ie 19
Back button
Double click on Document Type KZ
Note down the No. Range ie 15
In the same screen ‘Number range information’ button
Company Code : LAP
Change intervals button
Insert Interval button
No. Year From number To number
15 2011 1500000000 1599999999
Enter
Insert Interval Button
No. Year From number To number
17 2011 1700000000 1799999999
Enter
Insert Interval Button
No. Year From number To number
19 2011 1900000000 1999999999
Enter
+91-9959765211 80
79.
SrinivasaKasireddy+91-9959765211
Save
Continue button
6.Creation of 2 GL Accounts
Tcode : FS00
Sundry Creditors account:
Select GL account ‘100200’ ( ICICI term loan account)
Copy button
GL Account : 100980
Enter
Change the description to ‘Sundry Creditors’
Control Data Tab
Only balances in local crcy
Recon account for acct type : Vendors
Sort Key : 012
Create/bank/interest tab
Field status group : G067 Reconciliation A/C
Save
Inventory Raw Material Account :
Select GL account ‘200691’ Cash A/C
Copy button
GL account : 200700
Enter
Change the Description to ‘Inventory RM’
Control Data Tab:
Only balances in local crcy
Sort Key : 012 Vendor Name
Create/Bank/Interest tab:
Field status group : G059
Relevant to cash flow
Save
4. End User
1. Creating Vendor master
+91-9959765211 81
80.
SrinivasaKasireddy+91-9959765211
SAP Easy AccessAccountingFinancialAccountingAccounts PayableMaster
RecordsMaintain CentrallyCreate
Tcode : XK01
Vendor : LAPGNVNDR
Company Code : LAP
Account Group : LAGN
Enter
Name : LAP General Vendor
City : Hyderabad
Country : IN Region : 01
Next screen button 4 times (or Enter 4 times)
Recon. account : 100980 [Sundry creditors]
Sort key : 012 [Vendor name]
Cash mgmnt group : A1
Next screen button
Payt Terms : 0001
Tolerance group : Blank
Chk double inv. √
Save
2. Posting Purchase Invoice
SAP Easy AccessAccountingFinancial AccountingAccounts
PayableDocument
EntryInvoice-General
Tcode : F-43
Document Date : 24.11.2011 Type : KR Company Code: LAP
Posting Date : 24.11.2011
PstKy : 31 Account : LAPGNVNDR
Enter
Amount : 45000
Bus Area : LANZ
Payt Terms : 0001
Text : Purchase Invoice
PstKy : 40 Account : 200700 [Inventory RM]
Enter
+91-9959765211 82
81.
SrinivasaKasireddy+91-9959765211
Amount : *
BusinessArea : LANZ
Text : +
Document MenuSimulate
Document MenuSimulate General Ledger
Back button
Post
3. Displaying Vendor Items
Up to Accounts Payable same path
AccountDisplay/Change Line Items
Tcode: FBL1N
Vendor account : LAPGNVNDR
Company code : LAP
All items
√ Normal items
Execute
(Red color in ‘St’ column indicates open items)
4. Out Going Payment with Clearing
Path: Up To Accounts Payable same path
Document EntryOutgoing PaymentPost
Tcode :F-53
Document Date: 25.11.2011 Type: KZ Company Code: LAP
Posting Date: 25.11.2011 Currency: INR
Bank data
Account : 200792(ICICI Check Issue ac) Business area : LANZ
Amount : 1
Text : Outgoing Payment
Open Item Selection
Account : LAPGNVNDR
Enter
Deselect the items that you don’t want to clear by double clicking on the amount.
(Selected items will be in blue colour and deselected items will be in black colour)
Charge of diff button
Double click on Amount ‘1.00’
Change the Amount to ‘ * ’
Enter
+91-9959765211 83
82.
SrinivasaKasireddy+91-9959765211
Process Open Itemsbutton
(‘Amount Entered’ should be equal to ‘ Assigned’)
Document menu Simulate
Document menu Simulate General Ledger
Back button
Post
Note: Document No. 150000000 is generated(Payment Document)
(In the next topic we are going to issue the check using the payment document
1500000000)
+91-9959765211 84
83.
SrinivasaKasireddy+91-9959765211
7. Check Management
AmericanEnglish British English
Check Cheque
Check issue is possible in 3 ways
Manual Clearing and
Manual Check issue
Manual Clearing with
Check printing
Automatic Clearing and
Bulk Check printing
Covered in this chapter Covered in Chapter 11 Covered in Chapter 10
5. Settings
1. Creating Void Reason Codes
SPRO Financial AccountingAccounts Receivable and Accounts Payable
Business TransactionsOutgoing PaymentsAutomatic Outgoing Payments
Payment MediaCheck Management Define Void Reason Codes
New Entries
Reason Void reason cde
12 Check lost by vendor
13 Stop Payment
Save
Continue
(Void Reason Code are global )
6. End User
1. Creating Check Lot(Non-sequential)
Tcode : F110
Environment MenuCheck informationNumber Ranges
Paying company code : LAP
House Bank : ICICI
Account ID : ICICI
Change Button
+91-9959765211 85
84.
SrinivasaKasireddy+91-9959765211
Create Button
Lot number: 1
Check number : 72000
To : 72099
√ Non-sequential (For manual check issue select this field)
Short info : ICICI
Purchase date : 24.11.2011
Enter
Save
2. Issuing Manual Checks
Up to Accounts Payable same Path
EnvironmentCheck InformationCreate Manual Checks
Tcode : FCH5
Payment document no. : 1500000000
(Info : Payment doc ‘1500000000‘ has been generated in previous chapter)
Paying company code : LAP
Fiscal Year : 2011
House Bank : ICICI
Account ID : ICICI
Check number : 72009
Save
3. Entering Check Encashment Date
Up to Check Information same Path
ChangeAdditional Info/Cash
Tcode: FCH6
Paying company code : LAP
House Bank : ICICI
Account ID : ICICI
Check number : 72009
Enter
Check encashment : 27.11.2011
Save
+91-9959765211 86
85.
SrinivasaKasireddy+91-9959765211
4. Voiding UnusedCheck
Up to Check information same pathVoidUnused Checks
Tcode :FCH3
Paying company code : LAP
House Bank : ICICI
Account ID : ICICI
Check number from : 72008
Void reason code : 06 [Destroyed / unusable]
Void button
Message: Checks 72008 to 72008 have been voided
5. Voiding Issued Check
Creating Purchase Invoice
T Code F-43
Document Date : 28.11.2011 Type : KR
Posting Date : 28.11.2011
PstKy : 31 Account : LAPGNVNDR
Enter
Amount : 45000
Bus area : LANZ
Text : Purchase Invoice
PstKy : 40 Account : 200700
Enter
Amount : *
Bus area : LANZ
Text : +
DocumentSimulate
Post
Outgoing Payment
+91-9959765211
Voiding Checks:
a. Unused checkeg:Check unusable, Check lost before issuing.
b. Issued CheckEg :Check lost by vendor (We can issue a new check to the vendor)
c. Cancel paymentStop Payment(Vendor items will be reset to open items )
87
86.
SrinivasaKasireddy+91-9959765211
T Code F-53
DocumentDate : 28.11.2011 Type : KZ
Posting Date : 28.11.2011
Bank Data
Account : 200792 [ICICI Check Issue a/c] Business area : LANZ
Amount : 45000
Text : Outgoing payment
Open Item Selection
Account : LAPGNVNDR
Enter
Documents MenuSimulate
Post
Note down the Payment Document No. 1500000001
Issuing Manual Check
Tcode: FCH5
Payment document no. : 1500000001
Paying company code : LAP
Fiscal Year : 2011
House Bank : ICICI
Account ID : ICICI
Check number : 72004
Save
Voiding Check
Tcode: FCH9
Upto Check Information same pathVoidIssued Checks
Paying company code: LAP
House Bank : ICICI
Account ID : ICICI
Check number : 72004
Void reason code : 12 (Check lost by vendor)
Void button
Message: Payment Document Not Reversed
Issuing New Check to Vendor
Tcode: FCH5
+91-9959765211 88
87.
SrinivasaKasireddy+91-9959765211
Payment document no.: 1500000001
Paying company code : LAP
Fiscal Year : 2011
House Bank : ICICI
Account ID : ICICI
Check number : 72005
Save
6. Cancel Payment
Creating Purchase Invoice
T Code F-43
Documents Date : 28.11.2011
Posting Date : 28.11.2011
PstKy : 31 Account : LAPGNVNDR
Enter
Amount : 9000
Bus area : LANZ
Text : Purchase Invoice
PstKy : 40 Account : 200700[Inventory RM]
Enter
Amount : *
Bus area : LANZ
Text : +
Document MenuSimulate
Post
Outgoing Payment
T Code F-53
Document Date : 29.11.2011
Posting Date : 29.11.2011
Bank Data
Account : 200792 (ICICI Check Issue a/c) Business area : LANZ
Amount : 9000
Text : Outgoing Payment
Open Item Selection:
Account : LAPGNVNDR
Enter
+91-9959765211 89
88.
SrinivasaKasireddy+91-9959765211
Document MenuSimulate
Post
Document No.1500000002
Issuing Manual Check
Tcode :FCH5
Payment document no : 1500000002
Paying company code : LAP
Fiscal Year : 2011
House Bank : ICICI
Account ID : ICICI
Check number : 72006
Save
Voiding (Cancel Payment)
SAP Easy AccessAccountingFinancial AccountingAccounts Payable
Environment
Check InformationVoidCancel Payment
T Code :FCH8
Paying company code: LAP
House Bank : ICICI
Account ID : ICICI
Check number : 72006
Void reason code : 13 [Stop payment]
Reversal Reason : 09 [Stop Payment]
Cancel payment button
7. Displaying Check Register
T Code FCHN
Up to Check Information same path
DisplayCheck Register
Paying Company Code : LAP
House Bank : ICICI
Account ID : ICICI
With Line Item
Execute
+91-9959765211 90
89.
SrinivasaKasireddy+91-9959765211
8. Display CheckDetails in Vendor Items
T Code FBL1N
Vendor : LAPGNVNDR
Company Code : LAP
All Items
Execute
Change Layout Button
Find Button
Find : Check
Enter
Select ‘Check Encashment date’ and ‘Check no. from ‘
In the line1 column select Document Number
Left arrow Button
Copy Button
Make a note of ‘Check No from’ and ‘Check encashment date’ columns
+91-9959765211 91
90.
SrinivasaKasireddy+91-9959765211
8. Partial-Payment andResidual payment
Partial Payment:
Partial-Payment does not clear the invoice. Both the Invoice and the Payment entry will
be
shown in the vendor account as open items. Partial-Payment method is used when the
remaining amount is to be paid later.
Residual- Payment:
Residual-Payment clears the invoice and creates a new open item for the balance
amount.
Residual-Payment method is used when the payment made is
overpayment/underpayment
but final. The difference (residual) amount can be settled to separate GL accounts.
Reason code:
Reason code can be defined in the system to explain the reason for payment
difference.
Each Reason code can be assigned to a separate G/L account.
Settings for Residual payment
1. Creating G/L accounts
Freight Charges
T Code - FS00
Select GL account 400500 [Salaries]
Copy Button
GL Account : 400592
Enter
Change the description to ‘Freight charges ‘
Save
Commision paid
T Code - FS00
Select GL account 400500 [Salaries]
Copy Button
GL Account : 400593
Enter
Change the description to ‘Commission paid‘
Save
2. Creating Reasoncodes
+91-9959765211 92
91.
SrinivasaKasireddy+91-9959765211
SPROFinancial AccountingAccounts Receivableand Accounts
PayableBusiness
TransactionsOutgoing paymentsManual Outgoing Payments
Overpayment/Underpayment Define Reason Codes (Manual Outgoing Payments)
Company Code : LAP
Enter
New Entries
RCd Short text Long text C
01 Freight charges Freight charges √
02 Commission Commission √
Save
Continue
3. Define Accounts for Payment Differences
Same path Define Accounts for Payment Differences (Manual Outgoing Payments)
Tcode OBXL
Chart of Accounts : LACA
Enter
Reason code √
Save
Accounts button
Reason code Account
01 400592
02 400593
Save
Continue
Enduser
1. Posting Purchase Invoice
Tcode : F-43
Create a purchase invoice for an amount of 63000
2. 1st
Partial Payment
Tcode :F-53
Document Date: 29.11.2011 Type: KZ Company Code: LAP
Posting Date: 29.11.2011 Currency: INR
+91-9959765211 93
92.
SrinivasaKasireddy+91-9959765211
Bank data
Account :200792(ICICI Chck Issue ac) Business area : LANZ
Amount : 54000
Text : Partial Payment
Open Item Selection
Account : LAPGNVNDR
Enter
Partial pmt tab
Double click in Payment amount field (or Enter 54000)
(Payment amount field will be updated)
(‘Amount Entered’ should be equal to ‘ Assigned’)
DocumentSimulate
Post
3. Displaying Vendor Items
Up to Accounts Payable same path
AccountDisplay/Change Line Items
Tcode: FBL1N
Vendor account : LAPGNVNDR
Company code : LAP
All items
√ Normal items
Execute
(Both the original invoice and the payment item are shown as open items)
+91-9959765211 94
93.
SrinivasaKasireddy+91-9959765211
4. 2nd
Partial Payment
Tcode:F-53
Document Date: 29.11.2011 Type: KZ Company Code: LAP
Posting Date: 29.11.2011 Currency: INR
Bank data
Account : 200792(ICICI Chck Issue ac) Business area : LANZ
Amount : 9000
Text : 2nd
Partial Payment
Open Item Selection
Account : LAPGNVNDR
Enter
Deselect other items except 63000 and 54000(if any)
(To select or deselect the items , double click on the amount.)
(Selected items will be in blue colour and deselected items will be in black colour)
(‘Amount Entered’ should be equal to ‘ Assigned’)
DocumentSimulate
Post
5. Posting Purchase Invoice
Tcode : F-43
Create a purchase invoice for an amount of 36000
6. Residual Clearing(Over payment)
Tcode :F-53
Document Date: 29.11.2011 Type: KZ Company Code: LAP
Posting Date: 29.11.2011 Currency: INR
Bank data
Account : 200792(ICICI Chck Issue ac) Business area : LANZ
Amount : 36900
Text : Outgoing Payment
Open Item Selection
Account : LAPGNVNDR
Enter
Res. Items tab
Deselect the other items except 36000(If any)
Double click in Residual items field
+91-9959765211 95
SrinivasaKasireddy+91-9959765211
2. Display SpecialGL Items
T Code FBL1N
VendorAccount : LAPGNVNDR
Company Code : LAP
All Items
Special GL Transactions
Execute
3. Posting Purchase Invoice
Post an Invoice for Rs.45000 using T CodeF-43
4. Clearing the invoice against the advance
Tcode : F-44
Up to Account Payable Same path
AccountClear
Account : LAPGNVNDR
Company Code : LAP
Special G/L ind : A √ Normal OI
Enter
Except Cr 45000 and Dr 45000, deselect other items [by double clicking]
Post
+91-9959765211
√
101
100.
SrinivasaKasireddy+91-9959765211
10. Down-payment Request
Down-paymentRequests are used to display advances to be paid in cash flow
statement
Down-payment Requests are used to pay the down-payment through APP
Special GL indicator ‘F’ is used for down-payment request
Down-payment Requests are displayed as Noted items in vendor item display
1. Settings
1. Creating GL Account Down-payment request
T Code: FS00
Select GL account 100980 (Sundry Creditors A/C)
Copy Button
G/L Account : 100881
Enter
Change the Description to ‘Down-payment Request ‘
Save
2. Specify Alternative Reconciliation A/C
SPROFinancial AccountingAccounts Receivable and Accounts
PayableBusiness
TransactionsDown Payment madeDefine Alternative Reconciliation Account for
Down
Payments
Double click on Special GL ind ‘F’
Chart of Accounts : LACA
Enter
Reconciliation Account Special GL Account
100980 100881
Save
Continue
2. End User
1. Posting Down-payment Request
SAP Easy AccessAccountingFinancial AccountingAccounts
PayableDocument
EntryDown PaymentRequest
+91-9959765211 102
101.
SrinivasaKasireddy+91-9959765211
Tcode : F-47
DocumentDate : 2.12.2011 Type : KA
Posting Date : 2.12.2011
Vendor
Account : LAPGNVNDR
Trg .sp .G/L ind : A
New item button
Amount : 27,000
Business Area : LANZ
Due on : 4.12.2011
Text : Down payment Request
Post
2. Displaying Down-payment Request ( Noted items):
T Code: FBL1N
Vendor Account : LAPGNVNDR
Company Code : LAP
All Items
√ Noted Items
Execute
+91-9959765211 103
SrinivasaKasireddy+91-9959765211
11. Automatic PaymentProgramme [APP]
APP is run periodically (Weekly or every 10 days or so)
APP selects the items based on specified criteria and clears them. We can manually
edit the
items.
APP can be used for the following payment modes:
1. Bulk Check Printing at our Site
2. Check Printing at Bank
3. Direct Debit
4. RTGS
5. NEFT
Payment modes are specific to country . RTGS and NEFT are payment modes available in
India . Similar payment modes may be available in other countries and APP can be used to
make payments in those modes.
Payment types 2-5 Payment type 1
Step1: Run APP
Step2: Run a customized ABAP program
which can download the details to a text file
Step3: Send the text file to the House bank
Step4: The Bank system will read the text
file and process the payments .
Step1: Run APP
Step2:Printing checks
For payment type 1 we are doing the following configuration
1. Settings
1. Creating HDFC Current Account
T Code: FS00
Select GL account 200790 (ICICI Current Account)
Copy Button
GL Account : 200770
Enter
Change the Description to ‘HDFC Current Account’
Save
2. Define House Bank (HDFC)
+91-9959765211 105
104.
SrinivasaKasireddy+91-9959765211
T Code: F110
EnvironmentMenuMaintain config
House banks button
Company Code : LAP
Enter
New Entries button
House Bank : HDFC
Bank Country : IN
Bank Key : 345678
Enter
Create
Bank Name : HDFC
Street : Bank Street
City : Hyderabad
Branch : Tarnaka
Enter
Save
Continue
Double Click on Bank Accounts folder
New Entries button
Account ID : HDFC
Description : HDFC Current Account
Bank Account No. : 39495469
G/ L : 200770 (HDFC Current A/C)
Currency : INR
Save
3. Creating HDFC Check Deposit Account
T Code: FS00
Select GL Account 200770 ( HDFC Current account)
Copy Button
GL Account : 200771
Enter
Change the Description to ‘HDFC Check Deposit account ‘
Control Data Tab
√ Open item management
Sort key : 000 (Assignment number)
+91-9959765211 106
105.
SrinivasaKasireddy+91-9959765211
Save
4. Creating HDFCCheck Issue Account
Select GL Account 200771 (HDFC Check Deposit account)
Copy Button
GL Account : 200772
Enter
Change the Description to ‘HDFC Check issue account’
Save
5. Configuring APP
SAP Easy AccessAccountingFinancial AccountAccounts PayablePeriodic
ProcessingPayments
T Code: F110
Environment MenuMaintain Config.
T Code: FBZP
All Company codes button
New Entries
Company Code : LAP
Paying company code : LAP
Vendors
Sp. G/L transactions to be paid : F
Save
Continue
Back button twice
Paying company codes button
New Entries
Paying co. code : LAP
Forms button
Form for the Payment Advice : F110_D_AVIS
Sender Details button
Text ID : ST [Standard Text]
Letter header : F_0001_HEADER
Footer : F_0001_FOOTER
Sender : F_0001_SENDER
Save
Continue
+91-9959765211 107
106.
SrinivasaKasireddy+91-9959765211
Back button twice
SAPScripts, Smart Forms are used for printing in SAP
Standard Objects Customized Objects
Name Starts with any
charter other than ‘Z’ or ‘Y’
Ex: F110_D_AVIS
Name Starts with
‘Z’ or ‘Y’
Ex: ZF110_D_AVIS
Displaying/Changing Forms :
SAP Easy AccessToolsForm printoutSAP
ScriptsForm
Tcode: SE71
Form : F110_D_AVIS
Display Button
Enter to Ignore the Msg
Utilities MenuPrinting Test
Output Devise: LP01
Print Preview Button
Pmnt methods in country button
New Entries
Country : IN
Pymt Method : H
Description : Check
Outgoing payments
Check
√ Street ,P.O.box or P.O. Box pst code
Bank details
+91-9959765211
Info:
‘Street ,P.O.box or P.O. Box pst code’ is selected for payment type check
‘Bank details’ is selected for transfer payment modes.
108
107.
SrinivasaKasireddy+91-9959765211
Document type forpayment : ZP
Clearing document type : ZV
Payment medium program : RFFOUS_C (Check printing program)
Name of print dataset : LIST1S
Save
Continue
Info: Create a payment method for each of the payment types(2-5)
Back button twice
Pmnt methods in company code button
New Entries
Paying co. code : LAP
Pymt Method : H
Form Data button
Form for Payment Medium : F110_PRENUM_CHCK (Check printing form)
Drawer on the form
For LAIR P LTD
Authorized signatory
Save
Continue
Back button twice
Bank determination button
Select Paying company code ‘LAP’
Double Click on Ranking Order folder
New Entries
PM Crcy Rank.order House bk
H INR 1 ICICI
H INR 2 HDFC
Save
Continue
Double Click on Bank Accounts folder
+91-9959765211 109
108.
SrinivasaKasireddy+91-9959765211
New Entries
House bankPay. Method Currency Account ID Bank subaccount
ICICI H INR ICICI 200792
HDFC H INR HDFC 200772
Save
Double Click on Available Amounts folder
New Entries
House bank Account ID Currency Available for outgoing payment
ICICI ICICI INR 90000
HDFC HDFC INR 54000
Save
6. Creating Number Ranges for Document Types ZP & ZV
T Code: OBA7
Double click on Document Type ‘ZP’
Note down Number range ie 20
Number range information button
Company Code : LAP
Change Intervals button
Insert Interval button
No. Year From number To number
20 2011 2000000000 2099999999
Enter
Save
Continue
2. End User
1. Changing Vendor Master
T Code: XK02
Vendor : LAPGNVNDR
Company code : LAP
General Data
√ Address
Company code data
√ Payment transactions
Enter
+91-9959765211 110
109.
SrinivasaKasireddy+91-9959765211
Street : DSNR
PostalCode : 500035
Next screen button
Payment methods : H
Individual pmnt √
Save
2. Creating Pur Invoice
Tocde:F-43
PstKy : 31 Account : LAPGNVNDR
Enter
Amount : 27000
Business Area : LANZ
Pmt Method : H
Text : Purchase Invoice
PstKy : 40 Account : 200700
Enter
Amount : *
Business Area : LANZ
Text : +
Document MenuSimulate
+91-9959765211 111
110.
SrinivasaKasireddy+91-9959765211
Post
Create 4 moreInvoices for amount 9000, 18000, 36000, 45000
3. Down Payment Request
T Code: F-47
Create Down Payment request for amounts 9000, 18000
(Payment mthd : H
Due on : Todays date)
4. Creating Check Lots (Sequential)
T Code: F110
Environment MenuCheck informationNumber Ranges
Paying company code : LAP
House Bank : ICICI
Account ID : ICICI
Change button
Create button
Lot number : 2
Check number : 81000
To : 81999
Non-sequential
Shot Info : ICICI
Purchase date : 1.12.2011
+91-9959765211 112
111.
SrinivasaKasireddy+91-9959765211
Enter
Save
Back Button
House Bank: HDFC
Account ID : HDFC
Change Button
Create Button
Lot number : 1
Check number : 81000
To : 81999
Non-sequential
Shot Info : HDFC
Purchase date : 1.12.2011
Save
5. Payment Run
T Code: F110
Run Date : 30.11.2011(Today’s date)
Identification : LAP
Parameter tab
Posting Date : 30.11.2011 Docs entered up to : 30.11.2011
+91-9959765211 113
112.
SrinivasaKasireddy+91-9959765211
Company codes Pmtmeths Next p/ date
LAP H 1.12.2011
Vendor : LAPGNVNDR
Save
Info:
Importance of Next P/Date
Run Date Next P/Date
5.5 .2011 10.5.2011
Due Date Selected for payment ?
Invoice 1 8-5-2011 Yes
Invoice 2 6-5-2011 Yes
Invoice 3 11-5-2011 No*
+91-9959765211 114
113.
SrinivasaKasireddy+91-9959765211
*Invoice 3 isnot selected for payment because it can be paid in next Payment Run(on 10-
12-2013) without becoming over due
Status tab
Proposal button
√ Start immediately
Enter
Keep on pressing Enter until status changed into “Payment proposal has been
created”
Displaying Proposal:
Edit MenuProposalDisplay Proposal
Back button
Displaying Proposal List:
Edit MenuProposalProposal listEnter
Back button
*Incase of Error
Display Proposal log button
Delete the Proposal and redo Proposal after rectifying the problem
Deleting Proposal (In case of errors):
Edit menuProposalDelete
’Yes’ button to delete`
+91-9959765211
Proposal
Run
Edit proposal
NoErr
or
Pymnt
Run
Error
Rectification
Delete
proposal
Che
ck
Transf
er
Print Checks
Run ABAP
program
and send
the text file
to bank
115
114.
SrinivasaKasireddy+91-9959765211
Editing Proposal:
1. Blockthe invoice for payment
2. Changing the bank for an item
Edit MenuProposalEdit
All accounting clerks
Enter
Double click on the item that you want to block
Again Double click on the item
Payment Block : A [Block for payment]
Enter
Back button
Double click on the item for which you want to change the bank
Again double click on item
Reallocate button
New Payment button
House Bank : HDFC HDFC
Continue
Back button twice
’Yes’ button to save data
Payment Run Button
√ Start Immediately
Enter
+91-9959765211 116
115.
SrinivasaKasireddy+91-9959765211
Keep on Pressingenter until the status changed to ‘Posting orders X generated,
Posting orders X completed’
In case of error in Payment run:
Edit MenuPaymentDelete output “Yes” button
Fix the problem Payment run(Redo)
Display vendor line items [FBL1N]
All items
Execute
6. Check Printing(Bulk)
Printout/data medium tab
Program Variant Variant
RFFOUS_C ICICI_LAP HDFC_LAP
Keep the cursor on variant ICICI_LAP
Maintain Variants button
+91-9959765211 117
116.
SrinivasaKasireddy+91-9959765211
For All SelectionScreens
Continue
Program run date : 30.11.2011
Identification feature : LAP
Paying Company Code: LAP
Payment method : H
House Bank : ICICI
Account ID : ICICI
Check lot number : 2
Print Control:
√ Print checks Printer :LP01 √ Print Immediately
√ Print payment advice notes Printer : LP01 √ Print Immediately
√ Print Payment Summary Printer : LP01 √ Print Immediately
Number of sample printouts : 0
Attributes button
Description : ICICI_LAP
Save
Back button
Keep the Cursor on variant HDFC_LAP
Maintain Variants button
House bank : HDFC
Account ID : HDFC
Check lot number : 1
Remaining fields same as before
+91-9959765211 118
117.
SrinivasaKasireddy+91-9959765211
Attributes button
Description :HDFC_LAP
Save
Back button
Save
Status tab
Printout button
√ Start Immediately
In the Job name replace ‘?’ With ICICI_LAP
Enter
Again click on Printout button
√ Start immediately
Replace ‘?’ with HDFC_LAP
Enter
Displaying Print status :
System MenuServicesOutput control
Date Created : 30.11.2011
Execute
Double Click on Type column against Check
+91-9959765211 119
SrinivasaKasireddy+91-9959765211
12. Manual clearingwith check printing
1. Settings
Settings already done in APP
2. End User
1. Posting Pur Invoice
Tcode : F-43
Post an invoice worth 18000
Payment methd : H
2. Clearing with printing check
SAP Easy access Accounting Financial accounting Accounts payable
Document Entry Outgoing payment Post +Print Forms
Tcode F-58
Company Code : LAP
Payment method : H
House Bank : ICICI
Check lot number : 2
Printer for forms : LP01
√ Print immediately
Enter payments button
Document Date : 1.12.2011 Type : KZ Company Code : LAP
+91-9959765211 121
120.
SrinivasaKasireddy+91-9959765211
Posting Date :1.12.2011
Amount : 1 Business Area : LANZ
Value date : Todays date
Text : Outgoing payment with check printing
Vendor : LAPGNVNDR
Process open items button
Deselect the items that you do not want to clear .
Charge of diff button
Double click on ‘1.00’
Amount : *
Document Simulate
Post.
Enter
Output device : LP01
Continue
Check the print status using Tcode SP01
+91-9959765211 122
SrinivasaKasireddy+91-9959765211
13. Accounts Receivables
ARis a sub ledger connected to main ledger (GL) with a reconciliation account called
Sundry Debtors account
SD Implemented SD Not Implemented
SD is used for sale of finished goods
AR used for sale of assets, services
Account Receivable is used for all kind of sales
1. Settings
1. Creating Customer Account Groups
SPROFinancial AccountingAccounts Receivable and Accounts
PayableCustomer
AccountsMaster DataPreparations for Creating Customer Master DataDefine
Account
Groups with Screen Layout [Customer]
New Entries Button
Account Group : LAGN
Name : General Customers [LAP]
Double Click on Company code data
Double Click on Account management
Suppressed Req Entry Opt Entry
Reconciliation account
Save
Create request button
Short Description : AR settings (LAP)
Enter
Continue
Back button
Select account group ‘LAGN’
Copy as button
Change Account Group to ‘LASD‘
Change Name to ‘SD Customers [LAP]’
Enter
Save
+91-9959765211 124
123.
SrinivasaKasireddy+91-9959765211
2. Creating NumberRanges for Customer Accounts
Same Path
Create Number Ranges for Customer Accounts
Change Intervals Button
Insert Intervals Button
No. From number To number Ext
XX A ZZZZZZZZZZ √
Enter
Save
Continue
(Customer number ranges are global. Please skip this step in the lab if Num Range
already exists)
3. Assign Number Ranges to Customer Account Groups
Same Path Next Line
Position Button
Account Group : LA*
Enter
Account Group No Range
LAGN XX
LASD XX
Save
Continue
4. Creating Tolerance group for Customer Account
(Already created in AP Settings – skip this step)
5. Creation of Sundry Debtors A/C
T Code FS00
Select GL account 200790 ICICI Current Account
Copy button
GL Account : 200610
Enter
Change Description : Sundry Debtors
Control Data Tab
Only balances in local crcy
Recon. account for acct type : Customers
Sort key : 031 Customers
+91-9959765211 125
124.
SrinivasaKasireddy+91-9959765211
Create/bank/interest tab
Field statusgroup : G067 Reconciliation Account
Relevant to cash flow
Save
6. Creating Number Ranges for Document Types DR, DZ
& DA
T Code: OBA7
Double Click on Document Type DA
Note down the No. range ie 16
Back button
Double Click on Document Type DR
Note down the NO. Range ie 18
Back button
Double Click on Document Type DZ
Note down the No. Range ie 14
Number Range information button
Company Code : LAP
Change Intervals button
Insert Interval button
No. Year From number To number
14 2011 1400000000 149999999
Enter
Insert Interval button again
No. Year From number To number
16 2011 1600000000 1699999999
Enter
Insert Interval button again
No. Year From number To number
18 2011 1800000000 1899999999
Enter
Save
Continue
+91-9959765211 126
125.
SrinivasaKasireddy+91-9959765211
2. End User
1.Creating Customer master
T Code: XD01
SAP EASY AccessAccountingFinancial AccountingAccounts Receivable
Master RecordsMaintain CentrallyCreate
Account Group : Gen Customers (LAP)
Customer : LAPGNCUST
Company Code : LAP
Enter
Name : LAP Gen customer
Country : IN
Company Code Data Button
Recon account : 200610
Sort key : 031 Customer No.
Payment Transaction Tab:
Terms of pymt : 0001
Save
2. Posting Sales Invoice
Tcode : F-22
SAP Easy AccessAccountingFinancial AccountingAccounts
ReceivableDocument EntryInvoice – General
Document Date : 06.12.2011 Type : DR
Posting Date : 06.12.2011
PstKy : 01 Account : LAPGNCUST
Enter
Amount : 27000
Business Area: LANZ
Text : Sales Invoice
PstKy : 50 Account : 300510 (Sales a/c)
Enter
Amount : *
Business Area: LANZ
Text : +
Enter
+91-9959765211 127
126.
SrinivasaKasireddy+91-9959765211
Document menuSimulate
Document menuSimulateGeneral
Back button
Post
3. Displaying Customer Items
Tcode:FBL5N
Up to Account Receivable same PathAccountDisplay/Change line items
Customer Account : LAPGNCUST
Company Code : LAP
All Items
Execute
(Red colour indicates open items)
(Display customer balances FD10N)
4. Posting Incoming Payment
Tcode : F-28
Up to Account Receivable Same path Document EntryIncoming Payments
Document Date: 06.12.2011 Type : DZ
Posting Date : 06.12.2011
Bank Data
Account: 200791 (ICICI Check receiving ac) Business Area : LANZ
Amount : 1
Text : Incoming Payment
Open Item Selection
Account : LAPGNCUST
Enter
(Deselect the items that you don’t want to clear by double clicking on the amount
Deselected items will be in black color)
Charge of diff button
Double click on amount ‘1.00’
Change Amount to *
Enter
Document menu Simulate
Document menu Simulate General Ledger
Back button
Post
+91-9959765211 128
SrinivasaKasireddy+91-9959765211
14. Down-Payments Received
NormalAdvances
Sales
Payment Receipt
Payment Receipt
Sales
Reconciliation Account: Sundry Debtors Alternative Reconciliation Account :
Advance from Customer
No special GL indicator Spl GL indicator ‘A’
1. Settings
1. Creating GL Account Advance from Customers
Tcode : FS00
Select GL account 100980 (Sundry Creditors account)
Copy Button
G/L Account : 100908
Enter
Change Description : Advance from customers
Control Data Tab:
Recon account for acct type : Customers
Sort key : 031
Save
2. Specify Alternative Reconciliation Aaccount
SPROFinancial AccountingAccounts Receivable & Account PayableBusiness
TransactionsDown Payment ReceivedDefine Reconciliation Account for Customer
Down payments
Double click on Spl. GL ind ‘A’
Chart of Accounts : LACA
Enter
Reconciliation Account Spl. GL Account
200610 100908
Save
Continue
+91-9959765211 130
129.
SrinivasaKasireddy+91-9959765211
2. End User
1.Posting Advance Receipt from Customer
Tcode: F-29
SAP Easy AccessAccountingFinancial AccountingAccounts
ReceivableDocument EntryDown paymentDown payment
Document Date: 06.12.2011 Type : DZ
Post Date : 06.12.2011
Customer
Account : LAPGNCUST Special G/L ind : A
Bank
Account : 200791 ICICI Check deposit a/c Business Area: LANZ
Amount : 63000
Text : Advance from Customer
Enter
Amount : * Business Area : LANZ
Text : +
Document MenuSimulate
Document MenuSimulate General Ledger
Back button
Post
2. Displaying Advance Items
Tcode : FBL5N
Customer Account : LAPGNCUST
Company Code : LAP
All items
√ Spl G/L Transactions
Execute
3. Creating Invoice
T Code : F-22
Create an invoice worth 9000
4. Converting Advance Item to Normal Item (spl GL to
Normal)
Tcode: F-39
Up to Document Entry same pathDown PaymentClearing
Document Date: 06.12.2011 Type : DA
+91-9959765211 131
130.
SrinivasaKasireddy+91-9959765211
Posting date :06.12.2011
Customer
Account : LAPGNCUST
Invoice Reference : Blank
Text : Advance to Normal
Process Down payments button
Transfer Posting
9000
Document MenuSimulate
Document MenuSimulate General ledger
Back button
Post
5. Clearing
Tcode:F-32
Up to Account Receivable Same PathAccountClear
Account : LAPGNCUST
Company Code : LAP
Process open items button
Deselect other items (if any) except Dr. 9000 and Cr. 9000
Post
6. Display Customer Items
Tcode: FBL5N
Customer : LAPGNCUST
Company Code : LAP
All items
√ Normal Item
√ Spl. G/L Transactions
Execute
+91-9959765211 132
131.
SrinivasaKasireddy+91-9959765211
15. Dunning
Sending Remaindersto Customers or Vendors requesting the payments
Dunning level determines the format of the letter.
We are using 4 dunning levels
1. Grace Period: Items will be included in the dunning letter after the grace period
2. Dunning Interval: No. of days between two dunning levels
3. Days in Arrears: No of days that past after the due date
4. Minimum days in arrears: To start the dunning for the customer at least one item
must past the Minimum days in arrears
1. Settings
1. Define Dunning Areas
SPROFinancial AccountingAccounts Receivable and Accounts
PayableBusiness TransactionsDunningBasic Settings for DunningDefine
Dunning Areas
New Entries button
Enter ( If any Warnings)
CoCd Area Text
LAP Blank Dunning Area for LAP
Save
Enter
Continue
2. Define Dunning Procedure
Up to Dunning same path
Dunning ProcedureDefine Dunning Procedures
New Procedure button
Dunn. Procedure : LAP1
+91-9959765211 133
132.
SrinivasaKasireddy+91-9959765211
Name : DunningProcedure for LAP
General Data
Dunning Interval in Days : 10
No. of dunning levels : 4
Min.days in arrears (acct) : 5
Line Item grace periods : 3
Interest Indicator : 01 Standard
Public hol . cal . ID : 01
√ Standard transaction dunning
Dunning levels button
Enter to ignore warning msg
Printing Parameters
1 2 3 4
Always Dun? √ √ √ √
Print all items √ √ √ √
Charges button
+91-9959765211 134
SrinivasaKasireddy+91-9959765211
Customer
Enter
New company codeButton
Company Code : LAP
Enter
Company Code Separate notice for dunning level
LAP √
Save
Continue
Dunning texts button Again
Company Code : LAP
Enter
Normal Dunning Procedure Form
1 F150_DUNN_01
2 F150_DUNN_02
3 F150_DUNN_03
4 F150_DUNN_04
+91-9959765211 137
136.
SrinivasaKasireddy+91-9959765211
Back button
Save
2.End User
1. Changing Customer Master
Tcode: XD02
Customer : LAPGNCUST
Company Code : LAP
Enter
Company Code Data button
Correspondence tab
Dunn procedure : LAP1
Save
+91-9959765211 138
137.
SrinivasaKasireddy+91-9959765211
2. Creating SalesInvoices with various Due dates
Tcode: F-22
Document Date : 30.11.2011 (todays date)
Posting Date : 30.11.2011
PstKy : 01 Account : LAPGNCUST
Enter
Amount : 18000
Business Area: LANZ
Payment Terms : 0001
Baseline date : Todays date
Text : Sales Invoice
PstKy : 50 Account : 300510 Sales
Enter
Amount : *
Business Area: LANZ
Text : +
Document MenuSimulate
Post
Create 5 more sales invoices in the following way
Doc Date/Posting Date/
Bline date
Payment terms
Inv1 5 days back
0001
Inv2 4 days back
Inv3 2 days back
Inv4 1 day back
Inv5 Todays date NT30
+91-9959765211 139
138.
SrinivasaKasireddy+91-9959765211
(Inv3 & Inv4will not be selected for dunning because the two items hasn’t passed the
grace period )
3. Checking Due Dates
T Code: FBL5N
Customer Account : LAPGNCUST
Company Code : LAP
Open Items
Execute
Change Layout button
In the Hidden fields select ‘Arrears after net due date’
Select Net due date in Line1 column
Left arrow button
In the hidden field column select ‘Net Due date symbol’
Left arrow button
Copy Button
+91-9959765211 140
SrinivasaKasireddy+91-9959765211
4. Execute DunningProcedure
Tcode :F150
Up to Accounting Receivables Same path
Periodic ProcessingDunning
Run On : 30.11.2011
Identification : LAP
Parameters tab
Dunning Date : 30.11.2011
Docmnts posted up to: 30.11.2011
Company Code : LAP
Customer : LAPGNCUST
Save
Status Tab
Schedule button
Output device : LP01
Enter
Start Immediately √
Schedule button
Keep on pressing enter until status changed to ’ Dunn Selection is complete’
Dunning list button(to display items that are included in dunning)
Enter
+91-9959765211 142
141.
SrinivasaKasireddy+91-9959765211
Back button
Dunning printoutbutton
Output device : LP01
Continue button
Print button
Keep on pressing Enter until status change to ‘Dun Print out is complete’
Displaying print status:
System MenuServicesOutput control
Date Created : 30.11.2011
Execute
Double Click in the Type column to display the forms printed
Display or Changing the form [SE71]
SAP Easy AccessToolsForm PrintoutSAP ScriptForm
Form : F150_DUNN_01
Display button
Utilities menuPrinting testOutput deviceLP01Print
preview
(Please check the image to see the letters printed)
+91-9959765211 143
SrinivasaKasireddy+91-9959765211
16. Discounts
Option 1:Automatic Discount Calculation (based on Payment terms)
Option 2: Manual Entry of Discount
1. Settings
1. Creating Payment Terms
SPROFinancial Accounting Accounts Receivable and Accounts Payable
Business
Transactions Incoming Invoices/ Credit Memos Maintain Terms of Payments
New Entries
Payment terms : LAP1
√ Customer
√ Vendor
Enter
Save
Continue
+91-9959765211
Term Percentage No. of days
1 5 15
2 2 30
3 45
145
144.
SrinivasaKasireddy+91-9959765211
2. Creating GLaccount ‘Discount given’
T Code :FS00
Select GL account 400500 ( Salaries)
Copy button
GL account : 400491
Enter
Description : Discount given
Save
3. Define Accounts for Cash Discount Granted
Up to Business Transactions same path
Incoming Payments Incoming Payments Global Settings Define Accounts for
Cash Discount Granted
+91-9959765211 146
145.
SrinivasaKasireddy+91-9959765211
Chart of accounts: LACA
Enter
Save
Account
400491
Save
Continue.
4. Changing Employee Tolerance group
Tcode : OBA4
Position button
Tolerance group : Blank
Company code : LAP
Enter
Double click on CoCd ` LAP’
Cash discount per line item : 5
Save
Continue.
+91-9959765211 147
146.
SrinivasaKasireddy+91-9959765211
2. End User
1.Posting Sales invoice (Discount calculated based on
Payment Terms)
T code : F-22
Document Date : 6.12.2011
Posting Date : 6.12.2011
PstKy : 01 Account : LAPGNCUST
Enter
Amount : 36000
Bus area : LANZ
Payt Terms : LAP1
Text : Sales invoice
Enter (Days/ percent will be updated )
+91-9959765211 148
147.
SrinivasaKasireddy+91-9959765211
PstKy : 50Account : 300510
Enter
Amount : *
Bus area : LANZ
Text : +
Document Simulate
Post.
2. Clearing the above invoice
Tcode: F-28
Document Date : 23.12.2011 (17 days after the inv date)
Posting Date : 23.12.2011
Bank data
Account : 200791 Bus area : LANZ
Amount : 1
+91-9959765211 149
148.
SrinivasaKasireddy+91-9959765211
Text : Incomingpayment
Account : LAPGNCUST
Enter
Deselect other items except Today’s
Charge of dif button
Double click on ‘1.00’
Change amount to ‘*’
Process open items button
Document Simulate
Double click on blue line item
Text : Discount given
Display Document Overview button
Post.
+91-9959765211 150
149.
SrinivasaKasireddy+91-9959765211
3. Posting Salesinv (Manual Entry of Discount)
(Discount amount can be entered in either invoice or clearing document)
Tcode :F-22
Document Date : Today’s date
Posting Date : Today’s date
PstKy : 01 Account : LAPGNCUST
Enter
Amount : 27000
Bus area : LANZ
Payt terms : 0001 Disc amount: 200
Text : Sales invoice
PstKy : 50 Account : 300510
Enter
Amount : *
Bus area : LANZ
Text : +
Document Simulate
Post
4. Clearing the above invoice
Tcode: F-28
Document Date : Today’s date
Posting Date : Today’s date
Bank data
Account : 200791
Amount : 1
Text : Incoming payment
Account : LAPGNCUST
Enter
+91-9959765211 151
150.
SrinivasaKasireddy+91-9959765211
Deselect other itemsexcept today’s.
(Discount can be changed or entered here )
Charge off dif button
Double click on amount `1.00’
Amount : `*’
Enter
Document Simulate
Double click on blue line item
Text : Discount given
Post.
+91-9959765211 152
151.
SrinivasaKasireddy+91-9959765211
17. Bills ofExchange
Sales invoiceDue date 1 month
Received post dated check that can be encashed after 1 month.
Produce the check with 3rd
party (bank) and receive money from bank.
Bill Discounting:
Bank will pay you invoice amount after deducting interest for 1 month. There will be
contingent liability on us. If the customer dishonours the check contingent liability will
become actual liability.
Bills sent for Collection:
The bill amount (less collection charges) is credited only after the customer clears the
bill.
Check is one instrument of BOE .There are other instruments which can be endorsed
by
customers.
Bills of exchange receivable are managed using the special G/L method in the SAP
System
Special G/L indicator ‘W’ is used for Bills of Exchange
1. Settings
1. Creating 6 GL accounts
BOE receivable
T Code: FS00
Select G/L account 200610 (Sundry Debtors Account )
Copy Button
GL Account : 200611
Enter
Description : BOE Receivable
Save
ICICI Bill Discounting Account
Select G/L account 100800 (Expenses payable)
Copy Button
GL Account : 100801
+91-9959765211 153
SrinivasaKasireddy+91-9959765211
Save
2. Define AlternativeReconciliation Account for BOE
Received
SPROFinancial AccountingBank AccountingBusiness Transactions Bill of
Exchange
TransactionsBill of Exchange ReceivablePost Bill of Exchange Receivable
Define
Alternative Reconcil.Acct for Bills/Exch.Receivable
Double Click on SGL Ind ‘ W’
Chart of Accounts : LACA
Enter
Recon. acct Special G/L account
200610 200611
Save
Continue
3. Define Accounts for Bill of Exchange Transactions
Same path
Double click on Transaction ‘BIK‘ Bank collection charges
Chart of Accounts : LACA
Enter
Account
400682
Save
Continue
4. Define Bank Sub Accounts
Up to Bill of Exchange Receivable same path
Present Bill of Exchange Receivable at BankDefine Banks Subaccounts
New Entries
ChAc Bank
Acct
Usage SGL
In
Customer recon.
acct
Bank sub account for
liab
LACA 200790 Discounting W 200610 100801
LACA 200793 Collection W 200610 100802
+91-9959765211 155
154.
SrinivasaKasireddy+91-9959765211
Save
Continue
2. EndUser
1. SalesInvoice with due date 30days
Tcode: F-22
Document Date : 09.12.2011
Post Date : 09.12.2011
PstKy : 01 Account : LAPGNCUST
Enter
Amount : 81000
Business Area : LANZ
Payt Terms : NT30
Text : Sales Invoice
PstKy : 50 Account : 300510
Enter
Amount : *
Business Area : LANZ
Text : +
Document MenuSimulate
Post
2. BOE Payment
T Code: F-36
SAP Easy AccessAccountingFinancial AccountingAccounts
ReceivableDocument
EntryBill of ExchangePayment.
Document Date : 9.12.2011 Company Code : LAP
Posting Date : 9.12.2011 Currency : INR
Incoming Payment
+91-9959765211 156
155.
SrinivasaKasireddy+91-9959765211
PstKy : 09Account : LAPGNCUST SGL Ind :
W
Enter
Amount : 81000
Text : BOE Payment
Due on : 08.01.2012 Planned usage : D Discount
Issue date : 9.12.2011
Domicile : ICICI
Cent.bnk loc : Tarnaka
Choose open items button
Enter
Deselect other items except the invoice for 81000
Document menuSimulate General Ledger
+91-9959765211 157
156.
SrinivasaKasireddy+91-9959765211
Back button
Post
Notedown the doc no. 1400000005
3. BOE Discount
T Code: F-33
Same path next line
Document Date : 12.12.2011
Posting Date : 12.12.2011
Usage : D Discounting
Bank account : 200790 ICICI current A/C
Business Area : LANZ
Amount : 80100
Text : BOE Discounting
PstKy : 40 Account : 400681 Interests Paid
Enter
+91-9959765211 158
SrinivasaKasireddy+91-9959765211
Entry should be:
Post
4. Sales Invoice
Tcode: F-22
Document Date : 09.12.2011
Post Date : 09.12.2011
PstKy : 01 Account : LAPGNCUST
Enter
Amount : 45000
Business Area : LANZ
Payment Terms : NT30
Text : Sales Invoice
PstKy : 50 Account : 300510
Enter
Amount : *
Business Area : LANZ
Text : +
Document MenuSimulate
Post
5. BOE Payment
T Code: F-36
+91-9959765211 161
160.
SrinivasaKasireddy+91-9959765211
SAP Easy AccessAccountingFinancialAccountingAccounts
ReceivableDocument
EntryBill of ExchangePayment.
Document Date : 9.12.2011 Company Code : LAP
Posting Date : 9.12.2011 Currency : INR
Incoming Payment
PstKy : 09 Account : LAPGNCUST SGL Ind :
W
Enter
Amount : 45000
Text : BOE Payment
Due on : 08.01.2012 Planned usage : Collection
Issue date : 9.12.2011
Domicile : ICICI
Cent.bnk loc : Tarnaka
Choose open items button
Enter
Deselect other items except the invoice for 45000
+91-9959765211 162
161.
SrinivasaKasireddy+91-9959765211
Document menuSimulate
Post
Notedown the doc no. 1400000006
6. BOE Collection
T Code: F-34
Same path
Document Date : 9.12.2011
Posting Date : 9.12.2011
Usage : Collection
Bank account : 200793 ICICI Bills Clearing
Business Area : LANZ
Amount : 44550
Bank charges : 450
Text : BOE Collection
’Select bill of exch’ button
Doc . Number Fiscal Year
1400000006 2011
DocumentSimulate
+91-9959765211 163
162.
SrinivasaKasireddy+91-9959765211
Double click onblue line items
Text : Collection charges
Display document overview button
Entry should be as shown in the image
Post
(There is an open item for 44550-00 in the ICICI bill clrng account which can be cleared
when we receive bank statement.)
7. Report to Display BOE items
Tcode :S_ALR_87012213
Up to Account Receivable same path
Periodic ProcessingBill of Exchange ProcessingKoreaBill of Exchange
Management
Chart of Account : LACA
GL Account : 200611 sundry debtors BOE
Company Code : LAP
Special G/L Indicator : W
Usage : I Collection
Discounted/Collected
Execute
8. BOE list
Up to Bill of Exchange Processing same path
+91-9959765211 164
163.
SrinivasaKasireddy+91-9959765211
GeneralBill of ExchangeList
Chart of accounts : LACA
G/L account : 200611
Company code : LAP
Fiscal Year : 2011
√ With bill of exchange usage
√ Without bill of exchange usage
Execute
(Bill of exchange list is as shown in the image)
9. Reverse of Contingent Liability(Discount items)
Tcode : F-20
Up to Account Receivable Same path
Document EntryBill of ExchangeReverse Contingent Liability
Document Date : 08.01.2012
Posting Date : 08.01.2012
Bills of Exchange selection
G/L account : 200611 BOE Recievable
Usage : D Discounting
Due by : 08.01.2012
Edit line items button( or Process items button)
+91-9959765211 165
164.
SrinivasaKasireddy+91-9959765211
Enter to ignorethe warning message
Com
+
Post
Document menu Display
General Ledger view button
(General Ledger view of the Reversing document is shown in the following image)
+91-9959765211 166
165.
SrinivasaKasireddy+91-9959765211
++ 1400000004 00109 LAPGNCUST 08.01.2012 50.000,00
1400000005 001 09 LAPGNCUST 08.01.2012 45.000,00
- 1400000006 001 09 LAPGNCUST 08.01.2012 27.000,00
1400000007 001 09 LAPGNCUST 08.01.2012 36.000,00
++ 1400000008 001 09 LAPGNCUST 08.01.2012 18.000,00
1400000009 001 09 LAPGNCUST 08.01.2012 9.000,00
In the above list items 1 to 5 except item 3 are selected.
Items between ++ and ++ are selected (Block selection)
Items between -- and -- are excluded (Block exclusion)
+ is used to include the item in selection
- is used to exclude the item in selection
10. Reverse of Contingent Liability(Collection items)
Tcode : F-20
Up to Account Receivable Same path
Document EntryBill of ExchangeReverse Contingent Liability
Document Date : 08.01.2012
Posting Date : 08.01.2012
Bills of Exchange selection
G/L account : 200611 BOE Recievable
Usage : I Collection
Due by : 08.01.2012
Edit line items button
Enter to ignore the warning message
Com
+
+91-9959765211 167
SrinivasaKasireddy+91-9959765211
18. Check Deposit&BRS
Manual BRS
Electronic BRS
1. Settings
1. Creating GL Account Bank Charges
T Code: FS00
Select G/L account 400500 (Salaries Account)
Copy Button
G/L account : 400594
Enter
Description : Bank Charges
Save
2. Define Posting Keys and Posting Rules for Check
Deposit
SPROFinancial AccountingBank AccountingBusiness TransactionsCheck
Deposit Define Posting Keys and Posting Rules for Check Deposit
Chart of Accounts : LACA
Enter
New Entries
Account Text
LA1 Main bank account
LA2 Check deposit account
LA3 Check issue account
LA4 Bills Clearing
LA5 Bank charges
Save
Continue
Double Click on Assign Accounts to Account Symbol folder
New entries
Act Symbol Currency G/L acct
+91-9959765211 169
168.
SrinivasaKasireddy+91-9959765211
LA1 INR +++++++++0
LA2INR +++++++++1
LA3 INR +++++++++2
LA4 INR +++++++++3
LA5 INR 400594
Save
Info:
‘+++++++++’ is replaced by first 9 digits of the Bank GL Account
Bank GL Accounts are stored internally with 10 digits as shown in the following table
Bank Main A/C Check Deposit A/c Check Issue A/c Bills clrng
ICICI 0000200790 0000200791 0000200792 0000200793
HDFC 0000200770 0000200771 0000200772 0000200773
Double Click on Create Keys for Posting Rules folder
New Entries
Posting Rule Text
LAPA Check receipt clearing customer
LAPB Check deposit clearing in bank
LAPC Check issue clearing bank
LAPD BOE clearing
LAPE Debit bank charges
Save
Double Click on Define Posting Rules folder
New Entries
Posting Rule : LAPA
Posting Area : 2
Debit Credit
Posting key : 40 Posting key : Blank
Acct symbol : LA2 Acct symbol : Blank
Document type : DZ
Posting Type : 8
+91-9959765211 170
169.
SrinivasaKasireddy+91-9959765211
Save
LAPA:
Clear Credit Subledger A/c
Cr Customer
Dr. Check deposit A/c
Next entry button
Posting Rule : LAPB
Posting Area : 1
Debit: Credit:
Posting Key : 40 Posting Key : Blank
Acct symbol : LA1 Acct symbol : LA2
Document Type : SA
Posting Type : 5 (Clear credit G/L acct)
Save
LAPB:
Clear Check deposit A/c
Dr. Bank A/c
Next entry button
Posting rule : LAPC
Posting Area : 1
Debit: Credit:
Posting Key : Blank Posting Key : 50
Acct symbol : LA3 Acct symbol : LA1
Document Type : SA
Posting Type : 4 (Clear debit G/L acct)
Save
LAPC:
Clear Check issue A/C
Cr. Bank A/c
Next Entry button
Posting Rule : LAPD
Posting Area : 1
+91-9959765211 171
170.
SrinivasaKasireddy+91-9959765211
Debit: Credit:
Posting Key: 40 Posting Key : Blank
Acct symbol : LA1 Acct symbol : LA4
Document Type : SA
Posting Type : 5 (Clear Credit G/L accounts)
Save
LAPD:
Clear ICICI Bills clrng
Dr. Bank A/C
Next Entry button
Posting Rule : LAPE
Posting Area : 1
Debit: Credit:
Posting Key : 40 Posting Key : 50
Acct symbol : LA5 Acct symbol : LA1
Document Type : SA
Posting Type : 1 (Post to G/L Account)
Save
LAPE:
Dr . Bank Charges A/C
Cr Bank A/C
3. Create and Assign Business Transaction
Same Path
New Entries
Tran +- Post. rule Text
LAP1 + LAPA Check receipt clearing customer
LAP1 - LAPA Rev : Check Receipt Clearing Customer
Save
4. Define Variants for Check Deposit
+91-9959765211 172
171.
SrinivasaKasireddy+91-9959765211
Same Path
Create Button
Variant: LAP1
Name : Check Deposit Variant LAP
Enter
Double Click on ‘Reference document no. (sel) ‘
Output length : 16
Enter
For Reference document no. (sel) change offset to ‘19’
Double Click on Customer number (sel)
Output Length : 10
Enter
Double click on Business area (Assign)
Output length : 4
Enter
Double click on 10-digit check number
Output length : 10
Enter
Save
Create request button
Short Description : Variants LAP
Enter
Continue
Keep the cursor on LAP1
Activate button
(The Check deposit variant should like the following image.)
+91-9959765211 173
172.
SrinivasaKasireddy+91-9959765211
5. Create andAssign Business Transaction for Manual
Bank Statement:
Up to Business Transaction Same Path
Payment TransactionsManual Bank StatementCreate and Assign Business
Transactions
New Entries
Tran +- Post rule Int algthm Text
LAP2 + LAPB Check Deposit clearing
LAP2 - LAPB Rev: Check Deposit Clearing
LAP3 + LAPC Check issue Clearing
LAP3 - LAPC Rev: Check Issue Clearing
LAP4 + LAPD BOE Clearing
LAP4 - LAPD Rev: BOE Clearing
LAP5 + LAPE Debit Bank Charges
LAP5 - LAPE Rev: Debit Bank Charges
Save
Continue
+91-9959765211 174
173.
SrinivasaKasireddy+91-9959765211
6. Define Variantsfor Manual Bank Statement
Same Path next line
Create button
Variant : LAP1
Name : MBS Variant for LAP
Enter
Lgth for Amount : 15
Double Click on Allocation number(sel).
Output Length : 13
Enter
Double Click on Business area (Assign)
Output length : 4
Enter
Save
Continue
Keep Cursor on LAP1
Activate button
(The Manual bank statement Variant should look like the following)
7. Changing Field Status Group
T Code: OBC4
+91-9959765211 175
174.
SrinivasaKasireddy+91-9959765211
Select Field StatusVariant : LAFS
Double Click on Field status groups folder
Double click on Field status group ‘G001’
Double click on General data
Suppress Req. Entry Opt. entry
Text
Back button twice
Double click on FSG : G005
Double click on General data
Suppress Req. Entry Opt. entry
Text
Save
2. EndUser
Incoming checks
1. Sales Invoice Posting
Tcode : F-22
Document Date : 16.12.2011
Posting Date : 16.12.2011
Reference : REF1
PstKy : 01 Account : LAPGNCUST
Enter
Amount : 81000
Business Area : LANZ
Text : Sales Invoice
PstKy : 50 Account : 300510
Enter
Amount : *
Business Area : LANZ
Text : +
Document menuSimulate
Post
2. Manual Check Deposit
+91-9959765211 176
175.
SrinivasaKasireddy+91-9959765211
Tcode: FF68
SAP EasyAccessAccountingFinancial AccountingBanksIncomingsCheck
DepositManual Entry
Settings MenuSpecifications
Start Variant : LAP1
Processing Type : 2
Enter
Bank Key : 345678
Bank Account : 39495469
Displaying Bank Details:
T Code: F110
Environment MenuMaintain ConfigHouse banks Button
Company code : LAP
Enter
Select house bank ICICI
Double click on Bank account
Note Down the Bank Account Number.
Currency : INR
Group : 9
Transaction : LAP1 with +
Posting Date : 16.12.2011
Value Date : 16.12.2011
Currency : INR
Enter
Amount Reference doc no. Customer BusA Check no
81000 REF1 LAPGNCUST LANZ 36009
(Pl check the image)
+91-9959765211 177
176.
SrinivasaKasireddy+91-9959765211
Save
Post individual listbutton
3. Process Batch Input Session
T Code: SM35
Select session name ‘/ICICI-ICICI ‘
Process button
Process/ foreground
Process Button
Keep on pressing Enter until Message: “Processing of batch input session
completed”
Exit batch input button
4. Display Customer Items
T Code: FBL5N
Customer A/C : LAPGNCUST
All Items
Execute
5. Display Check Deposit Account
T Code: FBL3N
G/L account : 200791
All Items
Execute
(Make a note of Assignment column. Check no is stored in this column.)
6. Enter Manual Bank Statement (Incoming check
cleared)
+91-9959765211 178
177.
SrinivasaKasireddy+91-9959765211
(1st
statement only)
Tcode: FF67
SAPEasy accessAccountingFinancial accountingBanksIncomingsBank
StatementManual Entry.
Settings MenuSpecifications
√ Int. bank determin.
Start Variant : LAP1
Processing type : 2
Enter
House Bank : ICICI
Account ID : ICICI
Statement No : 1
Statement Date : 16-12-2012
Control
Opening Balance : 0
Closing Balance : 81000
Posting Date : 16-12-2011
Enter
Enter to Ignore Warning Message
(Pl check the image)
Save
Post Statement button(Save button)
7. Process Batch Input Session
T Code: SM35
Select session ICICI-ICICI
Process button
+91-9959765211
Tran Value date Amount Allocation BusA
LAP2 with + 16.12.2011 81000 0000000036009 LANZ
179
178.
SrinivasaKasireddy+91-9959765211
Process foreground button
ProcessButton
Keep on pressing enter until the processing batch input session completed
Outgoing checks
1. Purchase Invoice
T Code: F-43
Document Date : 19.12.2011 Company Code : LAP
Posting Date : 19.12.2011 Currency : INR
PstKy : 31 Account : LAPGNVNDR
Enter
Amount : 54000
Business Area : LANZ
Text : Purchase Invoice
PstKy : 40 Account : 200700
Enter
Amount : *
Business Area : LANZ
Text : +
Document MenuSimulate
Post
2. Outgoing Payment
T Code: F-53
Document Date: 19.12.2011 Type : KZ
Posting Date : 19.12.2011
Bank Data:
Account : 200792 Business Area : LANZ
Amount : 54000
Text : Outgoing payment
Open item selection:
Account : LAPGNVNDR
Enter
(Pl check the image)
+91-9959765211 180
179.
SrinivasaKasireddy+91-9959765211
(Deselect other itemsif any by double clicking on the amount)
Document MenuSimulate
Post
(Note down the document no. 150000000X)
3. Creation of manual checks
Tcode : FCH5
Payment document no. : 150000000X
Paying company code : LAP
Fiscal Year : 2011
House bank : ICICI
Account ID : ICICI
Check number : 72007
Save
+91-9959765211 181
180.
SrinivasaKasireddy+91-9959765211
4. Update Assignmentfield
(In this step you can update Assignment field with Check number for already entered
Clearing documents )
Tcode : FCHU
Paying company code : LAP
House Bank : ICICI
Account ID : ICICI
Check number : 72007
Assignment
Execute
5. Enter Manual Bank Statement(Outgoing checks
cleared)
(2nd
statement onwards)
Tcode : FF67
Settings MenuSpecifications
Start Variant : LAP1
Processing type : 2
Enter
Overview button
(Pl check the image)
Double click on CoCd ‘LAP’ with `ICICI’.
New statement button
+91-9959765211 182
181.
SrinivasaKasireddy+91-9959765211
Statement Number ‘2’comes automatically
Opening balance ‘81000 ’comes automatically
Closing balance : 27000
Posting Date : 19-12-2011
(Pl check the image)
Enter
Enter to Ignore Warning Message
(Pl check the image)
Save
Post Statement button(Save button)
6. Process Batch Input Session
T Code: SM35
+91-9959765211
Tran Value date Amount Allocation BusA
LAP3with + 16.12.2011 -54000 72007(Check issued) LANZ
183
182.
SrinivasaKasireddy+91-9959765211
Select session ICICI-ICICI
Processbutton
Process foreground button
Process Button
Keep on pressing enter until the processing batch input session completed
7. Display checks issue account
T Code: FBL3N
GL Account : 200792
All items
Execute
8. Display Main Bank account
T Code: FBL3N
GL Account : 200790
All items
Execute
9. Display Bank Statement
Tcode: FF67
Over view button
Double click on LAP with ICICI
Double click on statement
10. Deleting Bank Statement /Check deposit(in case of
errors):
T Code: SA38
Program : RFEBKA96
Execute
Application : 0001
Execute
Deselect All button
Select the statements to be deleted
Delete statements button
Yes button
+91-9959765211 184
SrinivasaKasireddy+91-9959765211
19. Foreign Currencies
1.Currency Settings
1. Check Exchange Rate types
SPROSAP NetWeaverGeneral settingsCurrenciesCheck Exchange Rate
types.
Make a note of the following Exchange rate types.
B Bank selling rate (During import)
G Bank buying rate (During Export)
M Average rate
2. Define Translation Ratios for Currency Translation
Same path next line
‘Yes’Button to continue
New entries
ExRt fro
m
To Valid from Ratio (from) Ratio (to)
B USD INR 01.4.2011 1 1
G USD INR 01.4.2011 1 1
M USD INR 01.4.2011 1 1
(Pl check the image)
Save
Create request button
Short description : FC settings
Enter
Continue.
+91-9959765211 186
185.
SrinivasaKasireddy+91-9959765211
(Skip this stepin the lab )
3. Creating G/L accounts
T code FS00
Select GL account 400500
Copy button
Gl account : 400690
Enter
Description : Exchange loss
Save
Select GL account 300510
Copy button
G/L Account : 300690
Description : Exchange gain
Save
4. Enter Exchange rate type in Document type.
T code OBA7
Double click on document type KR
Ex. rate type for forgn crncy docs : B
Save
Continue
Back button
Double click on document type KZ
Ex. rate type for forgn crncy docs : B
Save
(For document types DR and DZ use Ex. Rate type G)
5. Define Accounts for Exchange Rate Differences
SPROFinancial AccountingAccounts Receivable and Accounts
PayableBusiness
TransactionsOpen Item Clearing Define Accounts for Exchange Rate Differences.
Chart of accounts : LACA
Enter
New entries
Chart of Accounts : LACA
+91-9959765211 187
186.
SrinivasaKasireddy+91-9959765211
G/L Account :100980
Currency : USD
Loss : 400690
Gain : 300690
(Pl check the image)
Save
Continue
1. Enduser
1. Enter exchange rates in forex table
Tcode : OB08
SAP Easy accessAccountingFinancial AccountingGeneral ledger
Environment
Current settingsEnter Translation Rates
New Entries
ExRt ValidFrom Ratio(from) Fro
m
Dir.quot Ratio(to) To
B 11.01.2011 1 USD 49 1 INR
G 11.01.2011 1 USD 47 1 INR
M 11.01.2011 1 USD 48 1 INR
+91-9959765211 188
187.
SrinivasaKasireddy+91-9959765211
Save
Continue
(Pl check theimage)
2. Posting document in foreign currency
Tcode :F-43
Document Date : 11.01.2011 Type : KR Company Code : LAP
Posting Date : 11.01.2011 Period : 10 Currency/Rate :USD / 49(Pl check
the image )
PstKy : 31 Account : LAPGNVNDR
Enter
Amount : 1000 USD
Bus. Area : LANZ
Text : pur inv
PstKy : 40 Account : 200700
Enter
Amount : *
Bus Area : LANZ
Text : +
DocumentSimulate
+91-9959765211 189
188.
SrinivasaKasireddy+91-9959765211
Post
3. Enter exchangerates in forex table
Tcode :OB08
SAP Easy accessAccountingFinancial AccountingGeneral ledger Environment
Current settingsEnter Translation Rates
New Entries
ExRt ValidFrom Ratio(from) Fro
m
Dir.quot Ratio(to) To
B 20.01.2011 1 USD 52 1 INR
G 20.01.2011 1 USD 50 1 INR
M 20.01.2011 1 USD 51 1 INR
Save
Continue
Info:
ExRate ValidFrom Dir.quot
B 11.01.2011 49
B 20.01.2011 52
There is no ‘ValidTo’ field in forex table .
In the above scenario ,
1 . If a document is posted on 11th
or before 20th
rate 49 will apply .
2 . If a document is posted on/after 20th
rate 52 will apply .
+91-9959765211 190
189.
SrinivasaKasireddy+91-9959765211
4. Clearing foreigncurrency document
Tcode : F-53
Document date : 20.01.2011
Posting date : 20.01.2011 Currency : INR
Bank data
Account : 200792
Amount : 1
Value date : 20.01.2011
Text : Outgoing payment
Open item selection
Account : LAPGVNDR
Enter
Deselect other items
Charge of Diff button
Double click on ‘1.00’
Change the amount to *
Document Simulate
Display currency button
Post
+91-9959765211 191
190.
SrinivasaKasireddy+91-9959765211
20. TDS (WithholdingTax)
While paying vendors we deduct the tax amount and pay the remaining amount. The
deducted amount is going to be remitted to tax authority periodically.
Eg : TDS on Contractor charges ,
Surcharge on TDS
TDS on salaries
TDS on Rent
TDS on Interest
1. Settings
1. Check WHT Countries
SPROFinancial AccountingFinancial Accounting Global SettingsWithholding
TaxExtended Withholding TaxBasic SettingsCheck Withholding Tax Countries.
New Entries
Cty WCty Description
IN IN India
Save
Create request button
Short Description : TDS settings(LAP)
Enter
Continue
(Skip this step in the lab)
2. Define Withholding Tax Keys
Same path next line
Country Key : IN
Enter
+91-9959765211 192
191.
SrinivasaKasireddy+91-9959765211
New Entries
Off KeyName
194C TDS on contract
Save
Continue
Info:
Section 194C of Indian Act describes TDS on contract
3. Check Income types
Same path
Country Key : IN
Enter
New entries
ITyp Text
CN Income from Contract
IN Income from Interest
SL Income from Salary
Save
Continue
4. Define Business Places (Sec code)
Info:
+91-9959765211 193
192.
SrinivasaKasireddy+91-9959765211
Section Code TANNo Business Place
Hyderabad Br. TAN1
AP-Range , Rangareddy -Circle
Secunderabad Br. TAN2
Mumbai Br. TAN3 MH-Range , Mumbai -Circle
Section Code: For every TAN we create a section code
Business place: For every tax office we are reporting to , we create a business place.
Path :Up to Basic settings same path
IndiaDefine business places
New Entries
Company code Sec. Code Name 1
LAP LAPF Section Code for LAP
Save
Name : Section code for LAP
Name 2 : Section Code for LAP
Country : IN
Enter
Continue
5. Assign Factory Calendars to Section code
Same path
New Entries
Company code Sect. code Factory Calendar ID Rule
LAP LAPF 01 Day before
Save
Continue
6. Define Business Places (Table View : J_1BBRANCV )
(Each Business Place represents a tax reporting office)
Tcode :SM30
Table View : J_1BBRANCV
Maintain button
Company Code : LAP
Enter
New Entries
Business Place : LAPF
Description : Business place for LAP
+91-9959765211 194
193.
SrinivasaKasireddy+91-9959765211
Save
Name : APRange
Name2 : Hyderabad circle
Country : IN
Enter
Continue
7. Assign Section Code to Business place (V_SECCODE )
Tcode :SM30
Table view : V_SECCODE
Maintain button
Company Code : LAP
Enter
section Code Business Place
LAPF LAPF
Save
Continue
8. Define WithholdingTaxType in Invoice Posting
Up to Extended Withholding Tax same path
CalculationWithholding Tax TypeDefine Withholding TaxType for Invoice Posting
Country Key : IN
Enter
New Entries
Withhld tax type : LI
Description : TDS on contract( Invoice)
Gross amount
√ Post w/tax amount
No Accumulation
Save
Continue
Next Entry button
Withhld tax type : LS
Description : Surcharge on TDS ( Invoice)
Gross amount
+91-9959765211 195
194.
SrinivasaKasireddy+91-9959765211
√ Post w/taxamount
No Accumulation
Save
9. Define Withholding Tax Type for Payment
Posting(Advance payment)
Same path up to Calculation
Withholding Tax TypeDefine Withholding Tax type for Payment Posting
Country Key : IN
Enter
New Entries
Withhld tax type : LA
Description : TDS on contract (Advance)
Gross amount
√ Post w/tax amount
No accumulation
Central Inv. Prop
Save
Continue
10. Define Withholding Tax Codes
Same path up to Calculation
Withholding Tax CodesDefine Withholding Tax Codes
Country Key : IN
Enter
New Entries
Withhld tax type : LA
W/tax code : L1 Off. W/Tax Key : 194C
Description : 2 % TDS on contract (Advance)
Percentage subject to tax : 100 Post.indic. : 1 (Standard
posting)
With/tax rate : 2%
Income type : CN
Save
Continue
+91-9959765211 196
195.
SrinivasaKasireddy+91-9959765211
Next Entry button
Withhldtax type : LI
W/tax code : L2 Off. W/Tax Key : 194C
Description : 2% TDS on contract (inv)
Percentage : 100 Post Indi : 1
With/tax rate : 2%
Income type : CN
Save
Next Entry button
Withhld tax type : LS
W/tax code : L3 Off. W/Tax Key : 194C
Description : 2% Surcharge on TDS
Percentage : 2 Post Indi : 1
With/tax rate : 2%
Income type : CN
Save
11. Portray Dependencies Between Withholding Tax types
Up to Extended Withholding Tax same path
CalculationWithholding Tax Base Amount Portray Dependencies Between
Withholding
Tax types
Country Key : IN
Enter
Make a note of W/tax type no. for ‘LI’ ie (‘1’ here)
Double click on Withholding Type ‘LS’
Depend. on type no. : 1
Save
Continue
12. Check Receipt Types
Up to Extended Withholding Tax same path
Basic SettingCheck Recipient Types
Country Key : IN
Enter
New Entries
Wht .t. type Rec.ty Text
+91-9959765211 197
196.
SrinivasaKasireddy+91-9959765211
LA CO Company
LAIN Individual
LI CO Company
LI IN Individual
LS CO Company
LS IN Individual
Save
Continue
13. Maintain Tax Due Dates
Up to Basic Settings same path
IndiaMaintain Tax Due Dates
New Entries
Country Official Withholding Tax Key Recipient type No Days Until Tax Due Date
IN 194C CO 777
Save
Continue
14. Assign Withholding Tax Types to Company Codes
Up to Extended Withholding Tax same path
Company codeAssign Withholding Tax Types to Company Codes
New Entries
Company Code : LAP
Withhld tax type : LA Recipient type : CO
√ With/tax agent
W/tax obligated frm : 1-4-2011 Oblig.to w/tax until : 31-3-9999
Save
Continue
Next Entry button
Company Code : LAP
Withhld tax type : LI Recipient type : CO
√ With/tax agent
W/tax obligated frm : 1.4.2011 Oblig.to w/tax until : 31.3.9999
Save
Next Entry button
+91-9959765211 198
197.
SrinivasaKasireddy+91-9959765211
Company Code :LAP
Withhld tax type : LS Recipient type : CO
√ With/tax agent
W/tax obligated frm : 1.4.2011 Oblig.to w/tax until : 31.3.9999
Save
15. Activate Extended Withholding Tax
Same path next line
Position
Company Code : LAP
Enter
CoCd Ext. w/tax
LAP √
Save
Enter (to ignore warning message)
Continue
16. Creation of 3 GL Masters
Tcode : FS00
Select GL account ‘100800’
Copy button
G/L account : 100450
Enter
Description : TDS Payable
Save
Select GL account ‘100450’ TDS payable
Copy button
G/L account : 100451
Enter
Description : Surcharge on TDS
Save
Select G/L account ‘400500’ Salaries
Copy button
G/L Account : 400590
+91-9959765211 199
198.
SrinivasaKasireddy+91-9959765211
Enter
Description : ProcessingCharges
Save
17. Assignment of G/L Accounts
Up to Extended Withholding Tax same path
PostingsAccounts for Withholding TaxDefine Accounts for Withholding Tax to be
Paid
Over
Chart of Accounts : LACA
Enter
Withholding tax code √
Withholding tax type √
Save
Withholding tax type Withholding tax code Account
LA L1 100450
LI L2 100450
LS L3 100451
Save
Continue
18. Maintain Company Code Settings
SPROLogistics -GeneralTax on Goods MovementsIndiaBasic
SettingsMaintain
Company Code Settings
New Entries
Company Code : LAP
Save
Continue
19. Specify Document types for Remittance Challan
Upto Extended WHT same path
PostingsIndiaRemittance ChallansDocument TypesSpecify Document Type
(Accounts Payable)
New Entries
CoCd RC Doc Typ
LAP SA
Save
Continue
+91-9959765211 200
199.
SrinivasaKasireddy+91-9959765211
20. Maintain NumberGroups
Same path up to Remittance Challan Maintain Number Groups
New Entries
Co. Code Sect Code Off W/Tax Key Number Grp
LAP LAPF 194C 207
Save
Continue
21. Assign Number Ranges to Number Groups
Same path next line
New Entries
Number grp IntNR
207 27
Save
Continue
22. Maintain Number Ranges
Same path next line
Maintain Groups button
Group MenuInsert
+91-9959765211 201
200.
SrinivasaKasireddy+91-9959765211
Company code :LAP
Enter
Text : RC No. range for LAP
Year From number To number
2011 270000000 279999999
Enter
Save
Continue
Double click on ‘207’ under ‘Group without text’
√ RC no. range for LAP
Element/Group button
Save
Continue
23. Assign Number Group to Business Places
+91-9959765211 202
201.
SrinivasaKasireddy+91-9959765211
Tcode :SM30
Table View: J_1IEWTNUMGR
Maintain button
New Entries
Company Code : LAP
Business Place : LAPF
Off. W/Tax Key : 194C
Number group : 207
Save
Continue
24. Assign Number Group to Section Code(already done)
Tcode :SM30
Table View : J_1IEWTNUMGR_1
Maintain button
New Entries
Company Code Sect Code Off W/TaxKey Number grp
LAP LAPF 194C 207
Save
Continue
25. Maintain Number Groups and SAP Script Form
Up to Extended Withholding Tax same path
PostingsIndiaWithholding Tax Certificates for Vendors and CustomersMaintain
Number Groups and SAP script Forms
New Entries
CompanyCode Sect Code Off W/Tax key Form Number grp
LAP LAPF 194C J_1IEWT_CERT 108
Save
Continue
Note : J_1IEWT_CERT is Form 16A.
26. Assign Number Ranges to Number Groups
Same path next line
New Entries
Number grp IntNR
+91-9959765211 203
202.
SrinivasaKasireddy+91-9959765211
108 18
Save
Continue
27. MaintainNumber Ranges
Same path next line
Maintain Groups button
Group menuInsert
Company Code : LAP
Enter
Text : Certificate No. Range for LAP
Year From No. To No.
2011 180000000 189999999
Enter
Save
Continue
√ Certificate no. range for LAP
Double click on ‘108’ under ‘Group without text’
Element /Group button
Save
Continue
28. Maintain acknowledgement number for the quarter
TCode : SM30
Table/View : J_1IEWT_ACKN
Maintain button
New entries
CoCd Year Sect.Code Form Type Period Acknowledgment
LAP Next fiscal yr LAPF Form 26Q First Quarter 01
LAP Next fiscal yr LAPF Form 26Q Second Quarter 01
LAP Next fiscal yr LAPF Form 26Q Third Quarter 01
LAP Next fiscal yr LAPF Form 26Q Fourth Quarter 01
Save
Continue
29. Maintain TDS, PAN No.
+91-9959765211 204
203.
SrinivasaKasireddy+91-9959765211
Tcode : OBY6
Position
CompanyCode : LAP
Enter
Double click on company code ‘LAP’
Additional Data button
TDS No. : LAP TDS No. 567
PAN No. : LAP PAN No. 567
Back button
Save
Conitnue
30. Creating Validation for Business place/section code
Scenario: End-user may forget to enter Bus. place/Sectn code
If Bus. place/Sectn is not entered, error msg should popup and doc should not be
posted.
Settings:
1.Maintain Validation
2.Define Validation for posting
1.Maintain validation:
SPROFinancial AccountingSpecial Purpose LedgerToolsMaintain
Validation/Substitution/RulesMaintain Validation
Double click on Financial Accounting folder
Select Line Item folder
Validation button
Validation name : LAP1
+91-9959765211 205
204.
SrinivasaKasireddy+91-9959765211
Description : Validationfor business place/Section code
Enter
Select LAP1 under Line Item folder
Step button
Under Step 001
Double click on Prerequisite
Double click on Accounting Document Header
Double click on ‘Document Type ‘
’=’ button
Constant button
Document type : KR
+91-9959765211 206
SrinivasaKasireddy+91-9959765211
Next Free Numberbutton
Keep the curser on top most message.
Individual maint. button
Change original language button
New original language : EN
Continue Continue.
Yes button
023 Business place and section code Mandatory
Save
Back button
Message number : 023
Save
2.Define Validations for Posting:
Up to Financial Accounting same path
Financial accounting Global settingsDocumentLine itemDefine validations for
Posting
New Entries
CoCd CallPnt Validation Activtn level
LAP 2 LAP1 1
Save
Continue
2. End User
1. Maintain Tax Codes in Vendor master
Tcode :XK02
+91-9959765211 211
210.
SrinivasaKasireddy+91-9959765211
Vendor : LAPGNVNDR
CompanyCode : LAP
√ Withholding Tax
Enter
WH Tax Country : IN
Wth t. type W/tax code Liable Rec. ty
LI L2 √ CO
LA L1 √ CO
LS L3 √ CO
CIN Details button
Enter 3 times to ignore the warning msg
Withholding Tax tab:
PAN No : LAPGNVNDR457
Back button
Save
Info:
Activating CIN Details button : SPROLogistics -GeneralTax on Goods
Movements
IndiaMaster Data Assign Users to Material Master Screen Sequence for Excise Duty
Double click on User Screen Reference folder
New Entries
Name SRef: user
SAPUSER
Save
Continue
2. Testing Validation
Tcode F-43
Document date : 28.12.2011
Posting date : 28.12.2011
Psky : 31 Account : LAPGNVNDR
Enter
Account : 45000 Busi Place/Sectb : Blank/Blank
Text : Processing charges
Psky : 40 Account : 400590
+91-9959765211 212
211.
SrinivasaKasireddy+91-9959765211
Enter
Delete W/taxcode ‘N1’
Enter
There should be an error message ‘Business Place&Sec_code are mandatory’
3. Posting of Processing Charges
Tcode : F-43
Document Date : 28.12.2011 Type : KR
Posting Date : 28.12.2011
PstKy : 31 Account : LAPGNVNDR
Enter
Amount : 45,000
Bus place/Section Code : LAPF /LAPF
Bus Area : LANZ
Text : Processing charges
PstKy : 40 Account : 400590
Enter
Delete W/tax code ‘L1’
Enter
Amount : *
Bus Area : LANZ
Text : +
+91-9959765211 213
212.
SrinivasaKasireddy+91-9959765211
DocumentSimulate
Double click online item TDS Payable
Text : TDS
Post
4. Create Remittance Challan
SAP Easy AccessAccountingFinancial AccountingAccounts Payable
Withholding
Tax IndiaExtended Withholding TaxRemittance of Withholding TaxCreate
Remittance challan
Tcode : J1INCHLN
Company Code : LAP
Fiscal Year : 2011
Bus place/Sec. Code : LAPF
Posting Date : 1-12-2011 to 31-12-2011
Section : 194C
Vendors : LAPGNVNDR
Receipt types : CO
Document Date : 07-01-2012
Posting Date : 07-01-2012
Bank Account : 200792
Execute
Document Number
Enter
Select TDS items to be cleared
Charge of diff button
Double click on amount ‘1.00’
Change amount to *
Process open items button
Document menuSimulate
+91-9959765211 214
213.
SrinivasaKasireddy+91-9959765211
Post
Note the documentNo. 1000000024
5. Enter Bank Challan
Same Path
Tcode: J1INBANK
Company Code : LAP
Fiscal Year : 2011
Challan Clearing Number : 1000000024
Bank challan No. : 45652563 [Given by Bank]
Bank Challan Date : 07-01-2012
Bank Key : ICICI
Execute
6. Print TDS Certificate
Same path up to Extended Withholding Tax
CertificatesPrint
Tcode : J1INCERT
Company Code : LAP
Fiscal Year : 2011
Bus place/Sec. Code : LAPF
Section : 194C
Posting date : 01-10-2011 to 31-12-2011
Bank Challan Date : 01-10-2011 to 07-01-2012
Certificate Date : 07-01-2012
Signatory : Mr. x
Designation : Accounts manager
+91-9959765211 215
214.
SrinivasaKasireddy+91-9959765211
Place of Printing: Hyderabad
√ Test Run
Execute
Output device : LP01
Print preview button
Back button twice
Test Run
Execute
Output device : LP01
√ Print Immediately
Print button
Enter
Displaying print status
System menuServicesOutput control
TCode : SP01
Execute
+91-9959765211 216
SrinivasaKasireddy+91-9959765211
21. Asset Accounting
AssetAccounting in SAP is a sub-ledger connected to G/L with the help of
reconciliation
accounts like Asset a/c and respective Accumulated Depreciation a/c.
We differentiate all assets in to different Asset Classes. For every Asset Class we
create an
Asset a/c and an Accumulated Depreciation a/c.
Posting keys : Posting keys 70 , 75 are used for Asset Debit and Asset Credit
respectively .
Asset and Sub-asset :
Assets and each sub-asset 1 . can have different acquisition dates.
2 . can have different depreciation rates
3. can belong to different org units
APC and Accu .Dep can be recorded separately for asset and it’s each sub-asset.
Transactions like acquisition , sale , scrapping , transfer can be recorded for asset and
each
of it’s sub assets separately.
Main asset is post fixed with ‘-0000’ and sub assets post fixed with ‘-0001 ‘, ‘-0002’
, ‘-
0003’ -……..etc
Asset and sub-asset concept is useful in the following situations
1. Add-on components of a machine can be created as sub assets
Asset Sub number Description
10000 0000 Machine1 Main asset
10000 0001 Component
1
Sub-assets
10000 0002 Component
2
10000 000n Component
n
Here Machine1 is the main asset and is represented by 10000-0000
Component 1 is a sub-asset and is represented by 10000-0001
2.Subsequent acquisitions can be created as sub-assets.
Asset Sub number Description Year of aquisition
+91-9959765211 218
217.
SrinivasaKasireddy+91-9959765211
20000 0000 Adminbuilding 2007
20000 0001 South block 2009
20000 0002 North block 2010
1. Settings
1. Creating G/L accounts
Asset Class Asset a/c Acc Dep a/c Recon account for acct type Sort key FSG
P & M
Buildings
Lands
Computers
Capital WIP
200901
200902
200903
200904
200905
100701
100702
--
100704
--
Assets 018 067
Expenses Accounts
Description G/L account Sort key
Depreciation Account 400403
018Loss due to scrapping 400402
Loss on sale of asset 400401
Income Accounts
Description G/L account Sort key FSG
Profit on sale of asset 300516
018 G052
Sale of assets 300515
T-Code FS00
Select G/L account 200700
Copy button
G/L Account : 200901
Enter
Description : Plant & Machinery
Control Data tab
+91-9959765211 219
218.
SrinivasaKasireddy+91-9959765211
Recon. account foracct type : Assets
Sort key : 018
Create/Bank/Interest tab
Field status group : G067
Save
Create G/L accounts 200902 to 200905 by copying G/L account 200901
Select G/L account 200901
Copy button
GL Account : 100701
Enter
Account Group : Liabilities
Description : Accu. Dep. on P&M
Save
Create GL Accounts 100702 and 100704 by copying G/L account 100701
Select G/L account 400500 salaries
Copy button
GL Account : 400403
Enter
Description : Depreciation
Sort key : 018
Save
Create G/L accounts 400401 and 400402 by copying GL Account 400403
Select G/L account 300510 Sales
Copy button
GL Account : 300516
Enter
Description : Profit on sale of assts
Sort key : 018
Filed status group : G001
Save
Select GL Account 300516 Profit on sale of asset
Copy button
+91-9959765211 220
219.
SrinivasaKasireddy+91-9959765211
GL Account :300515
Enter
Description : Sale of Asset
Field status group : G052
Save
2. Assign Tax codes for Non Taxable Transactions
SPROFinancial AccountingFinancial Accounting Global SettingsTax on
Sales/PurchasesPostingAssign Tax Codes for Non Taxable Transactions
Position button
Company Code : LAP
Enter
Company code Input tax code Output tax code
LAP I0 O0
Save
Continue
3. Copy Reference Chart of Dep./Dep. Areas
SPROFinancial AccountingAsset AccountingOrganizational structuresCopy
Reference Chart of Depreciation/Depreciation Areas
Double click on Copy Reference Chart of Depreciation.
Copy org. object button
From chart of Depreciation : 1IN
To Chart of Depreciation : LACD
Enter
+91-9959765211 221
220.
SrinivasaKasireddy+91-9959765211
Enter to ignorethe wrng msg
Yes button
Create Request button
Short description : AA settings (LAP)
Enter
Continue
Enter to conform the msg
Back button
Double click on Specify Description of Chart Of Depreciation
Position
Chart of dep : LACD
Enter
For ‘LACD’ change Description to ‘COD for LAP’
Save
Continue
Back button
Double click on Copy /Delete Depreciation Areas
Chart of dep : LACD
+91-9959765211 222
221.
SrinivasaKasireddy+91-9959765211
Enter
Select All button
Deselect1 Book Dep.
15 Depreciation as per Income Tax Act 1961
30 Consolidated balance sheet in local currency
Delete button
Save
Enter to ignore the wrng msg
Continue
4. Assign Chart Of Depreciation to Company Code
Same path next line
Position
Company Code : LAP
Enter
CoCd Chrt dep
LAP LACD
Save
Enter to ignore warning Message
Continue
5. Specify Account Determination
Up to Organizational Structures same path
Asset classesSpecify Account Determination
New Entries
+91-9959765211 223
222.
SrinivasaKasireddy+91-9959765211
Acct. determ Namefor the account determination
LAP1 Plant & Machinery
LAP2 Buildings
LAP3 Lands
LAP4 Computers
LAP5 WIP (AUC) Asset under construction
Save
Continue
6. Create Screen Layout Rules
Same path next line
Select Screen layout rule 1000
Copy as button
Change the Screen Layout rule to LAP3
Change the Name of screen layout rule to ‘Lands’
Enter
Select Screen layout rule 1100
Copy as button
Change the Screen Layout rule to LAP2
Enter
Select Screen layout rule 2000
Copy as button
Change the Screen Layout rule to LAP1
Change the Name of screen layout rule to ‘P&M’
+91-9959765211 224
223.
SrinivasaKasireddy+91-9959765211
Enter
Select Screen layoutrule 2000
Copy as button
Change the Screen Layout rule to LAP4
Change the Name of screen layout rule to ‘Computers’
Enter
Select Screen layout rule 4000
Copy as button
Change the Screen Layout rule to LAP5
Change the Name of screen layout rule to ‘AUC’
Enter
Save
Continue
7. Define Number Range Intervals (01 to 05)
Same path next line
Company Code : LAP
Change intervals button
Insert intervals button
No From number To number
01 10000 19999
Enter
Insert intervals button
No From number To number
02 20000 29999
Enter
Insert intervals button
Enter
Insert intervals button
No From number To number
04 40000 49999
+91-9959765211
No From number To number
03 30000 39999
225
224.
SrinivasaKasireddy+91-9959765211
Enter
Insert intervals button
NoFrom number To number
05 50000 59999
Enter
Save
Continue
8. Define Asset Classes
Same path next line
New Entries
Asset class : LAP1
Short text : P&M
Account determ : LAP1
Scr layout rule : LAP1
Number range : 01
√ Include asset
No AuC or summary management of AuC
+91-9959765211 226
225.
SrinivasaKasireddy+91-9959765211
Save
Continue
Next Entry button
Assetclass : LAP2
Short text : Buildings
Account determ : LAP2
Scr layout rule : LAP2
Number range : 02
√ Include asset
No AuC or summary management of AuC
Save
Next Entry button
Asset class : LAP3
Short text : Lands
Account determ : LAP3
Scr layout rule : LAP3
Number range : 03
√ Include asset
No AuC or summary management of AuC
Save
Next Entry button
Asset class : LAP4
Short text : Computers
Account determ : LAP4
Scr layout rule : LAP4
Number range : 04
√ Include asset
No AuC or summary management of AuC
Save
Next Entry button
Asset class : LAP5
Short text : WIP
Account determ : LAP5
Scr layout rule : LAP5
Number range : 05
Include asset
+91-9959765211 227
226.
SrinivasaKasireddy+91-9959765211
Line Items Settlement
Save
9.Assignment of G/L Accounts
Upto Asset Accounting same path
Integration with General LedgerAssign G/L Accounts
ChDep : LACD
Enter
Select Chart of Accounts ‘LACA’
Double click on Account determination folder
Select Account determination LAP1
Double click on Balance sheet accounts folder
+91-9959765211 228
227.
SrinivasaKasireddy+91-9959765211
Acquisition: Acquisition andproduction cost (APC) : 200901
Loss made on asset retirement w/o revenue : 400402 Loss due to scrap
Clearing acct revenue from asset sale : 300515 Sale of Assets
Gain from asset sale : 300516 Prft on sale of assets
Loss on sale of asset : 400401 Loss on sale of asset
Enter
Double click on Depreciation folder
Acc. Dep. account for ordinary dep. : 100701 Acc. Dep. on P&M
Expenses account for ordinary dep. : 400403 Depreciation
+91-9959765211 229
228.
SrinivasaKasireddy+91-9959765211
Save
Enter to ignorewarning
Continue
Back button twice
Select Account determination LAP2
Double click on Balance sheet accounts folder
Acquisition: Acquisition and production cost : 200902
Loss made on asset retirement w/o revenue : 400402 Loss due to scrap
Clearing acct revenue from asset sale : 300515 sale of asset
Gain from asset sale : 300516 profit from sale of asset
Loss on sale of asset : 400401 Loss on sale of asset
Double click on Depreciation folder
Acc. Dep. account for ordinary dep. : 100702 Acc. Dep. on Buildings
Expenses account for ordinary dep. : 400403 Depreciation
Save
Enter
Back button twice
Select Account determination LAP3
Double click on Balance sheet accounts folder
Acquisition: Acquisition and production cost : 200903
Loss made on asset retirement w/o revenue : 400402 Loss due to scrap
Clearing acct revenue from asset sale : 300515 sale of asset
Gain from asset sale : 300516 profit from sale of asset
Loss on sale of asset : 400401 Loss on sale of asset
(No Depreciation for Lands)
Save
Back button twice
Select Account determination LAP4
+91-9959765211 230
229.
SrinivasaKasireddy+91-9959765211
Double click onBalance sheet accounts folder
Acquisition: Acquisition and production cost : 200904
Loss made on asset retirement w/o revenue : 400402 Loss due to scrap
Clearing acct revenue from asset sale : 300515 sale of asset
Gain from asset sale : 300516 profit from sale of asset
Loss on sale of asset : 400401 Loss on sale of asset
Double click on Depreciation folder
Acc. Dep. account for ordinary dep. : 100704 Acc. Dep. on Computers
Expenses account for ordinary dep. : 400403 Depreciation
Save
Enter
Back button twice
Select Account determination LAP5
Double click on Balance sheet accounts folder
Acquisition: Acquisition and production cost : 200905
Loss made on asset retirement w/o revenue : 400402 Loss due to scrap
Clearing acct revenue from asset sale : 300515 sale of asset
Gain from asset sale : 300516 profit from sale of asset
Loss on sale of asset : 400401 Loss on sale of asset
(No Depreciation for WIP)
Save
10. Specify Document type for Posting Dep
Up to Integration with General Ledger same path
Post Depreciation to General Ledger AccountingSpecify Document Type for Posting
of
Depreciation.
Double click on Specify Document Type for Posting of Depreciation
Position
Company code : LAP
Enter
CoCd Doc. Type
LAP AF
Make a note of Doc type AF
11. Creating Number Ranges
Tcode : OBA7
+91-9959765211 231
SrinivasaKasireddy+91-9959765211
Save
Continue
14. Determine DepreciationAreas in the Asset Class
Up to Asset Accounting same path
ValuationDetermine depreciation areas in Asset class
ChDep : LACD
Enter
Select Asset class ‘LAP1’
Double click on Depreciation areas folder
Area Dep Area Deact. Layout
01 Book Dep . 2000
15 Depreciation as per Income Tax √ 2000
30 Consolidated balance sheet in local crncy √ 2000
Double click on Asset class folder
Select Asset class ‘LAP2’
Double click on Depreciation areas folder
Area Dep Area Deact. Layout
+91-9959765211 233
232.
SrinivasaKasireddy+91-9959765211
01 Book Dep. 2000
15 Depreciation as per Income Tax √ 2000
30 Consolidated balance sheet in local crncy √ 2000
Double click on Asset class folder
Select Asset class ‘LAP3’
Double click on Depreciation areas folder
Area Dep Area Deact. Layout
01 Book Dep . 2000
15 Depreciation as per Income Tax √ 2000
30 Consolidated balance sheet in local crncy √ 2000
Double click on Asset class folder
Select Asset class ‘LAP4’
Double click on Depreciation areas folder
Area Dep Area Deact. Layout
01 Book Dep . 2000
15 Depreciation as per Income Tax √ 2000
30 Consolidated balance sheet in local crncy √ 2000
Double click on Asset class folder
Select Asset class ‘LAP5’
Double click on Depreciation areas folder
Area Dep Area Deact. Layout
01 Book Dep . 2000
15 Depreciation as per Income Tax √ 2000
30 Consolidated balance sheet in local crncy √ 2000
Save
Continue
15. Specify Rounding of Net Book Value and/or
Depreciation.
Up to Valuation same path
Amount Specifications(Company Code/Depreciation Area) Specify Rounding of Net
Book
Value and/or Depreciation
Enter twice to ignore the warning msg
Position
Company code : LAP
+91-9959765211 234
233.
SrinivasaKasireddy+91-9959765211
Enter
Select company codeLAP
Double click on Rounding specifications folder
Enter to ignore the msg
Double click on Dep. area ‘01’
√ Automatically calculated depreciation.
Arithmetic Rounding
Save
Continue
16. Creating Depreciation Keys
Define base method
Up to Asset Accounting same path
DepreciationValuation MethodsDepreciation KeyCalculation MethodsDefine
Base
methods
Make a note of Base method ‘0014’ ie Ordinary: explicit percentage (after end of
life)
Define Declining-Balance methods
Same path
Chrt/dep : LACD
Enter
Make a note of Declining-Balance method ‘ 001’ ie 0.00x / 0.0000% / 0.0000%
Define Multi-Level Methods
Same path
New entries
Multi-level method : L1 Straight Line Method
Validity start : From ordinary depreciation start date
Double click on Levels folder
+91-9959765211 235
234.
SrinivasaKasireddy+91-9959765211
New Entries
Acq.
Year
Years Basevalue Percent
9999 1 01 10
9999 999 01 5
Save
Continue
Back button twice
Next Entry button
Multilevel button : L2 10% WDV
Validity start : From ordinary depreciation start date
Double click on Levels folder
New Entries
Acq.
Year
Year Base value Percent
9999 999 24 10
Save
Maintain Period Control Methods
+91-9959765211 236
235.
SrinivasaKasireddy+91-9959765211
Same path
New Entries
Prd.c.met
h
DescriptionAcq Add Ret Trn
006 01/01/01/01 01 01 01 01
Save
Continue
Maintain Depreciation Key
Up to Depreciation key same path
Maintain Depreciation Key
ChDep : LACD
Enter
New Entries
Dep. key : LAP1 Stright Line Method
Period control according to fiscal years .
Dep. to the day .
Assignment of Calculation Methods folder
New Entries
DepType : N Ord depreciation
Phase : 1 From the start of depreciation.
Base method : 0014
Decl-bal. method : 001
Prd cont : 006
Multilev. meth : L1
Class : 1 straight- line depreciation
Multiple shift : Increase in depreciation and expired useful life
Scrap value : Base value is reduced by the scrap value amount
Shut down : No
+91-9959765211 237
236.
SrinivasaKasireddy+91-9959765211
Save
Continue
Back button 3times
Next Entry button
Dep. key : LAP2 10% WDV
Period control according to fiscal years .
Dep. to the day .
Assignment of Calculation Methods folder
New Entries
DepType : N Ord depreciation
Phase : 1 From the start of depreciation.
Base method : 0014
Decl-bal. method : 001
Prd cont : 006
Multilev. meth : L2
Class : 2 Declining-balance depreciation
Multiple shift : Increase in depreciation and expired useful life
Scrap value : Base value is reduced by the scrap value amount
+91-9959765211 238
SrinivasaKasireddy+91-9959765211
Double click on‘LAP’ under Not assigned
Element/Group button
Save
Continue
2. End User
1. Creating Asset master
Tcode: AS01
SAP Easy accessAccountingFinancial AccountingFixed assetsAssetCreate
Asset
Asset Class : LAP1
Company Code : LAP
Number of similar assets : 1
Enter
Description : Gantry
Asset main no. text : Gantry
Inventory no : 567
Capitalized on : 04-01-2012
Time -dependent tab
Business Area : LANZ
Deprec. Areas Tab:
Dep. Key Useful life Period O Dep. start date
LAP1 15 04-01-2012
Save
Scrap value : 900
Save
Messg: Asset 10000 0 created
2. Creating Sub Asset Master
Tcode: AS11
Up to Create same path
Sub-NumberAsset
Asset : 10000
Company code : LAP
Number of similar subnumbers. : 1
Enter
+91-9959765211 241
240.
SrinivasaKasireddy+91-9959765211
Change Description :Motor
Inventory no : 568
Time- dependent tab
Dep. Areas tab
Dep. Key : LAP2
Save
3. Creating Sub Asset Master
Tcode: AS11
Asset : 10000
Company code : LAP
Number of similar subnumbers. : 1
Enter
Change Description : Control panel
Inventory no : 569
Dep. Areas tab
Dep. Key : LAP2
Save
4. Creating Asset master(WIP)
Tcode: AS01
Asset Class : LAP5
Company Code : LAP
Number of similar assets : 1
Enter
Description : Machine Under Commissioning
Asset main no. text : Machine Under Commissioning
Inventory no : 567
Capitalized on : 04-01-2012
Time -dependent tab
Business Area : LANZ
Dep. Areas Tab:
Dep. Key Useful life Period O Dep. start date
0000
Save
+91-9959765211 242
241.
SrinivasaKasireddy+91-9959765211
Scrap value :900
Save
Messg: Asset 50000 0 created
5. Main asset acquisition
Tcode: F-90
Up to Fixed Assets same path
PostingAcquisitionExternal AcquisitionWith Vendor
Document Date : 04-01-2012
Posting Date : 04-01-2012
PstKy : 31 Account : LAPGNVNDR
Enter
Amount : 90000
Busi area : LANZ
Text : Asset Purchase
PstKy : 70 Account : 10000-0
TType : 100
Enter
Delete all WHT codes
Enter
Amount : *
Text : +
Document MenuSimulate
Post
6. Sub asset acquisition
Tcode : F-90
Document Date : 04-01-2012
Posting Date : 04-01-2012
PstKy : 31 Account : LAPGNVNDR
Enter
Amount : 9000
Business Area : LANZ
+91-9959765211 243
242.
SrinivasaKasireddy+91-9959765211
Text : subAsset purchase
PstKy : 70 account : 10000-1
TType : 100
Enter
Delete all WHT Codes
Enter
Amount : *
Text : +
Document menuSimulate
Post
7. Sub asset acquisition
Tcode : F-90
Document Date : 04-01-2012
Posting Date : 04-01-2012
PstKy : 31 Account : LAPGNVNDR
Enter
Amount : 9000
Busi Area : LANZ
Text : Sub asset purchase
PostKy : 70 Account : 10000-2
TType : 100
Enter
Delete all WHT codes
Enter
Amount : *
Text : +
Document menuSimulate
Post
8. Report to Display Asset values
Tcode: AW01N
Up to Fixed Assets same path
Asset Asset Explorer
Asset : 10000 0
Posted Values tab
+91-9959765211 244
243.
SrinivasaKasireddy+91-9959765211
9. Report todisplay Asset balances
Up to Fixed Assets same path
Information systemReports on Asset AccountingAsset BalancesBalance Lists
Asset
Balances By Asset Class
Company Code : LAP
Asset Class : LAP1
+91-9959765211 245
244.
SrinivasaKasireddy+91-9959765211
Report date :31-03-2012
Dep. Area : 01
List assets
Execute
Back button twice
By Business area
Company code : LAP
Business area : LANZ
Report Date : 31-01-2012
Dep. Area : 01
List assets
Execute
10. Depreciation Run
Tcode: AFAB
Up to Fixed Assets same path
Periodic ProcessingDepreciation RunExecute
Company code : LAP
Fiscal Year : 2011
Period : 10
Unplanned posting run
√ List assets
√ Test Run
Error Analysis
Execute
’Yes’ button to ignore the warning message
+91-9959765211 246
245.
SrinivasaKasireddy+91-9959765211
In case oferrorsError list button
Back button
Test run
Program MenuExecute in Background
Output device : LP01
Continue
Enter
Immediate button
Save
Msg No documents were created in this run :
Solution : Run Dep (AFAB) for each month with planning posting run radio button for all
periods up to period before capitalization execute with production run.
Please do production run from period 1 through period before capitalization.(Testrun screen
shows blank ) and then run Depreciation for later periods(Periods after capitalization).
Problem : If no items are shown in the testrun , and Error List log shows no errors .
Solution : Execute Depreciation Run without selecting Error Analysis check box.
Ie . Error Analysis
11. Display Log
Tcode: AFBP
Same path
Company Code : LAP
Fiscal Year : 2011
Posting Period : 10
√ SchedMan Monitor
Execute
+91-9959765211 247
246.
SrinivasaKasireddy+91-9959765211
12. Checking Background Job Status
System MenuServicesJobsJob overview
Job name : RAPOST 2000
Schedule √
From 05-01-2012 to 31-01-2012
Execute
13. Display Asset Explorer
Tcode : AW01N
Asset 10000-0
Posted values tab
14. Sale of Asset
Tcode: F-92
Up to Fixed Assets same path
PostingRetirementRetirement W/RevenueWith customer
Document Date : 31-01-2012 Type : DR
Posting Date : 31-01-2012
PstKy : 01 Account : LAPGNCUST
Enter
Amount : 88000
Text : Sale of Asset
PstKy : 50 Account : 300515
T Type : 210
Enter
Amount : *
Text : +
Asst retirement √
Enter
+91-9959765211 248
247.
SrinivasaKasireddy+91-9959765211
Asset : 10000
Subnumber : 0
Asset Value date : 31-01-2012
√ Complete Retirement
Enter
DocumentSimulate
Post
(Entry will be as shown in the following image)
15. Scrapping of Asset
Tcode: ABAVN
Same path
Asset Retirement by scrapping
Asset : 10000 1
Document Date : 31-01-2012
Posting Date : 31-01-2012
Asset Value date : 31-01-2012
Text : Scrapping of sub asset
Save
16. Settlement of WIP line items
Purchase of Machinery
Tcode: F-90
Document Date : 04-01-2012
Posting Date : 04-01-2012
+91-9959765211 249
248.
SrinivasaKasireddy+91-9959765211
PstKy : 31Account : LAPGNVNDR
Enter
Amount : 45000
Busi area : LANZ
Text : Machinery Purchase
PstKy : 70 Account : 50000-0
TType : 100
Enter
Delete all WHT codes
Enter
Amount : *
Text : +
Document MenuSimulate
Post
Posting Commissioning charges
Tcode : F-02
Document Date : 15-01-2012
Posting Date : 15-01-2012
PstKy : 70 Account : 50000-0 TType : 100
Enter
Amount : 9000
Bus area : LANZ
Text : Commissioning Charges
PstKy : 50 Account : 200792
Enter
Amount : *
Bus area : LANZ
Text : +
Document MenuSimulate
Post
Creating Asset master(Machine)
Tcode: AS01
Asset Class : LAP1
Company Code : LAP
Number of similar assets : 1
+91-9959765211 250
249.
SrinivasaKasireddy+91-9959765211
Enter
Description : Machine
Assetmain no. text : Machine
Inventory no : 56799
Capitalized on : 31-01-2012
Time -dependent tab
Business Area : LANZ
Dep. Areas Tab:
Dep. Key Useful life Period O Dep. start date
LAP1 15 6 31-01-2012
Save
Scrap value : 900
Enter
Messg: Asset 10001 0 created
Create Distribution rules
Tcode: AIAB
Up to Fixed Assets same path
PostingCapitalize Asset u. ConstDistribute
Company Code : LAP
Asset : 50000
Subnumber : 0
Execute
Select all button
Enter distribution rules button
Cat Settlement Receiver Receiver Short Text %
+91-9959765211 251
250.
SrinivasaKasireddy+91-9959765211
FXA 10001-0 Machine100
Back button
Save
Settlement
Tcode: AIBU
Up to Posting same path
Capitalize Asset u. ConstSettle
Company code : LAP
Asset : 50000
Sub-number : 0
Document Date : 31.01.2012
Asset val. date : 31.01.2012
Posting Date : 31.01.2012
Period : 10
Text : Settlement of AUC
Document Type : AA
√ Test Run
√ Detail List
Execute
+91-9959765211 252
SrinivasaKasireddy+91-9959765211
22. Sales/Purchase Tax
Salestax = Output tax
Purchase tax = Input tax
VAT : Value Added Tax
VAT is a mode of collection of tax
Purchase of RM Sale of FG
Pay purchase tax to Vendors Collect Sales tax from Customers
5000 Rs 7000 Rs
The diff is 2000. This amount is to be remitted to tax authority.
1. Settings
1. Define Tax procedure:
SPROFinancial accounting Financial accounting Global settingsTax on
Sales/Purchases
Basic settingsCheck Calculation Procedure
Double click on Define Procedures
New Entries
Procedure Description
TAXIN Ind Tax procedure(LAP)
Save
Create Request button
Short Description : Sales/Pur Tax Settings (LAP)
Enter
Continue
Select Tax Procedure ‘TAXIN’
Double click on Control Data folder
New Entries
Step Ctyp Description Fro To AccKey
100 BASB Base amount
110 MWAS Output Tax 100 100 MWS
120 MWVS Input tax 100 100 VST
Save
+91-9959765211 255
254.
SrinivasaKasireddy+91-9959765211
2. Assign Countryto Calculation procedure :
Same path
Position
Country : IN
Enter
Cty Proc
IN TAXIN
Save
Continue
Info:
Tax is configured at country level but not at Comp Code level. This setup is going to
work for all Comp Codes which belongs to India .
3. Define Tax Codes for Sales and Purchases
Upto Tax on Sales/Purchases same path
Calculation Define Tax Codes for Sales and Purchases
Country : IN
Enter
Taxcode : V0
Enter
Description : 0% input tax
Taxtype : V ie inputtax
Check ID √
Continue
Keep the cursor on Output tax(Click)
Deactivate line button
InputTax : 0
Save
Taxcode : V1
Enter
Description : 4% input tax
Taxtype : V ie inputtax
Check ID √
+91-9959765211 256
255.
SrinivasaKasireddy+91-9959765211
Continue
Keep the cursoron Output tax(Click)
Deactivate line button
InputTax : 4
Save
Taxcode : A0
Enter
Description : 0% output tax
Taxtype : A ie outputtax
Check ID √
Continue
Keep the cursor on Input tax(Click)
Deactivate line button
OutputTax : 0
Save
Taxcode : A1
Enter
Description : 14.5% output tax
Taxtype : A ie outputtax
Check ID √
Continue
Keep the cursor on Input tax(Click)
Deactivate line button
OutputTax : 14.5
Save
4. Creation of 2 GL accounts
a. VAT Payable
Tcode: FS00
Select GL account 100800 Expenses payable
Copy button
GL account : 100530
Enter
Description : VAT Payable
+91-9959765211 257
256.
SrinivasaKasireddy+91-9959765211
Control Data tab
TaxCategory : > ie Output Tax Account
Create/Bank/Interest tab
Field status group : G041
Save
b. VAT Recievable
Select GL account 100530 VAT Payable
Copy button
GL account : 200530
Enter
Account Group : Assets
Description : VAT Receivable
Control Data tab
Tax category : < ie Input Tax Account
Save
5. Change GL accounts Sales, Inventory RM
Tcode :FS00
Select GL account 300510 Sales
Change button
Control Data Tab
Tax category : + ie Only output tax allowed
√ Posting without tax allowed
Save
Enter to Ignore the Wrng Msg
Select GL account 200700 RM inventory
Change button
Control Data Tab
Tax category : - ie Only input tax allowed
√ Posting without tax allowed
Save
Enter to Ignore the Wrng Msg
+91-9959765211 258
257.
SrinivasaKasireddy+91-9959765211
6. Define Taxacounts
Upto Tax on Sales/Purchases same path
Posting Define Tax accounts
Double click on transaction MWS ( Output tax)
Chart of accounts : LACA
Enter
Save
Account
100530
Save button
Continue
Back button
Double click on transaction VST ( Input tax)
Save
Account
200530
Save
Continue
7. Define Tax Determination Rules
SPROSales and Distribution Basic FunctionsTaxes Define Tax Determination
Rules
New entries
Tax count Name Seq Tax Categ Name
IN 5 MWST Taxble
Save
8. Define Tax Relevancy Of Master Records
SPROSales and Distribution Basic FunctionsTaxesDefine Tax Relevancy Of
Master Records
Double click on ‘Customer Taxes’
New entries
Tax categ Tax class Description
MWST 1 Taxable
+91-9959765211 259
SrinivasaKasireddy+91-9959765211
40 0000200530 VATRecievable 1.285,71
2. Posting Sales Inv:
Tcode :F-22
PstKy : 01 Account : LAPGNCUST
Enter
Amount : 18000
√ Calculate Tax
Bus. Area : LANZ
Text : Sales inv
PstKy : 50 Account : 300510
Enter
Amount : *
Tax Code : A1
Bus Area : LANZ
Text : +
Document menuSimulate
Post
Entry should be
01 LANZ LAPFICUST LAP fi customer 18.000,00
50 LANZ 0000300510 Sales 15.720,52-
50 100631 VAT payable 2.279,48-
+91-9959765211 261
260.
SrinivasaKasireddy+91-9959765211
23. MM Integration
LIVEproject
MM Configuration MM consultant
FI Configuration FI consultant
FI-MM Integration FI Consultant
Learning environment
MM Configuration FI consultant
FI Configuration FI consultant
FI-MM Integration FI Consultant
1. MM configuration
1. Maintain Calendar:
SPROSAP Net weaverGeneral SettingsMaintain Calendar
Public holidays
Change button
Create Button
With fixed date
Enter
Day : 15
Month : 8
Not Guaranteed
Short holiday name : Independence day
Long holiday name : Independence day
Enter
Continue
Back button
Holiday Calendar
Change button
Create button
Calendar ID : LC
Description : holiday calendar for LAP
+91-9959765211
…
…
…
…
…
…
…
…
…
…
…
…
…
…
…
…
262
261.
SrinivasaKasireddy+91-9959765211
Assign Holiday button
Selectholidays to be included
Assign publ. holiday button
Save
Continue
Back button twice
Factory calendar
Change button
Create button
Factory calendar ID : LF
Description : Factory calendar for LAP
Holiday calendar ID : LC
Workdays
Select Monday to Saturday
Save
Continue
2. Define plant:
SPROEnterprise StructureDefinitionLogistics-GeneralDefine, Copy, delete,
check
plant
Double click on Define Plant
New Entries
Plant : LAPL
Name 1 : LAP Hyd plant
Factory calendar : LF
Save
Name : LAP Hyd plant
Country : IN
Region: 01
City : Hyd
Enter
Create Request button
Short Description : MM configuration for LAP
Enter
Continue
+91-9959765211
…
…
…
…
263
262.
SrinivasaKasireddy+91-9959765211
3. Define Division:
Samepath
Define, copy, delete, check division
Double click on Define Division
New Entries
Division Name
LS Small Cars
Save
Continue
4. Maintain Storage Location:
Up to Definition same path
Materials Management Maintain storage location
Plant : LAPL
Enter
New Entries
SLoc Description
LAP1 Hyd Storage Location
Enter
Save
Continue
5. Maintain purchasing organisation:
Same path next line
New Entries
Purch. Organisation Purch. Org Descr
LAPO LAP purchase org.
Save
Continue
6. Assign plant to company code:
Up to Enterprise Structure same path
AssignmentLogistics-General Assign plant to company code
New Entries
CoCd Plnt
+91-9959765211 264
263.
SrinivasaKasireddy+91-9959765211
LAP LAPL
Save
Continue
7. AssignBusiness Area to Plant/Valuation Area and
Division:
Same path next line
Valuation area - division button
New entries
ValA Dv BusA
LAPL (Valuation area is nothing but plant LS LANZ
Save
Continue
8. Assign Purchasing organization to company code:
Up to Assignment same path
Materials ManagementAssign purchasing organisation to company code
Position
Purchasing org : LAPO
Enter
POrg CoCd
LAPO LAP
Save
Continue
9. Assign purchase organisation to plant:
Same path next line
New Entries
POrg Plnt
LAPO LAPL
Save
Continue
10. Create Purchasing Groups:
SPROMaterials ManagementPurchasingCreate Purchasing Groups
New Entries
Purchasing Group Desc. Pur.Grp
LPG LAP purchasing group
+91-9959765211 265
264.
SrinivasaKasireddy+91-9959765211
Save
Continue
11. Define MaterialGroup:
SPROLogistics-GeneralMaterial MasterSettings for Key FieldsDefine Material
Groups
New Entries
Matl Group Material Group Desc
LAPM Metals
Save
Continue
12. Maintain Company Code for Material Management:
Up to Material Master same path
Basic SettingsMaintain Company Codes for Material Management
Position
Company code : LAP
Enter
(CAUTION: Enter current period .If you enter wrong period it can’t be changed)
Cocd Year Period ABp
LAP 2012 5(Current period) √
Save
Continue
Note: Material posting starts from the above period . ABp is Allow Back posting .
If ABp is selected 2 periods(current and previous) are allowed , other wise only current
period is allowed.
13. Define Attributes of Material Types:
Up to Basic Settings same path
Material typesDefine Attributes of Material types
Position
Material type : FERT
Enter
Select Material Type ‘FERT’
Double click on ‘Quantity/value updating’ folder
Position
Valuatin area : LAPL
+91-9959765211 266
265.
SrinivasaKasireddy+91-9959765211
Enter
Valuation area Material
s
Qtyupdating Value Update
LAPL FERT √ √
Save
Continue
Back button
Position
Material type : ROH
Enter
Select Material type ‘ROH’
Double click on Quantity/value updating folder
Postion
Valuation Area : LAPL
Enter
Val .area Matl type Qty updating Value Update
LAPL ROH √ √
Save
14. Set Tolerance Limits for Price variance ( purchasing
order):
SPROMaterial ManagementPurchasingPurchase OrderSet Tolerance Limits
for
Price Variance
Select ‘TlKy’s PE, SE for Company code ‘1000’
Copy as button
Change the Company Code to ‘LAP’
Enter
Again change the Company Code to LAP
Enter
Save
Continue
15. Plant Parameters
Up to Materials Management same path
Inventory Management and Physical InventoryPlant Parameters
Select Plant ‘1000’
+91-9959765211 267
266.
SrinivasaKasireddy+91-9959765211
Copy as button
Changethe plant to ‘LAPL’
Enter
Save
Continue
16. Define Number Assignment for Material and Phys.
Inv .Docs
(One time setting)
SPROMaterials ManagementInventory Management and Physical
InventoryNumber
Assignment Define Number Assignment for Material and Phys. Inv .Docs
Maintain Groups button
√ Material documents for goods receipts
WE WF WO WW
Interval menuMaintain
Position the cursor on any interval
Edit menuInsert year
Year From number To number
2013
(Calendar year)
4500000000 4599999999
Enter
Back button
√ Material documents for goods movements and inventory diffs
WA WH WI WL WQ WR WS WZ
Interval menuMaintain
Position the cursor on any interval
Edit menuInsert year
Year From number To number
2013
(Calendar year)
5000000000 5099999999
Enter
Save
Continue
17. Set Tolerance Group (for GR):
Same path up to Inventory Management and Physical Inventory
+91-9959765211 268
267.
SrinivasaKasireddy+91-9959765211
Goods ReceiptsSet ToleranceLimits
Select Tlky B1, B2, VP for company code ‘1000’
Copy as button
Change Company Code to ‘LAP’
Enter
Change Company Code to ‘LAP’
Enter
Change Company Code to ‘LAP’
Enter
Save
Continue
18. Maintain Default Values for Tax codes:
Up to Material Management same path
Logistics Invoice VerificationIncoming InvoiceMaintain Default Values for tax codes
New Entries
Company Code : LAP
Save
Continue
19. Set Tolerance Limits (for invoice verification):
Up to Logistic Invoice Verification same path
Invoice BlockSet Tolerance Limits
Select Tolerance Keys PP, PS & ST for company code ‘1000’
Copy as button
Change Company Code to ‘LAP’ (3times)
Enter (3 times)
Save
Continue
20. Define Automatic status change:
Up to Logistics Invoice Verification same path
Invoice Verification in Back groundDefine Automatic Status change
New Entries
CoCd Set correct invoice to’’completed’’
+91-9959765211 269
268.
SrinivasaKasireddy+91-9959765211
LAP Blank
Save
Continue
21. Grouptogether Valuation areas:
Up to Materials Management same path
Valuation and Account AssignmentAccount DeterminationAccount Determination
Without WizardGroup Together Valuation Areas
Position
Valuation area: LAPL
Enter
Valuation Area Val. Grpg code
LAPL X
Save
Continue
22. Define Valuation Classes:
Same path next lineDefine Valuation Classes
Valuation Class button
Select Valuation Class 3000 ( ie Raw material1) ,3200 (ie Services) and
7920 ( ie FinishedGoods)
Copy as button
Change Valuation Class 3000 to ‘LAP1’
Change Valuation Class 3200 to ‘LAP2’
Change valuation class 7920 to ‘LAP3’
Enter
Save
Continue
2. FI Consultant’s Job
1. Changing GL account Inventory RM
Tcode: FS00
+91-9959765211 270
269.
SrinivasaKasireddy+91-9959765211
Select GL account200700 (RM Inventory)
Change button
Create /Bank/Interest tab
Field Status Group : G006 (Material Accounts)
√ Post automatically only
Save
Enter to ignore the warning message
2. Creating GL accounts
Inventory FG :
Select 200700 (Inventory RM)
Copy button
GL account : 200702
Enter
Description : Inventory FG
Control Data tab
Tax category : Blank
√ Posting without tax allowed
Save
Enter to ignore the warning message
GR/INR account
Select 100800 Expenses payable account
Copy button
GL account : 100520
Enter
Description : GR/INR account’
Control data tab
Tax category : - (Minus)
√ Posting without tax allowed
Sort key : 010 (Purchase order No.)
(Make sure Open Item Management is on)
Create/Bank/Interest tab
Field Status Group : G045 Goods/Invoice Received clearing account
Save
+91-9959765211 271
270.
SrinivasaKasireddy+91-9959765211
Freight Clrng account
SelectG/L account 100520 (GR/INR account)
Copy button
GL account : 100521
Enter
Description : Freight Clrng account
Create/Bank/Interest tab
Field Status Group : G017 Freight/customs provisions/ clearing (MM)
Save
RM Consumption Account
Select 400500 (Salaries)
Copy Button
GL account : 400599
Enter
Description : RM Consumption
Create/Bank/Interest tab
Field Status Group : G003 (Material Consumption Account)
Save
Edit Cost Element button
Valid From : 01.04.2012
Enter
Cost Elem category : 1
Save
Cost Of Goods Sold a/c
Select 400500 (Salaries)
Copy Button
GL account : 400204
Enter
Description : Cost Of Goods Sold a/c
Create/Bank/Interest tab
Field Status Group : G030 ie Change in stock accounts
Save
Inc/Dec in stock account
Select 300510 (Sales account)
Copy Button
GL Account : 300204
+91-9959765211 272
271.
SrinivasaKasireddy+91-9959765211
Enter
Description : Inc/Decin stock
Control data tab
Tax category : Blank
√ Posting without tax allowed
Create/Bank/Interest tab
Field Status Group : G030 (Change in stock account)
Save
3. Assignment of Accounts:
Tcode: OBYC
SPROMaterial ManagementValuation and Account AssignmentAccount
Determination Account Determination without wizardConfigure Automatic Posting
Cancel button
Account Assignment button
Double click on transaction ‘BSX’ (Inventory posting)
Chart of account : LACA
Enter
Valuation class √
Save
Valuation class Account
LAP1 200700(Inventory RM)
LAP3 200702(Inventory FG)
Save
Continue
Back button
Double click on Transaction ‘FR1’ (Freight clearing)
Valuation modif √
Valuation class √
Save
Valuation
modif
Valuation Class Account
X LAP1 100521
Save
Back button
+91-9959765211 273
272.
SrinivasaKasireddy+91-9959765211
Double click onTransaction ‘WRX’ (GR/IR clearing account)
Valuation modif √
Valuation class √
Save
Valuation
modif
Valuation Class Account
X LAP1 100520
Save
Back button
Double Click on transaction ‘GBB’
General modification √
Valuation modif √
Valuation class √
Save
Valuation
modif
General
Modification
Valuation Class Account
X VBR LAP1 400599
X VAY LAP3 400204
X AUF LAP3 300204
X VAX LAP3 400204
X ZOF LAP3 300204
Note: GL account 400599 is RM consumption ac 300204 is Inc/Dec in stock
And 400402 is Cost of Goods Sold a/c
Save
Continue
VBR : RM consumption
VNG : Material Scrapping
FG Reciept from Production
AUF ZOF
With Production Order
[PP implemented]
Without Production Order
[PP not implemented]
FG Delivery to customer
VAY VAX
+91-9959765211 274
273.
SrinivasaKasireddy+91-9959765211
Sales A/C asRevenue element
[CO Implemented)
Sales A/C not as a Revenue element
(CO not implemented)
4. Creating No. ranges for Document types WE WA RE
Tcode :OBA7
Double Click on document type ‘WA’
Note down the No range ‘49’
Back button
Doubl Click on document type ‘WE’
Note down the no range ‘50’
Back button
Double Click on document type ‘RE’
Note down the no range ‘51’
In the same screen ‘Number range information’ button
Company Code : LAP
Change Intervals button
Interval button
No Year From Number To Number
49 2012 4900000000 4999999999
Enter
Interval button
No Year From Number To Number
50 2012 5000000200 5099999999
Enter
Interval button
No Year From Number To Number
51 2012 5100000000 5199999999
Enter
Save
Continue
3. MM End User
+91-9959765211 275
274.
SrinivasaKasireddy+91-9959765211
Planned delivery costsUnplanned Delivery Costs
If you know the freight charges at the time of PO
creation, you can enter in PO. During the GR, the
freight charges will be posted to Freight clrng
account.
Freight charges will be posted to Inventory
account
During freight invoice verification they are
transferred to vendor account.
If you don’t know the freight charges at
the time of PO creation, you can enter
them during Inv Verification (MIRO)
There are two options as how to post
unplanned delivery cost (This is a CoCd
level setting).
1. Freight charges can be distributed
among invoice items
2. Freight charges can be posted to
Expenses account
Planned delivery costs:
Scenario1 : Goods inv and Freight inv are from single vendor
Solution : Goods inv and Freight inv can be entered in one step
Scenario2 : Freight inv is from a different vendor
Solution : Goods inv and Freight inv have to be entered in separate steps
(We are following scenario 2 ie Transport vendor is separate from goods vendor)
1. Creation of RM master
TCode :MM01
SAP Easy AccessLogisticsMaterials ManagementMaterial
MasterMaterialCreate
(General) Immediately MM01
Material : LAPRM
Industry Sector : Mechanical Engineering
Material type : ROH Raw Material
Select View(s) button
Select views Basic data1, Purchasing , General Plant Data / Storage 1 , Accounting 1,
Costing1 and Costing2
Org. Levels button
Plant : LAPL
Stor. location : LAP1
Enter
+91-9959765211 276
275.
SrinivasaKasireddy+91-9959765211
Basic Data1 tab:
Material: LAP RM (Steel)
Basic unit of measures : KG
Material Group : LAPM
Division : LS
Net Weight : 1 KG
Gross Weight : 1 KG
Purchasing Tab
Purchasing Group : LPG
Accounting 1 tab
Valuation class : LAP1
Price Control : V (Moving Average Price)
Moving Price : 200
Save
2. Creation of Vendor Masters
Tcode : XK01
Vendor : LAPRMVNDR
Company Code : LAP
Purchase Organisation : LAPO
Account Group : LARM
Enter
Name : LAP RM vendor
Country : IN
Region : 01
Enter 4 times (or Next Screen button 4 times)
Recon. account : 100980 (Sundry creditors)
Sort Key : 012 (Vendor Number]
Cash Management Group : A1
Enter
Payt Terms : 0001
Tolerance Group : blank
Chk double inv √
Save
3. Creation of Vendor Masters
Tcode : XK01
Vendor : LAPTRVNDR
+91-9959765211 277
276.
SrinivasaKasireddy+91-9959765211
Company Code :LAP
Purchase Organisation : LAPO
Account Group : LARM
Enter
Name : LAP Transport vendor
Country : IN
Region : 01
Enter 4 times (or Next Screen button 4 times)
Recon. account : 100980 (Sundry creditors)
Sort Key : 012 (Vendor Number]
Cash Management Group : A1
Enter
Payt Terms : 0001
Tolerance Group : blank
Chk double inv √
Save
4. Open Period for Current month
(Periodic activity)
Tcode : MMPV
Up to Material Master same path
OtherClose Period
From Company Code : LAP
To Company Code : LAP
Period : 5 (Current period)
Fiscal Year : 2012
Check and close period
Execute
5. Purchase Order Creation:
Tcode : ME21N
Up to Materials Management same path
PurchasingPurchase OrderCreateVendor/Supplying Plant Known
Vendor : LAPRMVNDR
Enter
Org.Data tab
Purch. Org : LAPO
+91-9959765211
…
…
…
…
278
277.
SrinivasaKasireddy+91-9959765211
Purch. Group :LPG
Company Code : LAP
Item Material PO
Quantity
Deliv.
Date
Net
Price
Currency Plnt Stor.
Location
10 LAPRM 100 15.08.2012 210 INR LAPL LAP1
Enter
Expand ‘Item Detail’ button
Conditions tab
Enter amount for condition type ‘FRB1’ as below
CnTy Name Amount
FRB1 Freight (Value) 45.00
Messages button to see any errors
Back button
Check button
Save
Note down the purchase order No. 4500017175
6. Goods Receipt
Tcode :MIGO
Up to Material Management same path
Inventory ManagementGoods MovementGoods ReceivedFor Purchase
OrderPO
Number Known
Purchase order : 4500017175
Enter
Where tab
Storage Location : LAP1
Text : GR
Quantity tab
Qty in Delivery Note : 100 kg
√ Item OK
Check button (‘Document is 0K ‘ msg should come)
Post
(Note down the material document no 600000030)
7. Displaying Material document
Tcode: MB03
+91-9959765211 279
278.
SrinivasaKasireddy+91-9959765211
Up to InventoryManagement same path
Material DocumentDisplay
Material Document : 600000030
Material document year : 2012
Enter
Accounting Documents button
Dr. 89 Inventory RM .00
Cr. 96 GR/INR account .00
Cr 50 Freight clrng account 45.00
8. Invoice Verification for goods
Tcode : MIRO
Up to Material Management same path
Logistics Invoice VerificationDocument EntryEnter Invoice
Invoice date : Todays date
√ Calculate tax
Tax code : V1 4%Input tax
Text : Inv Verifcation
PO Reference Tab
Purchase order/Scheduling agreement 4500017175 Goods/service items
Enter
Select √ Booking OK for item 1
Enter
Copy the amount in Balance field (red signal)
Paste to Amount field (without –‘ve sign)
Enter
(Red signal should turn into green signal)
Payment tab
Baseline date : Todays date
Payment term : 0001
Simulate button
Close the window
Post
Invoice Document menu Display
Follow-On Documents button
+91-9959765211 280
279.
SrinivasaKasireddy+91-9959765211
LAP RMvendor
GR/INR clrngaccount .
VAT Receivable
9. Inv Verification for Freight
Tcode: MIRO
Invoice date : Todays date
√ Calculate tax
Tax code : V0 0%Input tax
Text : Freight Inv verifcation
PO Reference Tab
Purchase order/Schedulin agreement 4500017175 Planned delivery costs
Enter
Select √ Booking OK for item 1
Enter
Details tab
Inv. Party : LAPTRVNDR
Enter
Enter to ignore the msg
Basic data tab
Copy the amount in Balance field (red signal)
Paste it to Amount field (without –‘ve sign)
Enter
(Red signal should turn into green signal)
Payment tab
Baseline date : Todays date
Payment term : 0001
Simulate button
Entry should look like the following
Cr LAP TR vendor 45.00-
Dr Freight clrng account 45.00
Close the window
Post
+91-9959765211 281
280.
SrinivasaKasireddy+91-9959765211
10. RM Consumption
Tcode: MB1A
Up to Materials Management same path
Inventory ManagementGoods MovementGoods Issue
Movement type : 201 (Consumption for CC)
Plant : LAPL
Storage location : LAP1
Enter
Cost Centre : 1001
Material : LAPRM
Qty : 25
Enter
Post
(Document 500000350 generated)
Goods Issue menuDisplay
Material Doc : 100000350
Mat. Doc. Year : 2012
Enter
Accounting Documents button
Double click on Accounting document
Entry should be :
Cr. Inventory RM 5011.25-
Dr. RM Consumption 5011.25
11. Display Stock Ledger
Tcode : MMBE
up to Material Management same path
Inventory ManagementEnvironmentStockStock Overview
Material : LAPRM
Plant : LAPL
Storage location : LAP1
Execute
12. Display Stock for posting date
Tcode :MB5B
+91-9959765211 282
SrinivasaKasireddy+91-9959765211
24. SD Integration
1.SD consultant job
1. Define Sales Organisation:
SPROEnterprise StructureDefinitionSales and DistributionDefine, copy,
delete,
check sales organization
Double click on Define Sales Organisation
New Entries
Sales Organisation : LASO
Description : LAP sales org
Statistics currency : INR
Save
Enter to ignore the warning message
Name : LAP sales org
Country : IN Region : 01
Enter
Create Request button
Short Description : SD configuration for LAP
EnterContinue
2. Define Distribution Channel:
Same path Next line
Define ,copy , delete ,check distribution channel .
Double click on Define distribution channel .
New Entries
Distr. Channel Name
LD Direct Sales
Save
Continue
3. Define shipping points:
Up to Definition same path
Logistics Execution Define, copy, delete, check shipping Point.
+91-9959765211 284
283.
SrinivasaKasireddy+91-9959765211
Double click onDefine shipping point.
New Entries
Shipping point : LASH
Description : LAP shipping point
Save
Name : LAP Shipping point.
Country : IN Region: 01
Enter
Continue.
4. Assign Sales Organisation to Company code:
SPROEnterprise StructureAssignmentSales and DistributionAssign Sales
Organisation to Company code
Position
Sales Org : LASO
Enter.
Sorg. CoCd
LASO LAP
Save
Continue
5. Assign Distribution channel to sales organisation:
Same path (next line)
Assign distribution channel to Sales Organisation.
New entries
SOrg
.
Dchl
LASO LD
Save
Continue.
6. Assign division to Sales Organization:
Same path next line
New Entries.
SOrg
.
Dv
LASO LS
+91-9959765211 285
284.
SrinivasaKasireddy+91-9959765211
Save
Continue.
7. Set upsales area:
Same path next line
New Entries
SOrg
.
DChl Dv
LASO LD LS
Save
Continue.
8. Assign sales organisation- distribution channel - Plant:
Same path
New Entries
SOrg
.
DChCust/Mt Plant
LASO LD LAPL
Save
Continue
9. Define Rules by Sales area:
Up to Sales and Distribution same path
Business Area Account AssignmentDefine Rules for Sales area
Position
Sales Org. : LASO
Enter
SOrg
.
Rule
LASO 001 (Bus Area determination from plant & division)
Save
Continue
10. Assign Business Area to Plant And Division
Same Path next line
New Entries
Plnt Dv BusA
+91-9959765211 286
285.
SrinivasaKasireddy+91-9959765211
LAPL LS LANZ
Save
Continue
11.Assign Shipping Point to Plant:
Up to Assignment same path
Logistics ExecutionAssign Shipping point to Plant
Find Button
Find : LAPL
Enter
Click on LAPL
Keep the cursor on LAPL
Assign Button
√ LASH
Enter
Save
Continue
12. Assign Shipping Points:
SPROLogistics ExecutionShippingBasic Shipping FunctionsShipping point
and
Goods receiving point DeterminationAssign shipping points
New Entries
SC LGrp Plnt PrShP MShPt
01 0003 LAPL LASH LASH
Save
Continue
13. Maintain Pricing Procedure:
SPROSales and DistributionBasic FunctionsPricingPricing controlDefine
and Assign Pricing Procedures
Double click on Maintain pricing procedures
Select Procedure ‘RVAA01’ ie Standard
Copy as button
Change Procedure with ‘LAPPP’
+91-9959765211 287
286.
SrinivasaKasireddy+91-9959765211
Change Description with‘LAP Pricing Procedure’
Enter
Copy all button
Enter to ignore the Wrng Msg
Select Procedure ‘ LAPPP’
Double click on Control Data folder
For Condition types SKTV (step 914), deselect Required
For Condition types K007 (step 104) MWST (step 915) select Required
Make a note of AccKey for ‘CTyp’s PR00 , MWST and K007 (ERL , MWS and
ERS respectively)
Save
Enter to ignore the msg
Continue
14. Define Pricing Procedure Determination:
Same Path same lineDefine and Assign Pricing Procedure
Double click on Define Pricing Procedure Determination
New Entries
SOrg. DChl Dv DoPr CuPP PriPr CTyp
LASO LD LS A 1 LAPPP PR00
LASO LD LS 2 1 LAPPP PR00
Save
Continue
15. Define Tax Determination Rules:
Up to Basic Functions same path
TaxesDefine Determination Rules
New Entries
Tax Count. : IN
Seq : 1
Tax categ. : UTXJ
Save
Continue (skip this step lab)
16. Set up Partner Determination:
+91-9959765211 288
287.
SrinivasaKasireddy+91-9959765211
Customer Partner role
Customer’sH Office Sold to party Sales to party
Payer HO will settle the bill
Customer’s Plant Ship to party Send goods to plant
Customer’s Br office Bill to party Send bill to Br Office
Up to Basic Function same path
Partner DeterminationSet up Partner Determination
Double click on Set up Partner Determination for Customer Master
Double click on ‘Account Groups- Function assignment’ folder
New Entries
Partn. Funct. Name Account Grp
SP Sold to party LASD
SH Ship to Party LASD
BP Bill to Party LASD
PY Payer LASD
Save
Enter 4times to ignore the msg
Continue
Double click on ‘Partner Determination Procedures’ folder
New Entries
Part. Det .proc Name
LAPD PDP for LAP
Save
Enter to ignore wrng msg
Select Partner Determination ‘LAPD’
Double click on ‘Partner Functions in Procedure’ folder
New Entries
Part.Det.
Proc
Partn.Funct. Not Modifiable Mandat.Funct
LAPD SP √ √
LAPD BP √
LAPD SH √
+91-9959765211 289
288.
SrinivasaKasireddy+91-9959765211
LAPD PY √
save
Doubleclick on ‘Partner Determination Procedure Assignment’ folder
Position
Account Group : LASD
Enter
Group ParPr
LASD LAPD
Save
17. Changing Schedule Line Category
Tcode : VOV6
Double cl ick on SLCa ‘DN’ ie Returns
Movement Type : 653 ie GD returns unrestr.
Save
Continue
2. FI Consultants job
1. Changing GL account
Tcode :FS00
Select GL account ‘300510’ ie Sales
Change button
Create/Bank/Interest tab
Change the Field Status Group to ‘G029’ ie Revenue accounts
Save
2. Assignment of Accounts for Automatic Posting:
SPROSales and DistributionBasic Functions Account
Assignment/CostingRevenue
Account DeterminationAssign G/L accounts
Double Click on table 1
New Entries
App CndTy ChAc SOrg
.
AAG AAG ActKy GL A/C
V KOFI LACA LASO 01 03 ERL 300510
V KOFI LACA LASO 01 03 ERS 400491
+91-9959765211 290
289.
SrinivasaKasireddy+91-9959765211
Save
Continue
3. SD EndUser
1. Creation of Customer
Tcode : XD01
Account Group : LASD (SD Customers)
Customer : LAPSDCUST
Company Code : LAP
Sales Organisation : LASO
Distribution Channel : LD
Division : LS
Enter
Name : LAP SD customer
Country : IN
Region: 01
Company Code Data button
Recon. account : 200610 (Sundry Debtors)
Sort Key : 031 (Customer Number)
Payment transactions tab
Terms of payment : 0001
Sales Area Data button
Sales tab
Cust. pric. proc : 1
Shipping Tab
Delivery priority : 02 (normal)
Shipping condition : 01 (as soon as possible)
Delivering plant : LAPL
Billing Documents tab
√ Price determine.
Inco terms : EXW (customer will take care of goods from plant only)
Terms of payment : 0001
Acct assgmt group : 01
Tax classification : 1 (liable for tax) for UTXJ
1 for MWST
Save
+91-9959765211 291
290.
SrinivasaKasireddy+91-9959765211
2. Creation ofMaterial FG
Tcode : MM01
Material : LAPFG
Industry Sector : Mechanical Engineering
Material Type : Finished products
Select View(s) button
Select Basic Data1, Sales: Sales Org. Data 1 , Sales: Sales Org. Data2 ,
Sales: General/Plant Data , MRP 1 , Accounting 1 , Costing1 and Costing2
Org. Levels button
Plant : LAPL
Stor. Location : LAP1
Sales Org. : LASO
Distr. Channel : LD
Enter
Description : LAP FG
Base Unit of Measure : EA
Material Group : LAPM
Division : LS
GenItemCatGroup : NORM
Sales: sales org .1 tab
Delivering plant : LAPL
Tax Data
Tax Classification : 1 for UTXJ
1 for MWST
Sales: sales org. 2 tab
Acct assignment grp : 03 ie Finished Goods
Item category group : NORM
Sales: General/Plant tab
Gross Weight : 1
Net Weight : 1
Availability check : KP (no check)
Trans. Grp : 0003
Loading Grp : 0003 ie Manual
MRP 1 Tab
MRP type : ND ie No plan
Accounting 1 tab
Valuation class : LAP3 (Finished Product)
+91-9959765211 292
291.
SrinivasaKasireddy+91-9959765211
Price control :S (std. price)
Standard price: 600
Save
3. Creation of Condition records
Tcode : VK11
SAP Easy AccessLogisticsSales and Distribution MasterData Conditions
Select Using Condition TypeCreate
Condition type : PR00
Key Combination button
Material with release status
Enter
Sales Organization : LASO
Distribution Channel : LD
Material Amount Valid From Valid to
LAPFG 700 1.04.2011 31.03.2012
Save
Back button
Condition type : K007
Key Combination button
Division/Customer
Enter
Sales Organization : LASO
Distribution Channel : LD
Division : LS
Customer Amount Valid From Valid to
LAPSDCUST 1 1.04.2011 31.03.2012
Save
Back button
Condition type : MWST
Key Combination button
Domestic taxes
Enter
Country : IN
TaxCl1Cust Tax cl. Mat Amount Valid From Valid to TaxCode
1 1 1.04.2011 31.03.2012 A1
Save
+91-9959765211
…
…
…
…
…
…
…
…
…
…
…
…
293
292.
SrinivasaKasireddy+91-9959765211
4. Creation ofSales order
Tcode :VA01
Up to Sales and Distribution same path
SalesOrderCreate
Order type : OR
Sales Organization : LASO
Distribution Channel : LD
Division : LS
Enter
Sold-to party : LAPSDCUST
PO Number : 567 (customer’s Purchase order no)
PO date : Todays date
Req. deliv. date : Todays date
Delivery plant : LAPL
√ Complete dlv
Payment Terms : 0001
Item Material Order Quantity Plant
10 LAPFG 10 LAPL
Enter
Select item 10
GoTo menuItemConditions
Enter CnTy ‘MWST’ and Amount ‘5%’
CnTy Amount
MWST 5
Make a note of Discount amount ie 7 Rs
Make a note of profit margin 93 ( ie (700-7)-600)
Back button
Edit menuIncompletion log
Save
Note down the order no
5. Production Receipts
Tcode :MB1C
Up to Logistics same pathMaterails ManagementInventory ManagementGoods
Movement Goods ReceiptsOthers
+91-9959765211 294
293.
SrinivasaKasireddy+91-9959765211
Document date :Todays date
Movement type : 521 (receipt w/o production order into unrestricted use
stock)
Plant : LAPL
Storage location : LAP1
Enter
Material Qty.
LAPFG 150
Enter
Text : GR from production
Post
Enter to ignore the warning message
Post
Note down the material document no. 100000360
Other Goods Receipt menuDisplay
Material document : 100000360
Mat. Doc year : 2012
Enter
Accounting Documents button
Double click on Accounting Document
Dr Inventory FG . 90000.00
Cr To Inc/Dec. in stock 90000.00- (=150*600)
6. Delivery
Tcode : VL01N
Up to Logistics same path
Sales and DistributionSalesOrderSubsequent FunctionsOut bound Delivery
Shipping point : LASH
Selection date : Sales order date (automatically come)
Order : 12124 (sales order)
Enter
Actual GI date : Todays date
Picking tab
Picked qty.
10
+91-9959765211 295
294.
SrinivasaKasireddy+91-9959765211
Post Goods Issuebutton
Note down the delivery document 80015213
Outbound Delivery menuDisplay
Outbound delivery : 80015213 (comes automatically)
Enter
Document flow button
Select GD goods issue
Display document button
Accounting Documents button
Dr Cost of Goods Sold 6000.00
Cr Inventory FG 6000.00-
7. Sales billing
Tcode: VF01
Same pathBilling Document
Select the Delivery document
Execute button
Goto menu ItemItem Conditions
Enter CnTy ‘MWST’ and Amount ‘5%’
CnTy Amount
MWST 5
Back button
Save
[Note down the billing document no)
Billing document menuDisplay
Billing document : xxxxxxxxxxxxx
Accounting button
Dr LAP SD Customer 7276.50
Cr Sales 7000.00-
Dr Discount 70.00
Cr VAT Payable 346.50
In case of error ‘Document xxxxxxxx saved (no accounting document generated)’ ,
+91-9959765211 296
295.
SrinivasaKasireddy+91-9959765211
for complete erroranalysis:
TCode: VF02
Billing document :
Billing document menu Release To Accounting
Double click on the error msg
8. Creating Cr Memo request
Tcode : VA01
SAPEasy AccessLogisticsSales and DistributionSalesOrderCreate
Order type : CR
Sales Organization : LASO
Distribution Channel : LD
Division : LS
Create with Reference button
Bill doc tab
Billing Document : XXXXXXXXXXX
Copy button
Item overview tab
Billing block : Check credit memo
Target quantity
2
Sales tab
Billing block : Blank
Order reason : Damaged in transit
Billing Date : Today’s date
Edit menu Incompletion log
Save
9. Posting Cr Memo
Tcode : VF01
Document
Enter Cr memo request
Execute button
Save
Billing document menuDisplay
Billing document 90036292
+91-9959765211 297
296.
SrinivasaKasireddy+91-9959765211
Accounting button
Double clickon Accounting document
Entry should be :
Cr LAP SD Customer 1455.30-
Dr To Sales 1400.00
Cr Discount given 14.00-
Dr VAT Payable 69.30
10. Sales Return Order (RE)
Tcode : VA01
Order Type : RE
Create with Reference button
Order tab
Order : xxxxx
Copy button
Sales Tab :
Delivery block : Blank
Billing block : Blank
Order reason : Returns
Order Quantity
5
Select Item 10
Goto menu ItemConditions
Edit menuIncompletion log
Save
11. Return Delivery (VL02n)
Tcode : VA02
Order : XXXX
Enter
Sales document menuDeliver
Actual GI date : Todays date
Picking Tab
Deliv
.Qty
SLoc
5 LAP1
+91-9959765211 298
297.
SrinivasaKasireddy+91-9959765211
Post goods Recieptbutton
12. CR Memo with reference to Returns order
TCode : VF01
Select Return sales order Execute
Save
Billing document menuDisplay
Billing document : xxxxxxxxxxx
Accounting button
+91-9959765211 299
298.
SrinivasaKasireddy+91-9959765211
25. Financial StatementVersion:
1. Balance sheet and Profit and loss
account statement:
SPROFinancial Accounting General Ledger Accounting Business Transactions
ClosingDocumentDefine Financial Statement Versions
New entries
Fin.Stmt. version : LAP1
Name : FSV for LAP
Maint. Language : EN
Item keys auto : √
Chart of Accounts : LACA
Save
Create Request button
Short description : Financial statement version (LAP)
Enter
Continue
Fin.statement items button
Keep the curser on LAP1
Create Items button
Financial statement version (LAP):
Balance sheet
Profit and Loss account
Profit/ Loss carried to Balance sheet
Enter
Click on Liab+Equity
’Select’ button
Click on Assets
’Select’ button
Click on Balance sheet
Reassign button
Subordinate
Enter
Double click on ‘Liab+Equity’
+91-9959765211 300
299.
SrinivasaKasireddy+91-9959765211
Item: Change Texts
Item:
Liabilties
Enter
Doubleclick on ‘Assets’
Item
Assets
Enter
Keep the curser on Profit and Loss account
Create Items button
Profit and Loss account
Income
Expenditure
Enter
Save
Continue
Keep the curser on Liabilities
Create Items button
Liabilities
Reserve and surplus
Secured loans
Unsecured loans
Current liabilities
Enter
Keep the curser on Assets
Create Items button
Assets
Net fixed assets
Current assets
Misc expenditure (to the extent not written off)
Enter
Keep the curser on Income
+91-9959765211 301
300.
SrinivasaKasireddy+91-9959765211
Create items button
Income
Sales
OtherIncome
Enter
Keep the curser on Expenditure
Create items button
Expenditure
RM consumption
Manufacturing Expenses
Admin Cost
Personal Expenditure
Depreciation
Interest
Other Expenses
Enter
Double click on ‘Net result : profit’
Item
Surplus transfered from P&L Account
Enter
Click on ‘Surplus transfered from P&L Account’
Select button
Click on ‘Reserve and Surplus’ under Liabilities
Reassign button
Subordinate
Enter
Double click on ‘Net result: loss’
Item
Loss transfered from Profit and Loss account
Enter
Click on ‘Loss transfered from Profit and Loss account’
Select button
Click on ‘Misc expn (to the extent not written off)’
+91-9959765211
…
…
…
…
302
301.
SrinivasaKasireddy+91-9959765211
Reassign button
Subordinate
Enter
Save
Assignment ofaccounts:
Click on Secured loans Assign Accounts button
FromAccount To Account D C
100200 √ √
Enter
Click on Current liabilities Assign Accounts button
FromAccount To Account D C
100980 √ √
Enter
Click on Net Fixed assets
Assign Accounts button
From Account To Account D C
200901 200905 √ √
100701 100702 √ √
100704 100704 √ √
Enter
Click on Current Assets
Assign Accounts button
From account To account D C
200691 200692 √ √
200770 √ √
200790 √ √
Enter
Click on Sales
Assign Accounts button
From Account To account D C
300510 √ √
300515 √ √
Enter
Click on ‘Other Income ‘
+91-9959765211
…
…
…
…
303
302.
SrinivasaKasireddy+91-9959765211
Assign Accounts button
Enter
Clickon RM consumption
Assign Accounts button
From Account To account D C
400599(RM consumption) √ √
Enter
Keep the curser on Depreciation
Assign accounts button
From Account To account D C
400403 √ √
Enter
Keep the curser on Interest
Assign accounts button
From Account To account D C
400681 √ √
Enter
Keep curser on Personal Expenditure
Assign Accounts button
From account To account D C
400500 √ √
Click on ‘Profit/Loss carried to Balance sheet’
Assign Accounts button
From Account To account D C
100100 √ √
Enter
Save
+91-9959765211
From Account To account D C
300591(Inc /dec in stock) √ √
300690(Exchange Gain) √ √
304
303.
SrinivasaKasireddy+91-9959765211
Check button (todisplay whether all accounts assign or not)
√ Nonassigned Accounts
Enter
Double click on Liabilities
Start of Group : Liabilities
End of Group : Total liabilities
√ Display total
Enter
Double click on Assets.
Start of Group : Assets
End of Group : Total assets
√Display total
Enter
Double click on Profit and Loss accounts
Start of Group : Profit and Loss accounts
End of Group : Profit/Loss of the year
√ Display total
Enter
Double click on Income
Start of Group : Income
End of Group : Total Income
√ Display total
Enter
Double click on Expenditure
Start of Group : Expenditure
End of Group : Total Expenditure
√ Display total
Enter
Double click on Profit/Loss carried to Balance sheet
Start of Group : Surplus/Loss carried to Balances sheet
+91-9959765211 305
304.
SrinivasaKasireddy+91-9959765211
End of group: Surplus/Loss carried to Balance sheet
√ Display total
Enter
Double click on ‘P+L result’
Item
Surplus/Loss carried to Balance sheet
End of Group : Surplus/Loss carried to Balance sheet
Enter
Save
2. Creating Balance sheet/Profit and loss
statement
SAP Easy accessAccountingFinancial Accounting General LedgerInformation
SystemGeneral Ledger ReportsBalance Sheet/Profit and Loss Statement/Cash
Flow
GeneralActual/Actual ComparisonsBalance Sheet/Profit and Loss Statement.
Chart of accounts : LACA
Company code : LAP
Fiscal statement version LAP1
Reporting year 2012 (current year)
Reporting periods : 1 to 16
Comparison year : 2011 (Previous year)
Comparison periods : 1 to 16
Special evaluations tab
Balance sheet type : 1
Output control tab
Company code Summarization : 1
Business area Summarization : 2
Summary Report : Blank
Comparison type : 1
Scaling : 5/0 (Figures will be in Lacks)
Execute button
Back button
+91-9959765211 306
SrinivasaKasireddy+91-9959765211
26. Multiple Ledger
NewGL
Multiple ledgers
Doc splitting
Realtime Integration
Scenario :
Parent Company Subsidiary
Country US IN
Currency USD INR
Fiscal Year Jan-Dec April-March
Fiscal Year Variant K4 V3
Requirement : To see the consolidation for both the company codes in Jan-Dec format
Solution : For Indian company code, maintain an additional ledger which has fiscal
year
variant ‘K4’ and currency ‘USD’ .
Indian Subsidiary
Std
Ledger(0L)
Additional Ledger
(M1)
Currency INR USD
Fiscal Year April-March Jan-Dec
Fiscal Year Variant V3 K4
1. Settings
1. Activate New GL accounting:
SPRO Financial Accounting Financial Accounting Global SettingsActivate New
General Ledger Accounting
( This is one time setting)
√ New General Ledger Accounting Is Active
Save
2. Define Ledgers for General ledger Accounting:
SPROFinancial Accounting (New) Financial Accounting Global Settings (New)
LedgersLedgerDefine Ledgers for General Ledger Accounting
+91-9959765211 308
307.
SrinivasaKasireddy+91-9959765211
New Entries
Ld LedgerName Total Table Leading
M1 Non-leading
ledger for LAP
FAGLFLEXT _
Save
Continue
Enter
Msg: Ledger group M1 is created only with ledger M1
Info: When we create a new ledger a ledger group with same name is created And the
ledger is assigned to the same ledger group. But we can reassign the ledger to different
ledger group.
Ledger group M1 is created only with ledger M1
3. Define and Activate Non-Leading Ledger:
Same path
Ledger : M1
Enter
New Entries
CoCd FV Var.
LAP K4 LAPP
Save
No button
Continue
4. Define Ledger Group:
Same path
New Entries
Ledger Grp Description
X1 LAP ledger group
Save
Continue
Select Ledger Group ‘X1’
Double click on the ‘Ledger Assignment’ folder
New Entries
+91-9959765211 309
308.
SrinivasaKasireddy+91-9959765211
Ld Rep.Ledger
0L √
M1.
Save
Continue
5. Define Document Type for Entry view in a Ledger:
SPROFinancial Accounting (New) Financial Accounting Global Settings (New)
DocumentDocument TypesDefine Document Types for Entry View in a Ledger.
Ledger : m1
Enter
New Entries
Type Number range
DA 45
DR 45
DZ 45
KA 45
KZ 45
KR 45
SA 45
WE 45
RE 45
AB 45
WL 45
RV 45
WA 45
ML 4
Save
Continue
6. Define Documents Types for General Ledger View :-
Same path next line
Ledger : M1
Enter
New Entries
Type Number range
+91-9959765211 310
309.
SrinivasaKasireddy+91-9959765211
DA 63
DR 63
DZ63
KA 63
KZ 63
KR 63
SA 63
WL 63
WE 63
AB 63
WI 63
RV 63
WA 63
RE 63
ML 63
Save
Continue
7. Define Document Number Ranges for Entry View:-
Upto Document same path
Document Number Ranges Documents in Entry View Define Document Number
Ranges for Entry View.
Company code : LAP
Change Intervals button
Intervals button
No Year From number To number
45 2013 4500000000 4599999999
(Enter the current fiscal year according to Fiscal Year Variant ‘K4’ )
Enter
Intervals button
No Year From number To number
63 2013 6300000000 6399999999
Enter
Save
Continue
+91-9959765211 311
310.
SrinivasaKasireddy+91-9959765211
8. Define DocumentNumber Ranges for General Ledger
View:
Same path up to Document Number RagesDocuments in General Ledger View
Define
Document Number Ranges for General Ledger View
Company code : LAP
Change Intervals button
Interval button
No Year From number To number
45 2013 4500000000 4599999999
Enter
Intervals button
No Year From number To number
63 2013 6300000000 6399999999
Enter
Save
Continue
2. End User
1. Posting of transaction for all Ledgers:
Tcode : FB01L
SAP Easy access AccountingFinancial AccountingGeneral LedgerDocument
Entry Enter General Posting for Ledger Group
Document date: 21-01-2013 Type :SA Company code: LAP
Posting date : 21-01-2013 Currency: INR
Ledger Grp : Blank
(If ledger group is blank all ledgers are updated)
PstKy : 40 Account : 200791
Enter
Amount : 45000
Business area : LANZ
Text : Term Loan receipt
PstKy : 50 Account : 100200
Enter
Amount : *
+91-9959765211 312
311.
SrinivasaKasireddy+91-9959765211
Business Area: LANZ
Text: +
DocumentSimulate
DocumentSimulate General ledger
Make a note of Posting period
Ledger button
Ledger : M1
Enter
Make a note of Posting period
Back button
Post
2. Posting of transactions for a ledger group:
Same Tcode : FB01L
Document date: 21-01-2013 Type :SA Company code: LAP
Posting date : 21-01-2013 Currency: INR
Ledger Grp : 0L
( Only Ledger ‘0L’ are updated)
PstKy : 40 Account : 200691
Enter
Amount : 50000
Business area : LANZ
Text : Term loan receipt
PstKy : 50 Account : 100200
Enter
Amount : *
Business area : LANZ
Text : +
Document menu Simulate
Post
3. Display Ledger :
Tcode :FAGLB03
Same path up to General Ledger
AccountDisplay Balances (New)
+91-9959765211 313
312.
SrinivasaKasireddy+91-9959765211
Account Number :100200
Company code : LAP
Fiscal year : 2012
Ledger : 0L
Execute
Back button
Choose Ledger button
Ledger : M1
Enter
Fiscal year : 2013 (Enter current fiscal year according to FYV ‘K4’)
Execute
+91-9959765211 314
313.
SrinivasaKasireddy+91-9959765211
27. Document splitting
1.Active splitting & Passive splitting
Active splitting Passive splitting
User split one of the items(Dr item in the
below case) in the entry the other item (Eg
Cr item in the below case ) will be split by the
system
While clearing the below inv, Cash item will
be split into 2 based on the preceding
document ie Inv
Active Splitting
Purchase inv :
Scenario:
Entry View
Cr vendor 45000
Dr Inv RM 27000 LASZ
Dr Inv RM 18000 LANZ
GL View
Cr Sundry Creditors 45000 ?
Dr Inv RM 27000 LASZ
Dr Inv RM 18000 LANZ
The Cr item will split into 2 items like below
Cr Sundry Creditors 27000 LASZ
Cr Sundry Creditors 18000 LANZ
Dr Inv RM 27000 LASZ
Dr Inv RM 18000 LANZ
Passive splitting:
Clearing the inv:
Dr Sundry Creditors 27000 LASZ
Dr Sundry Creditors 18000 LANZ
Cr Cash ?
Dr Sundry Creditors 27000 LASZ
Dr Sundry Creditors 18000 LANZ
Cr Cash 27000 LASZ
Cr Cash 18000 LANZ
+91-9959765211 315
314.
SrinivasaKasireddy+91-9959765211
2. Settings
1. CreatingZero Balance clearing account
Tcode: FS00
Select GL account 100800 Expenses payable
Copy button
G/L Account : 100305
Enter
Description : Zerobalance clrng ac
Field status group : G067
Save
2. Activate Document splitting (Globally)
SPROFinancial Accounting (New)General Ledger Accounting (New)Business
TransactionsDocument SplittingActivate Document Splitting
√ Document Splitting
Save
Continue
3. Activate Document splitting per Company code
Tcode :SM30
Table/View : V_FAGL_SPLIT_ACT
Maintain button
Postion button
Company Code : LAP
Enter
Company Code Inactive
LAP ..
Save
Continue
4. Classify G/L Accounts for Document Splitting
Same path
Chart of Accounts : LACA
+91-9959765211 316
315.
SrinivasaKasireddy+91-9959765211
Enter
New Entries
Acct fromCat.
200691(Cash
account)
04000
100980(Sundry
crditors)
03000
200700 01000
Save
Continue
5. Define Zero-Balance Clearing Account
Same path
Select Account Key ‘000’
Double click on Accounts folder
Chart of Accts : LACA
Enter
New Entries
G/L Account
100305
Save
Continue
6. Define Document Splitting Characteristics for General
Ledger Accounting
Same path
Field Zero balance Partner field Mandatory Field
Business Area √ PARGB √
ProfitCenter √ PRCTR ..
Segment √ PSEGMENT ..
Save
Enter
Yes button
+91-9959765211 317
316.
SrinivasaKasireddy+91-9959765211
Continue
3. Enduser
1. PostingPur inv
Tcode: F-43
PstKy : 31 Account : LAPGNVNDR
Enter
Amount : 45000
Bus. Area : Blank
Text : pur inv
PstKy : 40 Account : 200700
Enter
Amount : 27000
Bus. Area : LANZ
Text : +
PstKy : 40 Account : 200700
Enter
Amount : 18000
Bus. Area : LASZ
Text : +
Document menuSimulate
Document menuSimulate General Ledger
Back button
Entry should be:
31 Cr Sundry Creditors 27000- LASZ
31 Cr Sundry Creditors 18000- LANZ
40 Dr Inv RM 27000 LASZ
40 Dr Inv RM 18000 LANZ
Post
+91-9959765211 318
317.
SrinivasaKasireddy+91-9959765211
2. Clearing theinv:
Tcode: F-53
Account : 200691 Business Area: Blank
Amount : 45000
Text Outgoing payment
Open item Selection
Account : LAPGNVNDR
Enter
Deselect other items if any except today’s
DocumentSimulate
DocumentSimulate General Ledger
Entry should be:
50 Cr Cash 27000- LASZ
50 Cr Cash 18000- LANZ
25 Dr Sundry Creditors 27000 LASZ
25 Dr Sundry Creditors 18000 LANZ
Back button
Post
+91-9959765211 319
318.
SrinivasaKasireddy+91-9959765211
28. Central Excise
CentralExcise is part of CIN ie Country India version
All manufacturing companies must maintain the following registers
RG 23A part I RM Qty.
RG 23A Part II RM Value.
RG 23C Part I Capital Goods Qty
RG 23C Part II Capital Goods Value
ER1 Excise Return
RG1 Finished goods register
PLA Personal Ledger Account
Calculation of Excise and LST(or CST if applicable)
S No RM Purchase
1 Base Value 1000
2 BED 10% on 1000
(Paid to vendors)
100
(Posted to RG23A a/c)
3 LST 5% on 1100
(Base+BED )
55
CapitalGoods Purchase
4 Base Value 500
5 BED 10% on 500
(Paid to vendors)
50
25 – posted to RG23C a/c
25- Posted to CENVAT on hold a/c
+91-9959765211 320
319.
SrinivasaKasireddy+91-9959765211
6 LST 5%on on 550 27.5
Sale of FG
7 Base Value 2000
8 BED 10% on Base value
(Collected from Customers)
200
9 LST 15 % on 2200 330
PLA deposit (Deposited in bank )
10 150
Utilisation of RG 23 and PLA deposit accounts :
Utilisation Balance
RG23A 75 25
RG23C 20 5
CENVAT onhold - 25
PLA 105 45
Total 200
MM Purchase Scenario Tax Procedure
SD Sales Scenario Pricing Procedure
1. FI Settings
1. Activate Country Version India for Specific Fiscal
Years:
SPROFinancialAccountingFinancialAccounting Global SettingsTax on Sales
/PurchasesBasic SettingsIndiaActivate Country Version India for specific Fiscal
Years
Position
Component : IND
Enter
Comp To Year Activ
IND 2999 √
Save
Create request button
Short Description : CENVAT customisation (LAP)
+91-9959765211 321
320.
SrinivasaKasireddy+91-9959765211
SaveContinue
2. Check andChange Settings for Tax Processing:
Up to Basic Settings same pathCheck and Change Settings for Tax Procesing
New Entries
Process : L1
Description : BED Recievable
Tax type : 2 Input tax
Posting indic. : 2
Save
Continue
Back button
Select Process : L1
Copy as button
Change Process to ‘L2’
Description : LST Recievable
Enter
Save
Select Process : L2
Copy as button
Change Process to ‘L3’
Change Description to ‘CST Recievable’
Change Posting indic to ‘3’
Enter
Save
Select Process : L1
Copy as button
Change Process to ‘L5’
Change Description to ‘LST Payable’
Change Posting indic to ‘2’
Enter
Save
Select Process : L1
Copy as button
Change Process to ‘L6’
Change Description to ‘CST Payable’
+91-9959765211 322
321.
SrinivasaKasireddy+91-9959765211
Change Postingindic to ‘2’
Enter
Save
3. Define Condition Types LAP1, LAP 2, LAP3:
Up to Basic Settings same pathCheck Calculation Procedure
Double Click on Define Condition Types
New Entries
Condit. type : LAP1
Description : BED Recievable
Access seq : JTAX
Cond. class : D
Calculat. type : A percentage
Cond.category: D (Tax)
Changes which can be made
√ Amount/percent
Save
Continue
Next entry button
Condit. type : LAP2
Description : LST Recievable
Access sequence : JST1
Cond. class : D
Calculat.type : A
Cond .category : D (Taxes)
Changes which can be made
√ Amount/percent
Save
Next Entry button
Condit. type : LAP3
Description : CST Paid
Access sequence : JST1
Cond. class : D
Calculat.type : A
Cond .category : D (Taxes)
Changes which can be made
+91-9959765211 323
322.
SrinivasaKasireddy+91-9959765211
√ Amount/percent
Save
4. DefineTax Procedure:
Same path
Check Calculation Procedure
Double click on Define Procedures
New Entries
Procedure Descript
TAXLAP LAP tax procedure
Save
Continue
Select Procedure TAXLAP
Double click on Control Data
New Entries
Step CTyp Description Fro To Req Statistics AccKey
100 BASB
110 LAP1 APBED 100 100 √ L1
120 - Base+BED 100 110 √
130 LAP2 APLST 120 120 √ L2
140 LAP3 APCST 120 120 √ L3
Save
5. Assign Country to Calculation Procedure :
Same path up to Basic SettingsAssign Country to Calculation Procedure
Position
Country : IN
Enter
Cty Proc.
IN TAXLAP
Save
Continue
+91-9959765211 324
323.
SrinivasaKasireddy+91-9959765211
6. Define TaxCodes for Sales and Purchases:
Same path upto Tax on Sales/purchases
CalculationDefine Tax Codes for Sales and Purchases
Country : IN
Enter
Tax Code : V0
Enter
Description : Dummy input tax code
Tax type : V
Check ID √
Continue
Save
Tax Code : V1
Enter
Description : 4 % LST
Tax type : V
Check ID √
Continue
Keep the cursor on BED recievable (Click)
Deactivate line button
Keep the cursor on CST paid (Click)
Deactivate line button
LST Recivable : 4
Save
Tax Code : V2
Enter
Description : 2 CST
Tax type : V
Check ID √
Continue
Keep the cursor on BED recievable (Click)
Deactivate line button
Keep the cursor on LST Recivable (Click)
Deactivate line button
CST paid : 2
Save
+91-9959765211 325
324.
SrinivasaKasireddy+91-9959765211
Tax Code :A0
Enter
Description : Dummy Output tax code
Tax type : A
Check ID √
Continue
Save
7. Creation of GL accounts:
RG 23A Copy from VAT receivable account
RG 23C
Cenvat on hold
PLA
Cenvat Clrng account Copy from VAT payable account
Cenvat Suspense account
Excise Duty payable
CST payable
RG23A :
Tcode : FS00
Select 200530 VAT Receivable
Copy button
G/L Account : 200511
Enter
Change the Description to ‘RG 23A’
Control Data tab
Tax category : < Input Tax Account
Save
RG 23C :
Select 200530 VAT Receivable
+91-9959765211 326
325.
SrinivasaKasireddy+91-9959765211
Copy button
G/L Account: 200512
Enter
Change the Description to ‘RG23C’
Save
CENVAT on hold:
Select 200530 VAT Receivable A/C
Copy button
G/L Account : 200513
Enter
Change the Description ‘CENVAT on hold’
Save
PLA:
Select 200530 VAT Receivable
Copy button
G/L Account : 200514
Enter
Change the Description to ‘PLA’
Control Data Tab;
Tax Category : blank
Open Item management
Save
CENVAT Clrng account:
Select 100530 VAT Payable
Copy Button
G/L Account : 100612
Enter
Change the description ‘CENVAT clrng ‘
Control Data tab:
Change the Tax Category to ‘<’ Input tax account
Save
CENVAT Suspense A/C:
Select 100530
+91-9959765211 327
SrinivasaKasireddy+91-9959765211
Double Click onTransaction ‘L6’
Save
Posting key button
Debit : 40
Credit : 50
Save
Continue
Accounts button
Account
100615
(CST payble)
Save
9. Maintain Excise Registrations:
SPROLogistics-GeneralTax on Goods MovementsIndiaBasic
SettingsMaintain
Excise Registrations
New Entries
Excise Reg. : 9
ECC No. : LAPL ECC No.
Excise Reg. No. : LAPL Exc Reg. No.
Excise Range : Ameerpet
Excise Division : AMrpet
Commissionerate : Hyderabd commisionrate
EI Items : 999
√ Partial Credit
Save
Continue
10. Maintain Company Code Settings:
Same path next line
Double click on CoCd ‘LAP’
CENVAT Doc. Type : SA Utl FI Doc Typ : SA
√ Debit Acc Override
√ Aut adj ind
√ Imm. credit on Capital Goods
+91-9959765211 330
329.
SrinivasaKasireddy+91-9959765211
First Month :April
Exc sel Days : 30
No. Exclnv Sel : 999
EI sel. Proc. : FIFO
Save
Continue
11. Maintain Plant Settings:
Same path next line
New Entries
Plant Exc. Reg. GRs per EI
LAPL 009 Multiple Goods Receipt, Multiple Credits
Save
12. Maintain Excise Groups:
Same path next line
New Entries
Excise Group : 27 Plant : LAPL
Description : LAP Excise group
Excise Reg. : 009
No. GRs per EI : Multiple Goods Receipts, Multiple Credits
√ Default Challan qty in GR
Outgoing Excise Invoice
Excise Inv during Billing √ Create and Post Inv single step
MIGO Settings
√ EI Capture Post EI in MIGO √ Duty different at GR
√ Update RG 1 at MIGO
Save
Continue
13. Maintain Series Groups:
Same path next line
New Entries
Series Grp Series Des Exc. Reg.
036 Series Group for
LAP
009
Save
+91-9959765211 331
330.
SrinivasaKasireddy+91-9959765211
14. Maintain ExciseDuty Indicators:
Same path next line
New Entries
Exc. Ind +
0 Exempted
1 Taxable
Save
Continue
15. Select Tax Calculation Procedure:
Up to Basic Settings same path
Determination of Excise Duty Select Tax Calculation Procedure
Cty Proc.
IN TAXLAP
Save
Continue
16. Maintain Excise Defaults:
Up to Basic Settings same path
Determination of Excise DutyMaintain Excise Defaults
New Entries
Tax proc CVD cond A/P BED Cond A/R BED Cond BED Perc
TAXLAP JCV1 LAP1 LAPA LAP4
Save
Continue
17. Assign Tax Code to Company Codes
Same path Up to Determination of Excise Duty
Condition-Based Excise Determination Assign Tax Code to Company Codes
New Entries button
Company Code Tax Code
LAP VO
LAP V1
+91-9959765211 332
331.
SrinivasaKasireddy+91-9959765211
LAP V2
18. ActivatingCIN button in Vendor master screen
Up to India same path
Master Data Assign Users to Material Master Screen Sequence for Excise Duty
Double Click on User screen reference
New Entries
Name SRef:user
SAPUSER IN
Save
Continue
19. Specify G/L Accounts per Excise Transaction:
Same path up to India
Account DeterminationSpecify G/L Accounts per Excise Transactions
New Entries
Excise
Gp
ETT CoCd ChAc RG 3A
BED
RG23CBED ModClearing GL A/C
for PLA
BED
CENVAT
OH
CENVAT
sse
PLA
OnHld
27 GRPO LAP LACA 200511 200512 100612 200514 200513 100613
27 DLFC LAP LACA 100614 100614 100612 200514 200513 100613
27 EWPO LAP LACA 200610 200611 100612 200514 200513 100613
27 TR6C LAP LACA 200514
Enter
Save
20. Utilization Determination:
Same path up to India
Business TransactionsUtilizationUtilization Determination
New Entries
Excise gp ACC name BED perc +
27 PLA BED 50
27 RG23A BED 40
27 RG23C BED 10
Save
+91-9959765211 333
332.
SrinivasaKasireddy+91-9959765211
Continue
21. Maintain MinimumBalances for Excise accounts:
Same path Next line
New Entries
Excise Gp Account name Amount
27 PLA BED 1000
27 RG23A BED 1000
Save
Continue
22. Assign Billing Types to Delivery Types:
Up to India same path
Business transactions Outgoing Excise InvoicesAssign Billing Types to Delivery
Types
New Entries
DlvTy BillT
LF F2
LF F1
JF JEX
Save
Continue
23. Specify SAP Script Forms
Up to Business Transaction same path
Excise registersSpecify SAP Script Forms.
Select 10 entries with company code ‘IN01’
Copy as button
Change company code to LAP
Enter (10 times)
Save
Continue
24. Maintain No. Ranges for objects:
Same path up to India
+91-9959765211 334
333.
SrinivasaKasireddy+91-9959765211
ToolsNumber Ranges
Object :J_1IINTNUM
Number ranges Button
Change Interval Button
Interval Button
No. Year From number To Number
01 2012 0100000000 0199999999
Enter
Save
Continue
Back button 3 times
Object : J_1IRG23A1
Number ranges button
Excise Group : 27
Change Interval button
Interval Button
No. Year From number To Number
01 2012 0200000000 0299999999
Enter
Save
Continue
Back button 2 times
Object : J_1IRG23A2
Number ranges button
Excise Group : 27
Change Interval button
Interval Button
No. Year From number To Number
01 2012 0300000000 0399999999
Enter
Save
Back button 2 times
Object : J_1IEXCLOC
Number ranges button
+91-9959765211 335
334.
SrinivasaKasireddy+91-9959765211
Series Group :009
Change Interval button
Interval Button
No. Year From number To Number
01 2012 0400000000 0499999999
Enter
Save
Back button 2 times
Object : J_1IINTPR2
Number ranges button
Excise Group : 27
Change Interval button
Interval Button
No. Year From number To Number
01 2012 0500000000 0599999999
Enter
Save
25. Assign Tax codes for Non Taxable transactions
SPROFinancial Accounting Financial Accounting Global SettingsTax on Sales
/Purchases PostingAssign Tax codes for Non-Taxable Transactions
Position
Company Code : LAP
Enter
CoCd Input Tax Output Tax
LAP V0 A0
Save
26. Excise rates Maintenance
Tcode: J1ILN (India Localization menu) There is no path for this screen
Indirect taxesMaster dataExcise rate maintenance
Tcode: J1ID
Chapter-Id
Maintain button
New Entries
Chapter ID : 90000001
+91-9959765211 336
335.
SrinivasaKasireddy+91-9959765211
UOM Excise :KG
Desc as per Law : Steel
Save
Create Request button
Short Description : Excise rate Maintenance
Enter
Continue
Next Entry button
Chapter ID : 90000002
UOM Excise : EA
Desc as per Law : FG
Save
Back button
Material & Chapter-Id combination
Maintain button
New Entries
Material Plant Chap ID Mat type GR-xref Declared Decl.date
LAPRM LAPL 90000001 Rawmaterial Multiple goods recipt/
Multiple inv
X 1.4.2011
LAPFG LAPL 90000002 RG1 Multiple goods recipt/
Multiple inv
X 1.4.2011
Save
Back button
CENVAT Determination
Maintain button
New Entries
Plant Input Mat Output
Mat
X Int.date
LAPL LAPRM LAPFG 1.4.2011
Save
Back button
Vendor Excise details
Maintain button
+91-9959765211 337
336.
SrinivasaKasireddy+91-9959765211
New Entries
Vendor Permanentaccount number Exc Ind Vendor Type of Vendor
LAPRMVNDR 1 Manufacturer
Save
Back button
Customer Excise details
Maintain button
New Entries
Customer Permanent account number Exc.Ind .Cust
LAPSDUST 1
Save
Back button
Excise Indicator for Plant
Maintain button
New Entries
CoCd Plnt First Mnth Exc. Ind. Comp
LAP LAPL April 1
Save
Back button
Excise Indicator for Plant and Vendor
Maintain button
New Entries
Exc Ind Co Exc. Ind Ve ExcInd
1 1 1
Save
Back button
Excise Indicator for Plant and Customer
+91-9959765211 338
337.
SrinivasaKasireddy+91-9959765211
Maintain button
New Entries
Exc.Ind.Co Exc. Ind.Cu ExcInd
1 1 1
Save
Back button
27. Creation of Condition Records
Tcode : FV11(There is no path for this screen)
Condition type LAP1
Key combination button
Country/Plant/Ctrl code
Enter
Country : IN
Plant : LAPL
Control code Amount Unit Valid From Valid to Tax Code
90000001 10 INR 1.04.2011 31.03.2012 VO
Save
Info : Control code is nothing but Chapter ID
Back button
Condition type : LAP2
Key combination button
Country/ Region/Plnt Region
Enter
Country : IN
Region: 01
Plant Region Amount Valid From Valid to Tax code
01 5 1.04.2012 31.03.2013 V0
Save
+91-9959765211
…
…
…
…
339
338.
SrinivasaKasireddy+91-9959765211
2. SD Settings
1.Define Condition type:
SPROSales and DistributionBasic FunctionsPricingPricing ControlDefine
Condition Type
Double click on Maintain Condition Types
New Entries
Condit. Type : LAP4
Description : BED Payable
Access seq : JEXC
Cond. Class : D Plus/minus : Blank
Calculat type : A (%)
Cond . category : D
Save
Continue
Back button
Select condition type LAP 4
Copy as button
Change condition type to LAP5
Change the Description to ‘VAT Payable’
Access seq : JLST
Enter
Save
Back button
Select condition type LAP5
Copy as button
Change Condition type to LAP6
Change the Description to ‘CST Payable’
Access seq : JCST
Enter
Save
Back button
Select condition type LAP5
Copy as button
Change Condition type to LAPA
Change the Description to ‘Copy AR BED’
+91-9959765211 340
339.
SrinivasaKasireddy+91-9959765211
Access seq :JDUM
Enter
Save
2. Define & Assign Account keys: L4,
Up to Basic Functions same path
Account Assignment/CostingRevenue Account Determination Define and assign
account keys
Double click on Define Accounts Key
New Entries
ActKy Name
L4 BED Payable
Save
Continue
Back button
Select ActKy ‘K4’
Copy as button
Change ActKy to ‘K5’ and Name to ‘VAT Payble’
Enter
Save
Back button
Select ActKy ‘K4’
Copy as button
Change ActKy to ‘K6’ and Name to ‘CST Payble’
Enter
Save
3. Maintain Pricing Procedure:
SPRO Sales and Distribution Basic FunctionsPricingPricing ControlDefine
and
Assign Pricing Procedures.
Double click on Maintain pricing procedures
New Entries
+91-9959765211 341
340.
SrinivasaKasireddy+91-9959765211
Procedure Descript.
LAPPP LAPPricing Procedure
Save
Continue.
Select Pricing procedure ‘LAPPP’
Double click on Control data
New Entries
Step CTyp Description Fro To Required Statistical AccKey
100 PR00 Price √ ERL
110 LAP4 BED Payable 100 100 √ L4
120 LAPA Copy AR BED 110 110 √ √
130 Price+BED 100 110 √
140 LAP5 VAT Payable 120 120 √ L5
150 LAP6 CST Payable 120 120 L6
Save
Continue
4. Define Pricing Procedure Determination:
Upto Pricing control same path
Define and Assign Pricing Procedure
Double click on Define Pricing Procedure Determination
Position
Sales Org. : LASO
Enter
SOrg DChl Dv Dopr CuPP PriPr CTyp
LASO LD LS A 1 LAPPP PR00
Save
Continue
5. Define tax determination Rules:-
SPRO Sales and Distribution Basic FunctionsTaxesDefine Tax Determination
Rules
+91-9959765211 342
341.
SrinivasaKasireddy+91-9959765211
New Entries
Tax count.Seq Tax categ.
IN 1 LAP4
IN 2 LAP5
IN 3 LAP6
Save
Continue
6. Define Tax Relevancy of Master Records:-
Same path
Double click on Customer Taxes
New entries
Tax categ Name Tax class Description
LAP4 BED Payable 0 No Tax
LAP4 BED Payable 1 Taxable
LAP5 VAT Payable 0 No Tax
LAP5 VAT Payable 1 Taxable
LAP6 CST Payable 0 No Tax
LAP6 CST Payable 1 Taxable
Save
Continue
Back button
Double click on Material Taxes
Tax categ Name Tax class Description
LAP4 BED Payable 0 No Tax
LAP4 BED Payable 1 Taxable
LAP5 VAT Payable 0 No Tax
LAP5 VAT Payable 1 Taxable
LAP6 CST Payable 0 No Tax
LAP6 CST Payable 1 Taxable
Save
+91-9959765211 343
342.
SrinivasaKasireddy+91-9959765211
7. Assign DeliveringPlants for Tax Determination:
Same path
Position
Plant : LAPL
Enter
Select Plant ‘LAPL’
Address button
Region: 01
Save
Continue
8. Assignment of accounts for automatic posting:-
Upto Basic Functions same path
Account Assignment/CostingRevenue Account DeterminationAssign G/L Accounts
Double click on Table 1 ie Cust.Grp/MaterialGrp/AcctKey.
New Entries
App CondTy ChAc SOrg AAG AAG Act Key G/L Account
V KOFI LACA LASO 03 01 ERL 300510
V KOFI LACA LASO 03 01 L4 100613
(CENVAT Suspense)
V KOFI LACA LASO 03 01 L5 100530 VAT Payable
V KOFI LACA LASO 03 01 L6 100615 CST Payable
Save
Continue
3. SD End-user
1. Assign tax classification in Material master
T code: MM02
Material : LAPFG
Select Views button
Select Sales: sales org data 1
Organization levels button
Plant : LAPL
Sales Org : LASO
+91-9959765211 344
343.
SrinivasaKasireddy+91-9959765211
Distribution channel :LD
Enter
Tax Data
Country Tax category Tax Classification
IN LAP4 1
IN LAP5 1
IN LAP6 1
Save
2. Assign tax classification on Customer master.
T code: XD02
Customer : LAPSDCUST
Company code : LAP
Customer Sales Organization button
Double click on sales organization ‘LASO’
Enter
Sales Area Data button
Billing Document tab
Tax category Tax classification
UTXJ 0
LAP4 1
LAP5 1
LAP6 0
Save
3. Creation of Condition records for LAP4,5,6 and LAPA
Tcode: VK11
Condition Type: LAP4
Enter
Material
Enter
Material Amount Valid from Valid to Tax code
LAPFG 10 01-042012 31-03-2013 A0
Save
+91-9959765211 345
344.
SrinivasaKasireddy+91-9959765211
Back button
Condition Type: LAP5
County /Region/Plant/Material
Enter
County: IN
Plant : KAPL
Region: 01
Material Amount Valid from Valid To Tax code
LAPFG 14 01-04-2012 31-3-
2013
A0
Back button
Condition Type : LAP6
Enter
County/region/plant/material
County: IN
Plant : kapl
Region: 01
Material Amount Valid from Valid To Tax code
LAPFG 2 01-04-2012 31-3-
2013
A0
Save
Condition Type : LAPA
Enter
Sales org
Sales Org Amount Valid from Valid To Tax code
LASO 100 01-04-2012 31-3-
2013
A0
Save
4. MM Enduser
+91-9959765211 346
345.
SrinivasaKasireddy+91-9959765211
1. Creating PurchaseOrder
T Code :ME21N
Purchasing entry Vendor: LAPRMVNDR
Enter
Org.Data tab
Purchase organization : LAP0
Purhasing Group : LPG
Company code : LAP
Payment tab
Payment terms : 0001
Inco terms : EXW
Item Material PO Quantity Deliv date Net price currency Plant
10 LAPRM 50 19.01.2013 200 INR LAPL
Enter
Invoice Tab
√ GR-Bsd IV
Tax code: V1 4% Purchase tax
Enter
Back Button
Check Button
Save
2. Open Material period for the current per:
3. Goods Receipt
Tcode : MIGO
Purchase Order : 4500017102
Quantity tab
Quantity in delivery note: 50
Where Tab
Storage location : LAP1
Text : GR
√ Item OK
Enter
Excise invoice Tab
Only capture excise invoice
Excise Invoice : 999
+91-9959765211 347
346.
SrinivasaKasireddy+91-9959765211
Excise Invoice date: 20-01-2013
Enter
BED should be 500
Post
4. Excise Invoice creation:
T code : J1ILN
Indirect taxesProcurementExcise InvoiceIncoming Excise Invoice Central
ProcessingCapture/Change//Cancel/ Display/ Post
Tcode : J1IEX
Post Vender excise invoice 999
Enter
Part 1 Tab
Double click on Mat doc Number
Accounting Documents button
Back button twice
Post
Entry should be:
Dr Inventory RM 5045
Cr GR/INR 5000-
Cr Freight Clrng 45-
5. Display Excise invoice:
T code : J1IEX
Display Vendor Invoice 999
Enter
Part 2 tab
Double click on Accounting Document
Entry should be:
Dr RG23A 500
Cr Cenvat Clrng 500-
+91-9959765211 348
347.
SrinivasaKasireddy+91-9959765211
6. Invoice Verification
Tcode:MIRO
Invoice date : 20-01-2013
Text : inv verification
√ Calculate tax
Tax Code : V1
P O reference tab:
Purchase Order/scheduling agreement 4500017106 Goods/Service items
+ Planned Delivery Cost
Select √ Booking OK for item 1 & 2
Enter
PaymentTab
Base line date : 20-01-2013
Payment terms : 0001
Tax Code for Freight : V0
Copy the value from Balance field
Post in the Amount field with out –ve sign
Enter
(Balance will be Zero and green color)
7. Print Excise Register:
Indirect taxesRegistersExcise taxExtract
Tcode :J2I5
Excise group : 18
Start date : 01-01-2013(Begin of the month)
End date : 20-01-2013 (Today’s date)
Select any register
√ RG23A Part 1
√ RG23A Part 2
Execute
Back button
Same path
Print Utility Program Tcode : J2I6
RG23A PART 1
Execute
Excise group : 18
Start date : 01-01-2013
+91-9959765211 349
348.
SrinivasaKasireddy+91-9959765211
End date :20-01-2013
Output Device : LP01
Print privew
Back button
RG23A PART 2
Execute
Excise group : 18
Start date : 01-01-2013
End date : 20-01-2013
Output Device : LP01
Print privew
8. Display Sales register:
Tcode :
Same path up to Registers
Sales taxSales Tax Register.
Company code : LAP
Fiscal year : 2013
LST condition type : LAP1
Execute.
5. SD Excise
1. Creation of sales order:
T code :VAO1
Order type : OR
Sales Organization : LASO
Distribution Channel : LD
Division : LS
Enter
Sold-to party : LAPSDCUST
PO Number : 990 PO date : 20-01-2013
Req. deliv.date : 20-01-2013 Deliver. plant NAPL
√ Complete dlv.
Payment terms : 0001 Incoterms : EXW
+91-9959765211 350
349.
SrinivasaKasireddy+91-9959765211
Item Material OrderQuantity Plnt Amount Crcy
10 LAPFG 30 LAPL 1000 INR
Edit menuIncompletion Log
Save
2. Delivery:
Tcode : VL01N
Shipping Point : LASH
Selection date : 20-01-2013
Order : 11774
Enter
Actual GI date : 20-01-2013
Picking Tab
Picked quantity
30
Post Goods Issue Button
Note down documents No 80014997
3. Billing:
Tcode : VF01
Select the delivery Document
Execute
Save
4. Excise Invoice Creation:
Tcode : J1ILN
Indirect Taxes sales/Outbond Movements Excise Invoice For Sales
OrderOutgoing Excise invoice create/change/display
`From Billing’ button
Billing document : 90036109
Posting date : 20-01-2013
Enter
Excise group : 18
Series Group : 27
+91-9959765211 351
350.
SrinivasaKasireddy+91-9959765211
Preprint Excise No: 810
Balances button
Utilization Button
Enter the Ignore warning message.
Save
Msg :Excise Invoice xxxxxxxxx generated ; Modvat database updated
5. Billing Display:
Tcode:VF03
Billing document : 90036109
Accounting button
6. FI End User
1. PLA Deposit:
Tcode: F-02
Document date : 20-01-2013
Posting date : 20-01-2013
PstKy : 40 Account : 200514
Enter
Amount : 50000
Business area : LANZ
Text : PLA Deposit
PstKy : 50 Account : 200691
Enter
Amount : *
Business Area: LANZ
Text : +
DocumentSimulatePost
2. Entry of TR6 Challan:
Tcode : J1IH
Indirect taxes Excise JV Create
TR6 Challan
Document Number : 1000000000
Document year : 2012
Company code : LAP
+91-9959765211 352
351.
SrinivasaKasireddy+91-9959765211
Plant : LAPL
ExciseGroup : 27
Enter
Cr/Dr GL account Amount
C 000200514 50000
D 000200514 50000
Save
3. Excise duty payment:
Tcode : J2IUN
Indirect taxes Sales/Outbound Movements Fortnightly Payment
Company code : LAP
Excise group : 27
Period : 1-1-2013 to 20-01-2013
Fortnightly pymt posting date : 20-01-2013
Pay Cenvat from Ser tax Cr
Execute
Payable amount ARBED
A/C Name Available balance Utilized
PLA 50000
RG23A BED 500
Keep the curser on Payable amount
Select duty button
PLA Utilization: 600
RG 23A BED Utilization :
Post
4. Display Document (FB03)
+91-9959765211 353
SrinivasaKasireddy+91-9959765211
29. Data Uploading
Afterthe entire configuration is transported to Production client, before start entering
the current business data, we need to upload the data from existing system to new
SAP system.
Data uploading
Master data uploading
Eg :Customer masters
GL masters
Vendor masters
Material masters
Balances Uploading
Eg: GL balances
Customer Open items
Vendor Open items
First we upload the master data then we upload balances
+91-9959765211 355
354.
SrinivasaKasireddy+91-9959765211
Master Data upload
Thereare 2 options to upload master data
BDC Program
(Batch Data Communication)
LSMW
(Legacy System Migration Workbench)
ABAP programmers develop customized
programs which can upload the master data
LSMW is a tool that can be used by
Functional Consultants to upload the
master data.
We are using LSMW to upload G/L master. The following are the steps involved.
1. Downloading the data to a text file
Live Lab
In live scenario text file is generated from existing
system
In lab scenario text file is created
manually
Here we are creating text file manually. The text file consists of 4 lines . Each line
represents one G/L account.
Open a new Notepad file
Enter 4 lines as shown in the following image
File menuSave
File Name : GL master_LAP
Save
GLmaster_LAP.TXT
2. Creating Structure file
Open a new MSWord file.
Create a table with 4 columns Field name , Type , Length and Description
Tcode : FS00
Keep the cursor in GL Account field
F1 button
+91-9959765211 356
355.
SrinivasaKasireddy+91-9959765211
Technical Information button
Doubleclick on the Field name ‘SAKNR’
Note down the Length
Enter SAKNR under Field name in MS Word
Enter ‘10’ under Length column
Enter ‘G/L account‘ under Description
Back to FS00
Keep the cursor in Company Code Field
F1 button
Technical Information button
Double click on the Field name ‘BUKRS’
Note down the Length
Enter BUKRS under Field name in MSWord
Enter ‘4’ under Length column
Enter ‘Company code‘ under Description
Back to FS00
Repeat the same process for all fields which are there in the notepad file in the same
order.
Finally the MS Word file looks like the following image
+91-9959765211 357
SrinivasaKasireddy+91-9959765211
Continue button (orF8)
‘ Double click = Display ’ button
Maintain Object Attributes
Execute button
Batch Input Recording
Recordings : Overview button
Create recording button
Recording : GLLAP
Description : GL creation
Enter
Transaction code : FS00
Enter
GL Account : 400----
Company Code : LAP
Create button
Account Group : Expenses
P & L statement Acct
P&L statmt acct type : X
Short Text : Sample GL
Long Text : Sample GL
Control Data Tab:
√ Line item display
Sort key : 001
Create /Bank/Interest Tab:
Field status group : G001
Save
Keep the cursor on FS00
Default All button
Save
Back button twice
Recording : GLLAP
Save
Back button
Maintain Source Structures
Execute
Create a structure button
+91-9959765211 359
358.
SrinivasaKasireddy+91-9959765211
Source Structure :GLsourcestructure
Description : GL_Sourcestructure
Enter
Save
Back button
Maintain Source Fields
Execute
Keep the cursor on GLsourcestructure
Table Maintenance button
Copy the Field name column from MSWord file and paste into Field name column
Copy the Length column from MSWord file and paste into Length column
Enter ‘C’ in Type for all Fields
Copy the Field Description column from MSWord file and paste into Field Description
column
Save
Back button
Save
Back button
Maintain Structure Relations
Execute
Save
Back button
Maintain Field Mapping and Conversion Rules
Execute
Extras menu Auto-Field Mapping
Enter
Keep on pressing Accept Proposal button until ‘Auto field mapping is complete’
Save
Back button
Skip Maintain Fixed values, Translations, User Defined Routines
Specify Files
+91-9959765211 360
359.
SrinivasaKasireddy+91-9959765211
Execute
Double click on‘On the PC (Front end)’
File Name : GL master_LAP with complete directory
Name : G/L master_LAP
Delimiter
Other @
Enter
Save
Back button
Assign Files
Execute
Save
Back button
Read Data
Execute
Transaction Number : 1 to 4
Execute
Back button twice
Display Read Data
Execute
From Line : 1
To Line : 4
Execute
Back button
Convert Data
Execute
Transaction Number : 1 to 4
Execute
Back button twice
(Skip Display Converted Data button)
Create Batch Input Session
Execute
+91-9959765211 361
Srinivasa Kasireddy isa senior SAP consultant with a Singapore
based IT consulting company. Have nearly 10 years of experience
in FICO as well as ABAP programming. Handled different kinds
of projects like end- to- end implementations Rollouts and Up
gradations. Supported number of multinational clients on existing
projects.
Experienced in delivering ERP solutions for Airlines, Banking, Power
Generation and Manufacturing industries.
He is a professional trainer and visiting faculty in the area of SAP FICO and has trained
more than 100 batches.
For any training enquiries :
Please call 91-9959765211
Mail to srinivas3d@yahoo.com