Unit of Measure Selling vs Base (rounding on Sales order)

(0) Share

Report

Posted on by Charles0252

I have have an item that's base UOM is each, selling and Purchase uom is Carton

The conversion is loaded

1 ctn = 36 each

If I have a damaged cartoon I need to sell the system rounds up and charges for a full carton even if I have short picked, how do I over come this problem (Our Sales team are unable to identify at time of keying the sales order to change the UOM to Ea, we then have to continually post credits to the customers.

Eg. 71 inventory units in stock

Order for 2 Cartons, work created to pick 71ea. Invoice and Delivery note still show 2ctn and charged for 2 Ctn? this cannot be true as technically we have now invoice out inventory that is not available 72eaches?

I have the same question (0)

All responses (5)

Answers (0)

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Charles0252,

Is your question related to AX or D365FO?

Best regards,

Ludwig

Was this reply helpful? Yes No
Charles0252 88 on at

Like (0)

Report

Hi

Ludwig

its related to D365F&O

Thanks

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

moved to the d365 forum

Was this reply helpful? Yes No
André Arnaud de Cal... 301,075 Super User 2025 Season 2 on at

Like (0)

Report

Hi Charles0252,

In this case, the customer ordered 2 cartons, but technically you are delivering 71 eaches. Are you able to change the order to use eaches? At what exact moment(s) do you find out that you don't have full cartons?

Was this reply helpful? Yes No
Guy Terry 28,924 Moderator on at

Like (0)

Report

Hi Charles,

I think one factor is that your Carton unit has a decimal precision of zero. This means F&O is unable to post a delivery note for 1.97222 or whatever the quantity needs to be. Changing the decimal precision is not the only solution you could consider though.

If you have only 71 units in stock when the order is released, then the Release status of the Order header will go to Partially released. This could be a sign that something is about to go wrong. You could use Fulfilment rate functionality to block the release of orders which are not fully reserved.

If it is only discovered during picking that you will ship a partial carton, the operator has to use the Short pick function. This can create a Work exception, which can be used as an indicator that something is about to go wrong.

You also could think about how you handle 'partial cartons' in the warehouse. For example, you could move them to a special warehouse area, and give them a different stock status. Then it would be easier to see when there were partial cartons for sale, and it would be possible to indicate when an order line should be fulfilled using a partial carton, rather than a full carton.

Was this reply helpful? Yes No