Share
ReportI have a customer who may need more than five decimal places in the cost fields on the item card. Is there a work around to bypass the five decimal limit?
*This post is locked for comments
You’re offline. This is a read only version of the page.
I have a customer who may need more than five decimal places in the cost fields on the item card. Is there a work around to bypass the five decimal limit?
*This post is locked for comments
We have similar issues here. I hope that in the future the Dynamics GP Dev team is able to be exposed to the UoM handling in Dynamics AX. (<envy>2 way conversions, global conversions, etc. <\envy>)
I agree with everything Victoria is saying. There is a caveat to setting your base UoM to a unit that is not the smallest unit - you will need to set quantity decimal places to 5. If you are using Manufacturing consider the impacts of this as well on BOMs.
Tim
This is a limitation of Dynamics GP and will not be something you can easily bypass. Changing the Dynamics GP table definitions is not recommended, as future updates and upgrades will (a) wipe out your changes and/or (b) fail. You could create a customization to store the cost in custom tables, but the number of places where the cost is used throughout GP would most likely make a customization like this impractical.
One suggestion I have seen in the past is to get creative with the UofM setup. So if each item is 0.000002, but you typically buy the item in 1000 increments, make 1000 your Base UofM. That way the cost for each base UofM will be 0.002 and will not be hampered by the 5 decimal place limit.
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,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (