Symptom
The total amount of a certain receivable or payable G/L account with the Accounts Receivable - Open Items or the Accounts Payable - Open Items report is different to the total amount of the same G/L account displayed in a different balance report, such as the Financial Statements report or the G/L Accounts - Line items report.
Environment
SAP Business ByDesign
Reproducing the Issue
To check the Accounts Receivable/Payable report (ARP report):
- In the Receivables workcenter navigate to the Reports-List view - for a payable G/L account open the Payables workcenter.
- Open the Accounts Receivable - Open Items report - for a payable G/L Account open Accounts Payable - Open Items report.
- Maintain the mandatory variable fields as well as the G/L account that you want to check.
- Click Start.
- Add the key figure Balance Company Currency by pressing Settings – Keyfigures, moving this key figure to Selected and pressing OK.
- At the very bottom of the table a total result is displayed in the newly added Balance Company Currency column.
- Leave the report open.
To check the Financial Statements report:
- In the General Ledger workcenter navigate to the Reports-List view.
- Select the Financial Statements report.
- Maintain the variables according to the settings of the accounts receivable/payable report (ARP report) as well as an appropriate financial reporting structure and balance sheet type.
- Press Go.
- Move the characteristic G/L Account to the rows and filter for the respective G/L account.
- You notice that the amount displayed in the Amount Company Currency column is different to the total result in the ARP report.
To check the G/L Accounts – Line Items report:
- In the General Ledger workcenter navigate to the Reports-List view.
- Select the G/L Accounts – Line Items report report.
- Maintain the same variables as per the ARP report. Do not maintain any value in the Closing step field.
- Press Go.
- Add the key figure Balance Company Currency by pressing Settings – Keyfigures, moving this key figure to Selected and pressing OK.
- In the Edit Filter tab, filter for the respective G/L account.
- Press Go.
- You notice that the total result displayed in the Balance Company Currency Amount column is different to the total result in the ARP report.
Cause
The open items reports for accounts receivable/ payable do not take postings into account that have been executed without subledger involvement, such as manual journal entry voucher postings or balance carryforward postings.
Resolution
To check if the reason for the difference between the ARP report and the Financial Statements or G/L Accounts - Line Items report is a posting without subledger involvement:
- Navigate to the General Ledger workcenter and there to the Reports-List view.
- Select the G/L Accounts – Line Items report.
- Maintain the same variables as per the ARP report. Do not maintain any value in the Closing step field.
- Press Go.
- Add the key figure Balance Company Currency by pressing Settings – Keyfigures, moving this key figure to Selected and pressing OK.
- Now add the characteristic Subledger Account Type to the rows and move this characteristic to the first place of all row characteristics.
- In the Edit Filter tab, filter for the respective G/L account.
- Press Go.
- Check the amount displayed in the Balance Company Currency column for the subledger account type Without Subledger. It will display the difference between the ARP report and the other balance report.
- Then check the total amount displayed for subledger account type Accounts Payable/ Receivable. It will display the total result of your ARP report.
- Therefore the reason for the difference between the report is that there have been postings executed without subledger involvement, such as manual journal entry voucher postings or balance carryforward postings. These are not considered in the ARP-open items reports.
If the report does not display postings without subledger involvement but there is still a difference between the ARP report and the balance reports, open a case to have SAP Support checked the difference.
Keywords
accounts receivable; accounts payable; open items; financial statement , KBA , trial balance difference ap balance , trial balance , accounts payable , accounts receivable trial balance , accounts payable - trial balance , SRD-FIN-GL , General Ledger , How To