Inventory Valuation Change Utilities in Sage 100

Overview of valuation change utilities

The Inventory Valuation Change Utilities in Sage 100 let you change an item’s valuation method. You can switch between Standard, Average, FIFO, LIFO, Lot, and Serial methods.

Note: Kit items support only Average cost, FIFO, or LIFO valuation methods.

Change valuation to standard, average, FIFO, or LIFO

Steps to update valuation method

Open Inventory Management, Utilities, Item Valuation Change Selection.
Select a Product Line or an Item.
Choose the new valuation method: Standard, Average, FIFO, or LIFO.
Print the Inventory Valuation Change Register.
Update the Inventory Valuation Change Register.

Change valuation to lot or serial

Prepare inventory for change

Use Inventory Transaction Entry to reduce quantity to zero in every warehouse.

Complete valuation change

Open Inventory Management, Utilities, Item Valuation Change Selection.
In Valuation Selection, choose Product Line or Item.
Select the new valuation method: Lot or Serial.
Print the Inventory Valuation Change Register.
Update the Inventory Valuation Change Register.

Restore inventory quantities

Use Inventory Transaction Entry to add the item back into stock.

Change individual items directly

Use maintenance option

Open Item Valuation Change Maintenance to update individual items directly.

Important considerations

Ensure all transactions are complete before starting the process.
Verify inventory quantities before and after the valuation change.

Tip: Always review the register before updating to confirm changes.