How to get the AR records for a invoicelist number

[Former Member]

Dear All,

I'm looking for away to extract the AR records for a invoicelistnumber to build up our dunning records in a thirdparty software application.

We have the problem that there is no financial data extracted on a invoicelist number.

We want to have a simple export that makes our  dunning letters containing the invoicelistnumber with the financial data ( netvalue + tax)

Can you please help out wicht technical tables we need to adress to get this information and to connect the dots.

Many thanks for your help in advanced.

With kind regards,

Dennis Kristoffers

[VeselinaPeykova · Accepted solution]

In a standard system after an invoice list is created, the reference (BKPF-XBLNR) of the 'small' invoices is overwritten with the number of the invoice list. So if you search in BKPF for XBLNR (add leading zeroes) you can easily get the needed data. XBLNR is part of index, so it should not be too horrible for performance.

In case you have some custom logic implemented and the invoice list number is not updated in BKPF, you will have to go through VBRL to fetch the numbers of the F2 invoices first.