4 Decimals in D365

?We would like to implement 4 decimal places everywhere in AX in new implementation in D365.
Can we do it without customization?

——————————
Meenu Laul
3C InfoCorp, Inc.
Houston TX
——————————

?I am speaking from a 2012 R2 point of view-
This isn’t recommended by anyone and technically should not be needed if you utilize AX functionalities related to unit conversions and BOMs etc etc as mentioned above. Some accountants may believe this would cause discrepancies when reconciling inventory as many materials go past the second decimal place. But if properly set up, AX will correct itself and reconcile…depending on your business setting and assuming the parameters are set up correctly..

——————————
Alex Bailey
ATMC
——————————
——————————————-

?Hi again
To give you some background on when you can increase the UoM decimals.
This came up when I had one ingredient that was a tiny amount when compared to the others.
We were back flushing and when the UoM decimals was 2 decimals the Production pick list journal was rounding to zero and not posting anything.
Increasing the UoM decimals overcame this rounding issue and the Production pick list journal line was created for the correct amount.

——————————
Craig Cameron
Columbus EMEA
Nottingham
——————————
——————————————-

There is a native feature called “price unit” that many people overlook.  It allows you to handle any decimal precision.  You don’t have to be tied to 2 decimals or 4 decimals.  I’ve answered this question so many times that I created a blog post 3 years ago.  The link is below.  Customizing the application to show 4 decimals “everywhere” is not recommended.  There are too many places to deal with rounding.  I’ve seen customizations in a few targeted places, but remember getting unexpected results because of internal rounding.  In general it shouldn’t be necessary if you leverage the price unit feature.

Dynamic AX How To: Deal with Unit Prices That Have More Than Two Decimals

Hitachi Solutions		remove preview
Dynamic AX How To: Deal with Unit Prices That Have More Than Two Decimals On most Dynamics AX 2012 projects, there is confusion around how to deal with unit prices where the decimal precision is greater than 2 (e.g. fuel $1.1638 per L). Many projects go down the road of customizing AX to achieve this, but there is standard AX feature intended for this purpose which technically allows any level of decimal precision. View this on Hitachi Solutions >

——————————
Kaare Boraas
Solution Delivery Manager
PCL Constructors Inc.
Edmonton AB
——————————
——————————————-

Use ‘Price Unit’ on any of the Price related issues.
For UOM use decimal precision.

One word of caution from me is that even if you set-up UOM precision let’s say to 4, on all forms you will be able to see only 2 decimal places displayed.  We ran into issues where the production order estimated partial consumption (with 4 deciamal places).  However, users actually typed rounded value (to 2 decimal places) and we were left with small fractions which showed as 0.00 on the on-hand inventory screens.  The only way to get rid of those was to do counting journals otherwise you would need to see the exact value using SQL.

——————————
Marek Chrzanowski, P.Eng., M.Eng.
Inside Consultant
Dynamics AX 2012 R3
Cyclone Mfg
Toronto, ON, Canada
——————————
——————————————-

If you go into the AOT and browse table InventSum, and then CTRL+T it out to excel, you can see the full decimal precision of quantities by InventDimID.  I usually don’t have a SQL session up so that’s easier for me.

——————————
Colby Gallagher
Manufacturing Systems Consultant
Agility Business Solutions
Brecksville OH
——————————
——————————————-

Marek, I can relate to your horror story..

We are a moving average cost company with multiple warehouses and locations. Initially the financial value for the inventory storage dimension was only at the site level when it should have been down to the warehouse level. This combined with some unit conversions, BOMs, production, and Ordering parameters being set up incorrectly created quite the mess. Financial values were left on warehouses and locations where there was no inventory wrecking the inventsum table. Cleaning this up and correcting the incorrect parameters set up meant we had to clean up the tables “naturally”. You should be able to run basic inventory clean up processes in AX and it will revert the values to what they “should be”… But once running a consistency check, they will revert back to what they are “supposed to be”.  If you want my instructions on how to clean up the InventSum/InventDimID table, feel free to message me and I’ll be glad to shoot them your way. I worked on this over a month to make sure it was ‘natural’.. avoiding changing the data base with SQL.

Good Luck to anyone who has to face any issue related to this!

——————————
Alex Bailey
ATMC
——————————
——————————————-

?An additional place this will cause issues is since it displays 2 decimal places and calcs at 4 if you have to do a reverse on a pick list it can cause issues as well because the values you enter will not match what the system is looking for.

——————————
Paul Martin
Production Program Manager
Elite Comfort Solutions, LLC
Conover NC
——————————
——————————————-

Nope, it would require customization.  In previous versions, it was modifying extended data types and adjusting currency rounding, so I would assume it’s the same process as the back end hasn’t changed that much.  I would recommend you talk to your partner or Microsoft as generally Microsoft is very cautious about this change.

——————————
Shirley Adams
AKA Enterprise Solutions
New York NY
——————————
——————————————-

?Hi, without customization you can go part of the way.

• On the Units of measure you can specify the number of decimal places and this increases the accuracy on BOM/Formula calculations
• For pricing i.e. on Trade agreements and Items on Sales and Purchase orders you can price per 1000
• Everything else is 2 decimals (if I remember correctly)

——————————
Craig Cameron
Columbus EMEA
Nottingham UK
——————————
——————————————-

I agree with Kaare.

We are using price unit to accomplish four decimals. It is seamless.

——————————
Allen Rupp
Commercial Purchasing Manager
Woodland Foods
Waukegan IL
——————————
——————————————-

This is not possible as a customization at this time in D365.  There is an idea to allow it, you should go upvote it:  https://ideas.dynamics.com/ideas/dynamics-operations/ID0002210

——————————
Colby Gallagher
Manufacturing Systems Consultant
Agility Business Solutions
Brecksville OH
——————————
——————————————-