18,265
Hello Friends,
Customer has z-US$ setup as Functional Currency with 3 decimal. It is causing lot of issue because of 3 decimals. Can any one guide me how to decreased the Functional Currency from 3 to 2. How will get decimal difference effect from 3 to 2? what are the other things need to consider?
Thanks much
Sandip
Thanks so much David. Much appreciated for your quick reply.
The truncation of the 3rd digit for existing data was the expected side effect. Which was the concern I raised right at the start.
If you are happy to live with that, you are done.
Regards
David
Hello All,
I have done the functional currency Z-US$ decimal change from 3 to 2 with the below update query
Update DYNAMICS..MC40200 set DECPLCUR=3 where CURNCYID='Z-US$'
After that ran Reconciliation and checklink on almost each module. I don't see any big change in $ Amount. Only the third decimal is truncated in the report whereas GP Tables still hold 3 decimal places. New Transactions are with 2 decimal places.
I don't see any issue; Finance people are okay with a truncating decimal place which has less than a $1 difference.
I want to know your view if you see any potential issues in Dynamics GP. Please advice.
Thanks much
Sandip
Hello David,
Much appreciated for your detail explanation.
Thanks much
Sandip
Hi Sandip
Changing the setting in the Setup and Item Master tables from 3 to 2 is fairly easy using SQL as you can’t change it via the User Interface.
The issue is that any transactions already entered will probably not change. This is because the currency index is already stored on the transaction with the original decimal places.
If you want to update historical transactions it is possible but complex because you will need to zero out the third decimal place. You don’t want a value other than zero in the third decimal place once it is no longer visible. This means that your transactions and distributions and GL data could end up with rounding errors.
Starting a new company will be the cleanest approach with the least chance of anything going wrong.
Just my thoughts.
David
If you change decimal place from 3 to 2, GP WILL NOT allow you to do it, you will receive the following error:
I find a way to change back to 2 decimal by running the following statement:
update DYNAMICS..MC40200 set DECPLCUR=3 where CURNCYID='Z-US$'
Posted journals will still remain with 3 decimals, the new one will have two as I tested.
I recommend you try it on a test server first, make sure everything works before you update on your live server.
Hope it works for you.
Rob Yao
Hello Sandip,
If transactions have been posted using the three decimal places, you cannot change this. There are only two options for this issue.
Unfortunately, these are our only supported options when it comes to this scenario.
You can also review the Forum below that also asked this question previously.
(+) Change USD from 5 decimal place to 2 - Microsoft Dynamics GP Forum Community Forum
I hope this helps!
Thank you!
Brandon | Microsoft Support Engineer.
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,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (