Posted by: IS | July 30, 2009

Updating Inventory Decimal Places through SQL

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.


  1. 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.


  2. 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… 🙂

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s


%d bloggers like this: