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.
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 is
A setup page where you keep named consumer price index (CPI) schedules with index values by date.
What you do here
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.
Example
For example, a contract can be escalated every year by the change in the CPI plus 3 percent.
The page in Dynamics 365. page title tab to open what to set or check
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
Go to Subscription billing > Recurring contract billing > Setup > Consumer price index schedule.
Select New.
In Consumer price index schedule, enter a unique name, and in Description, enter a description.
On the Consumer price index schedule tab, select Add.
Enter the Consumer price index date and the index value for that date.
A 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 passed
Escalations 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 date
Escalation always uses the latest CPI value, whatever its index date. Enter index values on time; no adjustment is made later. Microsoft Learn
Test checklist
Create a CPI schedule with a base value and a later dated value.
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.
Check the escalated amount for the next unbilled period matches the formula for the chosen calculation.
On the CPI schedule select Process and review the updated billing schedule lines on the Consumer price index process FastTab.
Try to delete the CPI schedule and check it is blocked because a billing schedule uses it.
One 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.
Subscription billing (Must be on)Recurring contract billing (Must be on)
Licence or add-in
Turn 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.
Hard 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 later
Selecting 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 item
SubBillCPITableChecked in Dynamics 365
Form
SubBillCPITableChecked in Dynamics 365
Table
SubBillCPITableShown as “CONSUMER PRICE INDEX TABLE” in Record infoKey field: SubBillCPIScheduleIDChecked in Dynamics 365
Data entities
SubBillCPITableEntitySubscription billing consumer price index schedule headers Checked in Dynamics 365
Who can open it
PrivilegesSubscription 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 SubBillMaintain4 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 SubBillViewChecked in Dynamics 365
Roles to set it up and use it
To 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 URL
https://<your-environment>/?mi=SubBillCPITable
Integrate with
SubBillCPITableEntity data entity Checked in Dynamics 365
Data migration
SubBillCPITableEntity (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
Checked in a working Dynamics 365 system, version 10.0.49: the menu item, form, table and security, the page.
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