Versions Compared

Key

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

Anchortoptop

Excerpt
hiddentrue

Learn to work with Price plans

Panel
nameblue

On this page

Table of Contents
maxLevel2

Overview

Price plans are your company's price catalogues. All the billed products are added to at least one price plan in order for billing to be applicable. Subscribers and customers are billed for their purchases based on the rates defined in the price plan usually agreed upon contract signing.

Major features

  • Use price plans to define rates for every billable product that is added to a subscription, job or activity with the exception of usage services which are added in dedicated Usage Price Catalogs. 
  • Provide discounts to customers by defining lower than base rates for a specific period, or for a certain purchased quantity
  • Create conditional price plans, where rates specified can be applied only on fulfilling conditions specified on each price plan, making them a powerful tool used for providing several types of promotions and discounts to customers.
  • Easily manage overall price adjustments due to changed tax rates

 

Setting Up Price Plans

Info
iconfalse
 Finance Application > Products and Pricing > Price Plans

Price PlansImage Removed

...

Before setting up your price plans, it is important to understand the different rate models that exist and how billing handles each rate model. When adding new products to the price plan, the rate models available for selection depend on the classification of the product which can be one of the following: expense, termed service, one time service or physical good.

...

Rate Model

...

How it works

...

Applicable for Product Classification

...

Expenses

...

Flat Rate, Quantity Based

 

...

Applies a single fixed price based on the quantity of the product, which starts from a base rate and can be modified as the quantity increases, by using a multiple tiers table.

If used for termed services, then the logic changes according to the number of the distributors. The quantity of the service will be measured based on the number of authorised distributors of the service. The service will be billed only once, taking into consideration the applicable price.

 

...

Termed services, physical goods

...

Not cumulative;

If the quantity falls into multiple tiers , then the final price is equal to the price of the highest level .

If the quantity does not fall into any quantity range, then the final price is equal to base rate price

...

A channel available from multiple TVs (rooms in the house with different decoders):
If for 1 TV the price is €10 and from 2 to unlimited units the price is €8 then:

  • A channel available from one TV will be billed €10
  • A channel available from two TVs will be billed (€8*2) = €16
  • A channel available from three TVs will be billed (€8*3) = €24

...

One-time services

...

Not cumulative;

If the duration falls into multiple tiers, then the final price is equal to the flat rate price of the highest level.

If the duration does not fall into any quantity range, then the final price is equal to the base rate price

...

Installation service: for 1 hour the charge is €10 and from 2 to unlimited hours the charge is €8 then:

  • An installation that lasts for one hour will be billed €10
  • An installation that lasts for two hours will be billed (€8*2) = €16
  • An installation that lasts for three hour will be billed (€8*3) = €24

 

...

Tiered Rate, Quantity Based

...

Applies a price which starts from a base rate and can progressively change as the quantity increases, using a price table made up of multiple tiers.
Each tier, defines a quantity range and the rate that will be applied to a product if the quantity of the purchased product falls within that range.

...

Termed services, physical goods

 

...

Cumulative;

If the purchase of a product falls into multiple tiers, then the final price is calculated by adding up the base rate and the rates of each tier.

If the duration does not fall into any quantity range, then the final price is equal to the base rate price

...

Antenna: If for 1 antenna the price is €10 and from 2 to unlimited units the price is €8 then:

  • An antenna will be billed €10
  • Two antennas will be billed for  €10 + €8 = €18
  • Three antennas will be billed for (€10*1) + (€8*2) = €26

...

Applies a price which starts from a base rate and can progressively change as the duration required to provide the service increases, using a price table made up of multiple tiers.
Each tier, defines a duration range and the rate that will be applied to a service if the duration of the service falls within that range.

...

One-time services

...

Cumulative,

If the duration of the service falls into multiple tiers, then the final price is calculated by aggregating the base rate and the rates of each tier.

...

Installation service: for 1 hour the charge is €10 and from 2 to unlimited hours the charge is €8 then:

  • An installation that lasts for one hour will be billed €10
  • An installation that lasts for two hours will be billed  €10 + €8 = €18
  • An installation that lasts for three hour will be billed (€10*1) + (€8*2) = €26

...

Tiered Rate, Maturity Based

...

Applies a price which starts from a base rate and progressively changes as the subscription maturity (age length) increases, using a price table made up of multiple tiers.
Each tier defines a period range and the rate that will be applied on a product if the subscription age falls within that range.

 

...

Termed services

...

Cumulative;

If the subscription age falls into multiple tiers, then the final price is calculated by adding up the base rate and the rates of each tier.
The 'to' field, in tiered pricing, includes the binding end as an extra option (free text integers and unlimited option).

...

Channel: if for the first month the channel is for free, from the second to third month is €10 and then until binding end is €20 then

  • A subscriber with a biannual billing frequency (6 months) will be billed 0 +  €10 + €10 +  €20 +  €20 +  €20 = €80

Back to top

...

This table contains an explanation of the sections of price plans Data Entry page, a description of the usage of its fields and additional information.

...

Main Information

Code: The code of the price plan which is used to identify the plan throughout the system along with the name. Due to constant price changes, price plans usually have multiple versions, each applicable for a specific period. The code is always the same, for all versions of the price plan.

Type: The type of the Price Plan which can be either Base or Conditional and it is generated automatically by the system when creating the price plan.

Effective Date: The date that the price plan rates can be used for billing. A new effective date is set in each version of the price plan automatically.

Expiration Date: The date that the price plan rates can no longer be used for billing. 

    • Rates from expired price plan versions may still be used if the customer made a binding contract with the business, and the system is configured to apply the rates applicable during sign up. This applies even if the price changes due to a change in VAT.
    • The expiration date is set in each version of the price plan. Every time a new version is created it, the expiration date of the system is automatically set equal to the effective date of the new version.

Base Price Plan : Used when creating a new conditional price plan. The rates from the base price plan rates will be applied if the conditions specified in the conditional price plan are not met.
When a Base Price Plan is selected then, 'Selection Conditions' and 'Validity Condition' tabs become available.

