Validator Set Up
Variables
| Variable | Description |
|---|---|
Bill Entry details
Failure Prompt
BE – BillInvoiceNumber 
Ensures that an invoice number is being entered.
Set Up:
| Field | Criteria |
|---|---|
| Minimum invoice number length (chars) | Enter a minimum of 1 (Sigma will then expect to see an Invoice number) |
| Maximum invoice number length (chars) | Enter a maximum length that the invoice should be |
| Pattern that invoice field must adhere to | Enter .+ W H Y ???? |
BE – BillReceivedDateValidator
Ensures that a received date is entered in the invoice screen.
No additional set up required.
BE – BillThisPeriod
Checks to make sure the Bill This Period cell has been populated.
No additional set up required.
BE – ElecUseDeMin & BE – GasUseDeMin 
Checks whether a value of 1 has been entered in the deminimus cell. Validator will fail if any other value is there. If the 1 is present and the cost of the invoice is not adding up then it may be that CCL has been incorrectly charged.
BE – InvoicedvsCalc
This validator compares the invoice cost with the calculated Sigma bill cost and will fail if out of the tolerance threshold.
Set Up:
| Field | Criteria |
|---|---|
| Bill will pass validation in the Query Value is less than (£) | If the monetary difference is less that this figure, the validator will fail |
| Tolerance value (%) | Minimum value of 0 (if you want it to be exact) |
BE – MDentry
Used to ensure a maximum demand is entered on to the invoice screen. Works by comparing the maximum demand tag cell against the previous invoice; if the previous invoice is greater than 0, then the validator will fail if maximum demand has not been entered.
BE – WaterVat
Used to ensure that water invoices have 0% VAT.
Set Up:
Variable, VAT Limit: Enter 0 to ensure VAT isn't charged on a Water Bill
BE – UniqueInvoiceNumberValidator
Checks if the invoice number is unique to that account.
Tenant Billing
The Tenant Billing (TE) validators apply to Tenant Billing only:
TB - HfdChannelGapCheck.xml
Checks for any gaps in Periodic Channel Data
TB - ZeroConsumptionCheck.xml
Checks to see if the consumption is zero
TB - totalConsumptionTol.xml
Checks that the total consumption on this bill is within a set percentage of the previous bill
The percentage is set by the User
TB - totalConsumptionTolYear.xml
Checks that the total consumption on this bill is within a set percentage of the previous years bill
The percentage is set up the User