Skip to Content
Oct 16, 2013 at 12:48 PM

Details of Paid Invoices for each Incoming Payment



When we receive payment from debtors, we raise an Incoming Payment (in SAP B1), and settle the payment against the relevant Sales Invoices in AR

I wish to write a query that will list all Incoming Payments together with full details of all Sales Invoices (AR) that were settled (fully or partially) by that incoming payment.

Could you give me a full listing of tables that I must use to develop my query, and if possible what Joins I should make?

Thanks a lot

Leon Lai