Scenario:
The user wants to change the costing method (e.g., from Average to FIFO, or to Standard) on an existing inventory item record but is unsure whether this can be done directly.
Solution:
Once a costing method is set on an inventory item record, the system does not allow it to be changed. This is a system limitation designed to maintain costing consistency and data integrity for historical transactions.
Workaround
If you need to switch the costing method for an item, here’s the recommended manual approach:
- Adjust Inventory to Zero:
- Go to Transactions > Inventory > Adjust Inventory.
- Create an inventory adjustment to reduce the on-hand quantity to zero for the item in all locations.
- Inactivate the Item Record:
- Edit the item record and mark it as Inactive.
- This preserves the history of the item without allowing future transactions.
- Create a New Item Record:
- Set up a new inventory item with the desired costing method (e.g., FIFO, LIFO, Average, or Standard).
- You can use a naming convention to relate it to the old item (e.g., "ItemName-FIFO").
- Set Opening Balances:
- Perform an Inventory Adjustment or use the Inventory Opening Balance feature to bring in your initial stock with the correct cost basis for the new item.
-----
If you find this information useful, let us know by reacting or commenting on this post!