I want to know how to do BAQ part UOM Conversion

[mzahn (Mike Zahn)]

If for all of these UOM class, you have default UOM BOX and Base UOM PCS… You could just link a UOMCONV table to part and put a filter on the UOMCONV table of “UOMCode = “BOX””. then in a calculated field multiply the inventory by ConvFactor.

This would give you the number of pieces including partial boxes. If you want both the number of FULL boxes and PCS from full boxes, just add in some SQL math functions to round down. This would be the floor function.

UOMTest.baq (23.2 KB)

[teeraphongw]

@mzahn

If for all of these UOM class, you have default UOM BOX and Base UOM PCS… You could just link a UOMCONV table to part and put a filter on the UOMCONV table of “UOMCode = “BOX””. then in a calculated field multiply the inventory by ConvFactor.

This would give you the number of pieces including partial boxes. If you want both the number of FULL boxes and PCS from full boxes, just add in some SQL math functions to round down. This would be the floor function.

Thank You I Love You