Applied entries details

sajidhanifkhan

Hi,

I am trying to make a report where I need to show the Document No of the general journal or the payment journal batch of the pyament lines applied to particular vendor purchase orders.

What I want to show in report is the Document number entry number Vendor number and the PO number to which the payment applied.

Can any one suggest which tables I should be using to get the above details.

I tried looking Detailed Vendor ledger entries but it shows all the required information as explained above but unable to get the Application entry applied to which purchase order or invoice number.

Any one can help?

DaveT

Hi,

Depending on how you post your receipt/invoices you may be able to get the PO from the post purchase invoice header (table 122). You can then use the detailed vendor ledger entry to find the applications.