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, ...
Answered

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

(1) ShareShare
ReportReport
Posted on by 10
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)
  • Verified answer
    André Arnaud de Calavon Profile Picture
    300,721 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). 
  • Pedro Afonso Profile Picture
    10 on at
    Issue with Unit Conversions, Sales Orders and rounding issues for stock.
     
    Changing the Unit from Box to Pcs was my first thought, unfortunately this client has already gone live with this configuration. He has simply too many products to change and it would be too labor intensive. 
     
    Thank you very much for taking your time to reply.

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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

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

#1
Martin Dráb Profile Picture

Martin Dráb 683 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

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

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 398 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans