A report page that calculates billing and revenue per customer and reporting period for the dates you enter, and lists the billing schedule lines with quantity and billing dates.
Subscription billingRecurring contract billingInquiries and reports
SubBillBillingAndRevenueSummary
Business process
Bill subscriptions
Menu item
SubBillBillingAndRevenueSummary
Setup steps
1 on this page
Show what matters for
PAGE GUIDEWhat the page does and how to use it8 sections. Choose a role to highlight what matters to you.
Everyone
1What it is and why
What it is
A report page that calculates billing and revenue per customer and reporting period for the dates you enter, and lists the billing schedule lines with quantity and billing dates.
What you do here
Use this page to summarise billing and revenue by customer and by month (or another reporting frequency), optionally grouped by a financial dimension.
Example
For example, a BEAT controller runs it By customer, Monthly, for 1 January to 30 June, grouped by the department dimension, to show monthly billing per department.
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
Read Billing and revenue summary for the right dates
Use this page to summarise billing and revenue by customer and by month (or another reporting frequency), optionally grouped by a financial dimension.
Steps from Microsoft
Go to Subscription billing > Recurring contract billing > Inquiries and reports > Billing and revenue summary.
In the Calculate billing and revenue summary dialog, select the Billing and revenue report type and the Reporting frequency.
Enter the From date and To date, and optionally a Customer account or Billing schedule number.
Set Group by financial dimension to Yes and select the dimension group and line if the summary must be split by dimension.
Select OK and read the billing schedule lines on the page.
How the summary is grouped.Checked in Dynamics 365
By customer
Reporting frequency
The period length of the summary.Checked in Dynamics 365
Monthly
From date / To date
The period of the summary.Checked in Dynamics 365
Customer account / Billing schedule number
Limits the summary to one customer or schedule.Checked in Dynamics 365
Group by financial dimension
Yes groups the summary by a financial dimension.Checked in Dynamics 365
No
Financial dimension group / Financial dimension line
The dimension used when Group by financial dimension is Yes.Checked in Dynamics 365
Common errors and fixes
Message
What to do
The report page shows no lines after OK
The page only lists billing schedules in the dates you entered. Widen From date and To date, and check that the schedules aren't archived; archived lines no longer appear on inquiry pages. Microsoft Learn
Test checklist
Run the page By customer, Monthly, for 1 January to 30 June.
Check: Each customer's schedule lines are listed with billing dates and quantities.
Report type By customer and Reporting frequency Monthly, matching the period close.The report type and frequency decide how lines are grouped; the defaults give a monthly view per customer.
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 users and managers can open this page.
Reversible: The page only reads billing schedules; running it again with other dates changes nothing. Microsoft Learn
If you change it later
The page calculates from the billing schedules each time; it changes no data. Microsoft Learn
Technical architect
6Technical
Menu item
SubBillBillingAndRevenueSummaryChecked in Dynamics 365
Form
SysOperationTemplateFormChecked in Dynamics 365
Roles to set it up and use it
To use itSubscription billing manager SubBillBillingMaintainSubscription billing allocation, deferral, and billing manager SubBillMaintainSubscription 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
Load order: Billing and revenue summary has no data entity in Data management, so there is nothing to load from a file or a configuration template. It is calculated from the billing schedules when you run it, so load the billing schedules and run the page in the new environment.Microsoft Learn