Vendor balance

Posted by Chris on January 4, 2007, 7:19 am

Please log in for more thread options

Dear All,

Year End was 30 Nov 2006 and as of today need to output a report
showing a list of outstanding Bills as at 30th Nov. I can get this via
Vendor Balance Detail Report but it shows all Bills and Payments for
the whole year. How to hide the paid Bills.

Thanks for your your help

Chris

Posted by Laura on January 4, 2007, 8:30 am

Please log in for more thread options

> Dear All,

> Year End was 30 Nov 2006 and as of today need to output a report

> showing a list of outstanding Bills as at 30th Nov. I can get this via

> Vendor Balance Detail Report but it shows all Bills and Payments for

> the whole year. How to hide the paid Bills.

> Thanks for your your help

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.

Posted by Chris on January 4, 2007, 8:05 pm

Please log in for more thread options

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