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

image.png

NetSuite2.com source, is your quantity negative when pulling out data out of Sales Orders via TransactionLine? Can't find any documentation about this.

So these are non main line, non cogs, and non tax

`SELECT transactionline.quantity * -1 as quantity`

Thanks mate! That's my current workaround at the moment. Still wondering if this is NS bug.

No it's just how data is stored in database