Reset Average Cost of the Stock

When the cost of a specific item code needs to be adjusted, users could click on INVENTORY -> RESET MA.

RESET MA stands for Reset Moving Average Cost.

User are required to specify a PC CENTER and the item code when filling in the form because each PC Center many have stocks in multiple locations. When calculating the total quantity of existing stock balance, it will include all locations that belong to this PC Center.

Upon resetting the cost, the system will update the "inventory" and "inventoryVariance" General Ledger in the Accounting Module.

The amount to adjustment is calculated as below:

C2 = new cost

C1 = old cost

QTY = total quantity of the item in all locations for the same PC Center

ADJUSTMENT AMOUNT = (C2 - C1) x QTY