Versions Compared

Key

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

There are two in this section, one is specifically for Electricity.three Validators to check the invoiced cost against the calculated cost:

  • Invoice vs Calculated
    • Compares the total value of the invoice bill (as calculated by Sigma) against the total value declared on the invoicebill (entered in the Bill this period field). 
  • Electricity Invoiced Vs Calculated
    • Compares the total value of the Electricity

      invoice

      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 invoicethe bill (entered in the Bill this period field). 

Each Validator can be set to allow for a percentage difference

Validator Set Up

Image Added GB – InvoicedvsCalc Image Modified                                               Image Added  GB – ElecInvoicedvsCalc Image Added                          

...

                                                   

...

Validator Set Up

...

           

Image Added         Image Added                   Image Removed  


GB – GasInvoicedvsCalc

Image Added


Variables

VariableDescription
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

Image Removed

Failure Prompt

...

Electricity                                                                                                                                              Gas                                                                                 

  Image Added                 Image Added

Failure Prompt

Invoice Vs Calculated                                                            Electricity Invoice Vs Calculated 

...

                                   

Image Added                    


Gas Invoiced vs Calculated

Image Added


Electricity Invoice Vs Calculated Failure

Invoice cost differs from calculated: FAILED - The name of the Validator

'totalBilledCharge=136.00' - The total charges entered in the Bill this Period field £136.00  (only shows on Electricity Invoice Vs Calculated) 

'tolerance=1.00' - The percentage tolerance, ie 1%

...