Notifications
Announcements
No record found.
Good morning,
How can i increase Qty - No of decimals precision - 4 using extensions.
Please provide me some light on this.
What is the better approach to achieve this.
Regards,
Have a great day.
Have you already checked the documentation?
docs.microsoft.com/.../decimal-point-precision
By the way, what is your business requirement? Why do you need 4 decimals? Quite often you can just use a different unit and get the same result with standard 2 decimals. For example, instead of 0,0001 kg you can handle 0,1 grams. I suggest you explore this option before doing any development.
Hi AX2012,
You need to extend the edt for the quantity. Make sure after the change you validate different functions of the system.
Hi Nikaloas,
It was one of the requirement which they need it at any cost.
Please help me in doing this.
So for InventTrans .Qty if i change that in Field of Qty Edt - My new Edt with No of decimals - 4 .
Will that makes sense or please suggest me right way.
Have a nice day.
It's described pretty well in the documentation. Did you read it? The chapter "Product quantity" matches your requirement. Please understand that it has much wider impact than just one field in one table (InventTrans).
I have read that when you suggested in first reply
But here they have mentioned like this
"you must extend the decimal point precision of the ProductQuantity, CostQuantity, and CAMMagnitude extended data types."
Should i extend these 3 and change the No of Decimal precision to - 4
And i can understand there will be impact but i dont know to convence them can you please tell me what will be impact so that i may convey that by doing this so and so will happen and if they agree for that then i will do that.
Please suggest .
Yes, you understood the doc correctly. Just try it! Then you will see the impact.
Hi Nikolaos,
Yes i understood that the value of decimal will come up as 4.
But my question is what impact can have in system if i change to 4 Because i am not aware of this.I mean if this breaks functionality ?
Regards.
It will not break any functionality. Some reports might need dev adjustments since the report design might not fit 4 decimals. You can find plenty of discussions on the topic by searching the web (as usual).
I'm still curious about your business requirement, and why the customer feels they need this modification. Is this something you could share with us?
Every now and then I hear need to have more than 2 decimals for prices, but not so often for inventory quantities. After all we have so many units such as mg, g kg, t that it would seem that any quantity could be represented with 2 decimals, when using appropriate unit. If someone has such business that they feel they need 4 decimals, it would be very interesting to hear more details.
All currency amounts are only valid with 2 decimals precision.
Given the fact, quantiy directly impacts amount, if your quantity is precise upto 4, you will have extremely inconsistent rounding loss/gain.
An alternative approach is to use Price unit effectively.
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 660 Most Valuable Professional
André Arnaud de Cal... 549 Super User 2025 Season 2
Sohaib Cheema 307 User Group Leader
