need AP and AR detail report in a specific data range
currently, dear system just has an AR and AP summary report, like "supplier finance report". user can't drill down this report to get AR and AP detail report in a specific date range.
the real situation is that the management team wants to know the AR or AP balance for each invoice in a specific date range, like last year.
but for the "purchase invoice summary" report, the total paid amount is calculated for all payment records till today, not in the filter date range.