ACCOUNTS RECEIVABLE (A/R)
This is also a Sub Ledger (Subsidiary Ledger)
This is used when Sales & Distribution (SD) Module Is not implemented-All types of sales.
Eg: Product Sale/Raw Material Sale/Scrap Sale
When Sales & Distribution(SD) Module is implemented-This is used for Raw Material Sale /Scrap Sale/Asset Sale-(Other than Product Sale)
At the time of sale:
Customer Account Dr Sub ledger Sundry Debtors(General Ledger) | | TO SALES General Ledger |
| | Reconciliation Account Or
Control Account
BASIC SETTINGS FOR ACCOUNTS RECEIVABLE:
1.Creation Of Customer Account Groups
A)FI Customers
Asset Sale/Scrap Sale/RM Sale Reconciliation account field
Parties
B)SD CUSTOMERS Required Entry field
PRODUCT SALE PARTIES
2.Create number ranges for customer accounts
3.Assign number ranges to customer account groups
4.Creation of 2 GL masters
A)Sundry Debtors- "Current Assets,Loans&Advances"
B)Sales Account Sales
5.Creation Of Customer Master
6. Document Types And No.Ranges OBA7
DR Customer Invoice
DZ Customer Payment
DA Customer Document For
Transfers/Reversals
7.Posting Keys 01 Customer Debit
15 Customer Credit
We test a scenario where vendor is a customer
Party BCL Party BCL
Purchase 100000 Sales 100000
Sales 20000 Purchase 20000
-------- -------
Net Payable 80000 Net Receivable 80000
When we Pay/Receive net amount we have to clear vendor transactions and customer transactions at a time
Note : Create receipt terms (if any cash discount debit - Debit expenses )
1.SALES INVOICE POSTING:
Creation of customer account groups
Path: SPRO- Financial Accounting- Account Receivables and accounts payables customer accounts – Master data- Preparation for creating customer master data- Define account groups with screen layout (customers)
Select new entries button
Account group : AML1
Name : FI Customers for AML
Double lick company code data
Double click account management
Reconciliation account make it required entry filed
Save
Select create request button
Short description for AR customization for AML
Press enter
Enter once again to Save in your request
Select next entry button
Account group : AML2
Name : SD customers for AML
Double click on company code data
Double click on account management
Reconciliation account make it required entry filed.
Save.
Create No. range for customer accounts:
Path :Upto preparation for creating customer master data the path is same.-Create no. range for customer accounts (Tr.code is XDN1)
Select change intervals button
Select interval button
No. range :23
From no. :6600001
To no. :6700000.
Enter
Select interval button once again
No.range :24
From no. :6700001
To no. :6800000
Enter and Save
Ignore the warning message press enter
Assign Number ranges to customer account groups:
Same path
Select position button
Account group : AML1
Enter
For AML1 Assign no.range :23
For AML2 Assign no.range :24
Save
Press enter to save in your request
Define tolerance group for Customer
Path :SPRO-Financial accounting-Account receivable and account payable-Business truncations-incoming payments-manual incoming payments-Define tolerances(Customers)
Select new entries button
Company code :AML
Tolerance group : Blank
Description :Tolerance group for AML
Save
Press enter save in your request
Creation of GL Masters (FS00):
Give the GL account no. :200110
Company code :AML
Select with template button
Give the GL account no.200150 advance to vendors
Company code : AML
Enter
Change short text and GL account long text to Sundry Debtors
Select control data tab
Change reconciliation account for account type to customers
Change sort key to 031 customer number
Select Create / Bank / Interest tab
Field status group :G067
Save
GL account no :300000
Company code :AML
Select with template button
Change GL account 300100 Exchange gain
Company code :AML
Enter
Select type/description tab
Change the account group to sales/.
Change short text and GL account loge text to sales account
Other fields are common
Select save button or Ctrl+S
Creation of customer master
Path: Accounting- Financial accounting –Accounts receivables-Master records-Maintain Centrally-Create (Tr.Code is XD01)
Account group :select FI customer for AML
Company code :AML
Enter
Title : : select Company
Name : BIRLA Chemicals Limited
Country : IN for India
Select control data tab
Vendor :4200001
Select company code data button
Reconciliation account :200110 Sundry debtors
Sort key :031 (Customer no.)
Select payment transaction tab
Terms of payment :0001 payable immediately due net
Save
Document type number ranges (OBA7)
Select type Dr customer invoice
Select details button
No.range :18
Select no.range information button
Company code :AML
Select change intervals button
Select intervals button
No.range :18
Year :2008
Form no. :400001
To no. :500000
Enter and save
Ignore the warning message press enter
Select back arrow 3 times
Select type :DZ (Customer payment )
Select details button
No. range :14
Select no.range information button
Company code ::AML
Select change intervals button
Select interval button
No.range :14
Year :2008
From no. :500001
To no. :600000
Enter and save
Ignore the message press enter
Select back arrow three times
Select type :DA (customer document)
Select details button
No.range :16
Select no.range information button
Company code :AML
Select change interval button
Select interval button
No.range :16
Year :2008
Form no. :600001
To no. :700000
Enter and save
Ignore the warning message press enter
