on 06-29-2009 11:40 AM
Hi, expert
I am doing Integration with SD
We have two two type of sales account, domwstic sales and export sale, how to maintain for the same sequence (e.g. APP (V), condition type(KOFI), COA, SOrg, AAG, AAG, Act (ERL))?
I want to create Automatic Account Group (AAG) where i can create & what is the t code for create
regards
gk
Hi,
You can use t code ovk5 to maintain account key based on material to be sold.
You can then assign that key in VKOA transaction code under customer/Material/Account key combination.
Below mentaioned is one example
Material account assignment group
11- FG revenue
12-RM revenue
13-Scrap Revanue
Customer Account assignment group
20-Direct Domestic Revenue
21- Direct Export Revenue
Account Key
ERL- Revenue (FG) - 10001
ERL- Revenue (RM) - 10002
ERL- Revenue (Scrap) - 10003
Assigned in VKOA under customer Group/Material Group/Account key combination as follows
App-Condition Type- Chart of Acct -Sales Organization- Cust Acct Grp - Material Grp-GL Acct
V- KOFI- 0001- 1031- 20- 11- 10001
V- KOFI- 0001- 1031- 20- 12- 10002
V- KOFI- 0001- 1031- 20- 13- 10003
Assign the same in Customers Master Data in sales Data dilling documents tab account assignment field & in Material Master Data
Regards,
Sany
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
ok
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
G.Kumar ,
When you integrate fI/SD, need to choose AAG for Material group, AAG for Customer group and consider both combination of revenue GL Accounts(Export and Domestic GL Accounts) to the ERL ( e.g., 3 AAG Material group * 2 AAG Material groups = 6)
See the below example.
V KOFI CABE 0001 01 01 ERL 700000
V KOFI CABE 0001 01 02 ERL 700000
V KOFI CABE 0001 02 01 ERL 700000
V KOFI CABE 0001 02 02 ERL 700000
V KOFI CABE 0001 03 01 ERL 700000
V KOFI CABE 0001 03 02 ERL 700000
Rgds,
Ramesh.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
There aer two account assignment categories :
1. Customer - TCODE: OVK5
2. Material - TCODE: OVK5
Domestic sales and Export sale - differentiation can be done using the "Customer account assignment category" in TCODE : VKOA.
VVR
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
94 | |
11 | |
10 | |
6 | |
5 | |
5 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.