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 5 Next »


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

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
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 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 Billed this period cost of £150.44)  (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




  • No labels