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.
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.
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
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?
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!
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.
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
Are you referring to currency or quantity?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,554
Super User 2024 Season 2
#2
Martin Dráb
228,588
Most Valuable Professional
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (