Hello everyone, Iām looking for advice or real-life experiences regarding price precision beyond 6 decimals in Dynamics 365 Finance & Operations.
The customer operates in the a sector, where pricing precision is critical due to very low unit prices (e.g. per kg / mĀ³)
According to Microsoft documentation and our own tests, prices and amounts are technically limited to a maximum of 6 decimals, and any attempt to go beyond that is truncated at database level. That said, we tried several approaches to see if there was any supported or semi-supported workaround. Below is a summary of what we tested so far. Extending or replacing EDTs does not allow storing prices with more than 6 decimals. The limitation is enforced by the platform/runtime, not just metadata
https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/extensibility/decimal-point-precision#unit-amounts
The only technically compatible workaround so far is to keep prices within the supported decimals (4ā6) and use Price Unit / multipliers to achieve higher unit precision
Has anyone successfully managed to handle prices with 8 decimals (or more) in D365 Finance in a different way?
Any supported or unsupported technical approach that actually works end-to-end?
Any experience with deep customizations, calculated prices, or alternative data models?
Or is the 6-decimal limit for prices truly a hard stop in all real scenarios?
Thanks in advance
