Q57: AP Invoice and payment reconciliation

[Former Member]

Dear All,

Which table(s) can I use to see whether an AP Invoice has actually been paid.

I can get AP Invoice information from OPCH & PCH1 but hwere do I get the reconciliation from?

Thanks,

Robin

[Former Member · Accepted solution]

Hi......

You can refer OITR table for reconciliation.

If OPCH DocStatus is closed it means it is paid.......

Or if OPCH.PaidToDate contains value then AP is paid fully or partially......

Regards,

Rahul

[Former Member · Accepted solution]

Thank you, problem solved

[Former Member]

Dear Robin,

If you only need unpaid or not fully paid invoice, you can query OPCH table by a condition DocTotal-PaidtoDate>0

VPM2 holds the detail for each invoice payment.

The reconciliation tables are OITR and ITR1.

Thanks,

Gordon

[Former Member]

Hi,

You can get the AP invoice paid details from table VPM2 and InvType=18.

Pls refer SDK Help.

Regards,

Priya