G/L Account assignment issue

[Former Member]

Dear all,

I getting a problem with G/L account assignment. I have many materials and i have to record revenue for each material. Each material has a revenue GL account. But i can't assign more than one GL account for only account key ERL. So how can i do?

Moreover, pls tell me why it is olny post if i assign GL account for General, although i have assigned GL account in other group.

Thank you,

Edited by: Quang Le Vinh on Aug 18, 2008 10:09 AM

[Former Member · Accepted solution]

Hello,

You can definitely assign more than one G/L account to same account key ERL. Go through the following:

1. IMG - Sales & Distribution - Basic Functions - Account Assignment/Costing - Revenue Account Determination - Check Master Data Relevant For Account Assignment - Materials: Account Assignment Groups.

Here you can create different material account assignment groups as per your requirement. Suppose for the same material type FERT for different finished goods you hav to post to different G/L accounts for revenue then create new entries here.

2. Go to MM02 - Sales: Sales Org data2 screen . Here you select the respective account assignment group for the specific material & Save it.

3. Go to VKOA - select the option "Material Grp/Acct Key" - press enter. Here you will enter your respective G/L account for the same account key ERL but for different materials as follows:

Appl.....Cond Type.......ChAc.......Sales Org.....AAG.........Acct Key......G/L Account

V...........KOFI...........CAIN..............BP01..........01..............ERL............9021000

V...........KOFI...........CAIN..............BP01..........02..............ERL............9021010

Similarly you can create customer account assignment groups also if you want to have a different G/L account for same account key ERL but for different customer & different materials.

In VKOA you have 5 options as under:

1........Cust.Grp/MaterialGrp/AcctKey

2........Cust.Grp/Account Key

3........Material Grp/Acct Key

4........General

5........Acct Key

The account assignment function also works through condition technique in which you come across an access sequence (KOFI in case of standard). The access sequence has 5 tables mentioned above so it starts searching for the combination from 1.........If key combination 1 is not fulfilled then it will move onto 2..........& so on.....For general the G/L accounts will be same for all account keys.

It all depends on the clients requirement as to how the posting is to be done. Accordingly you select the particular option.

Hope this gives you a clear idea about your doubt.

With best regards,

Allabaqsh G. Patil

[Former Member · Accepted solution]

Dear Allabaqsh,

Thanks for your support. It was checked in material master.

As your suggestion, I can create many material group that for only a material.

I also tried to assign a G/L account for group 03 (Finished good) with acct key ERL but it is not posted.

Thanks,

[Former Member]

This can definately be controlled through Material Master Data, through the field 'Account Assignment Group of Material'.

This will help in determining a separate G/L account in T.Code: VKOA

Regards,

Rajesh Banka

[Former Member]

Hi,

Maintain account assignment group in material master(Sales Org2). E.g Trading goods,Services etc...

Choose material group/ Acc key or Cust.Grp/Material Grp/Acc key

Maintain G/L accounts for your combination.

In general, everyone use Cust.Grp/Material Grp/Acc key. In this combination we can classify the revenues and expenses by customer and material wise.

If you need further information, please let me know.

Regards,

Chandrasekhar.S

[Former Member]

Hi Chandrasekhar.S,

It only for group of material, not for an exact material.

[Former Member]

dear Quang,

Maintain the material group in the key then in t-code VKOA..

i.e. your condition should be based on

Acnt Assignment Grp(Customer)/Acnt Assignment Grp(Material)/ActKy/Material Grp.

I hope this helps...

Rgds,

Rags.

Edited by: Rags on Aug 18, 2008 9:51 AM

[Former Member]

Hi,

we should maintain account assignment group for each material, Whether it is group of material or one material,

If you want to post values to different G/L accounts for services / Trading goods / finished goods.

Maintain A/c assignment group for all material and assign G/L accounts.

could give me more information what exactly you are required, so I will explain step by step.

Regards,

Chandra

[Former Member]

Dear,

In Viet Nam country, we use detail accounts, not general account For example, there are some accounts use in sales:

511110......... general account

511111..........detail account

511112..........detail account

511113..........detail account

511114..........detail account

511115..........detail account

.......

There are 2 kind of customer groups : Domestic revenues 01 and foreign revenues 02

4 kinkd of material groups: Trading goods 01, Perfomances 02, Finished goods 03, Raw materials 04

Now i want to assign 5 GL accounts for 2 material groups, Example:

App.......CndTy.........ChAc........SOrg............AAG............AAG...........ActKy............G/L Account

V ..........KOFI .........COAV ..... HDQS ......... 01 ............... 03 ............ERL.................511111

V ..........KOFI .........COAV ..... HDQS ......... 01 ............... 03 ............ERL.................511112

V ..........KOFI .........COAV ..... HDQS ......... 01 ............... 02 ............ERL.................511113

V ..........KOFI .........COAV ..... HDQS ......... 01 ............... 02 ............ERL.................511114

V ..........KOFI .........COAV ..... HDQS ......... 01 ............... 02 ............ERL.................511115

If do that, it doesn't allow. It just allows for different AAG/AAG/ACtKy.

Edited by: Quang Le Vinh on Aug 18, 2008 11:45 AM

Edited by: Quang Le Vinh on Aug 18, 2008 11:50 AM

[Former Member]

dude,

You want to assign different G/L account for the same key? hows that possible? leave aside the sap system how will YOU determine the G/L for a material in a sales order with material grp 03?

which G/L account should be picked up--511111 or 511112 ?

thats illogical? be clear on your requirement...

Rgds,

Rags.

[Former Member]

Hi,

You can assign only one G/L for your combination. This will not work in SAP.

App.......CndTy.........ChAc........SOrg............AAG............AAG...........ActKy............G/L Account

V ..........KOFI .........COAV ..... HDQS ......... 01 ............... 03 ............ERL.................511111

V ..........KOFI .........COAV ..... HDQS ......... 01 ............... 03 ............ERL.................511112

Following combinations only will work for your scenerio.

Domestic revenues

App.......CndTy.........ChAc........SOrg............AAG............AAG...........ActKy............G/L Account

V ..........KOFI .........COAV ..... HDQS ......... 01 ............... 01............ERL.................511111

V ..........KOFI .........COAV ..... HDQS ......... 01 ............... 02 ............ERL.................511112

V ..........KOFI .........COAV ..... HDQS ......... 01 ............... 03............ERL.................511113

V ..........KOFI .........COAV ..... HDQS ......... 01 ............... 04 ............ERL.................511114

Foreign revenues

V ..........KOFI .........COAV ..... HDQS ......... 02 ............... 01............ERL.................511111

V ..........KOFI .........COAV ..... HDQS ......... 02 ............... 02 ............ERL.................511112

V ..........KOFI .........COAV ..... HDQS ......... 02 ............... 03............ERL.................511113

V ..........KOFI .........COAV ..... HDQS ......... 02 ............... 04 ............ERL.................511114

For Foreign revenues you can use either same G/L accounts or different G/L accounts

After transferring the billing document to accounts,

Goto FS10N Transaction code FS10N and enter G/L account, company code and Fiscal year.

system will give the balances, with this information we can know the howmuch trading goods we sold during this period.

Note : For Foreign revenues if use different G/L accounts, we can know the total foreign revenue for trading goods.

Regards,

Chandrasekhar.S

[Former Member]

Hi,

I would suggest you find out a parameter (field) which remains unique for every transaction. I mean when

AAG.............AAG...........Parameter

01..................03..................X..................511111

01..................03..................Y..................511112

If you come across such a parameter try to include the same in a new condition table keeping all the original fields. Assign it to the access sequence KOFI & then try to maintain the G/L accounts in VKOA as under

Thanks & regards,

Allabaqsh G. Patil.