How to use the Inventory Valuation Change Utilities for Sage 100

Description

How to use the Inventory Valuation Change Utilities

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 the Inventory Valuation Change Utilities to change an inventory item’s valuation method.

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

1. Open Inventory Management, Utilities, Item Valuation Change Selection.
2. Select a Product Line or an Item, and the new valuation (standard, average, LIFO, FIFO).
3. Print and update the Inventory 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, Utilities, Item Valuation Change Selection.
3. In Valuation Selection, select Product Line or Item, and the new valuation (Lot, Serial).
4. Print and update the Inventory 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.