You’re offline. This is a read only version of the page.
Hi:
A while back, a GP end user changed the number of decimals in one of his GP companies from 3 to 2. This has caused some customers to have a "fractional cent" balance.
Normally, this sort of issue is remedied through either the entry of credit memos or writing off these small customer balances.
He tried each of these remedies, but the new decimal placement does not allow for either.
Likewise, he has run Receivables Reconcile for "Outstanding Amounts" to no effect.
How is this fixed?
Thanks!
John
Hi John,
Yes there is a utility to make that change under the inventory module.
Hi Shannon:
I want to thank you for the awesome response! That is much appreciated!
Another end user recently informed the firm that I work for a few years back that one of the newer versions of GP has a utility either for A/R or inventory that updates currency decimal placement without having to use scripting.
Do you by any chance know if that's true?
John
Hi John,
When you try to decrease the decimal places you will get a message that states that the number of decimal places for a currency cannot be decreased after the currency has been saved. The below referenced KB article explains this in greater detail, and indicates that you can only make that change to decrease the decimal places if you have not entered any transactions using the increased decimal places:
support.microsoft.com/.../how-to-decrease-the-number-of-decimal-places-in-currency-setup
There unfortunately is not a good supported method to resolve this issue and often requires data fixing to resolve these types of situations, where transactions were entered while the decimal places were increased before they were changed back to the decreased decimal place setting.
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...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (