BeyondERP.Newsletter
Menu

Inquiry page · Subscription billing

Billing and revenue summary

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.

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 isA 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 hereUse this page to summarise billing and revenue by customer and by month (or another reporting frequency), optionally grouped by a financial dimension.
ExampleFor 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.
Billing and revenue summary 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 › Inquiries and reports › Billing and revenue summary
Set up firstAll billing schedules Microsoft Learn
Used next byTotal contract revenue Microsoft Learn
Related pagesBilling detail lines Microsoft Learn
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

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

  1. Go to Subscription billing > Recurring contract billing > Inquiries and reports > Billing and revenue summary.
  2. In the Calculate billing and revenue summary dialog, select the Billing and revenue report type and the Reporting frequency.
  3. Enter the From date and To date, and optionally a Customer account or Billing schedule number.
  4. Set Group by financial dimension to Yes and select the dimension group and line if the summary must be split by dimension.
  5. Select OK and read the billing schedule lines on the page.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
Billing and revenue report typeHow the summary is grouped.Checked in Dynamics 365By customer
Reporting frequencyThe period length of the summary.Checked in Dynamics 365Monthly
From date / To dateThe period of the summary.Checked in Dynamics 365
Customer account / Billing schedule numberLimits the summary to one customer or schedule.Checked in Dynamics 365
Group by financial dimensionYes groups the summary by a financial dimension.Checked in Dynamics 365No
Financial dimension group / Financial dimension lineThe dimension used when Group by financial dimension is Yes.Checked in Dynamics 365

Common errors and fixes

MessageWhat to do
The report page shows no lines after OKThe 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

  1. Run the page By customer, Monthly, for 1 January to 30 June.
  2. Check: Each customer's schedule lines are listed with billing dates and quantities.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Read Billing and revenue summary for the right datesReport 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.Which grouping does management need?Grouping by a financial dimension that the billing schedule lines don't carry, which puts every line in a blank group.Test: Monthly summary per customer

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 users and managers can open this page.

Microsoft Learn

Solution architect

5Design impact

Can it be undoneReversible: The page only reads billing schedules; running it again with other dates changes nothing. Microsoft Learn
If you change it laterThe page calculates from the billing schedules each time; it changes no data. Microsoft Learn
Technical architect

6Technical

Menu itemSubBillBillingAndRevenueSummary 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 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
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=SubBillBillingAndRevenueSummary
Data migrationLoad 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
Everyone

8Sources