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.
Reproducing the Issue
- Open the report Accounts Payable - Balance Audit Trail from the assigned work center.
- Change the view as required.
- Check the Balance Company Currency.
You will see that the amount is incorrect.
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
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.
KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , SRD-FIN-ANA , Analytics Content , How To