Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Stay in the Know
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
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)
0