Prepare the Subscription billing workspace reports
Subscription billingWorkspaces
SubBillWorkspace
Used by
Subscription billing user, Subscription billing module user with capabilities including billing, allocation, and deferral features
Business process
Bill subscriptions
Menu item
SubBillWorkspace
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
The Subscription billing workspace, where the Subscription billing Power BI analytical reports appear.
What you do here
Use this page to review key subscription billing metrics, such as monthly recurring revenue for billing schedules and the waterfall and declining balance of deferral schedules.
Example
For example, after the October invoice run a BEAT billing manager runs MRR analytical report batch processing for January 2024 to October 2026, refreshes the MRR report measurement and reads monthly recurring revenue by customer on the Analytics - MRR tab.
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
Prepare the Subscription billing workspace reports
Make sure the workspace reports show current monthly recurring revenue before managers read them.
Steps from Microsoft
Go to Subscription billing > Workspaces > Subscription billing.
Before the first look, run MRR analytical report batch processing for a date range of no more than three years; the reports don't store data themselves.
Go to System administration > Setup > Entity Store and refresh the MRR report aggregate measurement.
Open the Analytics - MRR tab and read the Monthly recurring billing report and the Billing schedule details report.
Use Create billing schedule on the Action Pane to start a new billing schedule from the workspace.
Report tab that shows the Monthly recurring billing report and the Billing schedule details report.Microsoft Learn
Analytics - Waterfall
Report tab that shows the Revenue waterfall report.Microsoft Learn
Analytics - Declining balance
Report tab that shows the Declining balance report.Microsoft Learn
Common errors and fixes
Message
What to do
The MRR reports in the workspace show no data or old data
Run MRR analytical report batch processing for the date range, then refresh the MRR report aggregate measurement in System administration > Setup > Entity Store. Microsoft Learn
The Waterfall or Declining balance tab shows no data
These tabs read deferral schedules. Turn on Revenue and expense deferrals, run its Waterfall or Declining balance analytical report batch processing for no more than 26 periods, and refresh that report's measurement in Entity Store. Microsoft Learn
The Subscription billing feature can't be turned on in Feature management
Turn off the Revenue recognition feature first, then turn on Subscription billing and after it Recurring contract billing. Microsoft Learn
Test checklist
Run MRR analytical report batch processing for the last 12 months.
Refresh the MRR report aggregate measurement in Entity Store.
Open the workspace as a Subscription billing user and select Analytics - MRR.
Check that the monthly recurring billing of one customer matches the invoiced amounts of its billing schedules for a month.
Schedule MRR analytical report batch processing as a recurring batch job after each invoice run, with a range of no more than three years, followed by a refresh of the MRR report measurement in Entity Store.The Power BI reports don't store data; they show what the batch job last built and the Entity Store last refreshed.
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. The workspace opens for the Subscription billing user and Subscription billing module user roles.
Reversible: The batch job and refresh rebuild reporting data only; billing schedules aren't changed.
If you change it later
The workspace only shows data. Its reports change after the batch jobs run again and the Entity Store measurement is refreshed; Create billing schedule opens the same dialog as All billing schedules. Microsoft Learn
Technical architect
6Technical
Menu item
SubBillWorkspaceChecked in Dynamics 365
Form
SubBillWorkspaceChecked in Dynamics 365
Who can open it
PrivilegesSubscription billing user SubBillBillingViewView Subscription billing deferral and allocation features processing and entities SubBillDeferralAllocViewSubscription billing module user with capabilities including billing, allocation, and deferral features SubBillViewDutiesSubscription billing user SubBillBillingInquireSubscription billing module user with capabilities including billing, allocation, and deferral features SubBillInquire2 security rolesSubscription billing user SubBillBillingViewSubscription billing module user with capabilities including billing, allocation, and deferral features SubBillViewChecked in Dynamics 365
Roles to set it up and use it
To 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, 2 roles can open this page.Checked in Dynamics 365
Actions on the page
(Action Pane without tabs): Create billing scheduleChecked in Dynamics 365
Developer
7Developer
Open it by URL
https://<your-environment>/?mi=SubBillWorkspace
Data migration
Load order: The workspace has no data entity in Data management, so there is nothing to load from a file or a configuration template. Its reports are rebuilt from billing schedules by the analytical report batch jobs, so run those jobs in each environment after the billing schedules are loaded.Microsoft Learn