Validation can be set up to in Sigma to check Tenant Bills. Click here for more details on how to set up Validation.
Once set up, any bill that fails Validation will be flagged in the Tenant Approve and Issue Bills Activity.
To deal with these failures:
Opening the Tenant Approve and Issue Bills Activity
Click on Tenant Approve and Issue Bills Activity
Filter to the Bills you want to view.
Click here for more details on Filtering.
Ensure the Validation Stats and Validation Status Columns are included in the view.
Click here for more details on adding Columns.
Viewing the Validation Results Overview
Hover over the bill line and the Validation Stats Column to see an overview of the Validation results
Viewing the Validation Results
Right click on the Tenant Bill
Click View Validation Notes
The Validation Results pop-up opens to show you the passed and failed validators
Right click on the Validator and click View to see more detail
By default, only validations results that passed or failed are displayed. To view validations results that were unable to complete:
Right click anywhere on the column header row
Click Filter
The Filter pop-up opens
Tick Show UNABLE TO COMPLETE results
Click OK
The Filter pop-up closes and the Validation Results pop-up is updated to display any validations which were unable to complete.
Click OK to close the Validation Results pop-up
Click the X in the top right-hand corner to close the Validation Results pop-up
Dealing with a Failed Validation
There are 4 Validators that can be set up for Tenant Billing.
Here is a list of the 4 Validators:
- TB - HfdChannelGapCheck.xml
- TB - ZeroConsumptionCheck.xml
- TB - totalConsumptionTol.xml
- TB - totalConsumptionTolYear.xml
Below details how to deal with each Validator if it fails:
TB - HfdChannelGapCheck.xml
Checks for any gaps in Periodic Channel Data.
Gaps can be filled so that the bill reflects the consumption for the whole period.
Click here for more details on how to check the data gap
TB - ZeroConsumptionCheck.xml
Checks to see if the consumption is zero
If the period of the bill shows no consumption, this Validator will fail.
Click here for details on how to check the data
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
To check the previous bills, you will need ??????????????????????????????? How do I see the bills?
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
To check the previous years bills, you will need ???????????????????????????????