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!
SO remaining amount calculation - ODBC
Hello friends,
I want to calculate the remaining amount in SO using SQL queries via ODBC.
Total SO amount less Invoiced Amount (of course, by items).
My thinking is to use TRANSACTIONS/TRANSACTION_LINES tables together with TRANSACTION_LINKS and to manually calculate this.
I know there are some nuances so you can please help me with some rules.
For example, I probably need to only consider Invoices with certain statuses, etc...
I can research with samples by my own, but if you can give me some guidance, it'll save me time.
Thank you very much!
Michael