Versions Compared

Key

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


There are two to check the Fixed Charges, one for Electricity and one for Gas.

...

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.

...

  • GB - ElecFixedCharges
  • GB - GasFixedCharges

They both require a Property Key to be on the Site. 

...

  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

See below for more details

         

Validators

There are two Validators to check the Fixed Charges, one for Electricity and one for Gas.

  • GB - ElecFixedCharges
  • GB - GasFixedCharges


The Property Keys needs a unique name (ie FixedElecCharges or FixedGasCharges) and you need to enter include the figure you want to validate against.

For example, if you enter 20 you would expect the Fixed Charges on the Account to be £20 (add a tolerance to the Validator if you don't expect it to be exact, ie 10%)

WHAT CELL(S) DOES IT CHECK??   - have i got the right cell?

...

25, 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 30
  • Validator allows for a 10% difference
    • 30 + 25% higher = 37.5  
  • The bill is for a period of 31 days
  • The Fixed Charges field in the bill has a value of 2000

2000 (the Fixed Charge) / 31 (number of days) = 64.52

The Validator would fail as 64.52 is over 37.5 (30 + 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)

          Image Removed          Image Added     


  • The Validator needs to be set up on the Accounts rather than the Organisation

          Image Added

Validator Set Up

GB - ElecFixedCharges                                                                             GB - GasFixedCharges

Image RemovedImage Added          Image RemovedImage Added


Variables 

VariableDescription
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 differenceEnter the percentage difference you want before the validator will fail, (ie 1 will be 1%)above the Property Key value that is acceptable, ie enter 25 for 25%

Bill Entry screen   

INVOICE SAVED ON VAL4 AND CALLED ElecFixedCharges

Electricity

Image Removed

Electricity 

Image Added  


Gas

Image RemovedImage Added  Image Added

Image Removed


Failure Prompts

Electricity and Gas

Image Added        

...

Image Added


Electric Fixed Charges Validator: FAILED  or Gas Fixed Charges Validator: FAILED - The name of the ValidatorValidator  

'TolerancePercentage=1025.00' -  The percentage tolerance set in the Validator, ie10 ie 25 for 10%25%

'DailyFixedCharge=200064.00516129'  The daily fixed charge?  Where is this figure fromFixed Charges figure (2000) divided by the number of days (31) = 64.516129

'upperLimit=2737.50' - Where is this figure from 

'ToleranceValue=25.00 - Where is this figure from  (the validator tolerance is 10%)??????????

Gas

Image Removed

Gas Fixed Charges Validator: FAILED - The name of the Validator

'TolerancePercentage=10.00' -  The percentage tolerance set in the Validator, ie10 for 10%

'DailyFixedCharge=20000.00'  The daily fixed charge?  Where is this figure from

'upperLimit=55.00' Where is this figure from 

'ToleranceValue=50.00'  Where is this figure from  (the validator tolerance is 10%)?????????? The figure in the Property Key (30) + 25% (the tolerance in the Validator, 25) = 37.5

'ToleranceValue=30.00'  - The figure in the Property Key - 30