Balance Due amount of AP Invoice

[rajesh_khater]

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.

[former_member212181 · Accepted solution]

HI Rajesh,

You can use either (OPCH.DocTotal-OPCH.PaidToDate)

or  JDT1.BalDueCred where JDT1.Account <>JDT1.ShortName and JDT1.TransType =18

PaidToDtae includes all types of adjusted document values whereas Paidsum only brings value from Payment.

Thanks

Unnikrishnan

[rajesh_khater · Accepted solution]

You are right, Unni.

PaidToDate includes all types of adjusted document values whereas Paidsum only brings value from Payment.

[Former Member]

hi rajesh,

use that what was frank wang given that one OPCH.DocTotal - OPCH.PaidSum

[frank_wang6]

OPCH.DocTotal - OPCH.PaidSum should be correct.

[rajesh_khater]

What is the difference between PaidSum and PaidToDate?

Even if AP Credit Memo is raised for the AP Invoice, will the PaidSum / PaidToDate columns in OPCH be updated?