Billing sum check

At the time of billing, there is a need to ensure that the sum of intervals align with the register usage for the billing period, within a configurable tolerance. This requirement has been addressed with Billing Sum Check, which is a custom billing validation functionality that can be enabled for interval billing.

The Billing Sum Check validation compares the sum of intervals for the entire billing period with the difference in registers at the start and end of the billing period.

There could be a scenario where intervals may not line up with the registers due to a technical issue in the meter or because interval estimates are not scaled properly. The Billing Sum Check validation captures these scenarios, which may not have been otherwise easily identifiable by the operator from the IEE User Interface.

The logic in the custom stored procedure:

• Uses the current register being provided for billing and the previous register provided for billing as the two anchors for the calculation.

• Uses any available registers whether they are actual, estimated, or edited.

• Handles register rollover scenarios.

The validation fails if:

• The comparison between the sum of all intervals and the difference between the registers is beyond the specified tolerance threshold.

• The data required to perform the comparison is missing i.e. if any interval reads for the billing period is missing, or if the start and/or end of billing register is missing.

• There has been a critical configuration change in the middle of the billing cycle period.