Versions Compared

Key

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

...

Excerpt

Compares the capacity declared on the current invoice to the capacity declared on the previous invoice and will allow for a tolerance if required.


Note: The Validator checks field 1028 (Capacity kVA Value)  SCREEN SHOTThe Validator will be is unable to complete if there is not a previous bill

Validator Set Up

Variables

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

Bill Entry Screen 

Current bill

Image Added

Previous bill

Image Added

Failure Prompt

Image RemovedImage Added


Total capacity within % of previous bill: FAILED - The name of the Validator

...

'capUnits=400.00' - The value entered into field 1028,  400 kVACapacity kVA field -  400 (in the current bill)

'MinimumQueryValue=50.00' -  The minimum amount the query needs to be (in £s) for the Validator to fail, ie £50

'upperlimit=191202.9000' - The amount of the kVA on the previous bill plus 1% (as set in the Validator) 190 200 + 1.90 2(1%) = 191202.9000

'capcost=200.00' - The value in the Capacity kVA field (field 1028-  200 (in the previous bill)

'QueryValue=105100.00' - The monitory value of the difference in the previous bill kVA and current bill kVA (current bill £200.00, previous bill £95£100,  £200 - £95 £100 = £105£100).  

'lowerlimit=188198.10 00 The amount of the kVA on the previous bill minus 1% (as set in the Validator) 190 200 - 1.90 2 (1%) = 188198.1000