HI 

I have two opinions 1st from the executive summary report will indicate avg debtors days 

2nd From Payment Reports group by the Refence ( Invoices ) then group by payment date and match these data with invoices record with invoice date and from this spreadsheet make an equation ( invoice date / payment date) will count the number of days and through that table will give the avg number of days