Saturday, July 13, 2019

Retrieve the 'Quantity' Field for Work Order, Assembly Build and Assembly Unbuild via ODBC

On some transactions such as Work Order, Assembly Build and Assembly Unbuild, there's a body field for Quantity.

However, one could notice that this field is not exposed on Transactions view. The best approach is to query from the Transaction Lines table, get the item_count field for the Quantity and add a condition that checks if the transaction_line_id is zero (0). Sample query below:

SELECT item_count FROM TRANSACTION_LINES WHERE transaction_line_id=0 AND transaction_id = 6027

No comments:

Post a Comment