web
You’re offline. This is a read only version of the page.
close
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) / How to Change Currency...
Microsoft Dynamics GP (Archived)

How to Change Currency Decimal Places?

(0) ShareShare
ReportReport
Posted on by Sunstone130 785

For some reason the currency decimal places is grayed out and I can't figure out how to change it. I don't want to mess up our accounting department, so how do I change the currency decimal places in the item maintenance window?

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

    Use the Adjust Decimal Places Utility under Inventory Utilities.  This will adjust decimals on transactions going forward, not on current unposted or historical transactions or POs, Sales Orders, etc.

  • Sunstone130 Profile Picture
    Sunstone130 785 on at

    I tried using that utility, however it would not change the decimal places. I tried it 3-4 times and nothing would happen. Any other suggestions?

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

    That's the only game in town for changing currency decimals on an item.  When you say it wouldn't do it, what errors or other messages did you get?  Did you get an edit list after you tried?  Any messages on it?

  • Sunstone130 Profile Picture
    Sunstone130 785 on at

    When I press OK for the adjustment screen, nothing pops up as an error message. It lets me print an audit list, and all it says is "Item exists on Purchase Order Processing transactions and could not be updated".

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

    Sunstone, I misled you in my earlier response.  Updating decimals DOES update all records in the system, not just future ones.  That's why you are getting the error above.  You'll need to post all open transactions that have that item on it.  If it appears on any Sales Orders, Purchase Orders, MFG Orders, Transfer Orders, etc., those documents will either need to be completed or the item removed from them before you can do the update.  Also, if the item exists on a Price List, updating the currency decimals will delete it from the Price List(s), which requires adding it back.  The update will also delete the Default Unit of Measure from the Item Purchasing Options window.

    I had a different utility in mind when I wrote the earlier response (so much for relying on memory :))

  • awildrick Profile Picture
    awildrick 190 on at

    I keep getting a message "You can't complete this process while transactions are being edited."

    This item was just created two days ago, I have had everyone exit this system just in case that was an issue. This item has not been used on any PO, it does not exist in a Kit. Any ideas what this could be?

  • Suggested answer
    Redbeard Profile Picture
    Redbeard 12,931 on at

    Cause

    You may have a user locked in a table even though all users are logged out.

    Resolution

    1. Have all users exit Microsoft Dynamics GP and execute the following query in the SQL Query Tool against the DYNAMICS database:

    delete SY00800

    2. Execute the following queries against the Tempdb database:

    delete DEX_LOCK

    delete DEX_SESSION

    KB 864434

  • Sydieslp21 Profile Picture
    Sydieslp21 33 on at

    Hi, Will it clear the issues once we run the SQL? Coz I am also  keep getting a message "You can't complete this process while transactions are being edited." and we logged out all active users. Once we execute the queries will it clear or are we able to complete the process of changing the decimal places. Thanks

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans