SO remaining amount calculation – ODBC SQL

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