SAP Knowledge Base Article - Public

2910918 - The Difference of the Ending Balance Company Currency Between Report Trial Balance and Report Accounts Receivable - Trial Balance

Symptom

You run the two reports, Trial Balance and Accounts Receivable - Trial Balance, finding that there is difference in the amount of Ending Balance Company Currency.

Environment

SAP Business Bydesign

Reproducing the Issue

  1. Go to General Ledger work center.
  2. Go to Report view.
  3. Open report Trial Balance.
  4. Enter below values in the selection; Company->AA; Set of Books->BB; Accounting period/Year->CCC.DDDD…EEE.DDDD; Display Currency - Conversion Date->FF.GG.DDDD.
  5. Run the report.
  6. Here you found the amount of Ending Balance Company Currency is XXXX.

Now, open the other report.

  1. Go to General Ledger work center.
  2. Go to Report view.
  3. Open report Accounts Receivable - Trial Balance.
  4. Enter below values in the selection; Company->AA; Set of Books->BB; Accounting period/Year->CCC.DDDD…EEE.DDDD; Display Currency - Conversion Date->FF.GG.DDDD.
  5. Run the report.
  6. Here you found the amount of Ending Balance Company Currency is YYYY.

You will see the difference is XXXX-YYYY=ZZZZ

Cause

Basically the difference is due to an amount that is not assigned to any business partner. If the amount is not assigned to a partner company it will not appear on account receivable reports because there is no account associated with it.

Resolution

You can narrow the period down in both reports for only HHH.DDDD (HHH.DDDD is the period when the difference first appears); Then in the View, add the row Partner Company into the Trial Balance report, you will see that there is a Not Assigned amount of ZZZZ showing under Ending Balance Company Currency - this isn't assigned to any partner company, it could be coming from a manual JEV or something like this.

Keywords

Ending Balance Company Currency; Trial Balance; Accounts Receivable - Trial Balance; Not Assigned; , KBA , SRD-FIN-ANA-GL , General Ledger (Reporting) , How To

Product

SAP Business ByDesign all versions