You can use this function to define different calculation schemes for creditors and customers for each billing document type. In addition to standard reconciliation account determination, you can use an alternative reconciliation account determination in Sales and Distribution (SD) to determine a reconciliation account in agency documents that differs from the company code master data.

The account determination procedure determines the condition types that the system uses for the billing document type to determine the reconciliation account. If you define an account determination procedure for the creditor and the vendor in the billing document type, you can use a reconciliation account that is different from the account specified in the customer or vendor master record for postings to Financial Accounting.

Source: http://help.sap.com/erp2005_ehp_06/helpdata/en/19/e97c15c7b8413bb949432478892729/content.htm

Scenario

In customer master, here I maintain for customer with code 100261 has reconciliation account 140000 (Trade Receivables – domestic). If this customer do transactions using distribution channel 12 (Sold for resale) therefore the recon account used will be 140040 (Non-Trade Receivables – domestic) instead of 140000.

Customizing

In order to fulfill this requirement, here I used combination of Sales Org/Distribution channel in condition tables. Since, fields sales organization and distribution channel already provide in field catalog, thus I don’t need to do some effort in this area.

1) Maintain Condition Tables

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

2) Maintain Field Catalog

Path: IMG > Sales and Distribution > Basic Functions > Account Assignment/Costing > Reconciliation Account Determination > Maintain 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

5) Maintain Account Determination Procedure

Path: IMG > Sales and Distribution > Basic Functions > Account Assignment/Costing > Reconciliation Account Determination > 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

7) Assign G/L Accounts

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

8) Define Alternative Reconciliation Accounts

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

Testing

First, check the G/L account data in transaction FS00 for account 140000 and 140040.

In customer master (Company Code Data), for customer 100261, recon account default used is 140000 (Trade – Receivables).

Check if distribution channel used is correct.

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

Finally, the G/L account for reconciliation account used in this transaction is 140040 instead of 140000, since distribution channel used is 12.