We have two digit after decimal places for the unit cost in the P.O entry form , due some requirements we need to have three digits after decimal places. How to change this? If some one knows kindly post answer for this . I will be very thankful.
IT Project (ERP) Manager
Cermic Pipes Co.
Riyadh - K.S.A
The decimals for unit cost is linked to the currency, you will need to increase the currency decimals.
*** If my answer resolved you issue, please verify the answer to make it easy for other users who has the same case ***
Mohammad R. Daoud MVP-MCT
Have you seen the GP Excel Paste yet? http://di.jo/GPExcelPaste.aspx
Use the Change Decimal Places Utility on the Inventory Area Page.
Leslie Vail, CPA, MVP, MCT, MCITP, MCP, MCITSASCI, Inc. * PO Box 600965 * Dallas, TX 75360 * 972-814-8550 * email@example.com
The currency decimal already set to 3 digits ,item class decimal are in 3 digits , and item Unit of measurement decimal palaces are also in 3 digits . But still the item unit cost appears in the 2 decimals.
On the Item Card, what are the settings? Also, are you talking about the number of decimals showing on the screen or printing on the invoice, or both?
There are actually two ways to change the currency decimal of the item; one can be accomplished using the GP's built in utility --> Microsoft Dynamics GP menu - Utilities - Inventory - Change Decimal Places. The other is by using SQL scripting:
Example: Update to 5 Decimal Places, the Update statement is:
Update IV10001 set DECPLCUR = '6' where ITEMNMBR = 'CURRENCY'
1 - 0 decimal place
2 - 1 decimal place
3 - 2 decimal places
4 - 3 decimal places
5 - 4 decimal places
6 - 5 decimal places