variance report - bill, meter accounts - pnpscada

Avatar

sdg.matiaan
2018-06-06 12:41

for more information on the billing process, see here

This screen compares this bill run with previous bill runs, so that you can easily pick up on irregularities.

2 tables are shown:

  1. First table shows each Meter Account involved in the bill run on a separate line
    Columns:
    1. CNUMBER: contains 2 links
      1. First link scrolls the second table to match up with the first table
      2. Second link takes you to the Profile Graph for the customer
    2. NEW RUN: this bill run's daily average bill (Total Bill divided by Number of Days in Bill Run)
      The averages allow you to compare different bill run lengths with each other.
    3. OLD1-3: Daily Averages of previous 3 bill runs
    4. NEW RUN: Worst Percentage comparing this month's average with the previous 3 months.
  2. Second tables shows each Line Item of each bill per Meter Account
If NEW RUN is more (positive or negative) than the percentage at the bottom, the line is marked in red.
This allows you to only zoom in to meter accounts that do not match up with previous month's trends.


Tags: billing
Please log in to post a comment