Discussions
Join the NetSuite community to innovate, connect, and discover what’s next.
SuiteWorld brings thousands of innovators, builders, and leaders together to learn, connect, and shape what’s next. This October, explore how to build a stronger foundation for growth through inspiring keynotes, major product reveals, hands-on sessions, and unforgettable moments—all in one place for our biggest event of the year. Register now
ODBC and reporting line item prices (not gl amounts)
We have discounts set up in our system as discounts - non-posting.
It seems to me that NS is storing the amounts of the transaction line items as GL amounts, ie. after discounts.
so if I have a kit at price $10,000 , with a $1,000 discount, in the transaction/transaction_lines table, the amount for the kit is $9,000 not the expected $10,000. (there is also a line for the discount, even though it's already been discounted in the item).
I need a way to display this properly. (There has to be a way I'm sure!!)
I need to be able to print out (not using NS UI) that the cost of Item A is 10K, -1k discount, item B 5k, discount -500, item c is 9k, discount -200 with the discounts showing as their own line items (as they were entered)