Rates

 

Define the rates of the products. The rates are categorised and can be filtered by product classification: physical good rates, One time services rates, termed services rates, expenses rates.

 

Product Information: The product that is rated, along with product type and product classification.

Code: The rate code used by the system to identify rates. It is automatically generated but is editable.

Product Bundle: The product bundle related with the selected product. This information is visible only if the specified product is used as a component belonging to a product with a type classified as flexible bundle product which is only applicable for termed services. 

Rate Model: The rate model that is applicable on the rate. The available rate models depend on the classification of the product to be rated, as described in the Rate Model Table. 

 Base Amount: The rate that is applied if tiered rates are not provided or are not applicable. Base amount also has a UOT(Unit of Time) which is applicable and mandatory for termed services and one-time services.
If necessary, the system will convert a rate from monthly to daily. Businesses which bill on a daily basis are recommended to add a Daily rate for more precise results. 

 Effective Starting From: This is applicable for termed services only and is used to determine when the recurring charge will become active. The following options are available:

  • Binding start date: The rate will become active on the date that the binding period (as specified at the Billing Term) begins.
  • Service Effective date: rate will become active on the date that the Service will become effective.
  • Agreement date: The rate will become active on the date that the customer accepted the Billing Terms.
Tiered Rates

Tiered Rates are used to define a different rate than the base rate either for a particular period or quantity, according to the rate model selected. Check the Rate Model Table to understand the application of the tiered rates.

Level: A level number to identify the order by which levels are considered.

From: The value from which the tier level applies.

To:The value up to which the Tier level applies. A selection can be done from:

    • Specific Number
    • Binding End (for termed services only)
    • Unlimited
Note
  • According to the selected Rate Model and the UOT, the unit for the From and To value may differ.
    • If it refers to a tiered service whose base rate is defined in UOT, the From and To fields refer to the number of UoT. (for example days, month)
    • If it refers to a duration based one time service and the UOT is hours then, the From and To fields refer to the number of UOT. (for example hours)
    • If it refers to a quantity based physical good, then the From and To fields refer to the number of items.

Amount: The amount to be applied for the tier level. 

Selection Conditions

Only available for conditional price plans 

 Conditions which are used to validate whether the price plan can be selected for a subscription or a job

Validity Conditions
Only available for conditional price plans 
Conditions which are used to determine if the rates denoted by a price plan can be applied during billing or not.
Billing will revert to using the respective base price plan rates if any conditions in the conditional price plan are violated.
Allowed Organisational Units
The organisational units that can select and assign the price plan on billing term schemes (as allowed price plans to be used), subscriptions and jobs.

 

Related configuration areas

The following modules are related to price plans and must be configured in order to be able to start using them

Manual LinkAreaDescription 
ProductsProduct Types and ProductsThe products that you would like to provide a rate for must already be configured. Note that if the price plan is already created then upon creation of the product you can also add it to the Price plan through the Product's screen. 

/wiki/spaces/WIP/pages/10008666

/wiki/spaces/WIP/pages/10008551

Billing Term SchemesOnce price plans are created they are added in the 'allowed price plans' tab of the billing term schemes in order to be available for selection on jobs and subscriptions 

 

Back to top 

Using Price Plans

Multiple effective price plans can be created and the applicable one (according to the customer's agreement terms) can be selected when creating a subscription or a job. If conditional price plans are available then they are also available for selection given that the selection conditions defined on the price plan are met, but will only e used during billing if the 'validity conditions set on the price plan are met.

Selecting and creating a price plan

...

Amend existing price plan rates

...

  1. Search for the price plan you wish to amend and from the Data Entry page click on Actions > Replace from the Actions Menu to open the Replace Price Plan Form modal.
    1. New Price Plan's Effective Date: Define the date from which the new price plan rates will take effect.
    2. Adjust Rates by '%': Add a % to update all rates in the price plan or leave empty to make manual updates.
      If you would like to increase rates then add a positive number, if you would like to decrease all rates then add a negative number. If you want to manually change rates of each product then leave this field blank.
  2. Click on SAVE to close the modal.
    If the Adjust Rates By % is defined then, all rates will be automatically updated.  
  3. Click on EDIT from the Actions Menu to start updating the price plan rates.

Automatically calculate and apply discount to rates

...

  1. Select the product rate you want to update.
  2. Click on Calculate Amount link, either on the base or tiered rate.
  3. In the modal
    1. Provide a number in the 'initial amount' text box (this can be the same or different than the base/tiered amount).
    2. Select between amount and percentage and provide a number in the text box below.
    3. Click anywhere outside the text box and check the calculated rate.
    4. Click on SAVE  to apply the change.
      • The system will set the amount that has been calculated, regardless if the 'initial amount' provided was different to the base or tiered amount.
Note
  • Positive numbers must be used in offering a discount.
  • If a negative number is used, then the System will ADD this to the initial amount instead.

    Initial AmountDiscount AmountCalculated Amount
    10.005.005.00
    10.00-5.0015.00
    10.005%9.50
    10.00-5%10.50

Adding new product to existing price plans

...

  1. Click on the name of the plan you would like to add a new product rate to go to the Data Entry page.
  2. Click on Actions > Add New Product from the Actions Menu.
  3. Use Quick Search or click on the magnifying glass to search for the product .
  4. In the modal provide all the necessary information for the creation of the Product as explained in the fields table.

Creating a conditional price plan

 Conditional price plans as implied by the name can be added and used for billing jobs or subscriptions only if two types of conditions are met. These conditions are defined in the price plan.

  • Selection Conditions: If satisfied, the price plan will be available where a price plan is selected to be added to a job or subscription.
  • Validity Conditions: If satisfied, the rates from the applied price plan will be used when billing the job or subscription. Validity conditions are required because from the time that a (job or subscription) price plan is set until the time that is it is billed, the 'selection conditions' may no longer be satisfied. It is recommended to have the same conditions defined for selection and validity.
    If during billing, the validity conditions are not met, then the system will get the rates from the base price plan that was used when creating the conditional price plan.

 

  1. Click on NEW from the actions menu to create a new price plan.
    1. Provide the information in the section as in the case of a base price plan and make sure you select a Base Price Plan that the system will use in case the selected conditional price plan conditions are not met during Billing
    2. Rates
      1. All the rates available in the selected Base Price Plan will be present here. Change the rates accordingly or use the Replace Price Plan action to change all the rates simultaneously by a certain percentage.

    3. SELECTION & VALIDITY CONDITIONS

      1. The process for adding Selection or Validity conditions is the same. 
        Follow the steps below:
      2. In 'Evaluation Settings' there are 2 options that can be set at 2 different levels to select whether all conditions or at least one condition should be met.

        1. General: Select whether conditions for all the condition groups should be met or at least one.

        2. Condition Group Specific: Select whether conditions for all rows within each of the condition group should be met or at least one.

      3. Once the Evaluation Settings are in place, click on each of the condition groups in the group list on the left to start defining the group row conditions.

        1. Click on ADD to add a new row.
          or 
          ADD FROM TEMPLATE to select an existing condition group row.
          Templates are condition group rows that have been previously saved to be reused. They already contain information such as type, operator and value.

        2. Type: Select the type of the condition from the drop-down list.
        3. Operator: Select whether the values defined should be:
            1. Equal
            2. Not Equal
          1. Value: Click on the ADD VALUES link to open the modal to add values for each condition group row, i.e. for the type you have selected.
            1. Like in Evaluation Settings, set whether all the values defined in the modal should be met, or at least one.
            2. Value 1 - Value 20: Use Quick Search or click on the magnifying glass for a search modal to select the values to be set as conditions.

        4. Save as Template: Save the values per Condition Group as a template so that it can be reused in other condition groups of the same type.
          1. Click on the SAVE AS TEMPLATE link and provide a name and description.
          2. Once all the Condition Group rows are complete, repeat the process for a new Condition Group.
          1. Allowed Organisational Units
            1. Add the organisational units that can select and assign the Price Plan
        5. Click on SAVE to save the Price Plan

 

Note

Different values will be available for selection for each type selected in the condition group.
The available types are:

  • Subscription Type: Evaluated against the subscription type of the subscription being billed; that is, the offering the customer is subscribed to. (only available for 'selection conditions')
  • Billable Entity Maturity: Evaluated based on the maturity of the billable entity, which means whether is a new or existing subscription or job. (only available for 'selection conditions')
  • Billable Entities Existing Products: Evaluated against physical goods or services added to the subscription or job
  • Billable Entities Products To Be Added: Evaluated against products that will be added to the subscription or job . (only available for 'selection conditions')
  • Billable Entities Existing Price Plans: Evaluated against existing price plans; for example if you have multiple subscriptions billed from the same account, it evaluates based on the price plans on the subscription (only available for 'selection conditions')
  • Billable Entities Owner Groups: Evaluated against the group that owns the subscription or job
  • Accounts Receivable Classifications: Evaluated against the classification of the account owner that owns the subscription or job
  • Accounts Receivable Credit Ratings: Evaluated against the credit rating of the account owner that owns the subscription or job
  • Accounts Receivable Payment Preference: Evaluated against the payment preference of the account owner that owns the subscription or job
  • Billing Term Scheme: Evaluated against the billing term scheme of the subscription or job
  • Billing Terms Binding State: Evaluated against the binding state of the subscription; for example whether the subscription is in and out of binding
  • Billing Terms Binding Period: Evaluated against the binding period of the subscription; for example if its annual or 2 years
  • Billing Terms Billing Frequency: Evaluated against the billing frequency of the subscription; for example if its billed monthly or annually
  • Segmentation: Evaluated against accounts receivable that belong to a selected segment (list)

 

Defining product bundle pricing

...

There are two types of product bundles, fixed and flexible.

  • Flexible Bundle Products: Products that have a variable selection of constituent products as components.
  • Fixed Bundle Products: Products that have a fixed selection of constituent products as components.

The price of fixed bundle products can be set just like the rest of the products.  Flexible bundle products which is only applied to termed service, allow the user to:

  • Define a price at bundle level; one price for all included products.
  • Define a price at the product level and differentiate when a product is sold as a stand-alone product or as part of a bundle.
  • Define both prices and bill for both the bundle and each product individually.

Add a rate at the bundle product Level

Add the product and in the 'Rates' section provide all the required information and leave empty 'Applicable Only If Part of Bundle'

Add a rate for a product when provided through a bundle

Add the product and in the 'Rates' section provide all the required information and for 'Applicable Only If Part of Bundle'  select the bundle in which the product belongs, and for which you are defining the rate.

Add a rate for a product that belongs to a bundle but is also sold as a standalone product.

  1. Add the product and in the 'Rates' section provide all the required information and leave empty 'Applicable Only If Part of Bundle'
  2. Add the product again and in the 'Rates' section provide all the required information and for 'Applicable Only If Part of Bundle'  select the bundle in which the product belongs, and for which you are defining the rate.

Back to top 

Applying business flows on price plans

Bulk adjustment of rates based on tax changes

Tax changes don't need to be a big hassle. Price Plan Adjustment Run Definitions allow you to define rules that will be used to adjust all affected price plan rates whenever vat or tax rates changes. 

Once the definition is created and scheduling setting set, SUBMIT the definition. Once the run is completed, it will create a new version of each affected price plan and calculate the new rate for products whose tax rate has changed. Note that the adjustment runs should not be used in case the rates in the price plans are not tax inclusive. Refer to Tax Definition, for more information.

 

 Price Plan Adjustment DefinitionImage Removed

Price plan adjustment run definition fields

This table provides an explanation of the sections of the definition Data Entry page, a description of the usage of its fields and additional information.

...

VAT Rate Change as of Date: Defines the date on which the VAT Rate changes to a new rating period.
All VAT Rates which have a 'period start date' before or equal to this date will be available for selection.

VAT Rates: A selection of VAT Rates. Multiple VAT rates can be selected and at least one should be specified.

...

Products not to be adjusted:  A selection of products and/or product types, whose rates should NOT be adjusted.
If no products are specified, then the rate of all affected products will be modified.

...

  • Run Now
  • Run on Specific Date / Time

 

Back to top 

Price plans Business Examples

...

nameblue

Business Requirement

Company ZX wants to set the rates for the following Products, with the following requirements:

  • TV Subscription Start-up fee
    • Start up fee: €5
       
  • Installation Service Fee based on the duration, providing a Tiered Rate:

    • €20 per hour

      • 1 hour: €20 per hour
      • 2 - 5 hours: €15 per hour
      • 6- unlimited: €10 per hour
        i.e. 5 hours of repairs = (1*20)+(4*15) = €80
         

  • Repairs based on the duration, providing a Flat Rate:

    • €20 per hour
      • 1 hour: €20 per hour
      • 2 - 5 hours: €15 per hour
      • 6- unlimited: €10 per hour
        i.e. 5 hours of repairs = 5*15 = €75

...

  • Antennas
    • 1: €10
    • 2: €9
    • 3: €8
    • 4 - Unlimited: €7
      i.e., buying 3 antennas = 3* €8 =  €24
       

...

VOD Service fee, based on the number of distributors that the Services are supplied to, providing a Flat Rate:

  • VOD Subscription Service
    • Only Main Distributor (i.e.,.1): €5
    • Main and Twin 1 Distributors (i.e. 2): €4
    • Main, Twin 1 & Twin 2 Distributors (i.e. 3) : €3
    • For any additional distributors (i.e. <= 4) : €2
       

PPV Service fee, based on the number of distributors that the Services are supplied to, providing a Tiered Rate:

...

Anchor
top
top

Excerpt
hiddentrue

Learn to work with Price plans

Panel
nameblue

On this page

Table of Contents
maxLevel2

Overview

Price plans are the set of rates at which a company offers goods and services.  The plans are used by the billing engine to charge customer accounts receivables for purchases. 

Every billable product that is added to a subscription, job or activity must belong to at least one price plan, with the exception of usage services whose rates are defined in Usage Service Catalogs

Price plans functionality 

  • Suitable for promotions and discounting; Price plans can be subject to conditions that result in special rates (such as discounts for employees).
  • Ideal for making price reductions; rates that are lower than the base rate can be defined for a specific period or purchase quantity.
  • Simplify overall price adjustments when tax rates change.

Setting Up Price Plans

Info
iconfalse
 Finance Application > Products and Pricing > Price Plans > Manage Price Plans

Image Added


Anchor
rate_model
rate_model
Price plan rate models

The classification of each product determines the rate models available when adding a product to a plan.  Billing handles each model differently.

 Products are classified as: 

  • Expenses
  • Termed services
  • One-time services
  • Physical goods.

Rate Model

Application

Intended for Classifications

Calculation LogicExample
Flat RateA single fixed price.

Expenses

Price = Base rate

A €20 setup fee

Flat Rate, Quantity Based

 

A single fixed price based on purchased quantity, starting from a base rate, and adjusted as the quantity increases according to preset tiers.

The purchased quantity of termed services depends on the number of service distributors. I.e., if the same channel is available from two different boxes, the quantity of the services is two.

Termed services, physical goods

  • Not cumulative
  • Price is that of the highest tier
  • If the quantity does not fall in a tier, the price is equal to the base rate.

A channel is accessible through several TV decoders (in different rooms).  If the price for accessing the channel is €10 from one TV decoder and €8 from two or more, then:

  • Access from one decoder is billed €10 (1*10)
  • Access from two decoders is billed €16 (2*8)
  • Access from three TV decoders is billed  €24 (3*8).
Flat Rate, Duration Based

A single fixed price based on the duration of the service, starting from a base rate, and adjusted as the duration of the service provided increases, according to preset tiers.

One-time services

  • Not cumulative
  • Price is flat rate price of last/highest level tier
  • If the duration does not fall in a tier, the price is equal to the base rate.

An installation service is billed €10 for the first hour and €8 for each consecutive hour.

  • An installation that takes one hour is billed €10
  • An installation that takes two hours is billed €16 (2*8)
  • An installation that takes three hours is billed €24 (3*8).

 

Tiered Rate, Quantity Based

A price starting from a base rate, which can be progressively adjusted as the quantity increases, according to preset tiers.  Each tier defines a quantity range and the rate for the product within that range.

Termed services, physical goods

 

  • Cumulative
  • Price is the sum of tiered rates, according to the purchased quantity
  • If the quantity does not fall in a tier, the price is equal to the base rate.

The price of an antenna is €10 for one and €8 for two or more.

  • One antenna is billed €10
  • Two antennas are billed €18 (10+8)
  • Three antennas are billed €26 (10+(8*2)).
Tiered Rate, Duration Based

A price starting from a base rate, which can be progressively adjusted as the duration required to provide the service increases, according to preset tiers.  Each tier defines a duration range and the rate for the product within that range.

One-time services

  • Cumulative
  • Price is the sum of tiered rates, according to the duration of the service.
  • If the duration does not fall in a tier, the price is equal to the base rate.

An installation service is billed €10 for the first hour and €8 for each consecutive hour.

  • An installation that takes one hour is billed €10
  • An installation that takes two hours is billed €18 (10+8)
  • An installation that takes three hours is billed €26 (10+(2*8)).

Tiered Rate, Maturity Based

A price starting from a base rate, which can be progressively adjusted as the subscription matures, according to preset tiers.  Each tier defines a period and the rate for the product in that period.

Termed services

  • Cumulative
  • Price is the sum of tiered rates, according to the duration of the subscription.
  • If the maturity does not fall in a tier, the price is equal to the base rate.

A channel is free for the first month, €10 for the second and third month, and €20 for each consecutive month until the binding end.

  • A subscriber with an annual binding period will be billed €80 ((0*1)+(2*10)+ (3*20)) for the first six months and €120 (6*20) for the next six months.
Flat Rate, Maturity Based

A price which changes according to the rated period, using a price table made up of multiple flat rates.

(I.e. Prepaid: pre-rate period, Normal - billable period)

 

Termed services

  • Not cumulative
  • Price is that of the highest tier
  • The maturity is evaluated against the period for which the service will be rated.

A channel costs €10 when billed for 1 month, €50 when billed for 6 months and €90 when billed for a year.

 

Flat Rate, Maturity & Quantity Based

 

A combination of flat rate maturity and quantity.

Termed services

  • Not cumulative
  • Price is that of the highest tier
  • If the maturity or quantity does not fall in a tier, the price is equal to the base rate.

 

A channel is accessible through several TV decoders (in different rooms). If channel access is free for the first month, and '€10 a month for one TV decoder' or '€8 a month for two or more decoders' for the second month onward:

  • Access from any number of decoders for the first month is free
  • Access from one decoder for the second month is billed €10
  • Access from two decoders for the second month is billed €16 (2*8)

Tiered Rate, Maturity & Quantity Based

 

A combination of tiered rate maturity and quantity.

Termed services

  • Cumulative
  • Price is the sum of tiered rates, according to the duration of the subscription.
  • If the maturity or quantity does not fall in a tier, the price is equal to the base rate.

A channel is accessible through several TV decoders (in different rooms).   If channel access is free for the first month, and '€10 a month for one TV decoder' or '€8 a month for two or more decoders' for the second month onward:

  • Access from any number of decoders for the first month is free
  • Access from one decoder for the second month is billed €10
  • Access from two decoders for the second month is billed €18 ((1*10)+(1*8))

 


Back to top

Anchor
attributes
attributes
Price plan fields

The table describes the sections of the Price Plans Data Entry page and explains how the fields on the page are used.

 Mandatory   Configurable

Main Information

Code & Name: Price plan identifiers that are used interchangeably in the system and remain constant across versions.

Version: Reflect price changes in specific periods for the same price plan.

Type: 'Base' or 'Conditional', selected by the system when creating the price plan. The value is 'Conditional' if a price plan is defined in the base price plan field.

Effective Date: The day from which the rates can be used for billing. A new effective date is automatically set for each version.

Expiration Date: The day from which the rates can no longer be used for billing. 

  • Based on the agreement between the customer and company, the system can be configured to keep the rates from an expired price plan version effective (even if the price is adjusted to reflect a change in VAT).
  • Whenever a new price plan version is created, the expiration date of the current version is set equal to the effective date of the new version.

Base Price Plan: Used when creating a new conditional plan. If the conditions specified in the new conditional plan are not met during billing, the rates from the base plan are applied on subscriptions.
When a base price plan is selected, 'Selection Conditions' and 'Validity Condition'
sections become available.

Note

Conditional price plans consist of a different set of rates (usually discounted) for the same products defined in a base price plan. These conditional rates are used for billing (instead of the base rates) provided the conditions defined in the plan are met. For example, customers are billed the conditional discounted rate, as long as their account receivable satisfies the defined requirement of VIP classification.

Accounts Receivable: The corporate customer account for which the price plan is used according to the pricing agreement.

Rates

Including information on the type and classification of the rated product

Rates are grouped by (and can be filtered on) product classification.

 Products are classified as:

  • Expenses
  • Termed services
  • One-time services
  • Physical goods.

Code: Used by the system to identify rates. It is automatically generated and can be edited.

Applicable only if part of a Bundle: Makes it possible to define a lower rate for the for termed service components of flexible bundle products when offered in a bundle.

Rate Model: Available rate models depend on the classification of the product, as described in the Rate Model Table. 


 Base Amount: The rate that is applied in the absence of tiered rates.

UOT: The unit of measurement of the period during which the base or tiered amounts are applied, for termed and one-time services.

Although the system can convert a monthly rate into a daily one, it is recommended that businesses that bill on a daily basis select a daily UOT. This produces more precise results than subsequently converting a monthly rate into a daily one.

Currency in which the price plan's base rate is specified for the plan and product (cannot be the same as the system currency defined in 'Global Settings').

Note

If multi-country network is enabled in 'General Settings', then additional rates in other currencies can be specified. Same product can be defined multiple times as long as it is in a different currency.

Note

A UOT must also be defined for termed services. A fixed rate can be defined to apply for a specific period, e.g., 30 days, 3 weeks, 2 months, 1 year. The following values can be set depending on the selected UOT:

  • From 1 to 6 days,
  • From 1 to 4 weeks,
  • From 1 to 11 months
  • From 1 to 3 years

 

Effective Starting From (applicable for tiered rates of termed services): the date on which the rating period is considered to start again. The options are:

  • Binding Start Date: On the date that the binding period begins (as specified in the Billing Terms).
  • Service Effective Date: On the date that the service will become effective.
  • Agreement Date: On the date that the customer accepted the Billing Terms.
Note
titleEffective Starting From Example

If 'Binding Start Date' is selected and you have a maturity model with 2 tiers, with tier 1 starting from the 1st month, then when the binding of a subscription is renewed, the rating will consider that the service is back to the 1st tier, even if it was activated 1 year ago.

Tax Model: Define whether the base and tiered rates of the specified price plan are tax inclusive. By default, the tax model of the price plan is that which is defined in Tax Definition.

 

Tiered Rates

Used to define a rate other than the base, for a particular period or quantity, depending on the selected rate model. Refer to the Rate Model Table for information on the application of tiered rates.

Level: A number that determines the order in which levels are considered.

From and To are the inclusive integer values that determine the range of each tier level (expressed in the defined UOT)

One of the following can be defined for the 'To' field value:
  • A specific number which is valid up to a specific UOT
  • 'Unlimited', i.e., until the end of the customer's subscription
  • Binding period end, i.e., valid until the binding end date of the subscription (this option is only available in the tiered pricing of maturity based models).

Note

The unit for the From and To values may differ, subject to the selected rate model and UOT.

    • For tiered services whose base rate is defined in UOT, the fields refer to the defined UOT; e.g., the number of days or months.
    • For duration based one-time services defined as a UOT, the fields refer to the defined UOT; e.g., the number of days or months.
    • For quantity based physical goods, the fields refer to the number of items.

Amount: The rate applied to the tier level. 

Selection Conditions

(For conditional plans only)

Conditions that are used to validate whether the price plan can be selected for a subscription or a job.

Validity Conditions

(For conditional plans only)

Conditions that are used to determine if the price plan rates can be applied during billing.
Billing will revert to the respective base price plan rates if any condition in the conditional price plan is breached.

Additional Price Plan Rates

(Base rates in currencies other than the system default)

The rates of each price plan can be specified in as many currencies as necessary, but each additional rate can be specified only once per price plan and currency.

Price Plan Rate for which additional rates in other currencies are specified.

Note

The price plan rate includes the price plan and product information. So for each rate, multiple additional rates can be specified as long as they are in a different currency.

Base Rate: the price of the product in the specified currency.

Currency in which the price plan's base rate is specified for the plan and product (cannot be the same as the system currency defined in 'Global Settings').

Additional Price Plan Tiered Rates

The rates of each price plan can be specified in as many currencies as necessary, but each additional rate can be specified only once per price plan and currency.

Price Plan Rate: the tiered rate for which additional tiered rates in other currencies are specified.

Note

The price plan rate includes the price plan and product information. So for each rate, multiple additional rates can be specified as long as they are in a different currency.

Tiered Amount: the price of the product in the specified currency.

Currency for which the tiered rate is specified.

 
Allowed Organisational Units
Organisational units that are authorized to select and assign the price plan on billing term schemes, subscriptions, and jobs.

 

Related configuration areas

Mandatory modules must be configured for the Price Plan module to work. 

Optional modules may be configured for the module to operate at its full capacity.

Manual LinkAreaDescriptionConfiguration
ProductsProduct Types and Products

Products must be configured before they are rated. New products can be added to existing price plans from the Product page.

Mandatory
PlatformVAT and other Tax RatesVAT and other tax rates that will apply for the products added to the price plans. Through the tax rates area, it is possible to define whether or not the price plan rates include taxes.Optional

 

Back to top 

Using Price Plans

Note

Validations take place before an action is initiated (prerequisite) or after it is submitted (postcondition).

Several 'Effective' price plans can be present in the system. A price plan is selected when a subscription or job is created, reflecting the terms of agreement of the customer. 

If available, conditional price plans can be selected by users subject to 'Selection Conditions'. Whether the selected plan is used during billing depends on the 'Validity Conditions' of the price plan.

Selecting and creating a price plan

...


Specify the criteria that match the price plan you are interested in or use NEW from the Actions menu to create a new plan.  Provide the information defined as mandatory in the price plan fields table and SAVE the plan.

Modifying a price plan

...

Use EDIT from the Actions menu to edit price plans that have been created but not yet added to a subscription or job. You can add, remove or edit product rates and information already defined in a plan. Use the respective actions to add new product rates or amend price plans that are already in use by subscriptions or jobs.

Anchor
amend
amend
Amending existing price plan rates

...


As a general rule, price plans that are already in use cannot be modified, as the company and customer agreed on the plan rates when the subscription or job was created. 

In exceptional cases it is possible to amend a plan, for example, to reflect a change in VAT or in rates across all contracts. When a price plan is updated, a new version of the plan is created including the previously defined products and rates.

Customers with updated price plans will be billed using the new rates (by default).  

Tip

The user can also, through billing term schemesdefine that customers are charged with the previous rates, until the binding end date.

  1. Find the price plan to amend and from its Data Entry page, click Replace in the Actions menu to open the Replace Price Plan modal.
    1. Define the New Price Plan's Effective Date.
    2. Input the percentage by which all price plan rates should be adjusted under Adjust Rates by '%', or leave the field empty for individual updates.
      Use a positive or negative number to increase and decrease rates, respectively.
  2. Click on SAVE to close the modal.
  3. Once a new price plan version is created including the products and rates from the previous plan, click on edit and update price plan rates. 

Calculating and applying a discount to rates

...

As long as a price plan is not already in use, it is possible to provide a discount on defined base and tiered rates.  When adding new or editing existing product rates, use Calculate Amount to enter a discount, expressed as an amount or percentage.  The discounted price is calculated and set automatically.

  1. While on EDIT mode and select the product rate to update.
  2. Click on CALCULATE, on the base or tiered rate.
  3. In the Calculate Amount modal:
    1. Provide a number in the 'Initial Amount' text box (this can be the same or different than the base/tiered amount).
    2. Select between amount and percentage and provide a number in the text box below.
    3. Click anywhere outside the text box and check the calculated rate.
    4. Click on SAVE to apply the change.
      • The system will set the amount that has been calculated, regardless if the 'initial amount' provided was different to the base or tiered amount.
Note
  • Positive numbers are used in discount calculations.
  • Negative numbers have the opposite effect (making the product more expensive).

    Initial amountDiscountResulting amount
    10.005.005.00
    10.00-5.0015.00
    10.005%9.50
    10.00-5%10.50

Anchor
add_new
add_new
Adding a new product rate to existing price plans

...

Use the Add New Product action to define rates for new products in existing price plans.

  1. Select the plan to which the new product should be added.
  2. In the Data Entry page, click Add New Product from the Actions menu.
  3. Use Quick Search or click on the magnifying glass to search for the product.
  4. In the modal, enter the information that is necessary to create the product (refer to the price plan fields table).
Tip

Add the new product to an existing price plan directly from the Products Data Entry page, when creating the product.


Creating a conditional price plan

...

Conditional price plans can be used for billing jobs or subscriptions, subject to two types of conditions, defined in the price plan:

  • Selection Conditions must be met to make the price plan available.
  • Validity Conditions must be met in order to use the rates for billing.  
    Selection conditions can change from the time a price plan is set until it is billed. It is recommended to have the same conditions defined for selection and validity.
    If validity conditions are not met during billing, then the system will use rates from the base price plan that was used when creating the conditional price plan.

Specify the criteria that match the price plan you are interested in or use NEW from the Actions menu to create a new plan. Provide the mandatory information in the price plan fields table before you SAVE the plan.

  1. Click on NEW from the Actions menu to create a new plan.
    1. Provide the mandatory information in the price plan fields table (like in base price plans).  

      Note

      Important: Select a Base Price Plan for the system to use in case the selected conditional price plan conditions are not met during billing.

    2. Rates: Available rates from the selected base price plan are displayed. Change the rates individually or use the Replace Price Plan action to change all the rates simultaneously by a specific percentage value.
    3. SELECTION & VALIDITY CONDITIONS (The process for adding selection or validity conditions is identical) 

      Follow the steps below:
      1. Under 'Evaluation Settings' select:

        1. General: whether 'Criteria in all condition groups should be met' or 'Criteria in at least one condition group' should be met.

        2. Condition Group Specific: whether 'Criteria in all condition rows should be met' or 'Criteria in at least one condition row' should be met.

      2. Once Evaluation Settings are in place, click on each of the condition groups in the list to start defining group row conditions.

        1. Click to ADD a new row, or ADD FROM TEMPLATE (a saved row that was used previously with preset values, such as for type and operator) to select an existing condition group row.  

        2. Type: Select from the drop-down list.
        3. Operator: Select whether the defined values should be 'Equal' or 'Not Equal'.
          1. ValueADD VALUES from the modal for each selected condition group row.
            1. Specify whether all values, or at least one, defined in the modal should be met.
            2. Value 1 - Value 20: Use Quick Search or click on the magnifying glass for a search modal to select the values to be used as conditions.

        4. Save as Template: Save the values for each condition group as a template, so that it can be used again with condition groups of the same type.
          1. Click on SAVE AS TEMPLATE and provide a name and description.
          2. Once all the condition group rows are complete, repeat the process for a new condition group.
        5. Select the Allowed Organisational Units that are authorized to select and assign the price plan.
        6. SAVE the price plan.

 

Note
titleSelection and Validity Conditions

Each condition group type selected in the condition group has different available values:

TypeEvaluated against

Only available for 'Selection conditions'

Subscription TypeSubscription type of the subscription being billed.
Billable Entity MaturityMaturity of the billable entity; whether it is a new or existing subscription or job.
Billable Entities Existing ProductsPhysical goods or services added to the subscription or job. 
Billable Entities Products To Be AddedProducts that will be added to the subscription or job.
Billable Entities Existing Price Plans

The price plan already used by the subscription or job
(Applicable only when the billing term scheme is modified using the 'Amend Billing Terms' action through jobs or subscriptions).

Billable Entities Owner GroupsGroup that owns the subscription or job. 
Accounts Receivable ClassificationsClassification of the account owner of the subscription or job. 
Accounts Receivable Credit RatingsCredit rating of the account owner of the subscription or job. 
Accounts Receivable Payment PreferencePayment preference of the account owner of the subscription or job. 
Billing Term SchemeBilling term scheme of the subscription or job. 
Billing Terms Binding StateBinding state of the subscription; i.e., whether the subscription is in or out of binding. 
Billing Terms Binding PeriodBinding period of the subscription; e.g., for one or two years. 
Billing Terms Billing FrequencyBilling frequency of the subscription; e.g., monthly or annual. 
SegmentationAccounts receivable that belong to a selected segment. 

 

Anchor
bundle
bundle
Defining product bundle pricing

...


A product bundle is a combination of component products offered for sale as one product, such as a single package including multiple channels.  Fixed Bundle Products have a fixed selection of constituent products as components.  Flexible Bundle Products are available for termed services and have a variable selection of constituent products as components.  The price of a fixed bundle product is set as that of a regular product.

Flexible bundle products allow the user to define prices at:

  • Bundle level; i.e., one price for all included products.
  • Product level, and differentiate when a product is sold as a stand-alone or part of a bundle.
  • Both bundle and product levels.

To add a rate at bundle product level:

  1. Add the product to the price plan.
  2. Provide the information required in the 'Rates' section.
  3. Leave 'Applicable Only If Part of Bundleempty. 

To add a rate for a product when provided through a bundle:

  1. Add the product to the price plan.
  2. Provide the information required in the 'Rates' section.
  3. Under 'Applicable Only If Part of Bundle' select the bundle that the product is part of.

To add a rate for a product that is sold as a standalone product and as part of a bundle:

  1. Add the product to the price plan.
  2. Provide the information required in the 'Rates' section.
  3. Leave 'Applicable Only If Part of Bundleempty
  4. Add the product to the price plan again.
  5. Provide the information required in the 'Rates' section.
  6. Under 'Applicable Only If Part of Bundle' select the bundle that the product is part of.

 

Anchor
calculating_UOT_rates
calculating_UOT_rates
Calculating the price of termed services for specific periods

...

When a rate is provided for a termed service over a specific period (e.g., 2 weeks), the following steps are used to calculate the price:

    • The time period value and UOT are taken into consideration. 
    • If the price plan provides a rate for the exact period being rated, then that rate is used.
      E.g., if a termed service is rated for a 3-day period and the pri



Price Plans Business Example

Panel
nameblue

Scenario

Company ZX wants to set rates for its products, according to its billing requirements:

  • TV Subscription Start-up fee.
    • Start-up fee: €5

  • Installation Service Fee, with a tiered rate, based on duration.

    • 1 hour: €20/hour
    • 2 to 5 hours: €15/hour
    • 6 or more: €10/hour
      E.g., a five-hour installation is billed €80 [(1*20)+(4*15)].

  • Repairs, with a flat rate, based on duration.

    • 1 hour: €20/hour
    • 2 to 5 hours: €15/hour
    • 6 or more: €10/hour
      E.g., a repair that takes five hours is billed €75 (5*15).

  • Antennas, with a flat rate, based on quantity.
    • 1 unit: €10
    • 2 units: €9
    • 3 units: €8
    • 4 units or more: €7.
      E.g., purchasing three antennas costs €24 (3*8).

  • Decoders, with a tiered rate, based on quantity.
    • 1 unit: €10
    • 2 units: €9
    • 3 units: €8
    • 4 units or more: €7.
      E.g., purchasing three decoders costs €27 (10+9+8).

  • VOD Service fee, with a flat rate, based on the number of distributors that the service is supplied to.

    • One Main Distributor (1): €5
    • Main and Twin 1 Distributors (2): €4
    • Main, Twin 1 and Twin 2 Distributors (3): €3
    • Additional distributors (4 or more): €2.
      E.g., viewing from three different boxes costs €9 (3*3).

  • PPV Service fee, with a tiered rate, based on the number of distributors that the services are supplied.

    • One Main Distributor (1): €5
    • Main and Twin 1 Distributors (2): €4
    • Main, Twin 1 and Twin 2 Distributors (3): €3
    • Additional distributors (4 or more): €2.
      E.g., viewing from three different boxes costs €12 (5+4+3).
  • Gold Service Subscription, based on a monthly fee with a free three-month trial period:

  • For the first three months, the Subscription will cost €0 per month
  • Starting from

    .

      • The subscription is free for the first three months.
      • From the fourth month
      the Subscription will cost €20 per month
      • onward, the subscription costs €20/month.


Solution

Create the following Base Price Plan

  • Create the Price Planprice plan
  • Once the Price Plan is created, start adding the Rates into the Plan
  • Check Add the rates to the plan
  • Refer to the table below and see the Rate Type and Model that should be for the rate type and model used to satisfy each requirement.
 
Product NameProduct Rate TypeRate ModelBase AmountTiered PriceComments
    Tier LevelFromToTier Amount 
Start Up Fee-up feeExpenseFlat Raterate€5    

Tiered

Rates

rates are not allowed for

Rate Type: Expenses
      

'Expense' rate type

 
 RepairsOne Time Service-time serviceFlat Raterate, Duration Basedduration based€10     
    111€20 
    225€15 
    36Unlimited€10 
         
Installation Service Installation service FeeOne Time Service-time serviceTiered Raterate, Duration Basedduration based€20    

5 Five hours of repairs = costs:

(1*20) + (4*15) = 80

    111€20 
    225€15 
    36Unlimited€10 
 
AntennaPhysical GoodgoodFlat Raterate, Quantity Basedquantity based€10    Buying 3 antennas =

Purchasing three antennas costs:

3*

€8

8 =

 €24

€24

    111€10 
    222€9 
    333€8 
    44Unlimited€7 
 
DecoderPhysical GoodgoodTiered Raterate, Quantity Basedquantity based€10    Buying 3 decoders = €10 + €9 + €8

Purchasing three decoders costs:

10+9+8 = €27

    111€10 
    222€9 
    333€8 
    44Unlimited€7 
 
GoldTermed ServiceserviceTiered Raterate, Maturity Basedmaturity based€20    Subscription

A subscription billed for a year is billed:

(3*0) + (9*20) = €180

    1130 
    23Unlimited€20 
         
VOD ServiceserviceTermed ServiceserviceFlat Raterate, Quantity Basedquantity based€5    

Service is distributed on

4

four distributors

=

:

4*2 = €8

    111€5 
    222€4 
    333€3 
    44Unlimited€2 
         
PPV ServiceTermed ServiceserviceTiered Raterate, Quantity Basedquantity based€5    

Service is distributed on

4

four distributors

=

:

(1*5) + (1*4) + (1*3) + (1*2) = €14

    111€5 
    222€4 
    333€3 
    44Unlimited€2 
Note
titleNotes

 

Glossary  

Services that are provided upon A tangible commodity which is provided to customers, such as cameras, decoders and magazines. Physical Goods can be traceable or not Distributors are used to relate subscription services and subscription associated devices to a specific Provisioning Provider as well as
CRM.COM TermDefinition
Usage ServicesServiceA product (usually a service) provided on customer request and are billed based on their its usage.
SubscriptionA collection of customer services billed on a recurring, usage or one-time basis.
JobA small project initiated by the operator for customers, involving the delivery and billing of services, products, and activities. Customer requests and orders, such as that for a new subscription, can be initiated and registered through a job.
ActivitySmall A small task or action that is either stand-alone or must be completed as part of a larger project.
ExpensesExpenseServices A service that are is provided just once, (usually upon on customer request, ) and are billed just once for a fixed amount.
Termed ServicesServices which are billed for a term and they cyclePhysical GoodsServiceA service that is provided continuously and billed for a recurring period, regardless of usage.
Physical GoodA tangible item that is provided to the customer, such as a camera, decoder or magazine (generally with exclusive ownership); can be traceable or non-traceable.
One-time ServicesServices which are only provide once and billed based on their durationProvisioning DistributorsService

A service (usually requested by the customer), which is provided and billed once, based on duration.

  

Provisioning Distributors

An abstract layer used in CRM.COM to relate subscription services (e.g., broadband service) and subscription associated devices (e.g., modems) to a provisioning provider and to define what services will be available from each device , (if more than one device is available on a single subscription).

CRM.COM offers integration with several providers.

SegmentsLists of records in CRM.COM based on conditions that are defined using CRMQL, (CRM.COM Query Language), a business query a CRM query language developed by CRM.COM.
Panel
namegrey

Related Links

Filter by label (Content by label)
showLabelsfalse
spacesV4Manual
showSpacefalse
labelsglobal