hi guys... Where does the transaction "Quantity" ...
# suitescript
e
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
I think the column you’re looking for is
ITEM_COUNT
.
e
I think you are right @Mike Robbins!!!
Why are the numbers negative?
m
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.