1684651 - Inventory Revaluation when Item Cost is managed by Company

Symptom

 When a company runs Perpetual Inventory and the setting Manage Item Cost per Warehouse is not selected (in Administration > System Initialization > Company Details > Basic Initialization tab), the Item Cost calculation is based on transactions in all warehouses and should be equal in all warehouses at any given time. Therefore, when an inventory revaluation document (MRV) is added, inventory revaluation will affect inventory in all warehouses.

Remark: For items managed by the Serial/Batch evaluation method (available from version 9.1), the batch or serial number cost will be managed on the Company level, even if Manage Item Cost per Warehouse is selected in Basic Initialization.

Therefore, when an inventory/material revaluation document (MRV) is added:

• For the Moving Average (MAP) evaluation method, inventory revaluation affects item inventory in all warehouses, no matter which warehouse is chosen in the MRV line. Also, MAP should be equal in all warehouses at any given time.
• For the Standard (STD) evaluation method, inventory revaluation affects item inventory in all warehouses, no matter which warehouse is chosen in the MRV line. Also, the STD price should be equal in all warehouses at any given time.
• For items managed by serial or batch numbers and the Serial/Batch evaluation method, inventory revaluation affects selected serial/batch inventory/cost in all warehouses, no matter which warehouse is chosen in the MRV line. Also the serial/batch cost price should be equal in all warehouses at any given time.
• For the FIFO evaluation method, revaluation affects selected FIFO layer open inventory.

When Set G/L Accounts By in Item Master Data is set to Warehouse or Item Level:

1. a) The inventory transaction will be assigned to the warehouse chosen in the MRV line.
2. b) The inventory transaction will be posted to the inventory account linked to the warehouse chosen in the MRV line and set in the Warehouses-Setupor Item Master Datawindow, respectively.
3. c) The transaction value will reflect the change in stock value in all warehouses.
4. d) In the journal entry, only the inventory account linked to the warehouse chosen in the MRV line will posted. The posted amount will reflect the change in stock value in all warehouses (that is, the amount for value change in all warehouses will be posted to the same account, even though different accounts are linked to different warehouses).

When Set G/L Accounts By in Item Master Data is set to Item Group:

1. a) The inventory transaction will be assigned to the warehouse chosen in the MRV line.
2. b) The inventory transaction will be posted to the inventory account linked to the item group to which the revaluated item belongs.
3. c) The transaction value will reflect the change in stock value in all warehouses.
4. d) In the journal entry, the inventory account linked to the relevant items group will be posted. The posted amount will reflect the change in stock value in all warehouses.

Example 1.

Prerequisites: The Manage Item Cost per Warehouse setting is not selected.

1. Item I001 is managed by the moving average valuation method (MAP); Set G/L Accounts By is set to Warehouse. Two warehouses, 01 and 02, are linked to the item. Inventory account 10001 is linked to warehouse 01, and inventory account 10002 is linked to warehouse 02. Current item cost price is 15, on-hand quantity in warehouse 01 is 10, and on-hand quantity in warehouse 02 is 20.
2. MRV with price change for item I001 is added, New Price is 17; warehouse 01 is chosen in the MRV line.

Result:
Inventory account 10001 is debited by amount 60=(17-15)*(10+20). The inventory transaction is assigned to warehouse 01.

Example 2:

Prerequisites: The Manage Item Cost per Warehouse setting is not selected.

1. Item I001 is managed by MAP; Set G/L Accounts By is set to Item Group. Item I001 belongs to the item group Materials. Inventory account 10003 is linked to item group Materials. Two warehouses, 01 and 02, are linked to the item. The current item cost price is 15, on-hand in warehouse 01 is 10, and on-hand in warehouse 02 is 20.
2. MRV with price change for item I001 is added, New Price is 17; warehouse 01 is chosen in the MRV line.

Result:
Inventory account 10003 is debited by amount 60=(17-15)*(10+20). The inventory transaction is assigned to warehouse 01.

Example 3:

Prerequisites: The Manage Item Cost per Warehouse setting is selected.

1. Item I001 is managed by batch numbers and the serial/batch valuation method; Set G/L Accounts By is set to Warehouse. Two warehouses, 01 and 02, are linked to the item. Inventory account 10001 is linked to warehouse 01, and inventory account 10002 is linked to warehouse 02.
2. Add a goods receipt for item I001, quantity 30, price 15, to warehouse 01; create a new batch B0001, quantity 30 for this receipt.
3. Create an inventory transfer from warehouse 01 to warehouse 02: item I001, quantity 20, and choose batch number B0001 for all 20 units. Batch B0001 quantity in warehouse 01 is now 10, and in warehouse 02 it is 20, overall 30 units for the batch.
4. Create an MRV with price change for item I001, while warehouse 01 is chosen in the MRV line. Choose batch B0001 in the Serials/Batches table. Set New Price to 17 for batch B0001.

Result:
Inventory account 10001 is debited by amount 60=(17-15)*(10+20), that is, the inventory account used in the journal entry of the A/P invoice is account 100001. The inventory transaction is assigned to warehouse 01.

Cause

Functionality Description

Solution

This is correct system behavior.