UB> Reports> Payments by Past Due

Payments by Past Due Report

 

Summary

 

The Payments by Past Due report is used to report on payments made on UB past due accounts. The report will display the Cycle, Route Number, Customer Number, Sequence Number, Reference Number, Serial Number, Service Address, Account Status, Paid Amount, and Payment Date for the included payments.

 

Related Links

 

Click here for information on the Jobs Viewer window.

Click here for information on the View Reports window.

 

Step by Step

 

1     Open the Payments by Past Due window (UB> Reports> Payments by Past Due).

 

2     Configure the report. 

 

  • The Batch Number field is used to select the Past Due batch you would like to report on.

  • The Payment Created Date From and Payment Created Date To fields are used to filter the payments included in the report by the date that the payment was created.

  • The Sort By field is used to specify how the report will be sorted.

    • Users can sort the report by Customer Number, Cycle Route & Sequence, Reference Number, or Route & Sequence. When sorting by Route & Sequence, the report can be set up to break by route by checking the Page Break on Route toggle below.

  • Check the Include Accounts Without Payments toggle to include past due accounts that did not have any payments processed during the date range specified above.

  • Check the Include Uncommitted Payments toggle to include past due accounts with payments created but not committed during the date range specified above.

  • Check the Include All Active Meters toggle to include all active meters for the past due accounts included in the report.

  • Check the Page Break on Route toggle to start a new report page for each route included in the report.

    • This toggle will only be enabled if Route & Sequence is selected in the Sort By field above.

  • The report will display the Cycle, Route Number, Customer Number, Sequence Number, Reference Number, Serial Number, Service Address, Account Status, Paid Amount, and Payment Date for the included payments.

 

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 here for information on the Jobs Viewer window.
    • 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). Click here for information on the View Reports window.