WILLIAMS RESPONSE
35.714 units (the amount of units between dates in the Channel) x 27 (not 28 for some reason) (the number of days in the bill) = 964.3 (the predicted advance for the billing period)
964.3 units (the predicted advance for the billing period) added to 12345 (the previous reading in the bill) = 13309.3 (validator shows 13308.4)
IF THE BILL PERIOD IS 1/2/20 - 28/2/20, WHY IS THE PROJECTED METER READING 13308 - THE LAST READING IN THE CHANNEL IS 13000 OF 31/3/20 (AFTER THE BILL PERIOD??)
GB – BillReadsAgainstSelfReadChannel
| Excerpt |
|---|
Compares the invoice meter readings against meter readings entered into Non-Periodic Channels. |
Requirements
...
- Needs the Meter Serial Number to be entered into the Sigma Bill entry screen and a Meter with a Non-Periodic Channel
It looks at the reading values and dates from each channel.
...
- The Account and the Meter to be in the same Supply Point
- The Meter Serial Number to be entered into the Sigma Bill Entry screenThe Meter to have a Non-periodic Channel
- The Non-periodic Channel to have a Property Key (ELECTRIC only) called Self Read Band
- The Meter Serial Number to be entered into the Sigma Bill Entry screen
The Account and the Meter to be in the same Supply Point
The Meter Serial Number to be entered into the Sigma Bill Entry screen
- Enter the Meter Serial Number in the Meter number field when creating the bill (or it will be automatically entered via the EDI File)
- Note: Once this has been added to a bill, it will automatically show on the next bill that is added
The Meter to have a Non-periodic Channel
Click here to see details on adding a Channel
The Non-periodic Channel to have a Property Key (ELECTRIC only)
- Click here to see details on adding a Property Key
Validator Set up
Variables
| Variable | Description | |
|---|---|---|
| Tolerance limit (%) | Enter the required tolerance percentage, ie 10 (for 10%) |
Bill Entry screen - Electricity
Channel Data - Electric
Failure Prompt (Electricity)
Electricity Failure Prompt
...
(E12345) - The name of the Meter
Explanation
Bill Details:
- The Previous reading - the Bill has a Meter reading value of 12345 (previous reading) as as of 1/2/2020 (From date)
- The Present reading - the Bill has a Meter reading value of 15000 (present reading) as as of 28/2/2020 (Reading date)
- Number of days in the bill = 28
Channel Details:
- The nearest date in the Channel to the from date of the bill is 1/2/2020, with a reading of 11000
- The nearest date in the Channel to the to date of the bill is 1/3/2020, with a reading of 12000 (1000 units used in 28 days)
- 1000 units / 28 days = 35.714 units per day between the two best available dates in the Channel
Calculation
35.714 units (the amount of units between dates in the Channel) x 27 (not 28 for some reason) (the number of days in the bill) = 964.3 (the predicted advance for the billing period)
964.3 units (the predicted advance for the billing period) added to 12345 (the previous reading in the bill) = 13309.3 (validator shows 13308.4)