BeyondERP.Newsletter
Menu

Job page · Asset leasing

Create schedule batch

A periodic job that creates payment schedules for many lease books at one time.

Business process
Make payments on asset leases
Menu item
AssetLeaseCreateScheduleBatch
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 job that creates payment schedules for many lease books at one time.
What you do hereRun this job to generate the payment, amortization, depreciation and expense schedules for all books, or for a chosen lease group, book or lease.
ExampleFor example, after importing 40 new leases, a lease accountant runs this job once instead of creating each schedule by hand.
Create schedule batch 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

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 itAfter leases are added or imported with their payment schedule lines, and before the payment schedules are confirmed.
How oftenOn demand, when many new leases need their schedules created at once.
Batch settingsRun it in the background with For all books set to Yes when many leases were added, for example after a lease import.
What the output showsLease books with payment, liability amortization, asset depreciation and expense schedules for each selected lease. An unexpected liability usually traces back to the payment schedule lines or the incremental borrowing rate on the lease.

Source: Microsoft Learn

Setup steps on this page

Create lease schedules in batch

Create the books and the payment, amortization, depreciation and expense schedules for many leases at once.

Steps from Microsoft

  1. Go to Asset leasing > Periodic > Create schedule batch.
  2. Set For all books, or choose a Lease group, Book ID or Lease ID.
  3. Run it in the background for a large portfolio and select OK.
  4. Check the books' Initial right-of-use asset and Lease liability, then run Confirmation batch.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
For all booksYes creates schedules for every book.Checked in Dynamics 365No
Lease groupCreate schedules for the leases of one group.Microsoft Learn
Book IDCreate schedules for specific books.Checked in Dynamics 365
Lease IDCreate schedules for one lease.Checked in Dynamics 365

Common errors and fixes

MessageWhat to do
A lease's figures didn't change after editing itCreate schedules again for the lease before confirming; confirmed leases change only through an adjustment. Microsoft Learn

Test checklist

  1. Each selected lease has a payment schedule on its lease book.
  2. The liability amortization and asset depreciation schedules show amounts for every period.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Create lease schedules in batchRun it by lease group right after a Lease import framework migration, then check the books before Confirmation batch.Create schedules makes each lease's books with their schedules; until it runs the leases have no figures to confirm or post.Are schedules created lease by lease or in batch?Running Confirmation batch straight after, without checking classification and present value on the new books.Test: Batch creates books for a lease group

Feature management and licence

Feature to turn onAsset leasing (Must be on)
Licence or add-inAsset leasing must be turned on in Feature management (feature Asset leasing). Microsoft Learn describes three Asset leasing roles: Maintain lease (add, edit and post leases), View lease (view leases and schedules and run reports) and Lease clerk (create new leases only). Maintain lease users run it.

Microsoft Learn

Solution architect

5Design impact

Shared or per companyPer company: leases with their books, schedules and journals belong to the legal entity you are working in, and Lease ID numbers come from a number sequence set per company. Turn on Cross entity batch in Asset leasing parameters to create journals for other legal entities from the current one. Microsoft Learn
Can it be undoneYes, before confirmation: Schedules can still be changed until the payment schedule is confirmed; after confirmation, changes are lease adjustments. Microsoft Learn
If you change it laterCreates or recreates the lease book schedules for the selected leases; nothing is posted. Microsoft Learn
Technical architect

6Technical

Menu itemAssetLeaseCreateScheduleBatch Checked in Dynamics 365
FormDialog Checked in Dynamics 365
Roles to set it up and use itTo use itLease accountant AssetLeaseLeaseMaintainAccountant LedgerAccountantGive 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=AssetLeaseCreateScheduleBatch
Data migrationLoad order: Create schedule batch has no data entity in Data management, so it can't be loaded from a file or a configuration template. It builds the books and schedules of leases already in the system, for example after an import.Microsoft Learn
Everyone

8Sources

KEEP EXPLORING

More in Asset leasing.

Open the other pages and setup steps in this module, or go back to the Atlas Hub to search every page.