Blackbaud

Instructions per:

http://www.blackbaud.com/files/support/guides/afnap/accounts_payable.pdf

When you open this guide and go to page 167 you'll find the chapter Query and Export. The information we are looking for starts at page 181 at the section Adding a new query

Based on this guide we've compiled some steps which should generate the results that we are looking for.

From the Start menu, select Programs, Blackbaud Accounts Payable.
Select Query and Export from the Accounts Payable modules.

Then in the Query Window:

Select File, New
Enter the Query type. (in our case we probably need Vendor)
Enter the Query format (we can leave this one at Dynamic)
Indicate Include in (we can choose Export here)
Click OK, the the New Query window appears.

In this window you'll find 4 tabs (Criteria, Output, Sort, Result)

In the Criteria tab, the only criteria we need to give is the Invoice date (e.g. 2008 - 2012). (page 182 describes in more detail how to enter the criteria)

In the Output tab, we should pick the fields to include in the query. Those are (it's likely that your system has slightly different field names):

Vendor Name / Number
Invoice Date
Invoice Number
Invoice Amount
GST/HST paid

Optional:

Batch or Cheque number
Document number
Purchase order number
Currency (USD or CAD)
Description
PST paid
GL Account

We don't need to specify anything in the Sort tab

In the Results tab after pressing the Run button there should be an option to Export the results. The most useful format for us would be Comma Separated or Tab delimited but an Excel spreadsheet will also do.