Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

 GB – ExcessiveNonConsumptionCost   (ELECTRICITY ONLY)


Excerpt

Checks bills for excessive electricity non consumption based charges such as standing charges. It will fail validation if the standing charges are greater than those on consumption charges – a tolerance can be applied.



Validator Set Up

Variables

VariableDescription
Bill will pass validation if the Query Value is less than (£)Enter a monitory figure, for example 100.  The Validator will only fail if the value of the difference is above £100
Tolerance value non consumption based charges must not exceed (%)Enter a percentage figure that you want the value to be within, for example 50  (for 50%)

Bill Entry screen

Failure Prompt

...

'MinimumQueryValue=100.00' - The minimum difference in the two figures before the validator fails, ie 100.00 is £100

'toleranceAmount=133.00' - 50% (the tolerance figure) of the Taxable total field (ie 50% of £266.00 = £133.00)

...