Validator Set Up
Variables
...
Bill Entry details
Failure Prompt
BE – BillInvoiceNumber
...
| Excerpt |
|---|
Checks that an invoice number |
...
has been entered. |
...
Set Up:
...
Can also be used to ensure a minimum/maximum length of invoice number |
Validator Set Up
Variables
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
...
| Variable | Description |
|---|---|
| Minimum invoice number length (chars) | Enter a minimum of 1 ( |
| This will ensure the invoice isn't left blank and that at least 1 digit/character has been entered) | |
| Maximum invoice number length (chars) | Enter a maximum length that the invoice should be |
| Pattern that invoice field must adhere to | Enter.+ |
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:
...
to ensure something is entered into this field Alternatively, you can specify what characters you expect the invoice number to be. An example would be \d* which means a number followed by zero or more numbers. This would pass 123, but fail A123 or 123A |
Bill Entry details
Failure Prompt
Value " has length less than defined contract '1' - shows that no invoice number has been entered
If the Minimum Value in the Validator was 3, and only 2 digits were entered, the following failure prompt would show:
Value '12' (the figure in the Invoice number field) has length less than defined constraint '3' (the figure in the Minimum Value in the Validator)