Announcements
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
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.
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
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
