When doing our intermediary report we go to Purchases, View Suppliers, and do an advanced search for Total Paid between two dates.
The particular example I’m looking at is Andre Lopes, on the screen it shows £1,031 for total paid between the two dates. This is correct as one invoice from a previous period was paid late so it falls in the period we’re looking at.
When I export the report to excel, it shows columns of total invoiced gross and net £995 which are correct for the period and then a total paid which is for all time, but that means the actual report that downloads isn’t the report I asked for, that is still on screen. Am I going wrong somewhere?