SAP Knowledge Base Article - Public

2091664 - Report Accounts Payable - Balance Audit Trail Shows Wrong Value in Balance Company Currency

Symptom

You are viewing the report Accounts Payable - Balance Audit Trail to check the balance. You have set up the view as required, for example with the characteristics G/L account, Supplier, Accounting Period / Year,... You can see that the key figure Balance Company Currency is showing the wrong amount.

Environment

SAP Business ByDesign.

Reproducing the Issue

  1. Open the report Accounts Payable - Balance Audit Trail from the assigned work center.
  2. Change the view as required.
  3. Check the Balance Company Currency.

You will see that the amount is incorrect.

Cause

This report has a particular use case and needs a specific layout to show the correct balance. This means that you will have to use the characteristics Source of Data and Posting Date in the rows.

Generally, the key figure Balance Company Currency is calculated based on the following formula:

Opening Balance + Debit Amount - Credit Amount

Resolution

Please pull the characteristics Source of Data and Posting Date into the rows in order to check the balance. Source of Data is invisible in the report but it is required for technical purposes.

Please note, if you do not want to use these characteristics and require a layout that shows the data grouped by e.g. the Accounting Period / Year, you can use the report Accounts Payable - Trial Balance instead.

Keywords

Balance Audit Trial. Business Analytics. , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , SRD-FIN-ANA , Analytics Content , How To

Product

SAP BUSINESS BYDESIGN 1705 ; SAP BUSINESS BYDESIGN 1708 ; SAP Business ByDesign 1408 ; SAP Business ByDesign 1411 ; SAP Business ByDesign 1502 ; SAP Business ByDesign 1505 ; SAP Business ByDesign 1508 ; SAP Business ByDesign 1511