BeyondERP.Newsletter
Menu

Setup step on the Period allocation categories page · Inventory management

Set up Period allocation categories

Use this page to allocate forecasts and budget amounts across periods, for example to reflect seasonal variation.

Used by
Budget manager, Chief financial officer, Accountant and 6 more roles
Business process
Maintain inventory levels
Menu item
ForecastLedgerAllocateKey
Main table
LedgerAllocateKey
Data entity
LedgerPeriodAllocationCategoryEntity
Setup steps
1 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 allocation keys that spread an amount or quantity across periods by percentage and date.
What you do hereUse this page to allocate forecasts and budget amounts across periods, for example to reflect seasonal variation.
Period allocation categories 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.

Step by step, with screenshots

Set up Period allocation categories1 screen

Use this page to allocate forecasts and budget amounts across periods, for example to reflect seasonal variation.

  1. Screen 1

    Create a period allocation category

    Go to Inventory management > Setup > Forecast > Period allocation categories

    1. Select New
    2. Enter the period key and name
    3. Select Save
    4. Select Lines to enter the dates and percentages that spread an amount across periods
    1Period keyBEAT-EVEN
    NameEven monthly spread
    Create a period allocation category (zoomed on the outlined fields)
    Show the full screenCreate a period allocation category
    page title tab to open what to set or check

How to use it

  1. Go to Inventory management > Setup > Forecast > Period allocation categories.
  2. Select New to add a period allocation category.
  3. Enter the Period key and the Name.
  4. Select Lines on the Action Pane to open the lines for the selected period key.
  5. Select Copy or Wizard on the Action Pane if you want to use those options.
  6. Select Save.

Source: Checked in Dynamics 365

Fields on the page

FieldWhat it meansExampleTable column
Period keyEVENKey
NameThe name of the period allocation key.Checked in Dynamics 365Even monthly spreadTxt

Test checklist

  1. Create a period key with percentages across several periods.
  2. Create a demand forecast line, set Method = Key and select the period key.
  3. Select Allocate forecast and check the Allocation grid spreads the quantity by the key's percentages.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Period allocation categoriesPeriod keys only for items with seasonal demand; use them with Method = Key when you allocate a forecastLearn says to use the Key method when seasonal variation should be considered; otherwise the Period method spreads the same quantity per period.Selecting Method = Key without a period key, or with a key that doesn't cover the forecast horizon, so the forecast isn't spread as expected.
Solution architect

5Design impact

Shared or per companyPer company: each legal entity has its own records. Microsoft data model
Can it be undoneReversible: Keys can be edited; they are applied when a forecast is allocated.
Technical architect

6Technical

Menu itemForecastLedgerAllocateKey Checked in Dynamics 365
FormLedgerAllocateKey Checked in Dynamics 365
TableLedgerAllocateKeyShown as “Period allocation key” in Record infoKey field: KeyChecked in Dynamics 365
Data entitiesLedgerPeriodAllocationCategoryEntityPeriod allocation categories Microsoft data model
Who can open itPrivilegesMaintain ledger period allocation keys ForecastLedgerAllocateKeyMaintainView fiscal period allocation keys ForecastLedgerAllocateKeyViewDutiesEnable 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 sales manager RentalSalesManagerRental manager RentalManagerAccounting manager LedgerAccountingManagerRental purchasing manager RentalPurchasingManagerAccounting supervisor LedgerAccountingSupervisorTo use itFinancial controller LedgerFinancialControllerChief financial officer CompanyChiefFinancialOfficerAccountant LedgerAccountantBudget manager BudgetBudgetManagerGive people one of these roles. On this system, 9 roles can open this page.Checked in Dynamics 365
Actions on the pageOptions: Personalize, Page options, ShareChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=ForecastLedgerAllocateKey
Integrate withLedgerPeriodAllocationCategoryEntity data entity Microsoft data model
Data migrationLedgerPeriodAllocationCategoryEntity (Period allocation categories): loaded for each company, in Microsoft's default template 160 - Budgeting.Load order: Microsoft's default template 160 - Budgeting loads Period allocation categories at execution unit 1, level 30, 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 General ledger)Microsoft Learn
Table definitionLedgerAllocateKey columns and relations Microsoft data model
Everyone

8Sources

To cite this step: IM-SETUP-420, Set up Period allocation categories. Beyond ERP Atlas Hub, 2026-11-11. https://www.beyonderp.cloud/atlas/step/IM-SETUP-420