Summary

The Consumption by Service Report displays the total consumption filtered by meter route and grouped by service. Meters are included on the report by the service rates attached to the customer account. The consumption on a meter will only be included on the report if there is an active service rate on the customer account that has the same bill type as the meter. For example, if a meter has a bill type of WATER, the consumption on that meter will only be included on the report is the customer account attached to that meter has an active service rate for the WATER bill type. Bill types are attached to service rates using the Service Rate Maintenance window (UB> Maintenance> Service Rates> General tab> Bill Type field).

The consumption on the meter will display on the report twice if there are two service rates of the same bill type attached to the customer record attached to the meter. For example, if a meter has a bill type of WATER and there are two active service rates on the customer account with a bill type of WATER, the consumption on the meter will display on the report twice. The consumption on the meter will display on the report even if the service rate is set up as a flat amount.

You can generate the report in summary or detailed format. The summary version of the report will display a separate line item for each service rate attached to the customer account on the meter that has the same bill type as the device. For example, if you generate the report for a meter route that only contains WATER bill type meters and all of the customer accounts attached to those meters have service rate WATER1 (which is set up as a WATER bill type service rate), all of the meters on the route will be combined into a single line item that reads WATER1.

The detail version of the report will display each meter separately on the report, including the meter route, sequence, and serial number and the customer account number.

Step by Step

1     Open the Consumption by Service window (UB> Reports> Consumption by Service).

2     Configure the report.

• The Route field is used to select the meter routes you would like to include on the report.
  • Press CTRL+A to highlight all of the toggles and then press SPACE to check or uncheck all of the selected toggles.
  • You can view the route of a meter attached to a customer account using the Account Master Maintenance window (UB> Maintenance> Account> Devices tab> Meter Details sub-tab> Route-Sequence field).
• The Report Type drop-down menu is used to select the level of detail you would like to display on the report.
  • Select Summary if you would like all of the meters on the report to be totaled by the service rate attached to the customer account. Each service rate will display as a separate line item on the report.
  • Select Detail if you would like all of the meters to display on the report. This will add the meter route, sequence and serial number to the report along with the customer account number of the customer attached to the meter.
• The Service drop-down menu is used to select the services you would like to include on the report.
• Select a conversion in the Convert To drop-down menu to convert the consumption that displays on the report to another unit type. If you do not select a conversion, the consumption will display on the report as it was read. For example, if there is 100 acre feet of consumption one meter and 100 cubic feet of consumption on another meter, both devices will display 100 units of consumption on the report. The Convert To drop-down menu allows you to convert the consumption on both meters to a single unit type such as acre feet or cubic feet.
  • The Convert To drop-down menu will display all Consumption Conversions created in UB> Maintenance> Consumption Conversions.
  • The consumption amount in the report is pulled from the Consumption field of the Meter History table and is multiplied by the conversion selected in the Convert To field.
• The Reading Period and Reading Year fields are used to filter the meter readings that are included on the report.
  • The reading period and reading year of a meter read are set in the Meter Reading Import window when the meter readings are imported into the application (UB> Meter Management> Readings Import> Reading Period and Reading Year fields).
  • You can view the read period and read year of a meter reading on a customer account using the Account Master Maintenance window (UB> Maintenance> Account> Devices tab> Meter History sub-tab> Reading Period/Year column).
• The Device Type drop-down menu is used to select the device type you would like to include on the report.
  • Device types are attached to meters when they are created or installed on the account using the Service Request Input Wizard. You can view the device type attached to a meter on an account using the Account Master Maintenance window (UB> Maintenance> Account> Devices tab> Details section> Device Type column).

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