http://wavelet.asia/customer-portal/?p=7806
- Inventory > Maintenance > Reset MA
- RESET MA stands for Reset Moving Average Cost.
- Select a PC Center and enter the Item Code, click 'Retrieve Stock'.
- The item last unit cost and moving average cost will be listed in a table.
- Enter the New Moving Average Price and a reason for resetting the moving average.
Reset Average Cost of the Stock
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