This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

how can  convert transactionLine.quantitybilled whic is giving me the case unit amount  to the correct unit messure of the bill
```  transactionLine.quantitybilled   transactionLine.units```

<@U013PDCADJ5> you can join in the `unitstypeuom` table to access the `conversionrate` for the units on both transactions and convert between them.

```SELECT
     transactionLine.transaction,
    transactionLine.uniquekey,
    transactionLine.memo,
    transactionLine.item as item_id,
    NVL(transactionLine.quantityshiprecv,0) a,
    transactionLine.quantitybilled,
    transactionLine.units,
    -- (add subquery)
    -- BUILTIN.DF(transactionLine.quantitybilled, transactionLine.units)
    FROM transactionLine
    INNER JOIN NextTransactionLineLink ON
      NextTransactionLineLink.previousline = transactionLine.id AND
      NextTransactionLineLink.previousdoc = transactionLine.transaction
      WHERE NextTransactionLineLink.nextdoc = 14121889```

```SELECT uom.conversionrate 
FROM unitsType 
INNER JOIN unitsTypeUom as uom 
    ON (unitsType.id = uom.unitstype) 
WHERE uom.internalid = ???```

if anyone wants to know the subquery i used see below
```(SELECT conversionrate FROM unitsTypeUom WHERE internalid = transactionLine.units) AS whatever```