So, I have a situation involving Unit of Measure on a Purchase Order. The line is using 'Cases' (Which is 12 units). The PO line says 10 Cases .... and the suiteQL results in a quantity of 120. I'm looking for the suiteQL result to be 10 Cases. Does this mean I need to calculate the quantity myself? In a NetSuite saved search, there's a

quantityuom

that would give me the correct value. Does this not exist in suiteSQL

The quantity on the transactionline is always the base unit. However you can get the unit and join it.

SELECT transactionline.quantity/unitstypeuom.conversionrate as quantity, unitstypeuom.unitname

FROM transactionline INNER JOIN unitstypeuom on unitstypeuom.internalid = transactionline.units

Thanks @Alan Fitch,

In some accounts we are seeing a native field called "Quantity in Transaction Units" . does that help in suiteql as it might sae having to join the units

In saved searches?

Yes in Saved Searches. Personally I've only seen it recently. It's not In All of my client accounts though. Was thinking if it's in suiteql it might help resolve your issue

I don't think that's a real field. I think it's doing something like the calculation above.