Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
Don’t miss your chance to meet our SuiteGurus—NetSuite Support professionals and subject matter experts with extensive experience in select product areas, including OneWorld, Advanced & Basic Accounting, Supply Chain Management, Receivables & Payables, CRM, Account Administration, and the SuiteCloud Platform. Full Conference attendees can prebook exclusive 30-minute one-on-one sessions for your product questions.
Spots are limited! Register through your Agenda Builder and find SuiteGuru under Agenda Enhancements.
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)