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!


Rookie Asked on May 7, 2021 in Accounting.

are you using cash sales or invoice & payment.

on May 8, 2021.
Add Comment
0 Answer(s)

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Limebox   Become a Sponsor   Become a Sponsor