...
| Excerpt |
|---|
Calculates the daily amount for fixed charges based on the number of days in the billing period and checks this against the value in the Property Key. The Validator fails if the value from the bill exceeds the figure set in the Property Key. |
Requirements:
- Needs a Property Key setting up on each Account
- The Validator needs to be set up on the
...
- Accounts rather than the Organisation
There are two Validators to check the Fixed Charges, one for Electricity and one for Gas.
- GB - ElecFixedCharges
- GB - GasFixedCharges
...
The Property Key needs a unique name (ie FixedElecCharges or FixedGasCharges) and you need to enter the figure you want to validate against.
For example, if you enter 2025, the Validator will take that as a daily figure, it will then look at the figure in the Fixed Charges field in the bill and divide it by the number of days and match one against the other.
Example:
- Property Key has a value of 25 30
- Validator allows for a 10% difference
- 25 30 + 10% 25% higher = 2737.5 5
- The bill is for a period of 30 31 days
- The Fixed Charges field in the bill has a value of 1050 2000
1050 2000 (the Fixed Charge) / 30 31 (number of days) = 35 64.52
The Validator would fail as 35 as 64.52 is over 27 37.5 (25 30 + 10%25%)
Requirements
- A Property Key needs to be attached to the
...
- Account, with the exact wording in the Variables (ie FixedElecCharges or FixedGasCharges)
- Click here for more details on how to add the Property Key(s)
- The Validator needs to be set up on the Accounts rather than the Organisation
Validator Set Up
GB - ElecFixedCharges GB - GasFixedCharges
Variables
| Variable | Description |
|---|---|
| Name of the Property Key defining Tolerance value (attached to Account) | Enter the exact name of the Property Key that is attached to the Account (see above, for example FixedElecCharges) |
| Tolerance Percentage for difference | Enter the percentage above the Property Key value that is acceptable, ie enter 10 25 for 10%25% |
Bill Entry screen
ElectricityElectricity
Gas
Failure Prompts
Electricity and Gas
...
Electric Fixed Charges Validator: FAILED - The name of the Validator
'TolerancePercentage=10.00' - The percentage tolerance set in the Validator, ie10 for 10%
'DailyFixedCharge=35.00' -The Fixed Charges figure (1050) divided by the number of days (30) = 35
'upperLimit=27.50' -The figure in the Property Key (25) + 10% (the tolerance in the Validator, 10) = 27.50
'ToleranceValue=25.00 - The figure in the Property Key - 25
Gas
Gas FAILED or Gas Fixed Charges Validator: FAILED - FAILED The name of the ValidatorValidator
'TolerancePercentage=1025.00' - The percentage tolerance set in the Validator, ie10 ie 25 for 10%25%
'DailyFixedCharge=64.516129' - The Fixed Charges figure (2000) divided by the number of days (31) = 64.516129
'upperLimit=5537.0050' - The figure in the Property Key (5030) + 10% 25% (the tolerance in the Validator, 1025) = 5537.5
'ToleranceValue=5030.00' - The figure in the Property Key - 5030