Table where SAP stores the billwise tagging for payment

[Former Member]

Hi experts,

I am looking for the table where SAP stores the billwise payment / adjustment info.

Can you please help me finding out the same?

Thanks in advance.

Nabyendu Saha

[jitin_chawla · Accepted solution]

Hi,

The details of the Invoices which are paid can be found by linking the Marketing document table with the VPM2 table in case of Outgoing Payment and RCT2 in case of Incoming Payment.

You can also have a look at the OITR and ITR1 table for all those Payments/credits which are made not based on the marketing document but still used to close and reconcile the documents.

Hope it helps.

Regards,

Jitin

SAP Business One Forum Team

[Former Member · Accepted solution]

Thanks to you all.

I have already got the tables.

These adjustments are being posted in OITR and ITR1 only irrespective of reconciliation methods, e.g.

Manual Reconciliation, Billwise adjustment during voucher entry etc. and reconciliation types are being marked with the recontype column in OITR.

Best regards,

Nabyendu

[Former Member]

Hi Nabyendu,

Since you have got your answer, please close your thread.

Thanks,

Gordon

[KennedyT21]

Hi Nabyendu Saha..

Check with these tables

RCT2 - Incoming Payments - Invoices

VPM2 - Outgoing Payments - Invoices

INV6 - A/R Invoice - Installments

PCH6 - A/P Invoice - Installments

Regards

Kennedy