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
Parties
B)SD CUSTOMERS Required
Entry field
PRODUCT
SALE
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 click 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
ENTER USER AREA
Sales invoice posting:
Path
accounting – Financial accounting –Account receivable- Document entry-Invoice
–General (F-22)
Give the document date :Today’s
date
Type :DR
Company code :AML
Posting key :01
Invoice (Customer debit) C:Customer D: Debit
Account :
select 6600001
Enter
Give the amount :500000
Business area :
AMLH
Text :
Sales Invoice posting
Posting key :50
Account :300000
(sales account)
Enter
Account :*
Business area :AMLH
Text :+
From the menu select document à Simulate and save
2.How To View Customer Account
Transactions-
Path :
Accunting – Financial accounting – Accounts receivable- Account-Display /
Change line items (Tr.code is FBL5N)
Give the customer account no. :6600001
Company code :AML
Select open items radio button
Select normal items check box
Select execute button
Select back arrow
To view vendor and customer
transactions together
Select
vendor items check box along with normal items
Execute
3.Incoming payment and clear vendor
and customer transactions together
Step
A)Document type DZ should allow vendor transactions
Document
types and no. Ranges-OBA7
Select
doc type: DZ Select doc type:
kz
Select
details button Select
details button
Below
no. Range- Below
no. Range-
Account
type: Account
type:
A Assets A assets
D Customers selected D customers to select
K Vendors to select K vendors selected
M Materials M materials
S GL accounts selected S GL
accounts selected
Normal
receipt entry: Normal payment entry:
Bank
A/c DR GL vendor a/c DR Vendor
To customer customer To Bank GL
use the Tr.code OBA7
Select
document type :
DZ (customer payment )
select
details button
select
vendor check box
save
Incoming Payment :
Path
:Accounting – Financial accounting – Accounts receivable- Document entry-
Incoming payments – (Tr.Codes is F-28)
Give the document date :
Today’s date
Type :
DZ Customer payment
Company code :
AML
Clearing text :
Incoming payment
Account under bank data :
200105 (SBI current account)
Business area :AMLH
Amount :496000
Text :
Incoming payment
Account under open item selection : Select 6600001
Account type :D
comes by default (D stands for
customers)
Select other accounts check box
Select process open item button
Select standard open items check box
Account type :
Select K (Vendors)
Company code :AML
Account :4200001
Select continue button
Double click on all open items
Document à Simulate and save
Go And See The Customer Account
Transactions (Tr.code is FBL5N)
Give the customer account no. :6600001
Company code :AML
Select cleared items radio button
Select normal items check box
Select vendor items check box
Execute
Advance
Receipts From Customers
(Down
Payment Receipts From Customers)
Sundry Sale
Debtors Customers
(Current (Current
Liabilities)
Asset)
Receipt Sale
1. Creation Of GL Master-Advance From Customers- under Current Liabilities &
Provisions (FS00)
- Link between Sundry
Debtors and advance from Customers
A (Advance) Special GL Indicator
/\
Sundry debtors Advance from customers
(Reconciliation Account) (Alternative reconciliation
account
or special GL account)
3.Advance Receipt Posting
4. Sales invoice posting
5. Transfer of advance from special GL to normal by
clearing special GL items
6. Clearing of normal items
a)Customer
account two parts
b) Special GL
items
1.
Creation of GL master –advance from customer current liabilities &
provisions (FS00)
Give the GL account no. :100502
Company code :AML
Select with template button
Give the GL account no. :200110 Sundry debtors
Company code :AML
Change account group to current
liability & provisions
Change short & GL account long
text advance from customers
Save
- Link between Sundry Debtors and advance from
Customers
Path :SPRO-Financial accounting-Accounts
receivable and accounts payable-Business transactions-Down payment received
–Define reconciliation accounts for customer down payments(OBXR)
Double click on special GL indicator
A
Give a your chart of accounts :AML
Enter
Reconciliation account :200110
Special GL account :100502
Select save button or Ctrl+S
Press enter to save in your request
END USER AREA
Advance receipt posting:
Path :Accounting-
Financial accounting –Accounts receivable-Document entry-Down payment –Down
payment (Tr.code is F-29)
Give the
document date :Today’s
date
Type :DZ
Company code :AML
Customer
account :6600001
Special G/L
indicator :A
Bank account :200105
SBI current account
Business area :AMLH
Amount :12000
Text :Advance
receipt posting
Enter
Amount :*
Business area :AMLH
Text :+
From the menu
select –Document –Simulate and save
Go and see the customer account transaction (FBL5N)
Give the
customer account no. :6600001
Company code :AML
Select open
items radio button
Select special
GL transactions check box
Execute
Sales invoice posting ( Tr code is F-22)
Give the
document date :Today’s date
Type :DR
customer invoice
Company code :AML
Posting key :01
Account :6600001
Enter
Amount :12000
Business area :AMLH
Text :Sales
invoice posting
Posting key :50
Account no. :300000 Sales A/c
Enter
Amount enter :*
Business area :AMLH
Text :+
Form the menu
select document –Simulate and save
Go and see the customer account transaction (FBL5N)
Give the
customer account no. :6600001
Company code :AML
Select open
items radio button
Select normal
items check box
Execute
Select back
arrow
Select special
G/L transactions check box along with normal items
Execute
Transfer of advance from special GL to normal by clearing
special GL items:
Path :Accounting-Financial
accounting –Accounts receivable-Document entry-Down payment clearing (F-39)
Give the
document date :Today’s
date
Type :DA
Company code :AML
Customer
account :6600001
Text :Advance
receipt clearing
Select process
down payment button
Transfer
posting :12000
Save
Go and see the customer account transactions (FBL5N)
Give the customer
account no. :6600001
Company code :AML
Select cleared
items radio button
Select special
GL transactions check box
Execute
Select bank
arrow
Select open
items radio button
Select normal
items check box
Execute
Clearing of normal items:
Path :Accounting- Financial
accounting –Accounts receivable –Account –Clear (F-32)
Give the
account no. :6600001
Company code :AML
Select process
open item button
Double click on
debit :12000
Double click on
credit :12000
Save
Go and see the customer account transactions FBL5N
Give the customer account
no. :6600001
Company code :AML
Select cleared items radio
button
Select normal items check
box
Execute
No comments:
Post a Comment