Summary

The Consumption by Type Report allows you to group the meter consumption by meter size and/or the miscellaneous 1 or miscellaneous 2 fields attached to the lot on the accounts. The report will group the consumption that displays on the report by consumption inside the city and consumption that is outside of the city. If the In City toggle is checked on the lot record (UB> Maintenance> Account> Lot tab> In City toggle), the consumption on the meter on that lot will display in the In City column on the report.

Step by Step

1     Open the Consumption By Type window (UB> Reports> Consumption by Type Report).

2     Configure the report.

• Select the meter read routes you would like to include in the report in the Route List field.
  • Press CTRL+A to highlight all of the routes in the field. Press SPACE to check or uncheck all of the selected routes.
  • Meter routes are attached to devices, not UB customer accounts. You can view the meter route attached to a device on a customer account using the Account Master Maintenance window (UB> Maintenance> Account> Devices tab).
• Select the billing cycles you would like to include on the report in the Billing Cycle field.
  • A billing cycle is attached to a UB customer account when the account is created using the New Account Wizard. You can view the billing cycle attached to a UB customer account using the Account Master Maintenance window (UB> Maintenance> Account> Account tab> Billing Cycle field).
  • Press CTRL+A to highlight all of the billing cycles in the field. Press SPACE to check and uncheck the toggles in the field.
• The Type and Sub Type drop-down menus are used to select the type of consumption that is included on the report.
  • Select Meter Size if you would like to group the consumption on the report by the meter size attached to the device.
  • Select Lot Miscellaneous 1 or Lot Miscellaneous 2 if you would like to group the consumption by the value in the miscellaneous field attached to the lot record.
    • You can view the values in the miscellaneous 1 and miscellaneous 2 fields on the lot attached to a customer account using the Account Master Maintenance window (UB> Maintenance> Account> Lot tab> Miscellaneous sub-tab).
    • The label of the miscellaneous 1 and miscellaneous 2 fields will vary depending on the label set up for those fields using the miscellaneous fields labels maintenance feature (SS> Utilities> Miscellaneous Fields Labels).
• The Reading begin and Reading end fields are used to filter the meter reading included on the report.
  • You can view the meter read date on a meter reading using the Account Master Maintenance window (UB> Maintenance> Account> Devices tab> Meter History sub-tab). You can also view the meter readings on a device using the Device Maintenance window (UB> Maintenance> Device> Consumption tab).
• The Reading period and Reading year fields are used to filter the readings that display on the report by the read period and read year. You can view the read period and read year of a meter reading using the Account Master Maintenance window (UB> Maintenance> Account> Device tab> Meter History sub-tab). You can also view the meter readings on a device using the Device Maintenance window (UB> Maintenance> Device> Consumption tab).

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).