Hi All,
Sorry for all the questions lately. In the middle of a rough roll out.
The owner iandvertently changed the company's Currency to 3 decimals from 2. We need to change it back. Only once check was run against the new currency format and has since been voided. When we try to downgrade the decimals back to 2 we get an error:
"The number of decimal places for a currency canot be decreased once the currency has been saved".
I've been looking at a number of posts on the topic but they seem old and not necessarily pertinent to the current GP2013R2.
Can someone help?
THanks,
Gus
*This post is locked for comments
Hi Justin,
Sorry for the late reply. I've been testing that no adverse issues arrose as a result. And, it turns out it worked without issue.
Thanks again for the input.
Gus
Nothing more valuable at all than what's mentioned above. Just a previous thread with the similar issue Dynamics GP2010 Currency Decimal point
Yes, Frank is right, I was only using GBP as an example. Please use the currency ID appropriate to your installation.
There "shouldn't" be any issues if the only transaction you've posted is the 1 check (and it's corresponding void).
Even if you did post other transactions, there "shouldn't" be any issue as long as the only value in the 3rd decimal place was 0.
Now, of course, I cannot make any guarantees, hence my recommendation to make a backup and thoroughly test. From past experience though, I don't foresee any issues.
Another option I suppose is to restore a backup to the point in time prior to this inadvertent change...but I presume that isn't possible/feasible given you asking the question.
I hope this advice helps,
Justin
Are there any other transactions in the system or just the 1 check? I think Justin was using GBP as an example. The currency ID value would be whatever your functional currency is.
Hi Justin,
Thanks for the suggestion.
1. Would the only repercussions on the installed companies be that the currencies/inventory quantities are truncated. Or would there be more systemic issues, i.e., sysstem stability arrising from this change back to 2 Decimals?
2. GBP? We are in the US.
Thanks again,
Gus
Hi,
My recommendation is:
1.) Make the revelevant backups
2.) Update the number of decimal places using SQL. Here is an example of the statement:
update MC40200
set DECPLCUR = 3 --This actually equates to 2 decimal places
where CURNCYID = 'GBP'
3.) Test thoroughly to make sure everything is working as expected.
Thanks,
Justin
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,134 Super User 2024 Season 2
Martin Dráb 229,928 Most Valuable Professional
nmaenpaa 101,156