BeyondERP.Newsletter
Menu

Setup page · Project management and accounting

Project allocation keys

A setup page where you create allocation keys: named splits whose lines each give a share, as a percentage, to a project, resource or line property. Forecast lines can refer to an allocation key.

Used by
Project accountant, Project supervisor
Business process
Plan projects
Menu item
ProjAllocateKey
Main table
ProjAllocateKey
Data entity
ProjProjectAllocationKeyEntity
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 setup page where you create allocation keys: named splits whose lines each give a share, as a percentage, to a project, resource or line property. Forecast lines can refer to an allocation key.
What you do hereUse this page to keep standard splits, such as how a lump-sum forecast is shared between projects, and to open the Lines of a key to set its percentages.
ExampleFor example, BEAT creates the key SPLIT-6040 with two lines, 60.00 percent to PRJ-0042 and 40.00 percent to PRJ-0057, and uses it on a 10,000.00 item forecast so that 6,000.00 and 4,000.00 are forecast on the two projects.
Project allocation keys 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 processPlan projects
Menu pathProject management and accounting › Setup › Forecasts › Project allocation keys
Set up firstForecast models Microsoft Learn
Used next byAll project forecasts Microsoft Learn
Related pagesProject management and accounting parameters (default allocation keys) Microsoft data model
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 Project allocation keys1 screen
  1. Screen 1

    Create a project allocation key

    Go to Project management and accounting > Setup > Forecasts > Project allocation keys

    1. Select New
    2. Enter the allocation key code and name
    3. Select Save
    4. Select Lines to set how the amount is spread over periods
    1Allocation keyBEAT-AK
    NameAllocation key
    Create a project allocation key (zoomed on the outlined fields)
    Show the full screenCreate a project allocation key
    page title tab to open what to set or check

Steps from Microsoft

  1. Go to Project management and accounting > Setup > Forecasts > Project allocation keys.
  2. Select New and enter the Allocation key and its Name.
  3. Select Lines and add one line per share, with the project, resource or line property and its Allocation percentage.
  4. Check that the percentages add up to 100.00, then select the key on a forecast line.

Source: Microsoft data model

Fields on the page

FieldWhat it meansExampleTable column
Allocation keyThe ID of the allocation key that forecast lines refer to.Microsoft data model SPLIT-6040AllocateId
NameThe name of the allocation key.Checked in Dynamics 36560/40 split between projectsName
Allocation percentageOn the Lines of the key: the share of the amount given to the line's project, resource or line property.Microsoft data model 60.00

Common errors and fixes

MessageWhat to do
A split forecast doesn't add up to the original amount.The key's line percentages don't total 100.00. Correct the Lines of the key. Microsoft data model

Test checklist

  1. Create key SPLIT-6040 with 60.00 percent to PRJ-0042 and 40.00 percent to PRJ-0057.
  2. Enter a 10,000.00 forecast that uses the key.
  3. Check that 6,000.00 is forecast on PRJ-0042 and 4,000.00 on PRJ-0057.

Source: Microsoft data model

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Project allocation keysA few named keys for the splits that recur in forecasting, each with lines that total 100.00 percentA forecast line that refers to a key is split by its percentages, so a correct key saves entering the same forecast several times.Split shared forecasts with allocation keys?Lines that don't total 100.00 percent, so part of the forecast is lost or doubled.Test: Forecast split by key

Feature management and licence

Licence or add-inOn the live system, Project supervisor maintains this page and Project accountant can open it.

Checked in Dynamics 365

Solution architect

5Design impact

Shared or per companyPer company: each legal entity has its own records. Microsoft data model
Can it be undoneReversible: Keys and their lines can be changed at any time; forecasts already split keep their amounts. Microsoft data model
If you change it laterForecast lines that refer to the key are split by its percentages. Changing the percentages affects forecasts split afterwards, not forecasts already created. Microsoft data model
Technical architect

6Technical

Menu itemProjAllocateKey Checked in Dynamics 365
FormProjAllocateKey Checked in Dynamics 365
TableProjAllocateKeyShown as “Project allocation keys” in Record infoKey field: AllocateIdChecked in Dynamics 365
Data entitiesProjProjectAllocationKeyEntityProject allocation keys Microsoft data model ProjProjectAllocationKeyDetailsEntityProject allocation key details Microsoft data model
Who can open itPrivilegesMaintain project allocation keys ProjAllocateKeyMaintainView project allocation keys ProjAllocateKeyViewDutiesInquire into project accounting policies ProjProjectAccountingPolicyInquireEnable project accounting process ProjProjectAccountingProcessEnable
2 security rolesProject accountant ProjProjectAccountantProject supervisor ProjProjectSupervisor
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itProject supervisor ProjProjectSupervisorTo use itProject accountant ProjProjectAccountantGive people one of these roles. On this system, 2 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=ProjAllocateKey
Integrate withProjProjectAllocationKeyEntity data entity Microsoft data model
Data migrationProjProjectAllocationKeyEntity Key headers, loaded for each company.ProjProjectAllocationKeyDetailsEntity Key lines, loaded after the headers.Load order: Load the key headers first, then the key lines after the projects, resources and line properties that the lines refer to.Load first: Projects, Line propertiesMicrosoft Learn
Table definitionProjAllocateKey columns and relations Microsoft data model
Everyone

8Sources