Adjusting Inventory costs in Sage MAS 90 / MAS 200
Sometimes it may be necessary to adjust the unit cost information for items already recorded into inventory.
Standard Cost:
For Standard Cost items, although the standard cost can be manually changed within Inventory Maintenance, this change will not update the inventory value in General Ledger. Using an adjustment to bring the total quantity (for all warehouses) to 0 at the current (incorrect) standard cost will bring the total quantity and total value in inventory to 0. At that time, you can manually change the standard cost within the Inventory Masterfile and adjust the total quantity back in at the new standard cost. This transaction will update General Ledger with the new inventory value.
The Automatic Cost/Price Change utility can also be used to update the standard cost for ranges of items. This utility does not update the general ledger. A G/L Journal Entry will need to be made for the difference in inventory value. The Inventory Valuation Report should be printed before and after the change and then used to make adjustments in General Ledger.
The ‘Cost Roll up Register’ can also be used to change the Standard cost if the item has a bill of material.
Average Cost:
To change average cost, the total quantity in all warehouses needs to first be adjusted out at the current (incorrect) average cost. This adjustment will reduce the inventory quantity and value to 0. Once the inventory has a $0 value, the same quantity can be adjusted back in at the correct average cost. This transaction will update General Ledger with the new inventory value.
LIFO, FIFO, Lot, and Serial:
The negative and positive adjustments must be made to the same cost tier (i.e. the receipt date and reference for LIFO/FIFO or lot/serial number for lot/serial items) by clicking the distribute (‘Distrib’) button on the Transaction Entry Lines tab and distributing the quantities to the correct cost tier. In other words, for a FIFO item, if the cost was incorrect on a particular FIFO tier, the negative adjustment would be entered for the quantity in that tier at the current (incorrect) cost and then distributed back to that tier with the correct cost
Note: For Serial / Lot items, you must first update the negative adjustment before entering the positive adjustment. For the other valuation methods, the negative adjustment and positive adjustment can be within the same update.
When entering the Inventory Adjustment transactions:
On the ‘Lines’ tab, select the ‘Item Number’ to be corrected.
Enter ‘Quantity’ as a negative number that will relieve the total quantity on hand for the warehouse selected.
If the items has LIFO, FIFO, Lot, or Serial valuation, select the tier to be adjusted.
The old (incorrect) cost will populate the ‘Unit Cost’. Click ‘OK’.
Create a 2nd entry by selecting the same ‘Item Number’ to be corrected.
Enter ‘Quantity’ but as a positive number that will add the same quantity back to the total quantity on hand for the warehouse selected.
If the items has LIFO, FIFO, Lot, or Serial valuation, select the tier to be adjusted (or a new tier can be created).
Enter the new (correct) cost for the ‘Unit Cost’. Click ‘OK’.
Print the Inventory Transaction Journal, confirming the correct Inventory Management Posting Date before printing.
Update the Inventory Transaction Journal.
Print the Daily Transaction Register. Note: the difference between the original cost and the new cost is posted to the Inventory Adjustments G/L account for the product line in Inventory Management / Setup / Product Line Maintenance.
Update the Daily Transaction Register.
For additional info, see Sage Knowledgebase Resolution ID: 405107