Sigma Online User Manual

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 6 Next »

There are two in this section, one is specifically for Electricity.

  • Invoice vs Calculated
    • Compares the total value of the invoice (as calculated by Sigma) against the total value declared on the invoice
  • Electricity Invoiced Vs Calculated
    • Compares the total value of the Electricity invoice (as calculated by Sigma) against the total value declared on the invoice

GB – InvoicedvsCalc                                                                               GB – ElecInvoicedvsCalc

                                                    

Validator Set Up

                                         

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

Failure Prompt

Invoice Vs Calculated                                                                                              Electricity Invoice Vs Calculated 

                                     


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%

'upperthreshold=137.36' - The upper threshold (the value in the Billed this period field, plus 1%  - ie £136.00 + £1.36 (1%) = £137.36

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

'lowerthreshold=134.64'  - The lower threshold (the value in the Invoice cost field, minus 1%  - ie £136.00 - £1.36 = 134.64

'totalCharge=126.00' - The amount  in the Invoice cost field (the amount Sigma calculates the bill to be), £126.00

'QueryValue=10.00' - The difference between the Bill this period field and Invoice cost field, ie  £136.00 - £126.00 = £10.00



  • No labels