Question Status

Suggested Answer
Hilal Uddin asked a question on 13 Nov 2012 6:28 AM

Hello!

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.

Regards,

Hilal Uddin

IT Project (ERP) Manager

Cermic Pipes Co.

Riyadh - K.S.A

Reply
Suggested Answer
Leslie Vail responded on 13 Nov 2012 9:28 PM

Use the Change Decimal Places Utility on the Inventory Area Page.

Leslie Vail, CPA, MVP, MCT, MCITP, MCP, MCITS
ASCI, Inc.    *    PO Box 600965   *   Dallas, TX 75360    *   972-814-8550   *   leslievail@earthlink.net

Reply
Suggested Answer
Arnold Marquez responded on 21 Mar 2013 10:27 PM

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'

Note that

1 - 0 decimal place

2 - 1 decimal place

3 - 2 decimal places

4 - 3 decimal places

5 - 4 decimal places

6 - 5 decimal places

Reply
Suggested Answer
Mohammad Daoud responded on 13 Nov 2012 7:30 AM

Hilal,

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 ***

Regards,

 

Mohammad R. Daoud MVP-MCT

Have you seen the GP Excel Paste yet? http://di.jo/GPExcelPaste.aspx

Reply
Suggested Answer
Leslie Vail responded on 13 Nov 2012 9:28 PM

Use the Change Decimal Places Utility on the Inventory Area Page.

Leslie Vail, CPA, MVP, MCT, MCITP, MCP, MCITS
ASCI, Inc.    *    PO Box 600965   *   Dallas, TX 75360    *   972-814-8550   *   leslievail@earthlink.net

Reply
Hilal Uddin responded on 13 Nov 2012 9:28 PM

Dear Mohammad

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.

Regards,

Hilal Uddin

Reply
Leslie Vail responded on 13 Nov 2012 11:01 PM

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?

Kind regards.

Leslie

Leslie Vail, CPA, MVP, MCT, MCITP, MCP, MCITS
ASCI, Inc.    *    PO Box 600965   *   Dallas, TX 75360    *   972-814-8550   *   leslievail@earthlink.net

Reply
Suggested Answer
Arnold Marquez responded on 21 Mar 2013 10:27 PM

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'

Note that

1 - 0 decimal place

2 - 1 decimal place

3 - 2 decimal places

4 - 3 decimal places

5 - 4 decimal places

6 - 5 decimal places

Reply