Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Currency Decimal changed inadvertently to 3 from 2

Posted on by Microsoft Employee

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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    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

  • Suggested answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    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

  • Verified answer
    Justin Thorp Profile Picture
    Justin Thorp 2,265 on at
    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

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at
    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.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    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

  • Suggested answer
    Justin Thorp Profile Picture
    Justin Thorp 2,265 on at
    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,134 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,928 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans