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

When executing the reconciliation report, error message 'Accounting and logistic inventories differ: Material ABC Business residence DEF (GHI)' is displayed.

ABC means the Material ID.

DEF means the Business Residence ID.

GHI means the Business Residence description.

SAP Business ByDesign.

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.

Error message: Accounting and logistics inventories differ: material ABC busines resid DEF (GHI)

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

To check this, 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 and 94 - Production Confirmation not posted in accounting.
5. Click Go and select the appropriate row.

In the messages area of the screen, the error message is displayed: "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.

To resolve this error, the maintained Account Determination Group for each material appearing in the error message must be identified:

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, the Account Determination Group maintained for material ABC can be found.

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 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 maintaining 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 and 94 - Production Confirmation not posted in accounting.
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.

reconciliation run; materials; inventory; accounting; logistics; gac; goods and activity confirmation , KBA , SRD-FIN-INV , Inventory , AP-IP-INV , Inventory , How To