BeyondERP.Newsletter
Menu

Setup step on the Consumer price index schedule page · Subscription billing

Set up Consumer price index schedule

Use this page to create, delete, review and process CPI schedules, which are used for escalation and discount pricing on billing schedules or processed to update billing amounts.

Used by
Subscription billing manager, Subscription billing user, Subscription billing allocation, deferral, and billing manager and 1 more role
Business process
Bill subscriptions
Menu item
SubBillCPITable
Main table
SubBillCPITable
Data entity
SubBillCPITableEntity
Setup steps
1 on this page
Show what matters for
SETUP GUIDEHow to set it up8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA setup page where you keep named consumer price index (CPI) schedules with index values by date.
What you do hereUse this page to create, delete, review and process CPI schedules, which are used for escalation and discount pricing on billing schedules or processed to update billing amounts.
ExampleFor example, a contract can be escalated every year by the change in the CPI plus 3 percent.
Consumer price index schedule page in Dynamics 365
The page in Dynamics 365. page title tab to open what to set or check
Functional consultant · Solution architect

2Where it fits

Business processManage accounts receivable › Bill subscriptions
Menu pathSubscription billing › Recurring contract billing › Setup › Consumer price index schedule
Set up firstRecurring contract billing parameters Microsoft Learn
Used next byAll billing schedules (Escalation and discount) Microsoft Learn
Related pagesRecurring contract billing parameters Microsoft Learn
In this process Set up End users · Set up Items
End user · Functional consultant

3How to do it

About the examples: Examples and screenshots in this guide use BEAT, a demo company in a Dynamics 365 test environment. Use your own company's codes and values instead of copying them.

Setup steps on this page

Set up Consumer price index schedule

Use this page to create, delete, review and process CPI schedules, which are used for escalation and discount pricing on billing schedules or processed to update billing amounts.

Steps from Microsoft

  1. Go to Subscription billing > Recurring contract billing > Setup > Consumer price index schedule.
  2. Select New.
  3. In Consumer price index schedule, enter a unique name, and in Description, enter a description.
  4. On the Consumer price index schedule tab, select Add.
  5. Enter the Consumer price index date and the index value for that date.
  6. Select Save.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansTable column
Consumer price index scheduleThe unique name of the CPI schedule.Microsoft Learn SubBillCPIScheduleID
DescriptionA description of the CPI schedule.Microsoft Learn SubBillCPIScheduleDesc
Consumer price index dateThe date from which an index value applies.Microsoft Learn SubBillCPIDate
Consumer price index schedule (line value)The index value for the date on the line.Microsoft Learn

Common errors and fixes

MessageWhat to do
A consumer price index schedule can't be deletedA schedule that is linked to any billing schedule can't be deleted. Keep it and go on adding index values to it. Microsoft Learn
An escalation isn't applied to a period that has passedEscalations and discounts can't be applied retroactively. Enter them with a start date in a period that isn't billed yet. Microsoft Learn
The escalation used a later index value than the escalation dateEscalation always uses the latest CPI value, whatever its index date. Enter index values on time; no adjustment is made later. Microsoft Learn

Test checklist

  1. Create a CPI schedule with a base value and a later dated value.
  2. On a billing schedule line select Escalation and discount, set the Consumer price index calculation and choose the CPI schedule with a start date and frequency.
  3. Check the escalated amount for the next unbilled period matches the formula for the chosen calculation.
  4. On the CPI schedule select Process and review the updated billing schedule lines on the Consumer price index process FastTab.
  5. Try to delete the CPI schedule and check it is blocked because a billing schedule uses it.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Consumer price index scheduleOne CPI schedule per published index the contracts use, with every index value entered on its publication date, and the Consumer price index calculation on the parameters set to the contracts' method.Escalations read the latest value on the schedule, and Process pushes it into the prices of the billing schedules that use it.Which Consumer price index calculation should escalations use?Entering index values late. Escalation always uses the latest CPI value regardless of the index date, and no adjustment is made when the later index is entered.Test: CPI escalation with base index

Feature management and licence

Feature to turn onSubscription billing (Must be on)Recurring contract billing (Must be on)
Licence or add-inTurn off the Revenue recognition feature first: Subscription billing can't be used while it is on. Then, in Feature management, turn on Subscription billing and after it Recurring contract billing. Revenue recognition was deprecated in January 2024 and replaced by Subscription billing. Subscription billing managers maintain this setup; Subscription billing users can view it.

Microsoft Learn

Solution architect

5Design impact

Can it be undoneHard to reverse: Process updates the prices on all billing schedules that use the CPI schedule. Escalations can't be applied retroactively, and a CPI schedule linked to any billing schedule can't be deleted.
If you change it laterSelecting Process updates the prices on the billing schedules that use the CPI schedule with its latest dates and values. Microsoft Learn
Technical architect

6Technical

Menu itemSubBillCPITable Checked in Dynamics 365
FormSubBillCPITable Checked in Dynamics 365
TableSubBillCPITableShown as “CONSUMER PRICE INDEX TABLE” in Record infoKey field: SubBillCPIScheduleIDChecked in Dynamics 365
Data entitiesSubBillCPITableEntitySubscription billing consumer price index schedule headers Checked in Dynamics 365
Who can open itPrivilegesSubscription billing manager SubBillBillingMaintainMaintain Subscription billing billing setup SubBillBillingSetupMaintainView Subscription billing billing setup SubBillBillingSetupViewSubscription billing user SubBillBillingViewSubscription billing allocation, deferral, and billing manager SubBillMaintainSubscription billing module user with capabilities including billing, allocation, and deferral features SubBillViewDutiesSubscription billing user SubBillBillingInquireSubscription billing manager SubBillBillingMaintainSubscription billing module user with capabilities including billing, allocation, and deferral features SubBillInquireSubscription billing allocation, deferral, and billing manager SubBillMaintain
4 security rolesSubscription billing manager SubBillBillingMaintainSubscription billing user SubBillBillingViewSubscription billing allocation, deferral, and billing manager SubBillMaintainSubscription billing module user with capabilities including billing, allocation, and deferral features SubBillView
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itSubscription billing manager SubBillBillingMaintainSubscription billing allocation, deferral, and billing manager SubBillMaintainTo use itSubscription billing user SubBillBillingViewSubscription billing module user with capabilities including billing, allocation, and deferral features SubBillViewGive people one of these roles. On this system, 4 roles can open this page.Checked in Dynamics 365
Actions on the page(Action Pane without tabs): ProcessChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=SubBillCPITable
Integrate withSubBillCPITableEntity data entity Checked in Dynamics 365
Data migrationSubBillCPITableEntity (Subscription billing consumer price index schedule headers): the schedule names; Microsoft also names a CPI schedule composite entity for the values.Load order: Load the setup in reference order: support and renewal levels, milestone templates and consumer price index schedules first; then billing schedule groups (a group can name a milestone template), item setup, item group setup, revenue split templates and unbilled revenue setup (they name items, templates and main accounts); then Recurring contract billing parameters, which name the default billing schedule group and support and renewal level; billing schedules come last.Microsoft Learn
Everyone

8Sources

To cite this step: SB-SETUP-040, Set up Consumer price index schedule. Beyond ERP Atlas Hub, 2026-11-11. https://www.beyonderp.cloud/atlas/step/SB-SETUP-040