Currency Decimal changed inadvertently to 3 from 2

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (6)

Answers (1)

Suggested answer

Justin Thorp 2,265 on at

Like (0)

Report

RE: Currency Decimal changed inadvertently to 3 from 2

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Currency Decimal changed inadvertently to 3 from 2

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

Was this reply helpful? Yes No
Frank Hamelly | MVP... 46,617 Super User 2025 Season 2 on at

Like (0)

Report

RE: Currency Decimal changed inadvertently to 3 from 2

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.

Was this reply helpful? Yes No
Verified answer

Justin Thorp 2,265 on at

Like (0)

Report

RE: Currency Decimal changed inadvertently to 3 from 2

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

Was this reply helpful? Yes No
Suggested answer

Mahmoud Saadi 32,738 on at

Like (0)

Report

RE: Currency Decimal changed inadvertently to 3 from 2

Nothing more valuable at all than what's mentioned above. Just a previous thread with the similar issue Dynamics GP2010 Currency Decimal point

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Currency Decimal changed inadvertently to 3 from 2

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

Was this reply helpful? Yes No