You’re offline. This is a read only version of the page.
32,738
I am doing a test on changing the currency decimals (Microsoft Dynamics GP 10), modules is setup to accept (2) decimals for the US $ (which is not the functional currency in the System), Although, there is an urgent need to increase the number of decimals up to 3 or 4.
I have read the knowledge base article KB930346 | How to change the currency decimal places or quantity decimal places in Manufacturing in Microsoft Dynamics GP. It seems that there is no such risk with changing the currency on the (Historical or Open) transactions specifically. But still, I am quite hesitant as further test is required.
That's why I am posting a question here regarding changing the currency decimals so that I could gain further knowledge on this issue.
The KB article points out the following;
Another path. Microsoft Dynamics GP > Tools > Utilities > Inventory > Change Decimals Places
Although, the article points that in order to reflect the changes on manufacturing, an SQL script shall be run on CT00102 (IC_COST_IV_Item_MSTR) ?
On the other hand, the KB article doesn't mentioned the currency setup windows at all
On this path, Microsoft Dynamics GP > Tools > Setup > Currency . Under Currency = USD , Separator > Decimals
So, in order to change the currency decimals, should i go to scenario on (Utilities and CT00102) OR the currency setup .. or both ?
Please provide me with any further required information in order to have a clear understanding of the effects of such change.
*This post is locked for comments
Hi Gloria,
I have ran into a similar problem as above...the system currency was changed to 3 decimal places and now our checks are printing with 3 decimal places. I need to get it back to 2. I'm not concerned with any values in the system being messed up as we do not use that 3rd decimal place for anything. I don't even really care if the decimals for the products are different than what prints on the checks. This was only changed 2 weeks ago so there really shouldn't be anything in the system that is using all three. I've tried changing the decimal places through the inventory module as suggested by another user but that only changed the items...not the system. How do I change the over all system? Or at least how do I change the checks back to 2?
thanks,
Jen
I really appreciate your help Ms. Gloria, That was exactly the answer that I was looking for.
Although, Just to make a point clear, the second way is excluded not because I am not adept to SQL, it is just that I don't prefer the hard-coded way ... "Simplicity is the secret"
Thanks
Best Regards,
Mahmoud Saadi
Using the utility will just change the item decimal points and the effect is in just the distribution series: I'VE SOP POP. On a PO for example, the line item extends with 4 decimals but ultimately the PO rounds to 2 decimal points for the total. This is the desirable effect. That's why you set up multi currency rounding accounts for those little adjustments in the GL.
If you're not adept at SQL scripts, I'd definitely stick with the utility. It keeps the whole process and any after effects under support also.
Thanks for your prompt and comprehensive replies. Though, I still have certain point to be clarified.
According to Mr. Mariano Gomez in the article "From the newsgroups: Changing item currency decimal places", he indicates that there are two ways in changing the currency decimal places of the item, which are briefly as follows;
Reference: dynamicsgpblogster.blogspot.com/.../from-newsgroups-changing-item-currency.html
1- Change the currency decimal place using the Change Decimal Places Utility. (Recommended)
2- Changing the currency decimals without having to remove items from Work transactions and without having to change price lists (SQL Scripting)
The second way is clear that all the "DECPLCUR" fields will be updated in tables like (AAG2001T, BM10300, CM10100, CT00002, EXT40010, IV00101,IVC10101, MOP1004, POP10310, SEE30303, SOP30300, SVC05200 ... etc) and many other tables. This means that the change will encompass ALL the Modules (POP, SOP, IV .. etc)
This means, If I receive a shipment of ( Item X- Inventory Item) with a unit cost = $ 50.3421 , the decimals will be recorded in the following modules;
1- POP as a liability on the company for the vendor
2- IV as a cost liar
3- GL as a Financial effect.
Although, the second way is still not recommended for me which is why I still have a question about the first way. Would the first way (changing the currency using the decimal places Utility) have such effect on the modules (such as POP, IV, GL , SOP .. etc) ? Or the utility will help me have increased number of decimals places in the Inventory Module only (cost layers) ?
Looking forward to hearing from you. Meanwhile, I am working on my test environment to further clarify this point before making a final decision.
Your efforts are highly appreciated.
Best Regards,
Changing decimal places on an inventory item is substantially different than changing decimal places at the system level (at Tools>Setup>Currency). Making a currency decimal change at the system level can have significant impact. It will affect all companies with that currency, even to the level of how many decimals print on payables and payroll checks. Bank reconciliation will be extended out to the number of decimal points you set at the system level. Will your bank clear a check with 4 decimal points of USD? Not likely. It is near impossible to un-do once you have transactions like $5.0123, for example. The system will not regard this as $5.01 if you later attempt to change back to 2 decimal points. Develop an understanding of the effects of your contemplated change. Make the change at the lowest level required. If Item Currency Maintenance will meet your needs rather than changing the decimal points at the system level, that change is far more amenable. Consider a test environment in a virtual machine before changing your live system. A decade ago, a GP user made the system level change with USD to 4 decimal points. We completed an entire replacement of every currency field in their system via SQL scripting over 4 company databases. Microsoft Consulting wouldn't touch the project. We charged $17,000 to correct the situation. Be very careful. GloriaB
It is possible to increase the number of decimals but it is a pain. You need to locate ALL of the tables that contain a field LIKE CURDECML (it won't be the same in all tables. Also, note that in the tables the number is offset by one. The value of 1 stands for 0 decimals, the value of 3 stands for 2 decimals. Think of it as the number of the option in the pull down list (0,1,2,3,4 is represented in the table by 1,2,3,4,5)
KEEP BACKUPS and expect problems!
Any suggestions ?
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,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (