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
Dear Leslie,
Correct me if I am wrong. By open I that the PO transactions for that item which are not received completely through Receiving Transaction Entry.
Regards,
Shahid
Hi Lesile,
Appreciated your reply.
When I run the utility. The report displays following message :
"Item exists on Purchase Order Processing transactions and could not be
updated."
Though I have checked the PO for this item, I did not find any open PO.
Please advise.
Regards,
Shahid Ahmed
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
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
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
Glad that my suggestion works best for you :)
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!
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (