SAP Knowledge Base Article - Public

3312767 - 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

The difference comes from Journal Entry Voucher postings done on any of the General Ledger Accounts.

Journal Entry Voucher Posting are on the General Ledger Account level and does not show up in Account Receivable Trial Balance Report.

Sometimes the differences dates back to previous Fiscal Years and do not necessarily belong to Fiscal Year for which the reports are being run.

Resolution

Once you have identified the Journal Entry Voucher postings,You can run the General Ledger Account line item to identify the Difference.

See Also

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

Keywords

Trial Balance,Accounts Receivable Trial Balance,Ending Balance Company Currency , KBA , ending balance company currency , trial balance , accounts receivable trial balance , SRD-FIN-ANA , Analytics Content , Problem

Product

SAP Business ByDesign all versions