FI – SD account determination:-
All Billing transactions happening in the Sales and Distribution module will result in FI postings. All accounting entries with respect to the billing will have one side of the account as a Customer or receivable and the other side to be a revenue account.
For e.g.
Customer –Dr.
To Revenue Account- Cr.
You have to bear in mind that the customer account gets picked up from the customer master data. All we need to do is to configure the revenue account or the discounts and surcharges
Where and how do we do this?
You make the allocation for each of these through access sequences. Access sequence is nothing but SAP’s terminology of determining the Gl accounts. SAP provides the following six ways of determining the Gl accounts in SD.
- Application (key for the Sales and Distribution application)
- Account determination type
- Chart of accounts (from the FI System
- Customer account assignment group
- Materials account assignment group
- Account key
The account determination in SD happens through an access sequence which can be seen in the below table.
The system goes about checking for the gl account from more specific criteria to less specific criteria.
Thus you can maintain different
GL codes for each combination of the above table entry.
This is how SAP will determine
the revenue account:
It will go through first table entry CustGrp/Material grp/ account key. If any Gl account is maintained here the system will then go to the transaction data of the particular billing document and see whether such a combination of Customer group and material group exists if it does it will pick that relevant Revenue account and post the accounting document.
If it does not it moves to the next combination in the table which is Customer group/account key and so on and so forth Customer grp is maintained in the Sales view of the customer master. Material grp is maintained in the Sales view of the material master. Account key is maintained in the pricing procedure for that condition type.
The last option it checks is account key entry. We will now maintain the Gl account for the combination of Material Grp/account key
Double Click
AAG is the material grp. We maintain
this since we want it to post to a different GL code as Sales 3rd parties.
That's it. The system will look into this table see this combination and
if the relevant combination exists in the transaction it will debit the
customer account and credit this account
As simple as it is. So basically
the SAP FI-SD
integration is for picking up the revenue accounts or the discounts and
surcharges. The account key determines whether it is revenue or a surcharge
or discount.
FI-SD INTEGRATION
Process Flow in SD
Step 1 Receipt of enquiry from customers (only SD is involved)
Step 2 Sending quotations (SD)
Step 3 Receipt of sales order (SD)
Step 4 Delivery of finished goods
(SD, MM and FI are involved)
Entry will be
Change in stock a/c Dr
Finished goods inventory a/c Cr
Step 5 Billing and invoicing to
customer (SD and FI)
Entry will be
Customer a/c Dr
Sales a/c Cr
For this step create number ranges
for document type RV in t code OBA7
Step 6 Receipt of payment (SD-FI)
cash a/c Dr
Customer a/c Cr
Customization Steps
In T-code VKOA assign sales account to account key ERL depending upon the pricing procedure in SD we have to assign accounts in VKOA
1) Insert regions OVK2
2) Define sales organization
OVX5
3) Define distribution channel
OVX1
4) Define shipping point
OVXD
5) Assign sales organization
to co. code OVX3
6) Assign distribution channel
to sales organization OVXK
7) Assign division to sales
org OVXA
8) Assign sales org/distribution
channel to plant OVX6
9) Assign shipping point
to plant OVXC
10) Setup sales area OVXG
11) Define rules by sales area
OVF2
12) Define pricing procedure determination
13) Define tax determination rules
14) Creation of G/L accts FS00
15) Assign G/L accts VKOA
16) Setup partner determination
17) Assign shipping points OVKC
18) Creation of SD customer master
XD01
19) Creation of finished goods
material master MM01
20) Maintain condition types VK11
