SAP Knowledge Base Article - Public

3589834 - "Cumulative Totals Calculated" Checkbox Not Checked Despite Executing "Calculate Cumulative Year Totals" Action

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

  1. Go to the General Ledger work center.
  2. Go to the Sets of Books and Assigned Companies view.
  3. Select the respective Company and choose Edit Fiscal Years.
  4. Select the Fiscal Year YYYY ('YYYY' represents the Fiscal Year) and choose the option Calculate Cumulative Year Totals.
  5. The following message is displayed:
    Cumulative total calculation run started in background
    Your entries have been saved.
  6. But the Cumulative Totals Calculated check box is not checked.
  7. Now, go to the Application and User Management work center.
  8. Go to the Background Jobs view.
  9. Select All Jobs run in last Week from the dropdown menu.
  10. Search for and select the respective run ID created and choose View Application Log.
  11. 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.

  1. Go to the General Ledger work center.
  2. Go to the Reconciliation view.
  3. Select New > Reconciliation.
  4. Enter the relevant details and select the option Inventory in the Subledger Selection section.
  5. Select Start Now and open the Display Log.
  6. Go to the Inventory tab and Accounting with Logistics sub-tab.
  7. 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

1820205 - Reconciliation Report Shows Error: Accounting and logistic inventories differ: Material ABC Business residence DEF (GHI)

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

Product

SAP Business ByDesign all versions