An inquiry that opens a query dialog on billing schedule lines and their billing schedules, and then lists the matching lines of all customers in one place.
Subscription billingRecurring contract billingInquiries and reports
SubBillScheduleLines
Business process
Bill subscriptions
Menu item
SubBillScheduleLines
Data entity
SubBillScheduleLineEntity
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
An inquiry that opens a query dialog on billing schedule lines and their billing schedules, and then lists the matching lines of all customers in one place.
What you do here
Use this page to review the items, prices and dates on billing schedule lines across customers without opening each schedule.
Example
For example, before raising the price of item D007 for 2027, an account manager lists every billing schedule line for D007 with a billing end date after 31 December 2026.
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 schedule lines for the right dates
Use this page to review the items, prices and dates on billing schedule lines across customers without opening each schedule.
Steps from Microsoft
Go to Subscription billing > Recurring contract billing > Inquiries and reports > Billing schedule lines.
In the Inquiry dialog, on the Range tab, enter criteria such as Billing schedule number, Item number or Customer account; the billing date ranges and Schedule status !Archived are filled in.
Use Add to filter on another field, or the Sorting tab to change the order.
Select OK to list the matching billing schedule lines, and open a schedule to change a line.
Limits the lines to one or more billing schedules.Checked in Dynamics 365
Item number (range)
Limits the lines to one item.Checked in Dynamics 365
D007
Billing start date / Billing end date (range)
Date ranges on the lines; the dialog fills them in.Checked in Dynamics 365
Schedule status (range)
Filled in as !Archived, so archived schedules are left out.Checked in Dynamics 365
!Archived
Customer account / End user account (range)
Limits the lines to a customer or end user of the billing schedule.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
Open Billing schedule lines and enter D007 in Item number.
Select OK.
Check: Both schedules' D007 lines are listed with their dates and prices.
Filter on Item number or Customer account and the billing dates first, and keep the !Archived status range.Without a filter the page lists every open line of every customer; archived schedules no longer appear on inquiry pages.
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 reads billing schedule lines as they are now; changes to the lines show the next time you run it. Microsoft Learn
Technical architect
6Technical
Menu item
SubBillScheduleLinesChecked in Dynamics 365
Form
SysQueryFormChecked in Dynamics 365
Data entities
SubBillScheduleLineEntitySubscription billing schedule line Checked 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
SubBillScheduleLineEntity data entity Checked in Dynamics 365
Data migration
SubBillScheduleLineEntity (Subscription billing schedule line): the lines this inquiry lists.Load order: Load billing schedules after customers, released products and all Recurring contract billing setup. Load the header first and then its lines. Lines that were already billed in the old system are then marked billed with Mass stubbing process, so Generate invoice doesn't bill them again.Load first: Billing schedule headersMicrosoft Learn