BeyondERP.Newsletter
Menu

Job page · Subscription billing

Update completion date process

A periodic task dialog that updates the completion date or completion percentage of milestone items on several billing schedules at once.

Business process
Bill subscriptions
Menu item
SubBillUpdateCompletionDate
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 periodic task dialog that updates the completion date or completion percentage of milestone items on several billing schedules at once.
What you do hereUse this page to record milestone progress for many billing schedules or end users in one run, including the completion percentage for milestone templates that use the Percent completed method.
ExampleFor example, a BEAT implementation project reaches 40 percent, and the project manager records 40 in Percentage amount for the milestone item on all its billing schedules in one run.
Update completion date process 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 › Update completion date process
Set up firstBilling schedule group (Milestone item type) Microsoft Learn
Used next byGenerate invoice Microsoft Learn
Related pagesMilestone templates 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.

When to run it

When to run itWhen project or service milestones are reached and the completion must be recorded before milestone billing.
How oftenOn demand, each time milestone progress is reported.
What the output showsA new line in the milestone allocation of each selected billing schedule for the percentage completed. A percentage that looks doubled usually means an increment was entered instead of the total percentage completed.

Source: Microsoft Learn

Setup steps on this page

Record milestone progress before invoicing

Record completion so milestone lines can be invoiced.

Steps from Microsoft

  1. Go to Subscription billing > Recurring contract billing > Periodic tasks > Update completion date process.
  2. In Milestone processing, select Update completion percentage for milestone templates that use the Percent completed method.
  3. Enter the total percentage completed so far in Percentage amount, and select the Item number related to the milestone template.
  4. Filter on End user account, Billing schedule number or Item numbers on Records to include, so only those milestones are updated.
  5. After the run, open the milestone allocation of a billing schedule and look for the new line with the percentage completed.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
Milestone processingChooses the update to run, such as Update completion percentage.Microsoft Learn
Percentage amountThe total percentage completed for the milestone.Microsoft Learn 40
Item numberThe item related to the milestone template.Microsoft Learn
Records to includeFilters the run by end user account, billing schedule number or item numbers.Microsoft Learn

Common errors and fixes

MessageWhat to do
Generate invoice skips a milestone lineEach milestone event needs an end date before it can be invoiced. Set it on the line or with Update completion date process. Microsoft Learn
Update completion percentage changes nothingIt applies only to milestone templates whose allocation method is Percentage of completion. Check the template's Allocation method. Microsoft Learn

Test checklist

  1. Each selected billing schedule has a new milestone allocation line.
  2. The line shows the total percentage you entered.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Record milestone progress before invoicingRun it each time progress is reported, entering the total percentage reached so far, before the next invoice run.Each run adds a milestone allocation line for the percentage, and milestone lines need end dates before they can be invoiced.Who reports milestone completion?Entering only this period's increase instead of the total percentage completed.Test: Completion adds an allocation line

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 undoneNo: There is no reversal of the run; correct the milestone allocation lines on the billing schedule. Microsoft Learn
If you change it laterProcessing adds a new line to the milestone allocation for the percentage completed. Microsoft Learn
Technical architect

6Technical

Menu itemSubBillUpdateCompletionDate Checked in Dynamics 365
FormSubBillUpdateCompletionDate 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=SubBillUpdateCompletionDate
Data migrationLoad order: Update completion date process has no data entity in Data management, so there is nothing to load from a file or a configuration template. Record the completion reached in the old system on the milestone lines after the billing schedules are loaded.Microsoft Learn
Everyone

8Sources