Dynamics GP - Force-Changing Item Valuation Methods

IV00101 - Item Master
VCTNMTHD - Valuation method 1 - FIFO, 3-Average

If you have any open sales orders, it will prevent the change valuation routine from running.

You can work around this issue using the following method

https://dynamicsuser.net/gp/f/users/40649/inventory-valuation-change

• This method is not perfect, and may cause costing errors in the future. If the cost of your stock needs to be accurately maintained, all stock should be removed, valuation changed, then re-entered
• This method should not be used in a production environment
• Backup the current sop10200 table to track the original amounts and data
• select * into sop10200_bak from sop10200
• Backup the current iv00102 table to track original allocated amounts
• select * into iv00102_bak from iv00102
• Set all sop lines to non-inventory
• Update sop10200 set NONINVEN = 1
• Remove all allocated stock temporarily
• update sop10200 set atyalloc = 0
• update iv00102 set ATYALLOC = 0
• Zero out all stock using inventory adjustments
• Run Valuation Change Utility
• Put back in all stock using inventory adjustments
• Set the allocation back to the original values 
• update sop10200 set sop10200.atyalloc = sop10200_bak.atyalloc inner join sop10200_bak on sop10200_bak.dex_row_id = sop10200.dex_row_id
• Set the non-inventory flag back to original values
• update sop10200 set sop10200.noninven = sop10200_bak.noninven inner join sop10200_bak on sop10200_bak.dex_row_id = sop10200.dex_row_id
• Set the allocated qty back to original values
• update iv00102 set iv00102.atyalloc = iv00102_bak.atyalloc inner join iv00102_bak on iv00102_bak.dex_row_id = iv00102.dex_row_id
• Run reconcile and check links on everything