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.