Determination of GL Account for billing

[former_member221515]

Hi

In VKOA, there are following tables:

01 - Plant / Customer account assignment group / Material account assignment group / Company code

101 - Plant / Customer account assignment group / Material account assignment group / Company code / Region

102 - Plant / Customer account assignment group / Material account assignment group / Company code / Destination country

For combination

Company code: 1000

Plant: 1100

Customer account assignment group: 01

Material account assignment group: 01

Account Key: ERL

GL Account is 31000000

For combination

Company code: 1000

Plant: 1100

Customer account assignment group: 01

Material account assignment group: 01

Destination: DE

Account Key: ERL

GL Account is 31000010

When billing is done it hit GL Account 31000010. Let me know why it did not picked GL Account 31000000 (ie 1st table). On what basis it picked 3rd tabe 102.

Let me know.

Thnx

Deepak

Edited by: Deepak Agrawal on Jun 23, 2010 8:43 PM

[Former Member · Accepted solution]

Please check the access sequence for the account determination, how the tables are placed.

SPRO > SD > Basic Functions > Account Assignmnet / costing > Revenue Account Determination > Access Sequences.

The tables mainatined here and the order in which they are maintained will determine which G/L account will be posted.

During VKOA the order in which the tables appear might be different from access sequence order.

Regards

Sai

[former_member221515 · Accepted solution]

But in my case table 1 is before 102. then why it determined GL from table 102. I am still not clear.

[Former Member · Accepted solution]

Presuming you checked SPRO > SD > Basic Functions > Account Assignmnet / costing > Revenue Account Determination > Access Sequences.

Select KOFI and double click on accesses. Now in this screen , please check the order in which the tables are maintained.

SAP checks most specific to most general.

Regards

Sai

[former_member221515 · Accepted solution]

I checked this step.

In Access number 5: Table 102 is given

In Acess number 10: Table 101 is given

In Access number 20: Table 1 is given.

These are the three access numbers given.

Why its picking 102 is since table 102 is given at first ?

And further i will tell you, sales order in 2009, entry went as per table 1 and not 102. What is the reason for it then ? Does it mean destination country was not mentioned in Sales order in 2009. So it bypassed 102 and picked table 1.

Edited by: Deepak Agrawal on Jun 24, 2010 10:08 AM

Edited by: Deepak Agrawal on Jun 24, 2010 10:10 AM

[Former Member]

HI, guy

I suggest you check the account determine analysis first.

Maybe you can take some helps from there.

Menu->Environment->Acc.determ.analysis

[former_member221515]

I tried that also.

[Former Member]

check for Exclusions

[Former Member]

Hii,

U r right. If the destination country is not mentioned in the order, it will bypass that access and retrieve data from next access sequence. I hope i am clear.

Regards,

Pankaj