GB – InvoicedvsCalc 
Compares the total value of the invoice (as calculated by Sigma) against the total value declared on the invoice. It allows for a % difference.
Validator Set Up
Variables
| Variable | Description |
|---|---|
| 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 |
| Tolerance value (%) | The percentage you want the invoiced and calculated costs to be within. For example, enter 1 for 1% |
Failure Prompt
Invoice cost differs from calculated: FAILED - name of the Validator
'upperthreshold=151.9444' - The amount of the acceptable higher threshold, £151.944 (1% higher than the Invoice cost of £152.87) (SHOULD THIS BE £151.3413???) THIS IS 1% LOWER THAN THE BILL THIS PERIOD FIGURE??
'tolerance=1.00' - The amount of acceptable difference, ie 1%
'MinimumQueryValue=0.50' - The minimum difference in the two figures before the validator fails, ie 50p
'lowerthreshold=148.9356' - The amount of the acceptable lower threshold, £148.9356 (1% lower than the invoice cost of £152.87) SHOULD THIS BE £151.3413???. THIS IS 1% LOWER THAN THE BILL THIS PERIOD FIGURE??
'totalCharge=152.87' - The figure entered in the Bill this period field
'QueryValue=2.43' - The difference between the Invoice cost and the Bill this period figures, ie £152.87 - £150.44 = £2.43
