# I want to know how to do BAQ part UOM Conversion

**URL:** <https://www.epiusers.help/t/i-want-to-know-how-to-do-baq-part-uom-conversion/130587>\
**Category:** Kinetic ERP\
**Tags:** baq\
**Created:** [November 7, 2025, 8:08am UTC](https://www.epiusers.help/t/i-want-to-know-how-to-do-baq-part-uom-conversion/130587 "2025-11-07T08:08:53Z")\
**Posts on this page:** 3\
**Page:** 2

<div class="post-metadata">

**Author:** ![mzahn](https://www.epiusers.help/user_avatar/www.epiusers.help/mzahn/32/97033_2.png) [@mzahn](https://www.epiusers.help/u/mzahn)\
**Post date:** [November 12, 2025, 1:47pm UTC](https://www.epiusers.help/t/i-want-to-know-how-to-do-baq-part-uom-conversion/130587/22 "2025-11-12T13:47:27Z")

</div>

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](https://www.epiusers.help/uploads/short-url/9GMB22SLXgvMp5zIdyhGQRxkr0J.baq) (23.2 KB)

 ![image](https://www.epiusers.help/uploads/default/original/3X/8/0/808768acaada0a88d400021291e93554567d63aa.png)

---

<div class="post-metadata">

**Author:** ![teeraphongw](https://www.epiusers.help/user_avatar/www.epiusers.help/teeraphongw/32/85756_2.png) [@teeraphongw](https://www.epiusers.help/u/teeraphongw)\
**Post date:** [November 13, 2025, 1:58am UTC](https://www.epiusers.help/t/i-want-to-know-how-to-do-baq-part-uom-conversion/130587/23 "2025-11-13T01:58:40Z")

</div>

> [@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 😍

---

<div class="post-metadata">

**Author:** ![DKehler](https://www.epiusers.help/letter_avatar_proxy/v4/letter/d/35a633/32.png) [@DKehler](https://www.epiusers.help/u/DKehler)\
**Post date:** [July 2, 2026, 6:20pm UTC](https://www.epiusers.help/t/i-want-to-know-how-to-do-baq-part-uom-conversion/130587/24 "2026-07-02T18:20:18Z")

</div>

Came across this topic while looking for something else but i have built something for this awhile ago that displays either the Part Specific UOM Conversion value, if applicable, or the UOM Class conversion factor if not part specific.

I join this as a subquery on PartNum = PartNum and UOMCode = PL and then i can take whatever value in OrderDtl.OrderQty \* UOM.uomcConvFactor to get the quantity in PL (pallets), or do the reverse with OrderDtl.SellingQty / UOM.uomcConvFactor and bring the PL values back to base.

 ![2026-07-02 11_58_05-UOM Conversions.sql - erpcad-read03.epicorsaas.com,50135.lv69861 (C69861RO (99))](https://www.epiusers.help/uploads/default/original/3X/b/5/b55591c0b7b3a8ace32d39bfd33568400556f5e7.png)

Epicor BAQ - I have a table criteria for Company that i blanked out, either add in your company or remove that altogether

[UOMConversions.baq](https://www.epiusers.help/uploads/short-url/fpZelE18dZfGMfe5bjJpHz2nJqi.baq) (43.9 KB)

SQL Version

> **Summary**
>
> SELECT  
> conv.PartNum,  
> conv.PartDescription,  
> conv.InActive,  
> conv.IUM,  
> uom2.UOMDesc ‘IUM Description’,  
> conv.PartUOMClassID ‘Part Specific’,  
> conv.UOMClassID ‘UOM Class’,  
> conv.UOMCode,  
> uom.UOMDesc,  
> conv.uomcConvFactor  
> FROM  
> (  
> SELECT  
> p.Company,  
> p.PartNum,  
> p.PartDescription,  
> p.IUM,  
> p.InActive,  
> ‘’ ‘PartUOMClassID’,  
> uomc.UOMClassID ‘UOMClassID’,  
> uomc.UOMCode ‘UOMCode’,  
> uomc.ConvFactor ‘uomcConvFactor’  
> FROM Erp.Part p  
> INNER JOIN Erp.UOMConv uomc  
> ON p.Company = uomc.Company  
> AND p.UOMClassID = uomc.UOMClassID  
> WHERE p.Company = ‘’  
> AND p.Inactive = 0  
> AND NOT EXISTS  
> (  
> SELECT  
> PartNum  
> FROM Erp.PartUOM  
> WHERE Company = ‘’  
> AND p.PartNum = PartUOM.PartNum  
> AND uomc.UOMCode = PartUOM.UOMCode  
> AND PartUOM.ConvFactor \<\> 0  
> )  
> UNION ALL  
> SELECT  
> p2.Company,  
> p2.PartNum,  
> p2.PartDescription,  
> p2.IUM,  
> p2.InActive,  
> p2.UOMClassID ‘p2UOMClassID’,  
> ‘’ UOMClassID,  
> puom.UOMCode ‘puomUOMCode’,  
> puom.ConvFactor ‘puomConvFactor’  
> FROM Erp.Part p2  
> INNER JOIN Erp.PartUOM puom  
> ON p2.Company = puom.Company  
> AND p2.PartNum = puom.PartNum  
> WHERE p2.Company = ‘’  
> AND p2.Inactive = 0  
> AND NOT EXISTS  
> (  
> SELECT  
> \*  
> FROM Erp.UOMConv  
> WHERE Company = ‘’  
> AND UOMConv.UOMClassID = p2.UOMClassID  
> AND UOMConv.UOMCode = puom.UOMCode  
> AND puom.ConvFactor = 0  
> )  
> ) conv  
> LEFT JOIN Erp.UOM uom  
> ON uom.Company = conv.Company  
> AND uom.UOMCode = conv.UOMCode  
> LEFT JOIN Erp.UOM uom2  
> ON uom2.Company = conv.Company  
> AND uom2.UOMCode = conv.IUM  
> ORDER BY conv.PartNum,  
> conv.UOMCode  
> ;

[Previous page](https://www.epiusers.help/t/i-want-to-know-how-to-do-baq-part-uom-conversion/130587.md?page=1)