Summary

The Outstanding Invoices report displays a list of outstanding invoice line items filtered by invoice date, JE date or payment date. Only committed invoice line items that have not been committed in the AP Computer Checks process will display on the report. Invoice line items that have been selected for payment in an uncommitted Computer Checks batch will display on the report until the batch has been committed. Invoices voided after the specified date range will also display on the report. Invoices in uncommitted AP Invoices batches will not display on the report. The fiscal year attached to the AP invoice will not affect whether it displays in the report.

The invoice line items that display on the report will be grouped by vendor number.

Step by Step

1     Open the Outstanding Invoices Report window (AP> Reports> Outstanding Invoices).

2     Complete the Print Options section.

• Select how you would like to group the report with the Group By drop-down menu.
• Select how you would like to filter the invoice line items that display on the report in the Date Type drop-down menu. The selection in this drop-down menu will determine which type of date will be used in the date range filter. This field is used in conjunction with the date range fields.
  • The invoice date will display on all invoice line items included on the report regardless of the filter selected in the Date Type drop-down menu.
• Specify a date range for the selected Date Type in the Date From and Date To fields.
  • Invoices voided after the specified Date To filter will also be displayed on the report.
• The report will display the Fund, Vendor, Account Number, Invoice Date, Invoice Number, Journal Entry, Amount, Description and JE Date or Payment Date if selected.

3     Print the report.

• Click the Print icon   to process the report immediately or enter a date and time in the field next to the Print icon to schedule the report to generate at a later time. You can view the progress of the report on the Job Viewer window (SS> Utilities> Show Scheduled Jobs).
  • Click the Print icon drop-down menu and select Print Preview to preview the report before printing.
  • Click the Print icon drop-down menu and select Excel to export the report data to an Excel spreadsheet as unformatted data.
  • Click the Print icon drop-down menu and select Excel (Formatted) to export the report data to an Excel spreadsheet that includes much of the Springbrook formatting found on the printed version of the report.
  • Once the report is generated, you can also display the report using the View Reports window (SS> Utilities> View Report).
• The report will display the vendor number, vendor name, GL account number on the invoice line item, invoice amount, Invoice Date, Invoice Description, Project Management Task Code, Project Management Type Code, Purchase Order Number, Payment Date, Vendor Total and Report Total.
  • The invoice amount that displays on the report includes the tax on the invoice line item. If there is a handling charge on the invoice, the total amount of the handling charge will be included on the first invoice line item invoice amount.