UOM Rounding Affecting Costing

We have an issue in our UOM. We have been using SH as a UOM with No Rounding and 4 decimals. This is giving us, for instance, a Qty/Parent of 0.3333, and a Required Qty of 0.3333.

However, we usually take these sheets, use pieces and toss the offal, so basically using a full sheet.

It was brought up that we just round off the UOM of SH with no decimals since we use the full sheet usually with the offal being tossed, so 0.3333 SH becomes 1 SH, 1.25 SH becomes 2 sheets, etc.

We had done a test previously where we changed this on our non-production server and everything seemed to come through okay, finance signed off, but somehow, now we are seeing big jumps in costs, as the inventory is being seen as the rounded up numbers.

Is there a way for the cost roll to use the qty/parent in the BOM for costing instead of the rounded up required qty?

Short answer, not easily, and only with custom programming.

BUT, a Cost Roll uses the Costing Lot Size value (Part > Sites > Detail screen, lower right)…
perhaps your finance team would consider changing that value to a more typical build size for parts like this?

1 Like

Possible! I can bring that to their attention as well. Thank you!

We also brought up in a meeting that we could just create a new UOM that is allowed to be rounded and assign the cheaper parts where costing is less of an issue to them. Would be a workaround of some kind.