Recently I had to do this. Always best to use standard functionality where available (Tools >> Utilities >> Inventory >> Change Decimal Places)..but the following did the trick for a decimal increase…
update iv00105 set decplcur = 3 where itemnmbr = ‘insert Item Number’
update iv00101 set decplcur = 3 where itemnmbr = ‘insert Item Number’
Remember, you can’t change currency or quantity decimal places if there are any unposted transactions (SOP, POP, Inventory) for an item. Eithre delete or post these first.
If you’re decreasing the number of decimal places, all receipts are rounded, and all item records, purchase receipts, quantities, vendor information, and kits are updated. I you are increasing the decimapl places, zero’s get added to all amounts.
You can use this method to increase decimal places, but if you use it to decrease the decimal places you might end up with values stored in the tables with decimal places that are not displayed and are not zero. This is bad.
David
http://blogs.msdn.com/DevelopingForDynamicsGP/
By: David Musgrave on August 13, 2009
at 04:43
I can’t even begin to tell you how many times I’ve had to do that, along with adjusting PO lines table POP10110 and SOP lines table SOP10200…
By: Q Factor on March 8, 2012
at 15:01