SQL Script to change decimal places of Item Currency

This script changes decimal places of currency effective for an item. It must update the DECPLCUR column of 2 gp dynamics inventory table, IV00101 and IV00105 to complete the desired results.

To set to 2 decimal places, specify a value of "3" for DECPLCUR. For 3 decimal places use "4".. and so on..

UPDATE IV00105 SET DECPLCUR = 3

WHERE ITEMNMBR = 'XXX'

GO

UPDATE IV00101 SET DECPLCUR = 3

WHERE ITEMNMBR = 'XXX'