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
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 * firstname.lastname@example.org
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
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
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?