hi guys... Where does the transaction "Quantity" value comes from when using ODBC queries? The table Transaction Lines doesn't have a column with that name.
m
Mike Robbins
12/07/2021, 7:58 PM
I think the column you’re looking for is
ITEM_COUNT
.
e
Edgar Valdés
12/07/2021, 8:32 PM
I think you are right @Mike Robbins!!!
Edgar Valdés
12/07/2021, 8:33 PM
Why are the numbers negative?
m
Mike Robbins
12/07/2021, 9:02 PM
Different transactions have a positive/negative affect. For example, an invoice may reflect a positive quantity of 10, if you create a create a credit memo for 5 of them, that quantity will be reflected as -5.