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.
• Use the field search button in the Account From and Account To fields to filter the invoices by an account number range.
• Check the Page Break by Fund toggle to place each fund included in the report on a new page. This toggle is only enabled if Fund, Vendor is selected in the Group By drop-down above.
• 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.

• Once the required report settings have been specified, click the Print button to print your report.
• Click the options arrow on the right side of the Print button to see other print options.
  • Select PDF to print the report in the default Springbrook PDF format.
  • Select Excel to export the report data to an Excel spreadsheet as unformatted data.
  • 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 a print option is selected, that option will automatically be selected the next time you access the report. For example, if you select Excel from the drop-down menu, the next time you access the report the Excel button will be displayed by default.
• Click the Schedule icon next to the Print button in order to schedule the report to generate at a later date and time.
  • Enter a Date and Time to generate the report and click SUBMIT.
• Users can also regenerate a report with the same configuration as a prior report via the report history section. This can help improve efficiency when an identical report is frequently generated.
  • Once a report has been generated, the date and time it was generated will display in the report history accessed via the Expand Arrow button   on the right side of the window.
  • Expand the report history and click on a previous report record to automatically populate the report criteria with the criteria specified on the previously generated report. This section will display the last three times the report was generated.
• 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.