Accounts payables:
This component will deal with vendors, Terms and conditions, Invoices, outgoing payments, Advance to vendors, Etc. Vendors are subsidiary ledgers. AP component integrates with General ledger component.
1. Define Account Groups
Definition: It controls fields in master record and number range intervals.
Path: SPRO- Financial Accounting(New)- Accounts Receivable and Accounts Payable- Vendor Accounts- Master Data- Preparations for Creating Vendor Master Data- Define Account Groups with Screen Layout (Vendors) (Tcode:OBD3)
Execute
Click on New Entries (F5)
Account Group :
Name : Dom.Vendors
Save and enter
Create Number Ranges for Vendor Accounts
Path: Same path (Tcode: XKN1)
Execute
Click on Change interval
Click on Insert interval (shift+S)
No :
From Number :
To Number :
Enter
Save and enter
Assign Number Ranges to Vendor Account Groups
Path: same path (Tcode: OBAS)
Execute
Go to Position button
Account group :
Enter
Number range :
Save and enter
Define Tolerances (Vendors)
Path: SPRO- Financial Accounting(New)- Accounts Receivable and Accounts Payable- Business Transactions- Outgoing Payments- Manual Outgoing Payments- Define Tolerances (Vendors) (Tcode:OBA3)
Execute
Click on New Entries (F5)
Company code :
Save and enter
Maintain Number ranges 19, 15, 17 for KR, KZ, KA document types respectively (KR: Vendor Invoice, KZ: Vendor payment, KA: Vendor Document)
Path: SPRO- SAP Reference IMG- Financial Accounting (New)- Financial Accounting Global Settings (New) - Document- Document Number Ranges- Documents in Entry View- Define Document Number Ranges for Entry View (Tcode:FBN1)
Execute
Company Code :
Click on change interval
Click on Insert interval (Shift+F1)
No : 19
Year : 2009
From number : 1900000000
To Number : 1999999999
Enter
Click on Insert interval (Shift+F1)
No : 15
Year : 2009
From number : 1500000000
To Number : 1599999999
Enter
Click on Insert interval (Shift+F1)
No : 17
Year : 2009
From number : 1700000000
To Number : 1799999999
Enter
Save and enter
Create Vendor Reconciliation Account (Tcode: FS00)
G/L Account : 190100
Company Code :
Click on create
Go to Type/Description Tab
Account Group : LIAB Liabilities
Select Balance sheet Account
Short Text : Dom.Vendors A/C
G/L Acct Long Text : Domestic Vendors Account
Go to Control data Tab
Recon.account for Acct type : K Vendors
Select Line item display
Sort Key : 012 (Vendor Number)
Go to Create/Bank/Interest tab
Field Status Group : G067
Save
Create Vendor Master Record
Path: Accounting - Financial Accounting - Accounts Payable - Master Records - FK01 - Create (Tcode: FK01)
Company Code :
Account Group :
Enter
Title : Company
Name : OMC
Search Term : Hyderabad
Street :
House number :
Postal code : 500020
City : Hyderabad
Country : IN
Enter, enter and enter
Recon.account :190100
Sort Key : 012
Cash mgmnt group : A1
Enter
Payt terms : 0001 (Immediately)
Save
Create Service G/L Master Record (Tcode: FS00)
G/L Account : 400100
Company Code :
Click on create
Go to Type/Descripition Tab
Account Group : EXPN Expense
Select P&L Statement acct
Short Text : Service A/C
G/L Acct Long Text : Service Account
Go to Control Data Tab
Select only balances in local crcy
Select Line item display
Sort Key : 001
Go to Create/bank/interest Tab
Field status group : G001
Save
Enter Vendor Invoice
Path: Accounting - Financial Accounting - Accounts Payable - Document Entry - F-43 - Invoice - General (Tcode: F-43)
Enter header data (Type KR)
PstKy : 31 (Credit)
Account : __________ (Vendor Number)
Enter
Amount : 25000
Business Area :
PstKy : 40 (Debit)
Account : 400100 (Service G/L)
Enter
Amount :*
Click on More
Business Area :
Enter
Go to menu bar
Document - simulate
Save
Vendor Line item report
Path: Accounting - Financial Accounting - Accounts Payable - Account - FBL1N - Display/Change Line Items (Tcode: FBL1N)
Vendor Account :
Company Code :
Select open items
Execute (F8)
Outgoing payments
Path: Accounting - Financial Accounting - Accounts Payable - Document Entry - Outgoing Payment - F-53 - Post (Tcode: F-53)
Enter Header Data (Type KZ)
Account : 290100 (Bank A/C)
Amount : 25000
Account :__________ (Vendor Number)
Enter
Note: Select Invoice amount against which invoice we are paying, Deselect Remaining invoices. Select means Blue color and Deselect means block color.
Note: Amount entered and Assigned amount should be same
See Report (Tcode: FBL1N)
Partial payments (Tcode: F-53)
Enter header data (Type KZ)
Account 290100 (Bank A/C)
Amount 10000
Account : _________ (Vendor Number)
Enter
Go to Partial pmt Tab
Payment amount : 10000
Save
See Report (Tcode: FBL1N)
Residual items (Tcode:F-53)
Definition: In Residual items, system will re determine terms of payments.
Enter header data (Type KZ)
Account : 290100
Amount : 5000
Account :
Enter
Go to Res.items Tab
Residual items : 30000-
Enter
Go to Menu bar
Document - simulate
Double click on blue color line item
Text : Being Residual items
Payment terms : 0002
One time go back
Save
See Report (Tcode: FBL1N)
Automation of Bank Charges and Cash discount
Creation of Bank Charges G/L Account (Tcode: FS00)
G/L Account : 400020
Company Code :
Click on create
Go to Type/Description Tab
Account Group : EXPN Expenses
Select P&L statement acct
Short Text : Bank Charges A/C
G/L Acct Long Text : Bank Charges Account
Go to Control data Tab
Select only balances in local crcy
Select Line item display
Sort Key : 001
Go to Create/bank/Interest Tab
Field status group : G001
Save
15. Creation of Cash Discount Taken G/L Account (Tcode: FS00)
G/L Account : 300010
Company Code :
Click on create
Go to Type/Description Tab
Account Group : INCO Incomes
Select P&L statement acct
Short Text : Cash Dis.Taken A/C
G/L Acct Long Text : Cash Discount Taken Account
Go to Control data Tab
Select only balances in local crcy
Select Line item display
Sort Key : 001
Go to Create/bank/Interest Tab
Field status group : G001
Save
Creation Accounts for Cash Discount Taken
Path: SPRO- SAP Reference IMG- Financial Accounting (New)- Accounts Receivable and Accounts Payable- Business Transactions- Outgoing Payments- Outgoing Payments Global Settings- Define Accounts for Cash Discount Taken
(Tcode: OBXU)
Execute
Chart of Accounts :
Enter
Save
Account : 300010
Save and enter
Define Accounts for Bank Charges (Vendors)
Path: Same path (Tcode: OBXK)
Execute
Double click on Bank Charges BSP
Chart of Accounts :
Enter
Account : 400020
Save and enter
Outgoing payment to vendor with bank charges and cash discount (Tcode: F-53)
Enter header data (Type KZ)
Account : 290100
Amount :
Business Area :
Bank charges :
Account : ______________ (Vendor A/c)
Enter
Cash Discnt :
Go to Menu bar
Document - Simulate
Save
Down payments (Advance To vendors)
Create Advance to Vendor G/L Account (Tcode: FS00)
G/L Account : 290200
Company Code :
Click on create
Go to Type/Description Tab
Account Group : ASST Assets
Select Balance Sheet Account
Short Text : Adv. to Vendors A/C
G/L Acct Long Text : Advance to Vendors Account
Go to Control Data Tab
Recon. account for acct type : K Vendors
Select Line item Display
Sort Key : 012
Go to Create/Bank/Interest Tab
Field Status Group : G067
Save
Assign Adv. to Vendor Account
Path: SPRO- SAP Reference IMG- Financial Accounting (New)- Accounts Receivable and Accounts Payable- Business Transactions- Down Payment Made- Define Alternative Reconciliation Account for Down Payments (Tcode: OBYR)
Execute
Double click on
K A Dwn pmt Down payment on current assets
Chart of Accounts :
Enter
Recon.acct : 190100
Special G/L Account : 290200
Save and enter
Scenario 1
Advance to Vendor :Rs 100000
Service :Rs 100000
Advance to Vendor
Path: Accounting - Financial Accounting - Accounts Payable - Document Entry - Down Payment - F-48 - Down Payment (Tcode:F-48)
Enter header data (Type KZ)
Account :
Special G/L Ind. : A
Account : 290100
Amount : 100000
Enter
Amount :*
Go to Menu bar
Document - simulate
Save
See Report (Tcode: FBL1N)
Service Invoice (Tcode: F-43)
Enter Header data (Type KR)
PstKy : 31
Account :
Enter
Amount : 100000
PstKy : 40
Account : 400100
Enter
Amount :*
Go to Menu bar
Document - simulate
Save
See Report (Tcode: FBL1N)
Clearing advance against Invoice
Path: Accounting - Financial Accounting - Accounts Payable - Document Entry - Other - F-51 - With Clearing (Tcode: F-51)
Enter header data (Type AB)
Select transfer posting with clearing
Choose open items (F6)
Company Code :
Account :
special G/L Ind. : A
Enter
Save
See Report (Tcode: FBL1N)
Scenario 2
Advance to Vendor :Rs 100000
Invoice : Rs 50000
Advance to vendor (Tcode:F-48): Rs100000
Path: Accounting - Financial Accounting - Accounts Payable - Document Entry - Down Payment - F-48 - Down Payment (Tcode:F-48)
Enter header data (Type KZ)
Account :
Special G/L Ind. : A
Account : 290100
Amount : 100000
Enter
Amount :*
Go to Menu bar
Document - simulate
Save
See Report (Tcode: FBL1N)
Invoice (Tcode:F-43): Rs50000
Enter Header data (Type KR)
PstKy : 31
Account :
Enter
Amount : 50000
PstKy : 40
Account : 400100
Enter
Amount :*
Go to Menu bar
Document - simulate
Save
See Report (Tcode: FBL1N)
Transfer posting
Path: Accounting - Financial Accounting - Accounts Payable - Document Entry - Down Payment - F-54 - Clearing (Tcode:F-54)
Enter header data (Type KA)
Account :
Keep blank invoice Field
Text : Being Transfer posting
Enter
Transfer posting : 50000
Save
Clear Advance against Invoice (Tcode:F-51)
Enter header data (Type AB)
Select transfer posting with clearing
Choose open items (F6)
Company Code :
Account :
Enter
Save
See Report (Tcode: FBL1N)
Scenario 3
Advance To Vendor : Rs 100000
Invoice : Rs 150000
Advance to Vendor (Tcode: F-48): Rs100000
Path: Accounting - Financial Accounting - Accounts Payable - Document Entry - Down Payment - F-48 - Down Payment (Tcode:F-48)
Enter header data (Type KZ)
Account :
Special G/L Ind. : A
Account : 290100
Amount : 100000
Enter
Amount :*
Go to Menu bar
Document - simulate
Save
See Report (Tcode: FBL1N)
Invoice (Tcode: F-43): Rs150000
Enter Header data (Type KR)
PstKy : 31
Account :
Enter
Amount : 150000
PstKy : 40
Account : 400100
Enter
Amount :*
Go to Menu bar
Document - simulate
Save
See Report (Tcode: FBL1N)
Transfer posting (Tcode: F-54): Rs100000
Path: Accounting - Financial Accounting - Accounts Payable - Document Entry - Down Payment - F-54 - Clearing (Tcode:F-54)
Enter header data (Type KA)
Account :
Keep blank invoice Field
Text : Being Transfer posting
Enter
Transfer posting : 100000
Save
Outgoing payment (Tcode: F-53): Rs 50000
Veryuseful guide to practice - Thanks
ReplyDeleteits awesome
ReplyDelete