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!
Reporting on Transaction Line Amount
I'm looking to do what seems to be very simple, but working over a month on it (with support as well) getting no-where.
If I have an order with 2 line items:
line1: Item costs 12,500
Line2: discount for -1,136.00
My assumption is that there should be 2 lines in the transaction_lines table, one for Line1 of 12500.00 and one for line2 for 1136.00
there are 2 lines in the transaction_lines table, the problem is line1 is storing the amount as -10914 and line2 is storing the amount (correctly) as 1136. (Line2 is a non-posting discount)
How can I report properly??
Line 1 *should* say -12500.00 not the -10914.00 (which is after the discount hits)?? It seems to me that the amount field is storing the GL amount.