BeyondERP.Newsletter
Menu

Setup step on the Period types page · Time and attendance

Generate pay and statistics periods

Create the period types and periods that pay transfer and payroll statistics use.

Used by
Business Performance Planning app role, Data management administrator, Data management migration user and 5 more roles
Business process
Record employee time
Menu item
ProjPeriodTable
Main table
ProjPeriodTable
Data entity
ProjPeriodEntity
Setup steps
2 on this page
Show what matters for
SETUP GUIDEHow to set it up8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA setup page where you define period types, which set how long pay or statistics periods are, and generate the periods for each type.
What you do hereIn Time and attendance, use it for the pay period each worker is paid in (Period code on Time registration workers), the period Transfer to pay exports, and payroll statistics periods such as a vacation year.
ExampleFor example, you create period type VacYear with the unit Years and generate five periods from September 1, so the VAC payroll statistics group counts vacation days from September to August.
Period types 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 time and attendance › Record employee time
Menu pathTime and attendance › Setup › Payroll › Period types
Set up firstTime and attendance parameters Microsoft Learn
Used next byTime registration workers Microsoft Learn
Related pagesPayroll statistics groups Microsoft Learn
In this process Decide on approval workflow
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.

Step by step, with screenshots

Generate pay and statistics periods

Create the period types and periods that pay transfer and payroll statistics use.

Set up Period types1 screen

Use this page to create period types, such as weekly or monthly ones, and generate their periods for uses like project revenue estimates.

  1. Screen 1

    Create a period type

    Go to Organization administration > Setup > Calendars > Period types

    1. Select New
    2. Enter the period type and its description
    3. Select the frequency; Ledger period follows the fiscal calendar
    4. Select the day the week starts
    5. Select Save; use Generate periods to create the periods
    1Period typesBEAT-PER
    DescriptionPeriod type
    FrequencyLedger period
    Day week startsMonday
    Create a period type (zoomed on the outlined fields)
    Show the full screenCreate a period type
    page title tab to open what to set or check

Steps from Microsoft

  1. Go to Time and attendance > Setup > Payroll > Period types.
  2. Select New and enter the period type and its unit, such as VacYear and Years.
  3. Select Generate periods, enter the start date and the number of periods.
  4. Use the period type in Period code on time registration workers, or on a payroll statistics group.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExampleTable column
FrequencyHow often periods occur, such as Week, Month or Quarter. Ledger period uses the general ledger periods, and Unlimited lets you enter custom periods.Microsoft Learn Ledger period
Period typesWEEKLYPeriodId
DescriptionA short description of the period type.Microsoft Learn Period typeDescription
Day week startsMondayWeekStart

Common errors and fixes

MessageWhat to do
A worker isn't in Transfer to payNo periods are generated for the worker's period type, or the Period code is wrong. Microsoft Learn

Test checklist

  1. Create VacYear and generate periods.
  2. Use it on payroll statistics group VAC.
  3. Check the VAC balance runs from September 1.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Generate pay and statistics periodsOne period type per pay frequency and one per statistics year, such as VacYear, with periods generated well ahead.Transfer to pay and payroll statistics work per period.Which period types are needed?Running out of generated periods at year end.Test: Vacation year periods
Set up Period typesWhich frequency should the period type use for project revenue estimates?Creating a period type and stopping there. Periods exist only after you select Generate periods, so check Periods before using the type for revenue estimates.

Feature management and licence

Licence or add-inTime and attendance roles come from the security read in the Technical section. On this system the page is opened with roles such as Business Performance Planning app role, Data management administrator, Data management migration user and 5 more. The Microsoft Learn article for this page names no Feature management feature to turn on.

Microsoft Learn

Solution architect

5Design impact

Shared or per companyPer company: each legal entity has its own records. Microsoft data model
Can it be undoneReversible: Generate further periods any time.
If you change it laterWorkers are transferred to pay per pay period, so the generated periods decide which days each Transfer to pay covers. Microsoft Learn
Technical architect

6Technical

Menu itemProjPeriodTable Checked in Dynamics 365
FormProjPeriodTable Checked in Dynamics 365
TableProjPeriodTableShown as “PROJECT PERIODS” in Record infoKey field: PeriodIdChecked in Dynamics 365
Data entitiesProjPeriodEntityProject periods Microsoft data model
Who can open itPrivilegesMaintain project periods ProjPeriodTableMaintainView project periods ProjPeriodTableViewResource manager ProjResourceManagerDutiesMaintain Master entity data for data management DataManagementApplicationMasterEntitiesMaintainView Master entity data for data management DataManagementApplicationMasterEntitiesViewEnable project accounting process ProjProjectAccountingProcessEnableInquire into project accounting reference data ProjProjectAccountingReferenceDataInquiResource manager ProjResourceManager
8 security rolesBusiness Performance Planning app role BPPBudgetPlanningAppRoleData management administrator DataManagementAdministratorData management migration user DataManagementMigrationUserProject manager ProjProjectManagerProject supervisor ProjProjectSupervisorResource manager ProjResourceManagerDemand planning app role ScpDemandPlanningAppRoleInformation technology manager SysServerITManager
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itInformation technology manager SysServerITManagerResource manager ProjResourceManagerBusiness Performance Planning app role BPPBudgetPlanningAppRoleData management migration user DataManagementMigrationUserDemand planning app role ScpDemandPlanningAppRoleTo use itProject manager ProjProjectManagerGive people one of these roles. On this system, 8 roles can open this page.Checked in Dynamics 365
Actions on the page(Action Pane without tabs): Periods, Generate periods, Update worker periods, Workers, Update timesheet periods, Show timesheet periodsChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=ProjPeriodTable
Integrate withProjPeriodEntity data entity Microsoft data model
Data migrationProjPeriodEntity (Project periods): loaded for each company, in Microsoft's default template 650 - Project accounting.Load order: Microsoft's default template 650 - Project accounting loads Project periods at execution unit 1, level 30, sequence 20. 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 General ledger)Microsoft Learn
Table definitionProjPeriodTable columns and relations Microsoft data model
Everyone

8Sources

To cite this step: TA-SETUP-240, Generate pay and statistics periods. Beyond ERP Atlas Hub, 2026-11-11. https://www.beyonderp.cloud/atlas/step/TA-SETUP-240