Alternative reconciliation account for customer invoices

When the SD / FI billing happens in SAP, the debtors line item in the accounting document gets the reconciliation account from the customer master. Sometimes, due to nature of transaction e.g. sale of fixed asset to the customer, you may want to post the debtor line to a different reconciliation account than in the customer master, you can use the SAP functionality of alternative reconciliation account.

(So there is no need to create two customer master for the same customer with two different reconciliation account.)

 

FI invoice (Transaction FB70)

IMG setting:

Financial Accounting (New) -> Accounts Receivable and Accounts Payable -> Business Transactions -> Postings with Alternative Reconciliation Account -> Define Alternative Reconciliation Accounts (S_ALR_87002480)

Enter GL and alternative reconciliation account

GL Master

Transaction FS00 – Enter the alternative account. Tab Create/bank/interest. Tick Recon account ready for input.

Transaction posting

When you enter the FI invoice using transaction FB70, after you enter your customer number and other details in the tab Basic Data, go to Tab Details, you will be able to change the reconciliation GL account.

SD invoicing

You need to work with the SD consultant.

IMG setting

Sales and Distribution -> Basic Functions -> Account Assignment/Costing -> Reconciliation Account Determination -> Maintain Access Sequences (S_ALR_87007059) Here you define a criteria on how it determine alternative reconciliation account.

GL Master

Transaction FS00 – Enter the alternative account. Tab Create/bank/interest. Tick Recon account ready for input.

Click here to subscribe by Email – Technical discussion and quirks in SAP FICO

You may also like read

  1. Change of alternative reconciliation account in MIRO