Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
Unanswered

How to change decimal places in GP to be 0

Posted on by 20

We need to adjust one of our entities to record transactions with 0 decimal places.  Most of our entities use 2 decimal places for transactions but we have come upon this exception. Is this a setting at the company level, or do we need to edit multiple settings within the company?  We use the Financial, Sales and Purchasing series.

  • Beat Bucher  GP Geek  GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Moderator on at
    RE: How to change decimal places in GP to be 0

    Richard,

    I had a customer running into this issue after creating a new currency and a new company, realizing afterwards that they should have setup with 0 decimals instead of 2.. As they only had brought over the beginning balances, it was easier to just scrap the company, adjust the currency setting and re-create the company. There is no easy way to do this once transactions have been posted into the system, without running into a few troubles.

  • Nicole Hellerud Profile Picture
    Nicole Hellerud 1,712 on at
    RE: How to change decimal places in GP to be 0

    Hey Richard,

    Thank you for your update.

    I did some testing and it does not seem to be a place when creating a new company that you can change the precision of decimal place for currency.

    Wishing you and yours healthy and happy days ahead!

    Nicole Fiskum

    Support Engineer

    Microsoft Dynamics GP

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: How to change decimal places in GP to be 0

    Nicole, that was fascinating. I never noticed that before. If I were setting up a new company is there a screen where I could change the currency precision or is only done through SSMS?

  • J.Weed Profile Picture
    J.Weed 20 on at
    RE: How to change decimal places in GP to be 0

    Hi Richard,

    I am not sure exactly, the request came to change the decimal places at the transaction level.  We do not use many items currently and so i think we are talking about invoices (AR and AP) as well as GL journal entries. Thank you for helping me clarify the currency settings.  I was pretty sure this would be a system wide change but glad you were able to confirm.  Really appreciate you taking the time!

  • J.Weed Profile Picture
    J.Weed 20 on at
    RE: How to change decimal places in GP to be 0

    Thank you, Nicole!  This related article was helpful and I think gives me enough to go back to our tech and accounting teams   for clarity on next steps.  

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: How to change decimal places in GP to be 0

    Is the currency question regarding the totals of invoices and POs or the cost of items or both? The currency setup for currency is system wide not company specific.

  • Nicole Hellerud Profile Picture
    Nicole Hellerud 1,712 on at
    RE: How to change decimal places in GP to be 0

    Hello J.Weed,

    Thank you for your post.

    Thank you, Richard, for your feedback as well!

    I am not sure if you seen this already, but I wanted to include it:

    How to decrease the number of decimal places in Currency Setup
    https://support.microsoft.com/en-us/help/865702/how-to-decrease-the-number-of-decimal-places-in-currency-setup
    What is the current decimal place set to?
    We don’t recommend lowering the decimal place value after transactions have been entered/posted as you will experience rounding issues.
    Wishing you and yours healthy and happy days ahead.
    Nicole Fiskum
    Support Engineer
    Microsoft Dynamics GP
     

  • J.Weed Profile Picture
    J.Weed 20 on at
    RE: How to change decimal places in GP to be 0

    Thanks for the reply!  I am talking about currency.  I think I found how to edit the currency settings, but ii looks like this is system wide and not specific to one company file.  Does that align with your understanding?

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: How to change decimal places in GP to be 0

    Are you referring to currency or quantity?

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

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

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,554 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,588 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans