Sage 100 Inventory Valuation Change

Disclaimer

Use caution when working with the below product functionality. Always create a backup of your data before proceeding with advanced solutions.

Resolution

Note: Kit items can only have one of the following valuation methods: Average cost, FIFO, or LIFO

Use Inventory Management, Setup, Inventory Management Utilities to change an inventory item’s valuation method.

To change the valuation method to Standard, Average, LIFO, or LIFO:

  1. Open Inventory Management, Setup, Inventory Management Utilities, Item Valuation Change Selection.
  2. Select a Product Line or a Item, and the new valuation (standard, average, LIFO, FIFO).
  3. Print and update the Valuation Change register.

To change valuation method to Lot or Serial:

  1. Use Inventory Transaction Entry to adjust the quantity down to zero in every warehouse.
  2. Open Inventory Management, Setup, Inventory Management Utilities.
  3. In Valuation Selection, select Product Line or Item, and the new valuation (Lot, Serial).
  4. Print and update the Valuation Change register
  5. Use Inventory Transaction Entry to adjust the item back into stock.

NOTE:  To change individuals items, you may go directly to Item Valuation Change Maintenance.

Support

If necessary, seek the assistance of Acute Data Systems to help provide assistance with this process.