web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested answer

Issue with Unit Conversions, Sales Orders and rounding issues for stock.

(1) ShareShare
ReportReport
Posted on by 5
Hello All, 

I have had an issue with unit conversions, in D365 F&O, that I can't seen to find anyone else that are talking about this and how to solve it.
 
I have setup unit conversion for a product, itemId = "0001" of unit "Box" to pcs ( ratio of 1 to 6), and created a unit sequence group properly (box and pcs added to ensure the packing quantity gets added).
On the conversion from Box to Pcs it rounds up.
 
I created a sales order with the following structure: 
- 1 Line of item "0001" with unit "Box and qty 1. 
- 6 individual lines of item "0001" each with  qty 1. 
 
The problem I have now is that the quantity of each of those 6 lines is "0.17 Box" which means it totals to "1.02 Box".
If I run the picking list and picking registration, it will try to reserve "1.02 Box" and this will introduce stock issues down the line. 
 
If I were to group all 6 lines of pcs into one line of qty 6 it will be have "1 Box" instead of "1.02 Box". 
 
It's hard for me to believe this has been something that has been missed  by Microsoft. 
 
What I am missing here? 
 
Thank you for your time.
 
Categories:
I have the same question (0)
  • Suggested answer
    André Arnaud de Calavon Profile Picture
    298,858 Super User 2025 Season 2 on at
    Issue with Unit Conversions, Sales Orders and rounding issues for stock.
    Hi Pedro,
     
    Apologies for a bit late reply as I only notice your question now unanswered.
     
    You can setup the inventory as PCS to avoid this rounding issue. I think it is best practice to have the inventory unit the same as the smallest unit you interact in your system (inbound and outbound). 

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.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 2,317

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 918 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 656 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans