Alternative Reconciliation Account for Customer Ledger Postings

Alternative Reconciliation Account for Customer Ledger Postings Scenario In customer master, I have maintained one reconciliation account (Sundry Debtors). Now requirement is to book the revenue in customer c ustomer ledger base on product.

Customizing 1) Maintain Condition Tables In order to fulfill this requirement, here I used combination of Sales Org/Acct assignment grp in condition tables. Path: IMG > Sales and Distribution > Basic Functions > Account Assignment/Costing > Reconciliation Account Determination > Maintain Condition Tables

Condition Table

2) Maintain Field Catalog Path: IMG > Sales and Distribution > Basic Functions > Account Assignment/Costing > Reconciliation Account Determination > Maintain Field Catalog

Field Catalog

3) Maintain Access Sequences Path: IMG > Sales and Distribution > Basic Functions > Account Assignment/Costing > Reconciliation Account Determination > Maintain Access Sequences

4) Maintain Condition Types Path: IMG > Sales and Distribution > Basic Functions > Account Assignment/Costing > Reconciliation Account Determination > Maintain Condition Types

Condition type used

5) Maintain Account Determination Procedure Path: IMG > Sales and Distribution > Basic Functions > Account Assignment/Costing > Reconciliation Account Determination > Maintain Account Determination Procedure

Maintain account determination procedure

6) Assign Account Determination Procedure Path: IMG > Sales and Distribution > Basic Functions > Account Assignment/Costing > Reconciliation Account Determination > Assign Account Determination Procedure

Assign account determination procedure

7) Assign G/L Accounts Path: IMG > Sales and Distribution > Basic Functions > Account Assignment/Costing > Reconciliation Account Determination > Assign G/L Accounts

Assign G/L account

8) Define Alternative Reconciliation Accounts

Path: IMG > Sales and Distribution > Basic Functions > Account Assignment/Costing > Reconciliation Account Determination > Define Alternative Reconciliation Accounts

Alternative recon account used

Testing First, check the reconciliation account from 14000010 to 14000030.

In customer master (Company Code Data), for customer 800001, Reconciliation account default used is 14000010 (Sundry Debtors).

Default recon. Account for customer 800001 is 14000010

Material Master Account assignment group is maintained as per requirement in m aterial master.

VF01 Before posting account document, we can m ake sure if reconciliation used is correct by go to Environment > Acc.determ.analysis > Reconciliation accounts.

Check if alternative recon account worked in billing document.

Accounts assignment group is different in both the items in billing document.

Accounting Document after Posted Billing

Finally, System used alternative recon account based on account assignment group, the G/L account for reconciliation account used in this transaction is 14000020 & 1400 0030, since account assignment group used in material master is 01 & 02.