SO remaining amount calculation – ODBC SQL
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!