...
There are three Validators to check the invoiced cost against the calculated cost:
- Invoice vs Calculated
- Compares the total value of the bill (as calculated by Sigma) against the total value declared on the bill (entered in the Bill this period field).
- Electricity Invoiced Vs Calculated
Compares the total value of the Electricity bill (as calculated by Sigma) against the total value declared on the bill (entered in the Bill this period field).
- Gas Invoiced Vs Calculated
- Compares the total value of the
...
- Gas bill (as calculated by Sigma) against the total value declared on the
...
- bill (entered in the Bill this period field).
Each Validator can be set to allow for a percentage difference
Validator Set Up
GB – InvoicedvsCalc GB – ElecInvoicedvsCalc
GB – GasInvoicedvsCalc
Variables
| Variable | Description |
|---|---|
| Bill will pass validation if the Query Value is less than (£) | Enter a monitory figure, for example 0.5 The Validator will only fail if the value of the difference is above 50p, or 5 for £5.00 |
| Tolerance value (%) | The percentage you want the invoiced and calculated costs to be within. For example, enter 1 for 1% |
Bill Entry details
...
Failure Prompt
...
Electricity Gas
Failure Prompt
Invoice Vs Calculated Electricity Invoice Vs Calculated
Gas Invoiced vs Calculated
Electricity Invoice Vs Calculated Failure
Invoice cost differs from calculated: FAILED FAILED - The name of the Validator
'upperthresholdtotalBilledCharge=151136.944400' - - The amount of the acceptable higher threshold, £151.944 (1% higher than the Billed this period cost of £150.44) (SHOULD THIS BE £151.3413???) THIS IS 1% LOWER THAN THE BILL THIS PERIOD FIGURE??The total charges entered in the Bill this Period field £136.00
'tolerance=1.00' - The percentage tolerance, ie 1%
'upperthreshold=137.36' - The amount of acceptable difference, ie 1% The upper threshold (the value in the Billed this period field, plus 1% - ie £136.00 + £1.36 (1%) = £137.36
'MinimumQueryValue=05.5000' - The minimum difference in the two figures before the validator fails, ie 50pamount the query needs to be (in £s) for the Validator to fail, ie £5
'lowerthreshold=148134.935664' - The amount of the acceptable - The lower threshold , £148.9356 (1% lower than the invoice cost of £152.87) SHOULD THIS BE £151.3413???. THIS IS 1% LOWER THAN THE BILL THIS PERIOD FIGURE??(the value in the Invoice cost field, minus 1% - ie £136.00 - £1.36 = 134.64
'totalCharge=152126.8700' - - The figure entered amount in the Bill this period fieldInvoice cost field (the amount Sigma calculates the bill to be), £126.00
'QueryValue=210.4300' - The difference between the Invoice cost and the between the Bill this period figures, ie £152.87 - £150.44 = £2.43field and Invoice cost field, ie £136.00 - £126.00 = £10.00