Versions Compared

Key

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

...

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

Image Added


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.


Image Added




Viewing the Validation Results Overview

Hover over the bill line and the Validation Stats Column to see an overview of  the Validation results


Image Added



Viewing the Validation Results

Right click on the Tenant Bill

...

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  ???????????????????????????????