Link between GL account and Billing Document

[Former Member]

Dear FI Gurus,

We are involved in a BI report generation. In the sales report customer wants to bifurcate the sales into Domestic and Export. They are give a logic of taking this bifurcation from GL account. Customer is maintaning 2 different GL account 40000000 - Export and 40100000 for Domestic.

My question here is How i will relate GL account to billing document? If yes, please tell me the table where i can find both...

With Regards,

Balachander.S

[Former Member · Accepted solution]

This is normally done via the account assignment group in the customer master, sales org level.

Once you define that, you then link the GL account via t code VKOA.

Therefore for certain types of customer, will use GL a/c 1 and others will use GL a/c 2.

If you have set up external accounting document determination, then the a/c document will be the same as the billing document.

Therefore if you are displaying a GL account's line items, the document number will also be the billing document.

If you are looking via tables, the billing document number will be held in BSID or BSAD, open and closed customer items, where the document number is the same as the entry in BSIS.

Hope this helps, award points if useful.

[former_member183879]

Hi,

For every invoice document in SD, there is an accounting document in FI. The mapping between these two is also maintained in the table BKPF where the details of accounting document are found. The field Reference in BKPF tells the invoice document for which the account document is created. But you have to be careful as the value of this field can be updated through user exits also. In this case, you can very well ask the business on where can you find the link between the invoice document and the accounting document in database table.

Once you get the link, using the accounting document number in BKPF, you can go to BSEG to find the GL account for every line item.

[Former Member]

Hi

Through Access Sequence u can maintain the link.

Shammi