Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Changing Currency Deci...
Microsoft Dynamics GP (Archived)

Changing Currency Decimals

(0) ShareShare
ReportReport
Posted on by Mahmoud Saadi 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

  • Jennifer Lyons Profile Picture
    Jennifer Lyons 40 on at
    RE: Changing Currency Decimals

    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

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Changing Currency Decimals

    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

  • Verified answer
    GloriaB Profile Picture
    GloriaB 981 on at
    RE: Changing Currency Decimals

    That was IV SOP and POP. My iPad was trying to help too much with spelling

  • Verified answer
    GloriaB Profile Picture
    GloriaB 981 on at
    RE: Changing Currency Decimals

    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.

  • Verified answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Changing Currency Decimals

    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,

  • Verified answer
    GloriaB Profile Picture
    GloriaB 981 on at
    RE: Changing Currency Decimals

    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

  • Verified answer
    Richard Whaley Profile Picture
    Richard Whaley 25,195 on at
    RE: Changing Currency Decimals

    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!

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Changing Currency Decimals

    Any suggestions ?

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,910 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,782 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans