Define a consumption statement item

If your cost and business service usage details are sourced from an external consumption table, then you can source the consumption details of the consumption table for the statement item.

Before you begin

Role required: service_charging_analyst

About this task

Business service consumption details can come from a table belonging to one of other platform applications or from an external consumption table, in which case the consumption details can be loaded on to the platform table. The consumption table gives you the daily or monthly consumption details of a business service. Based on the usage, the cost of the service is computed using the unit cost and quantity consumed for a fiscal period.

For example, the monthly utility bill for household power consumption has details of the appliances that you run and the power consumed in Watts, calculated monthly and annually. Based on the unit price and the consumption quantity, the bill amount is generated.

Procedure

  1. Navigate to Financial Reporting > Administration > Statement Items.
  2. Click New in the Statement Items list.
  3. Click Consumption Statement Item link in the What type of Statement Item? query form.
  4. Fill in the form fields.
    Table 1. Consumption Statement Item form
    Field Description
    Name Name of the consumption statement item.
    Consumption table Source table that has the consumption data, which is configured as the statement item.
    Consumption item The item for which the consumption data is held in the consumption table.
    Consumed date The column in the consumption table that has the consumed date details.
    Active Enable the check box to make the statement item active.
    Fiscal unit Defines the fiscal unit to be a month, quarter, or a period based on the fiscal calendar for which the consumption data is generated.
    Aggregate The consumption table is queried based on the aggregate function you select.
    Description Meaningful short description of the statement item.
    Consumption table filter Filters the table to display those items which meet your conditions.
    Amount
    Price basis Select the criterion to determine the price.
    • Amount retrieves the data from the selected Amount field of the consumption table.
    • Ratecard class is based on the pricing policy that is set for the statement item.
    • Unit price is the cost per unit of the item.
    Amount field If the Price basis is amount, then the amount data is taken from the selected field.
    Ratecard class Refers to the rate card class.
    Consumption table ratecard mapping field If you select Ratecard class in the Price basis field, then the amount is derived based on the consumption table ratecard mapped field and the rate card item mapping field.
    Rate Card Item mapping field If you select Ratecard class in the Price basis field, then the amount is derived based on the rate card item mapping field and consumption table ratecard mapping field.
    Service Charging
    Service owner Person who owns the business service and who views the consumption statement items.

    As a service owner, you can manage the showback items. You can view the unit cost, cost recovery based on consumption, and set unit price, discount, or surcharge to the showback item.

    Pricing policy Set the pricing policy for the statement item at the charge item level, charge item breakdown level, or at the item level.

    The price adjustment that you do as a service owner reflects the adjusted price at the statement item level if you had set the pricing policy at the charge item level. Similarly, for the charge item breakdown and the item levels, the price adjustment reflects at the respective levels.

    Pricing policy method Set the price adjustment based on a percentage of the average unit cost of the catalog item. Or, override the average unit cost by setting a price per unit of the item.
    Note: If the pricing policy is at the item level, then you can opt for percentage based pricing policy method.
  5. Click Submit.
  6. Click Generate Charge Lines to generate the charge lines for the consumption statement item.
    1. Enter the fiscal period for which you want to generate the charge lines in the Generate charge lines pop-up.
    2. Click OK.
  7. Click Update if you have updated an existing record.
  8. Click Delete to delete a record.

What to do next

Create breakdown records for the consumption statement item by clicking New in the Consumption Breakdowns related list.