Open Invoice Report - Instructions

System default. Lists all pertinent invoice information such as Invoice Number, Due Date, Vendor Name and Number, Account Number, Amount, Status, and Check Number (if the invoice was prepaid).

Lists the same information as the Summary report, plus Purchase Order Number, Invoice Date, 1099 Code, Reference, and Description. The last two fields contain free typed text entered by the user during invoice entry.

Tips:

For more information about running reports, see Print View.
At the Report Writer window, you can change the selection and sort options for the report. For more information, refer to the Report Writer Overview.
Frequently Asked Questions:
My report totals do not balance with my general ledger?
The total amount of all current year open invoices in the current year company should equal the amount in your AP Control account in general ledger. If it does not, here are some suggestions:
Make sure the Open Invoice Report is listing all open invoices. Delete any ranges or lists in the Report Writer window.
Make sure all entries in your general ledger are posted. Post all periods anyway (no double postings occur).
Is your general ledger in balance? If not, why?
Are there invalid invoices on your report? If so, correct them during Invoicing, and post general ledger again. Rerun Trial Balance report.
If your general ledger is out of balance by the amount that the AP Control account is off and all open invoices are valid, locate which period is wrong and edit the amount posted in general ledger. Use your Invoice Posting Sheets as guides.
What if I have negative invoices?
Negative invoices usually represent credits issued by that vendor to you. They will remain in the system until positive invoices are entered against that vendor causing the current balance to be positive. Once the positive invoice amounts are higher than the negatives, all invoices will qualify to be paid. The Accounts Payable routine will deduct the negative invoices from the positive.
How do I delete incorrect invoices?
All invoices listed on the report were entered using Invoice Entry and could contain invalid information such as wrong due dates, applied to the wrong vendor, wrong invoice number, etc. To delete an invoice, a negative invoice must be entered exactly the same way the incorrect positive invoice was entered, including the incorrect data. Refer to the Accounts Payable trouble shooting section for further instruction.

1. Click Fund Accounting from the Menu Bar.

2. Click Reporting.

3. Click Open Invoice Report.

Or, use the keyboard shortcut: [ALT] [u] [r] [o].

Open Invoice Report Window Example:

Open Invoice Report Prompts

Tip: To see more information about a field, click the hyperlink for the field name.

Report Type

To select the report type, click a choice in the drop-down list.

Report Types:

Summary Report - Lists all pertinent invoice information such as Invoice Number, Due Date, Vendor Name and Number, Account Number, Amount, Status, and Check Number (if the invoice was prepaid).
Detail Report - Lists the same information as the Summary report, plus Purchase Order Number, Invoice Date, 1099 Code, Reference, and Description. The last two fields contain free typed text entered by the user during invoice entry.

Print Totals

To print one Grand Total amount based on the criteria entered, click to select this box.

To print the detail as well as the totals, de-select this box.

To generate the report, click Continue or press [ENTER].

Keyboard shortcut: [ALT + o]

To escape from the print routine, click Cancel.

Keyboard shortcut: [ALT + c]

After clicking Continue, the following window displays:

Open Invoice Report Prompts

Tip: To see more information about a field, click the hyperlink for the field name.

Report Writer

Review the Report Writer prompts and make changes, if applicable.

Note: For more information, refer to the Report Writer Overview.

Printer

Displays the default printer number. For more information, see Printing Options.