Unit Cost digits after decimal places from 2 to 3

(0) Share

Report

Posted on by Community Member

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

*This post is locked for comments

I have the same question (0)

All responses (13)

Answers (0)

Suggested answer

Community Member on at

Like (0)

Report

Re: Unit Cost digits after decimal places from 2 to 3

Hilal,

The decimals for unit cost is linked to the currency, you will need to increase the currency decimals.

Was this reply helpful? Yes No
Suggested answer

L Vail 65,271 on at

Like (0)

Report

Re: Unit Cost digits after decimal places from 2 to 3

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Re: Unit Cost digits after decimal places from 2 to 3

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

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report

Re: Unit Cost digits after decimal places from 2 to 3

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

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

RE: Unit Cost digits after decimal places from 2 to 3

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Unit Cost digits after decimal places from 2 to 3

I just completed a change to the number of decimals on one billing item using Arnold's suggestion below in regards to using GP's built in utility. This worked as I hoped it would. Thank you!

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Unit Cost digits after decimal places from 2 to 3

Glad that my suggestion works best for you :)

Was this reply helpful? Yes No
Shahid.Ahmed 170 on at

Like (0)

Report

RE: Unit Cost digits after decimal places from 2 to 3

Dear Arnold,

I have used the option (Microsoft Dynamics GP > Tools > Utilities > Inventory > Change Decimals Places) but it does not change the item unit cost decimal in PO and Receiving transaction screen.

Kindly advise.

Regards,

Shahid

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report

RE: Unit Cost digits after decimal places from 2 to 3

Hi Shahid,

I think I responded to this on another thread, but your post confuses me. I took an item set for 2 currency decimal places, changed it to 3 decimal places and then created a PO for that item. The PO reflected 3 decimal places. Did you have any existing transactions at the time you ran through the decimal place change?

Kind regards,

Leslie

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Unit Cost digits after decimal places from 2 to 3

Hi Shahid,

Normally, items which already have an existing Purchase Order or Sales Order Transaction could not be updated using the available option in GP.

In this case, you have you have no other alternative, but to use the unconventional method to effect your desire changes.

To start;

First, Make a complete backup of the database you want to update.

Secondly, you need to know which tables that have the DECPLCUR as a column name. Use the below script;

SELECT * FROM sysobjects o, syscolumns c

WHERE o.id = c.id AND o.type = 'U' AND c.name = 'DECPLCUR'

ORDER BY o.name

Next create a script to update the value from DECPLCUR column. For example,

Update IV00101 set DECPLCUR = '3' where ITEMNMBR = 'ITEMCODE'

Lastly, Change will only affect the transaction which are not yet posted. Historical transactions will not be affected.

Hope this helps.

Arnold

Was this reply helpful? Yes No