BeyondERP.Newsletter
Menu

Inquiry page · Subscription billing

Billing schedule lines

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.

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 isAn 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 hereUse this page to review the items, prices and dates on billing schedule lines across customers without opening each schedule.
ExampleFor 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.
Billing schedule lines 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 schedule lines
Set up firstAll billing schedules Microsoft Learn
Used next byPrice update 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 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

  1. Go to Subscription billing > Recurring contract billing > Inquiries and reports > Billing schedule lines.
  2. 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.
  3. Use Add to filter on another field, or the Sorting tab to change the order.
  4. Select OK to list the matching billing schedule lines, and open a schedule to change a line.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
Billing schedule number (range)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 365D007
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

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. Open Billing schedule lines and enter D007 in Item number.
  2. Select OK.
  3. Check: Both schedules' D007 lines are listed with their dates and prices.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Read Billing schedule lines for the right datesFilter 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.Which filter should the standard query for Billing schedule lines keep?Removing the !Archived range and then counting archived lines as running contracts.Test: Lines for one item before a price update

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 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 itemSubBillScheduleLines Checked in Dynamics 365
FormSysQueryForm Checked in Dynamics 365
Data entitiesSubBillScheduleLineEntitySubscription billing schedule line 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=SubBillScheduleLines
Integrate withSubBillScheduleLineEntity data entity Checked in Dynamics 365
Data migrationSubBillScheduleLineEntity (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
Everyone

8Sources