BeyondERP.Newsletter
Menu

Setup page · Retail and Commerce

Date intervals

A setup page where you define date intervals, the time spans that loyalty programs use for their tiers and tier rules.

Used by
Budget manager, Chief financial officer, Accountant and 6 more roles
Business process
Define loyalty programs in Dynamics 365 Commerce
Menu item
LedgerPeriodCode
Main table
LedgerPeriodCode
Data entity
LedgerDateIntervalEntity
Show what matters for
PAGE GUIDEWhat the page does and how to use it7 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA setup page where you define date intervals, the time spans that loyalty programs use for their tiers and tier rules.
What you do hereUse this page to set how long a customer stays in a loyalty tier, and over which period points count towards qualifying for a tier. Date intervals apply only if your loyalty programs use tiers.
ExampleFor example, a one-year interval on a Gold tier keeps a qualifying customer in Gold for a year, and a previous-month interval on a tier rule counts only the points earned last month.
Date intervals 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.

Steps from Microsoft

  1. Go to Retail and Commerce > Customers > Loyalty > Date intervals.
  2. Select New.
  3. In the Date interval code field, enter a code, such as January.
  4. In the Description field, enter a description.
  5. Under Interval Start, set the From date period type, From date Start/End and From date adjustment unit.
  6. Under Interval End, set the To date period type, To date Start/End, To date +/- and To date adjustment unit.
  7. Select Save.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansTable column
Date interval codeThe name of the interval, picked on reports instead of typing From and To dates each time.Microsoft Learn Code

Test checklist

  1. Create a date interval that runs one year into the future for a tier.
  2. Create one that runs one year into the past for the tier rule's evaluation.
  3. Assign them on Loyalty programs and earn enough points on a test card.
  4. Check the tier end date on the card is one year from the qualifying date.

Source: Microsoft Learn

Solution architect

4Design impact

Shared or per companyPer company: each legal entity has its own records. Microsoft data model
Can it be undoneReversible: In loyalty, a date interval sets how long a customer stays in a tier and which past window counts towards a tier rule; edits change later tier calculations. If you need them applied to cards already issued, run Update loyalty card tiers. Microsoft Learn
Technical architect

5Technical

Menu itemLedgerPeriodCode Checked in Dynamics 365
FormLedgerPeriodCode Checked in Dynamics 365
TableLedgerPeriodCodeShown as “Date intervals” in Record infoChecked in Dynamics 365
Data entitiesLedgerDateIntervalEntityDate intervals Microsoft data model
Who can open itPrivilegesMaintain date intervals for ledgers LedgerPeriodCodeMaintainView date intervals for ledgers LedgerPeriodCodeViewDutiesEnable general ledger process LedgerGeneralLedgerProcessEnableInquire into general ledger reference data LedgerGeneralLedgerReferenceDataInquireEnable general ledger process RentalLedgerGeneralLedgerProcessEnable
9 security rolesBudget manager BudgetBudgetManagerChief financial officer CompanyChiefFinancialOfficerAccountant LedgerAccountantAccounting manager LedgerAccountingManagerAccounting supervisor LedgerAccountingSupervisorFinancial controller LedgerFinancialControllerRental manager RentalManagerRental purchasing manager RentalPurchasingManagerRental sales manager RentalSalesManager
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itRental manager RentalManagerRental sales manager RentalSalesManagerAccounting manager LedgerAccountingManagerRental purchasing manager RentalPurchasingManagerAccounting supervisor LedgerAccountingSupervisorTo use itAccountant LedgerAccountantFinancial controller LedgerFinancialControllerChief financial officer CompanyChiefFinancialOfficerBudget manager BudgetBudgetManagerGive people one of these roles. On this system, 9 roles can open this page.Checked in Dynamics 365
Developer

6Developer

Open it by URLhttps://<your-environment>/?mi=LedgerPeriodCode
Integrate withLedgerDateIntervalEntity data entity Microsoft data model
Data migrationLedgerDateIntervalEntity (Date intervals): loaded for each company, in Microsoft's default template 025 - General ledger.Load order: Microsoft's default template 025 - General ledger loads Date intervals at execution unit 1, level 25, sequence 10. Lower levels load first, and entities at the same level load in sequence order.Load first: the default templates at lower levels (System setup to Workflow)Microsoft Learn
Table definitionLedgerPeriodCode columns and relations Microsoft data model
Everyone

7Sources