``` ```

SELECT

BUILTIN.DF(transactionline.item) as item,

BUILTIN.DF(inventoryassignment.inventorynumber) as lot_number,

BUILTIN.DF(inventoryassignment.bin) as bin,

BUILTIN.DF(transactionline.location) as location,

SUM(inventoryassignment.quantity / unitstypeuom.conversionrate) AS quantity,

FROM

transaction

INNER JOIN transactionline ON transactionline.transaction = transaction.id

INNER JOIN inventoryassignment ON inventoryassignment.transactionline = transactionLine.id

inner join item on item.id = transactionline.item

inner join unitstypeuom on unitstypeuom.internalid = item.stockunit

AND inventoryAssignment.transaction = transactionLine.transaction

WHERE

transactionline.isinventoryaffecting = 'T'

GROUP BY

BUILTIN.DF(transactionline.item),

BUILTIN.DF(inventoryassignment.inventorynumber),

BUILTIN.DF(inventoryassignment.bin),

BUILTIN.DF(transactionline.location)

HAVING SUM(inventoryassignment.quantity) != 0