Unit Cost digits after decimal places from 2 to 3

This question has suggested answer(s)

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

All Replies
  • 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

  • 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

  • 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

  • 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

  • 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