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

SAP Knowledge Base Article - Public

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

Symptom

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

Reproducing the Issue

  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
Customer ID Debit Amount Company Currency Credit Amount Company Currency Balance Company Currency
ABC 3000 USD 300 USD 2700 USD
PQR 4000 USD 400 USD 3600 USD

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

Customer ID Debit Amount Company Currency Credit Amount Company Currency Balance Company Currency
ABC 3000 USD 300 USD 2700 USD
PQR 4000 USD 400 USD 6300 USD ( PQR 3600 + 2700 of Customer ABC )

Cause

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.

Resolution

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.

Keywords

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

Product

SAP Business ByDesign all versions