Versions Compared

Key

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

...

Image AddedGB – CapacityTolerance Image Modified


Excerpt

Compares the capacity declared on the current

...

invoice to the capacity declared on the previous

...

The Validator checks field 1028 (Capacity kVA Value)

...

invoice and will allow for a tolerance if required.


Note: The Validator 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