Skip to Content
0
Jun 15, 2015 at 02:52 PM

Balance Due amount of AP Invoice

503 Views

Hi,

Is there a field which stores the Balance Due amount for an AP Invoice in either the OPCH table or the OJDT table?

If not, what calculation should I use in my SQL which will give me EXACTLY the same value as shown in the Balance Due field in the AP Invoice on screen?

Example, whether I should use: OPCH.DocTotal - OPCH.PaidSum, or OPCH.DocTotal - OPCH.PaidToDate or any other column?

Thanks.