Symptom
- The Cumulative Totals Calculated check box is not checked even when the action Calculate Cumulative Year Totals is executed.
- The error 'Difference in accounting and logistics inventories' is observed in the Results tab of the Background Job.
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to the General Ledger work center.
- Go to the Sets of Books and Assigned Companies view.
- Select the respective Company and choose Edit Fiscal Years.
- Select the Fiscal Year YYYY ('YYYY' represents the Fiscal Year) and choose the option Calculate Cumulative Year Totals.
- The following message is displayed:
Cumulative total calculation run started in background
Your entries have been saved. - But the Cumulative Totals Calculated check box is not checked.
- Now, go to the Application and User Management work center.
- Go to the Background Jobs view.
- Select All Jobs run in last Week from the dropdown menu.
- Search for and select the respective run ID created and choose View Application Log.
- Navigate to the Results tab and the error 'Difference in accounting and logistics inventories' has occurred.
Cause
To check why this difference has occurred, execute a Reconciliation Run.
- Go to the General Ledger work center.
- Go to the Reconciliation view.
- Select New > Reconciliation.
- Enter the relevant details and select the option Inventory in the Subledger Selection section.
- Select Start Now and open the Display Log.
- Go to the Inventory tab and Accounting with Logistics sub-tab.
- An absolute difference can be observed and in the Message tab, the following error can be observed:
"Accounting and logistics inventories differ: material XXX business residence YYY"
Note: XXX refers to the Material ID and YYY refers to the Business Residence ID.
The error occurs because there is an unposted Goods and Activity Confirmation.
Resolution
The unposted document in the Source Documents view of the General Ledger work center has to be posted.
See Also
Keywords
Calculate Cumulative Year Totals, Cumulative Totals Calculated, Not Checked, Background Jobs, Difference in accounting and logistics inventories. , KBA , SRD-FIN-GL , General Ledger , How To