SAP Knowledge Base Article - Public

1820205 - Reconciliation Report Shows Errors : Accounting and logistic inventories differ : Material MMM Business residence XXX (AAA).

Symptom

When you execute the reconciliation report you are getting error message : Accounting and logistic inventories differ : Material MMM Business residence XXX (AAAA).

Reproducing the Issue

  1. Navigate to General Ledger and select Reconciliation.
  2. Select the Reconciliation Report which shows error and Click on Log Result.
  3. Navigate to Messages tab.

Here you can see the error : Accounting and logistics inventories differ: material MMM busines resid XXX (YYY)

Cause

There are some documents of type "55 - Goods and activity confirmation" are not posted in the accounting.

To check this, you can follow the below mentioned steps.

  1. Navigate to General Ledger and select Source Document.
  2. Show Unposted Source Documents.
  3. Click on Advance and Select Related Source Document Type as 55 - Goods and Activity Confirmation.
  4. Click On Go and select the appropriate row.

In the messages area of the screen you can see the error message : "Account determination is missing for position type Physical Inventory / Inventory Differences. Specify account determination in chart of accounts AAA and account determination profile BBB Column Path Inventories->Physical Inventory->Loss from Inventory Diff..., Position Type Physical Inventory / Inventory Differences."

Due to this Unposted Source Document Inventory Difference in accounting and logistic inventories Occured.

Resolution

To resolve this error you need to identify maintained Account Determination Group for each material which appears in the error message.

Step 1.

  1. Navigate to Product Portfolio and select by material.
  2. Show All materials and search for the material MMM.
  3. Click On material ID to open and view.
  4. Click On View all and Navigate to Valuation.

Here you can find the Account determination group for the material MMM.

Step 2.

  1. Go to Business configuration and select Implementation Project.
  2. Click on Open Activity List and navigate to Fine Tune.
  3. Search for activity Charts of Accounts, Financial Reporting Structures, Account Determination.
  4. Click on Inventories under the Account Determination section of screen
  5. Select Account determination profile BBB.
  6. Go to Physical Inventory sub tab.
  7. Maintain the appropriate data for the Account determination Groups you found in the Step 1.

Follow Step 1 and Step 2 for all materials appear in the Reconciliation report error message :  Accounting and logistics inventories differ: material MMM busines resid XX.

After you maintain the data please follow the below steps to post the unposted source documents.

  1. Navigate to General Ledger and select Source Document.
  2. Show Unposted Source Documents.
  3. Click on Advance and Select Related Source Document Type as 55 - Goods and Activity Confirmation.
  4. Click On Go and select the appropriate row.
  5. Click on Action and select Post Business Transaction.

Once Source document is posted successfully, Execute the Reconciliation again.

Keywords

KBA , LOD-CRM-EMP , Employee , How To

Product

SAP BUSINESS BYDESIGN 1708 ; SAP Business ByDesign 1302 ; SAP Business ByDesign 1305 ; SAP Business ByDesign 1308 ; SAP Business ByDesign 1311 ; SAP Business ByDesign 1402 ; SAP Business ByDesign 1405 ; SAP Business ByDesign 1408 ; SAP Business ByDesign 1411 ; SAP Business ByDesign 1502 ; SAP Business ByDesign 1508 ; SAP Business ByDesign 1602 ; SAP Business ByDesign 1605 ; SAP Business ByDesign feature pack 4.0