...
GB – BillAgainstAssociatedData
| Excerpt |
|---|
Compares any figure in Sigma that changes over time field in the Bill against a figure in an Associated Data channel. For example, comparing the Electricity Gas Pence Per Unit (PPU) against an Associated Data Channel (which contains the PPU) attached to an Account. |
This Validator can be used to verify the pence per unit (PPU) rates on your bill against the rate you expect it to be (which will be entered in an Associated Data Channel).
...
- Knowledge of how to identify Bill Tags (the number that identifies each field in a bill)
- An Associated Data Channel needs to be created with the specified value, ie the Gas PPU rate
- If the value varies from Account to Account, you would need an Associated Data Channel for each Account. If the value is the same for every Account, the Associated Data Channel could be set up at Organisation level.
- The PPU values needs to be added to the Channel for the period of time that the rates are effective. When prices change, the Channel can be updated
- Different Associated Data Channel Types need to be created for each type of PPU, for example
- PPU ELEC RATE 1
- PPU ELEC RATE 2
- PPU GAS RATE
- PPU WATER
- Click here for more details on how to create an Associated Data Channel
- If the value varies from Account to Account, you would need an Associated Data Channel for each Account. If the value is the same for every Account, the Associated Data Channel could be set up at Organisation level.
Validation Capability
- Compares the values/rate entered in the invoice against the rate(s) in the Associated Data Channel, based on the time and date of the billing period
- Rates are time and date stamped which means older invoices can be processed and validated against the older rates as well as the current invoice being processed if the rate has changed
- Can be set to compare the exact value or set to compare within a percentage tolerance
...