BeyondERP.Newsletter
Menu

Setup step on the MRR analytical report batch processing page · Subscription billing

Schedule the MRR data build

Keep the MRR reports current without manual runs.

Business process
Bill subscriptions
Menu item
SubBillMRRBIReportBatchProcessing
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 batch process that generates the monthly recurring revenue (MRR) data used by the Subscription billing Power BI analytical reports.
What you do hereUse this page to generate, and optionally refresh on a recurring schedule, the MRR reporting data for a date range before viewing the MRR reports.
ExampleFor example, BEAT schedules it every night for January 2024 to December 2026 (three years) and refreshes the MRR report measurement after it, so the workspace shows the latest month.
MRR analytical report batch processing 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 › Periodic tasks › MRR analytical report batch processing
Set up firstGenerate invoice Microsoft Learn
Used next bySubscription billing workspace Microsoft Learn
Related pagesSubscription billing workspace Microsoft Learn
In this process Create unbilled revenue entries before invoicing
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.

When to run it

When to run itBefore you view the MRR analytical reports, because the reports don't store this data directly.
How oftenOn demand before reporting, or as a recurring batch job so the reports stay current.
Batch settingsSchedule it as a recurring batch job, followed by a refresh of the MRR report aggregate measurement in the Entity Store.
What the output showsMRR reporting data for the date range, shown on the Monthly recurring billing and Billing schedule details reports after the Entity Store refresh. Old figures on the reports usually mean the aggregate measurement wasn't refreshed after the batch job.

Source: Microsoft Learn

Setup steps on this page

Schedule the MRR data build

Keep the MRR reports current without manual runs.

Steps from Microsoft

  1. Go to Subscription billing > Recurring contract billing > Periodic tasks > MRR analytical report batch processing.
  2. Enter the date range to generate monthly recurring revenue data for; it can't be longer than three years.
  3. Set up a recurring batch job if the MRR data should be refreshed regularly.
  4. After the batch job finishes, go to System administration > Setup > Entity Store and refresh the MRR report aggregate measurement.
  5. Open the Analytics - MRR tab in the Subscription billing workspace and review the Monthly recurring billing and Billing schedule details reports.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
Date rangeThe period to generate MRR data for, up to three years.Microsoft Learn 1 January 2024 to 31 December 2026

Common errors and fixes

MessageWhat to do
The MRR reports in the workspace show no data or old dataRun 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 date range isn't acceptedThe range can't be longer than three years. Shorten it. Microsoft Learn

Test checklist

  1. Run the job for the last 12 months.
  2. Refresh the MRR report aggregate measurement in Entity Store.
  3. Open Analytics - MRR in the workspace.
  4. Check the latest month matches the recurring invoices of that month.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Schedule the MRR data buildA recurring batch job after each invoice run, with a range of up to three years, followed by the Entity Store refresh.The reports don't store data; they show what this job last built, and the range is limited to three years.How far back should MRR be reported?Forgetting the Entity Store refresh after the job, so the workspace still shows the previous figures.Test: MRR after the job

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 run this task.

Microsoft Learn

Solution architect

5Design impact

Can it be undoneReversible: The job rebuilds reporting data only.
If you change it laterThe job rebuilds the MRR reporting data for the date range; the workspace reports show it after the MRR report measurement is refreshed in Entity Store. Microsoft Learn
Technical architect

6Technical

Menu itemSubBillMRRBIReportBatchProcessing Checked in Dynamics 365
FormSysOperationTemplateForm Checked in Dynamics 365
Roles to set it up and use itTo use itSubscription billing manager SubBillBillingMaintainSubscription billing allocation, deferral, and billing manager SubBillMaintainGive people one of these roles. On this system, 2 roles can run this page.Checked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=SubBillMRRBIReportBatchProcessing
Data migrationLoad order: MRR analytical report batch processing has no data entity in Data management, so there is nothing to load from a file or a configuration template. Set up its recurring batch job in each environment.Microsoft Learn
Everyone

8Sources

To cite this step: SB-PER-120, Schedule the MRR data build. Beyond ERP Atlas Hub, 2026-11-11. https://www.beyonderp.cloud/atlas/step/SB-PER-120