2203668 - Accounts Receivable - Balance Audit Trail Shows Balance Company Currency is Cumulative of Previous Customer Account Balance

You are checking the balance company currency of a certain receivable account balances with the Accounts Receivable - Balance Audit Trail report. You observe that the Balance Company Currency is derived by also including the Previous Customer Account Balance

1. Go to Business Analytics work center.
2. Select Design Reports view.
3. Show All and find Accounts Receivable - Balance Audit Trail and click on it.
4. Fill the required fields and leave the customer field if filled then the balance company currency shows correctly

      If the Customer field is left blank then the behavior is as shown below

If you leave the customer field blank then the balance company currency is cummulative of previous customer account aswell and Accounts Receivable Balance audit trail report is not the correct report for doing any kind of comparisons of balances of all customers together.

if you explicitely select a particular Customer ID then the balance amount is not a cumulative and does not add the previous customer account balance. 

If you want the balances listed for all customers then you need to look into Accounts Receivable - Trial Balance - Report. Here the balance does not cumulate the previous customer account balance - irrespective of whether you enter the Customer Account in the selection criteria or not.

KBA , AP-RC-BCT , Business Config. Tools (SAP Business ByDesign , How To