How to link customer account or vendor account or any master data with General Ledger?

[Former Member]

Hi folks,

I was researching on how SAP links master data like Customer Account or Vendor account or Bank account with General Ledger, especially while creating a invoice how these above mentioned master data will be linked or fetched?

Any link documentation or clarification of the process will be a great help for me.

Thanks in advance.

[kamalkumar_biswas2 · Accepted solution]

Hi Indranil

  General Ledger is the main Ledger where all accounts are maintained. Vendor and Customer ledgers are sub-ledgers where each line item transaction is kept vendor/customer wise.

  In general ledger one Reconciliation/Dy Debtor/Sy creditor account is opened and maintained in Vendor/Customer Master. This account is the link between General Ledger and Sub-Ledger of Vendor and customer.

When any invoice is posted against any vendor/customer system goes to Master data of that vendor/customer and find out the Recon account defined in the vendor/customer Master and link the transaction with that to post it to General Ledger.

I think you have got your answer.

kamal

[Former Member · Accepted solution]

Thanks for your descriptive answer.

[former_member186576]

In vendor master control data, provide customer No.

In customer master control data, provide vendor No

In customer master - company code data-Payment Transaction- activate Clearing with Vendor

In Vendor master -payment transactions accounting-activate Clearing with Customer

table that links customer and vendor is KLPA.

[kamalkumar_biswas2]

Hi

This part of setting is required when same party is a vendor and also a customer. To make the payable and receivable amount "NET" you can set this...so that at the time of any payment you can have net position of the party available.

Kamal

[Former Member]

hi Sam,

thanks for your answer. But I was looking for the process of linking master data like customer account or vendor account with GL especially how these master data will be selected while creating an invoice? But I guess your answer is aiming more towards how to link Customer Master and Vendor Master.

If you think I didn't get your answer, I will be glad if you can clarify in details for me.

[former_member186576]

Customer, Vendor, Asset are sub ledgers. The main ledger will be the recon account associated with each sub ledger. The reconciliation account gets updated parallel to the sub ledger (including while creating an invoice).