BeyondERP.Newsletter
Menu

Job page · Subscription billing

Generate invoice batch processing

A batch dialog that creates recurring invoices from billing schedules through a recurring batch job.

Business process
Bill subscriptions
Menu item
SubBillGenerateInvoiceBatchProcessing
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 batch dialog that creates recurring invoices from billing schedules through a recurring batch job.
What you do hereUse this page to schedule invoice creation as a recurring batch job, selecting billing schedules by start date or end date relative to today.
ExampleFor example, in January you can select Months and enter 2 to include billing schedule lines that start up to March 1.
Generate invoice batch processing 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 › Generate invoice batch processing
Set up firstRecurring contract billing parameters Microsoft Learn All billing schedules Microsoft Learn
Used next byGenerate invoice batch jobs Microsoft Learn
Related pagesGenerate invoice 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 recurring invoicing should run unattended on a schedule instead of being started by a user.
How oftenOn the recurrence of your billing cycle, for example monthly for monthly billing.
Batch settingsAlways runs as a batch job. Use a relative date range (days or months from today) so each recurrence picks up the lines that are due on that run date.
What the output showsRecurring invoices for the billing schedules whose start or end date falls in the relative range. Example: in January, Months with 2 includes lines through March. Lines invoiced twice or missing usually mean the offset in days or months doesn't match the recurrence of the job.

Source: Microsoft Learn

Setup steps on this page

Set the relative date range of the batch run

Run recurring invoicing unattended with a date range relative to today.

Steps from Microsoft

  1. Go to Subscription billing > Recurring contract billing > Periodic tasks > Generate invoice batch processing.
  2. In the Date range filter, choose whether billing schedules are selected by start date or end date.
  3. To use a date other than today, set Add the number of days or months to Yes. In Select by days or months, choose Days (0 is today) or Months (0 is the first through the last day of the current month) and enter the number.
  4. Set the recurrence of the batch job; Batch processing is always Yes for this task.
  5. After each run, review the created sales orders or invoices and the batch job log.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
Date rangeSelects billing schedules by their start date or end date.Microsoft Learn Start date
Add the number of days or monthsSet to Yes to use a start or end date other than today's date.Microsoft Learn
Select by days or monthsChooses whether the offset from today is counted in days or months, with the number entered alongside.Microsoft Learn Months
Batch processingAlways set to Yes for this task and can't be changed.Microsoft Learn

Common errors and fixes

MessageWhat to do
Batch processing can't be set to NoGenerate invoice batch processing always runs as a batch job. To invoice now and review the lines, use Generate invoice instead. Microsoft Learn
Two billing schedules of one customer give two sales orders although Consolidate by customer is YesSchedules are combined only when customer, sales document ID, customer reference, project and currency match, and payment terms, method and schedule are the same. Microsoft Learn
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

Test checklist

  1. The first run picks up exactly the lines in the expected date range.
  2. The next recurrence doesn't invoice the same lines again.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set the relative date range of the batch runSelect by Months with 0, so each monthly run takes the lines of the whole current month, and a recurrence of monthly on the first day.Months 0 means the first through the last day of the current month, and the current month is always included, so a monthly recurrence bills each month once.Should recurring invoicing run as a batch job?Using Days with a large negative number, which reaches back a year and bills lines that should have been stubbed or reviewed.Test: Monthly batch takes the current month

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 undoneYes, before posting: Unposted sales orders can be deleted; posted invoices must be credited. Microsoft Learn
If you change it laterCreates recurring invoices from billing schedules on every run of the batch job. Microsoft Learn
Technical architect

6Technical

Menu itemSubBillGenerateInvoiceBatchProcessing 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 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=SubBillGenerateInvoiceBatchProcessing
Data migrationLoad order: Generate invoice batch processing has no data entity in Data management, so there is nothing to load from a file or a configuration template. Set up its recurring batch job again in each environment.Microsoft Learn
Everyone

8Sources