Shows a list of machines that have billed the same meter repeatedly.
Jump to a specific section by clicking a link
Overview | Samples | Variables | Alert Functionality | Best Practices & Tips | Related Alerts
Overview
Overview
This alert is designed to advise when you are billing the same meter read on a machine repeatedly (showing no clicks per billing cycle). It looks only at billed meters. If you want to review all meters for duplicates, see ID506.
Run Schedule: Weekday evenings
Type of Output: Email
* * *
Sample
Sample
The emailed output is sorted by quantity of repeats, then by the equipment ID number.
1. Meter Type - The meter type for the meter.
2. # of Repeats - The number of times the meter has repeated.
3. Repeating Since - The date of the first repeat.
4. Contract # - The contract number the equipment is on.
5. Billing Cycle - The contract billing cycle.
6. Branch Name - The branch name on the contract.
7. Equipment # - The equipment ID number.
8. Serial # - The equipment serial number.
9. Make - The make of the equipment.
10. Model - The model of the equipment.
11. Customer Name - The customer name on the alert email is from the Equipment Record:
12. Eqp Meter Description - Pulls from the Description field listed in the equipment record meters tab:
13. Display - The display end meter that has been repeating.
14. Meter Source - The Meter source is the last billed meter reading source.
15. Bill Group - The bill group name.
* * *
Variables
Variables
Variable W: Enter minimum number of duplicate meter readings (i.e. if you enter '2', that is the same meter billed twice / one duplicate, if you enter '3', that is 2+ duplicates). Value for Variable W must be '2' or greater.
Variable X: Branch Numbers to trigger on, separated by a comma, or blank for ALL
* * *
Alert Functionality
Alert Functionality
1. To be considered for the alert, the meter must be billed and valid:
2. If the contract invoice has been voided, any meters on that invoice will not be considered.
3. The meter must be active to qualify for the alert.
4. The alert considers the branch per the contract record:
5. The alert checks the date on the invoice, not the date on the meter read:
6. When a new contract invoice is created, the alert logic finds the end meter used on the invoice and checks to see how many times that same meter read has been used as the ending billing meter. When the number of times the meter has been used is equal to greater than the value set in Variable W, the alert will trigger.
7. Alert will consider Contract Major Number, not minor, to see if repeated meter across multiple contract numbers. In the screenshot below, the contract major number is 33826.
* * *
Best Practices & Tips
Best Practices & Tips
When the customer is storing equipment and therefore no meter read is collected:
When customers temporarily put equipment in storage, if it remains on the contract you estimate the same meter over and over, therefore triggering this alert. One option is to remove the equipment from the contract (put an end date and end meter) so it will not bill out / ask for meters. When active again add the equipment back onto the contract (new start date).
Another option, if you want to keep the equipment on the contract, you can move it to its own meter group (i.e. Stored Equipment) and override the overage schedule just for that meter group i.e. to yearly. There is also the option to use equipment meter reading schedule only on the equipment that is in storage and set that schedule out further than the normal overage schedule. This way the stored equipment would need to be stored for 3 years (3 estimated meters entered in a row) for it to report on the alert. In that case any temporary stored equipment likely would not be stored for length of time, and you would be better to remove from the contract.
* * *
Related Alerts
Related Alerts
ID506 - Duplicate Identical Billable Meter Reads
ID550 - Takes new meter readings and compares to volume trend for sanity check
* * *
0 Comments