During our data migration, the valuation method for our MRO inventory parts was set wrong.  It was set to FIFO and we wanted Weighted Average.  We have 8500 parts set incorrectly.

My thought was:

1. Migration job to zero our inventory
2. Migration job to reset the valuation method
3. Migration job to replace inventory

However, I am not sure if this will work with all the connections within IFS to other tables (Inventory On Hand, Costs, etc).

Is this doable or is there a better way to do this?