3450028 - Trial Balance Report Balance is Different Than Material Inventories - Balance History Report

The balance of G/L Account ABC shows different amounts when comparing Reports Trial Balance and Material Inventories - Balance History. (ABC stands for the G/L Account ID).

SAP Business ByDesign

To check the Trial Balance Report:

1. Go to Business Analytics Work Center.
2. Open Design Reports View.
3. Search and open Report Trial Balance.
4. Maintain the mandatory variable fields as well as the G/L account that you want to check.
5. Click Apply.
6. At the very bottom of the table a total result is displayed in the Ending Balance Company Currency column.
7. Leave the report open.

To check the Material Inventories - Balance History Report:

1. Go to Business Analytics Work Center.
2. Open Design Reports View.
3. Search and open Report Material Inventories - Balance History.
4. Maintain the mandatory variable fields as well as the G/L account that needs to be checked.
5. Click Apply.
6. The total result displayed in the Ending Balance Company Currency column is different to the Ending amount in the Material Inventories - Balance History Report.

Reports such as Material Inventories - Balance History does not take postings into account that have been executed without subledger involvement, such as Manual Journal Entry Voucher postings or Balance Carryforward postings.

To check if the reason for the difference between the Trial Balance and the Material Inventories - Balance History Report is a posting without subledger involvement:

1. Navigate to the Business Analytics work center and there to the Design Reports view.
2. Select the G/L Accounts – Line Items report.
3. Maintain the same variables as per the Trial Balance Report.
4. Hit Apply.
5. Add the key figure Balance Company Currency by pressing the cross sign "+" on the Column Fields in the report View.
6. Now add the characteristic Subledger Account Type to the rows and move this characteristic to the first place of all row characteristics.
7. In the Edit Filter tab, filter for the respective G/L account.
8. Hit Apply.
9. Check the amount displayed in the Balance Company Currency column for the subledger account type Without Subledger. It will display the difference between Trial Balance and the Material Inventories - Balance History Report.
10. 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 Material Inventories - Balance History Report.

1838469 - Accounts Receivable/Payable - Open Items Report Balance is Different to Financial Statement Report Balance

Material Inventories, Trial Balance, difference , KBA , SRD-FIN-ANA , Analytics Content , How To