I was wondering how to configure the select statement this will return the base unit messure i would like to convert to unit on the bill

transactionLine.quantitybilled

@Sim Greenbaum you can join in the

unitstypeuom

table to access the

conversionrate

for the units on both transactions and convert between them.

that would require another join

Correct