PDA

View Full Version : Vendor Report


jennex
06-04-2009, 01:47 PM
I'm using QB Pro - Canadian Version and I'm trying to create a report that shows all invoices/payments for a specific vendor for a certain time period. I want to keep track of how much we're spending with specific vendors.

When I right click and do a 'Quick Report', the report shows the ins and outs but doesnt show me a running balance or total current balance. When I do an 'Open Balance' report it only shows me the o/s invoices and recent payments and seems to disregard the date span I select, only showing from Jan 1 to current.

Suggestions?

Thanks!

RobJoy
06-05-2009, 03:52 AM
Yes, very annoying. Please post a suggestion that the QuickReport shows totals under the Feedback link.

However, what you need may be covered by Expenses by Supplier Summary (under Company & Financial reports) and/or Purchases by Supplier Summary (under Purchases reports).

Joe Williams
06-05-2009, 04:27 AM
You may want to try using the Custom Transaction Detail report. Modify it ans set the Total By to Vendor and set the date range. Click Filters and set Account to All Accounts Payable. This will give the total for each vendor with a running balance for the date range selected.
As always, you can use Modify then Header/Footer and change the report title and then memorize it for future use.