Vendor balance

Did you try running the "Unpaid Bills Detail" report with a Nov 30 date?

If you are using the Vendor Balance detail report then modify it to filter on "paid status" and select only "open" to get the same as the Unpaid bills report.

Dear Laura,

Thanks for your reply. The problem with the 'paid status' filter is that many of the bills were paid after 30 Nov 06, the filter hides all of these bills as well. What I could do with is something like a 'date paid' filter.

Best Regards

Chris

I looked for a field that might contain the paid date and it does not appear to exist.

I see your problem. Take a look at the A/P Aging detail found under Vendor reports. Change the date to be November 30 and you should see those paid in December on the report. It will be grouped by aging category so you probably will want to dump the report to excel so that you sort it by vendor name.