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 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 material master.

VF01
Before posting account document, we can make 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 & 14000030, since account assignment group used in material master is 01 & 02.