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
2ps
are you using cash sales or invoice & payment.