Invoice inquiry Report

1. In the main menu select Accounts Payable > Invoice Inquiry/ Adjustment

2. In the Invoice Inquiry window, select the individual invoices that you would like to run the report on, or tick the Select All box

3. Click the Reports button

Report Details Tab

Open

Report Section
Input – Select if you want report sorted by transaction number
Distribution – Select if you want report sorted by account number
1099 – Use to print 1099 forms for the vendors

Summary – To have report sorted by vendor name
Run Date – Select date from which you would like the report cut-off date to be.

Currency Conversion Section
Base – Master currency you are reporting in
Native – Currency transactions are entered in

Exchange Rate Section
Budgeted – Set budget currency rate
Current – Variable exchange rate (not usually applicable)

Selection Section
Bank – Set to “A” for all, or select a specific bank account
Currency – Set to “A” for all, or select a specific currency

Report Layout Section
Report Layout - Select the report you require from the drop-down list

Range Tab

Open

Include Section

Paid – Select if you only want to run the report for paid invoices.

Unpaid – Select if you only want to run the report for unpaid invoices.

Both – Select if you only want to run the report for paid and unpaid invoices.

Order Section

Invoice – Select if you would like the report sorted by invoice number.

Cheque – Select if you would like the report sorted by cheque number

Details Section

Ranges – Input any filters you would like in the report, if there are no filters, make sure all the 9’s and Z’s are listed exactly as above.

4. Click the OK button and the report will appear in Preview

Aged Creditors Report

1. In the main menu select Accounts Payable > Invoice Inquiry 1 > Reports button

2. In the Invoice Inquiry Report window, select Input Control under Report type.  Click the Range tab, select Unpaid under Include section. Click OK