Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Validator Set Up

Variables

...

Bill Entry details

Failure Prompt

BE – BillInvoiceNumber Image Modified

Ensures that an invoice number is being entered.

Image Removed

Set Up:

...

Invoice number with a minimum / maximum length has been added.

Validator Set Up

Image Added


Variables

VariableDescription
Minimum invoice number length (chars)Enter a minimum of 1 (
Sigma will then expect to see an Invoice number
This will ensure the invoice isnt 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.+

    W H Y  ????

BE – BillReceivedDateValidator Image Removed

Ensures that a received date is entered in the invoice screen.

Image Removed

No additional set up required.

BE – BillThisPeriod Image Removed

Checks to make sure the Bill This Period cell has been populated.

Image Removed

No additional set up required.

BE – ElecUseDeMin & BE – GasUseDeMin Image Removed

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 Image Removed

This validator compares the invoice cost with the calculated Sigma bill cost and will fail if out of the tolerance threshold.

Image Removed

Set Up:

...

BE – MDentry Image Removed

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.

Image Removed

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

...

to ensure something is entered into this field

Alternatively, you can specify what characters you expect the invoice number to be

Bill Entry details

Image Added

Failure Prompt


Image Added

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:

Image Added

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)