Posted by: istewart | 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.

About these ads

Responses

  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.

    David
    http://blogs.msdn.com/DevelopingForDynamicsGP/

  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:

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

Categories

Follow

Get every new post delivered to your Inbox.

Join 25 other followers

%d bloggers like this: