Rate Notifications

Introduction

Whenever there are Rate updates or changes in the Tariff some sort of communication must be made with Users that are using those Rates. Rate Notifications functionality eases manual tasks by allowing users to quickly and automatically create Jobs that inform Users about upcoming (depending on 'effective from' the value in the future) Rate prices and also await their confirmation whether they agree or disagree with them.

Workflow schema

The workflow can be visualized using the following schema:

Rate Notifications Templates

The data is generated into an XLSX file. The system contains a Default template, which is assigned for all users.



It is possible to create a custom template file and use it for customers by clicking ADD NEW TEMPLATE and filling cells by your needs or uploading an XLSX Template file.

• Note: If a row has a value, the column near it cannot be blank.

It is also possible to assign Rate Notification Template for a User in his settings.

Rate Notifications

Rate Notifications is the primary page of the functionality, it displays unique Tariff - User associations to whom Notification can be sent.
This page can be found in Menu -> BILLING -> Tariffs -> Rate Notifications

Associated Tariff - User objects are shown only when the following conditions are met:

• Tariff is Sell type;
• User's Connection Point is assigned Sell Tariff in Origination Point settings;
• Tariff was modified and does not have any Rate Notification Job created for specific Tariff - User;
• Tariff was modified and a specific Tariff - User Rate Notification was created prior to Tariff modifications.

Creating Rate Notification

In order to create new Rate Notification Jobs, check wanted Tariff - User associations and press Set.
All required Notifications can be selected by clicking the header checkbox.



After selection, another page will be loaded with options for these specific Notifications.
"Selected Tariffs - Users" displays marked associations to whom Notifications will be sent. "Options" has several settings:

• Template - Rate Notification Template.
• Email Template: which Template will be used for email? The default "tariff_rate_notification" template is already present in the system and can be modified to fit specific needs.
  • Additional possible variables:
    • rate_notification_tariff_name - Rate Notification's Tariff name
    • rate_notification_url_agree - Rate Notification's Agreement link
    • rate_notification_url_disagree - Rate Notifications' Disagreement link
    • rate_notification_decreases_effective_from - Rate Notifications' Decreases Effective From date
    • rate_notification_increases_effective_from - Rate Notifications' Increases Effective From date
• Rate Notification Type:
  • Delta Only: future Rates only.
  • Full: all future and currently active Rates.
• Agreement Timeout in days: timeout after which Notification will be automatically marked as disagreed (ignored) if the User did not respond. A Timeout adds a specified day's value to the Notification created time.
• Decreases Effective From - select date and time.
• Increases Effective From - select date and time.
• Filename - Name of the notification file.
• Send Email:
  • Every day: send an email every day until either the Agreement link is pressed or Agreement Timeout is reached
  • Once: send email only one time.

After pressing the Create button, Jobs will be created and the Rate Notification Jobs page will be loaded.

Rate Notification Jobs

Rate Notification Jobs is the page where the system will automatically gather required Rates data, send emails, and awaits Users' response.
This page can be found in Menu -> BILLING -> Tariffs -> Rate Notifications -> Jobs

Jobs have the following states:
Assigned
After Rate Notification is created a new Job appears as assigned.

Date Generated
The system checks for all newly assigned Jobs and generates required data in XLSX format, which can be downloaded from the list. The same exact file will be attached to the email.
Rates will be converted using the default currency. To prevent conversion, setting - "Use Tariff currency in the CSV export" must be enabled.
This setting can be found in Maintenance -> Settings -> Various -> Use Tariff currency in CSV export.

Email Sent
All Jobs that have successfully generated data will send emails to Users with unique agree and disagree links which can be clicked on only once and within the specified timeout.
Email will not be sent if there were no changes in rates!

Completed
Depending on the User's actions, the Job can be either agreed upon, disagreed with, or ignored. The list will display specific responses and the time it was responded to. Also, an additional email will be sent to Admin informing Rate Notification Job response status.

Examples

Type: Full, Rate Notification Agreed

The user have tariff with some rates:



Admin uploads new rates with some changes on prices and Effective from date in the future:



In Billing > Tariffs > Rate Notifications, Admin now can see a new entries. Admin selects new entry and clicks “SET”:



Then Admin selects “Full” to display old rates and new rates and click “Create”:



New Rate Notification is created:



The user gets email with two links:



and file with rates comparison:



After checking new rates, the User clicks on the first link in the email to agree with the new rates:



Now, Admin gets an email about new rates being confirmed:



And also sees the update status in the Rate Notifications Jobs list:

Type: Delta Only, Rate Notification Disagreed

The user has tariff with some rates



In Billing > Tariffs > Rate Notifications, Admin can see a rate notification list of his users. Admin selects the needed user and clicks “SET”:



Then Admin selects “Delta” to display only new rates and press “Create”:



Tariff Rate Notification Job(s) successfully created.



Then Admin uploads new rates with some changes on prices Effective from the date in the future.

After this, the user gets an email with two links with rates to compare:

Dear Partner,
Please review the attached Tariff Rate changes.
To confirm upcoming rate changes, please click the link below:
http://123.123.123.123/billing/tariff_rate_notification_jobs/agree?id=1128bccbac519a04a4866c785f84f873eec6d5fd
If You do not agree with the changes, please click the link below:
http://123.123.123.123/billing/tariff_rate_notification_jobs/disagree?id=bcc02d82cf9d919af38bb4e4677685eeb0b382a8
Thank you for your cooperation.




For example, the User disagrees and presses the second link. He can see the notification that Tariff Rate changes successfully disagreed.

After that Admin will receive an email that the client disagreed and will see the same status in Tariff Job.

Tariff Rate Notification ID: 2 was disagreed with by the client.

When the User disagrees with the provided rates or ignores them, the system creates a Custom Tariff from the tariff assigned to Origination Point.

Custom Tariff includes increased rates, but these rates are blocked and calls will not pass over these destinations.

This Custom Tariff is assigned to Origination Point.

Note:

1. If Origination Point already has Custom Tariff assigned, Custom Tariff from Rate Notification will be applied.

2. If Origination Point has assigned a Conditional Tariff and the User disagrees with the provided rates or ignores them, Custom Tariff is created, but is not assigned to Origination Point.