SAP Knowledge Base Article - Public

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

Symptom

When you execute the reconciliation report you are getting error message: Accounting and logistic inventories differ: Material ABC Business residence DEF (GHI).

ABC means the Material ID.

DEF means the Business Residence ID.

GHI means the Business Residence description.

Environment

SAP Business ByDesign.

Reproducing the Issue

  1. Navigate to the General Ledger work center.
  2. Select the Reconciliation view.
  3. Select the Reconciliation Report which shows error and click Log Result.
  4. Navigate to the Messages tab.

Here you can see the error: Accounting and logistics inventories differ: material ABC busines resid DEF (GHI)

Cause

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

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

  1. Navigate to the General Ledger work center.
  2. Select the Source Documents view.
  3. Show Unposted Source Documents.
  4. Click Advance and select Related Source Document Type as 55 - Goods and Activity Confirmation.
  5. Click 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 LMN and account determination profile OPQ Column Path Inventories->Physical Inventory->Loss from Inventory Diff..., Position Type Physical Inventory / Inventory Differences."

LMN means the Chart of Accounts.

OPQ means the Account Determination Profile.

Due to this Unposted Source Document, the Inventory Difference in accounting and logistic inventories occurred.

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 the Product Portfolio work center.
  2. Select Products -> By Materials view.
  3. Show All materials and search for the material ABC.
  4. Click material ID to open and view.
  5. Click View all and Navigate to Valuation.

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

Step 2:

  1. Go to the Business configuration work center.
  2. Select the Implementation Projects view.
  3. Click Open Activity List and navigate to Fine Tune.
  4. Search for activity Charts of Accounts, Financial Reporting Structures, Account Determination.
  5. Click Inventories under the Account Determination section of screen.
  6. Select Account determination profile OPQ.
  7. Go to Physical Inventory sub tab.
  8. 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 ABC busines resid DEF.

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

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

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

Keywords

reconciliation run; materials; inventory; accounting; logistics; gac; goods and activity confirmation , KBA , LOD-CRM-EMP , Employee , How To

Product

SAP Business ByDesign all versions