BeyondERP.Newsletter
Menu

Setup step on the Project report sort fields page · Project management and accounting

Set up Project report sort fields

A setup page where you create the sort fields that classify projects for reporting, such as a customer segment or a region, in up to the three sort field slots a project has.

Used by
Project supervisor
Business process
Analyze project performance
Menu item
ProjSorting
Main table
ProjSorting
Data entity
ProjProjectReportSortFieldsEntity
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 create the sort fields that classify projects for reporting, such as a customer segment or a region, in up to the three sort field slots a project has.
What you do hereUse this page to define the values you can put in the sort fields of a project, so that project reports can be grouped and filtered by them.
ExampleFor example, BEAT creates the value PUBLIC for Sort field 1 (customer segment) and NORTH for Sort field 2 (region), so that the project statement can show PRJ-0042 and PRJ-0057 together under the public sector.
Project report sort fields 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 Project report sort fields1 screen
  1. Screen 1

    Create a project report sort field

    Go to Project management and accounting > Setup > Projects > Project report sort fields

    1. Select New
    2. Select the sort field, such as Sort field 1
    3. Enter an identification and a description
    4. Select Save
    1IdentificationBEAT-SORT
    SortingSort field 1
    DescriptionSort field
    Create a project report sort field (zoomed on the outlined fields)
    Show the full screenCreate a project report sort field
    page title tab to open what to set or check

Steps from Microsoft

  1. Go to Project management and accounting > Setup > Projects > Project report sort fields.
  2. Select New and choose the Sorting slot, for example Sort field 1.
  3. Enter the Identification value and a Description that says what the slot groups, such as Public sector customers.
  4. Add the values for the other slots you use, then open the project and enter the value in its sort field.

Source: Microsoft data model

Fields on the page

FieldWhat it meansExampleTable column
SortingWhich of the project sort field slots the value belongs to, such as Sort field 1.Checked in Dynamics 365Sort field 1SortCode
IdentificationThe value that can be entered in that sort field on a project.Checked in Dynamics 365PUBLICsortingId
DescriptionA short description of the sort value.Checked in Dynamics 365Public sector customersDescription

Common errors and fixes

MessageWhat to do
A project report grouped by sort field shows projects under a blank group.Those projects have no value in that sort field. Enter one of the values from this page on each project. Microsoft data model

Test checklist

  1. Create the value PUBLIC in Sort field 1.
  2. Enter PUBLIC in Sort field 1 on two projects.
  3. Run the Projects report filtered on Sort field 1 = PUBLIC.
  4. Check that exactly those two projects are listed.

Source: Microsoft data model

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Project report sort fieldsOne sort field slot per reporting dimension that the financial dimensions don't already give (for example customer segment in Sort field 1), with a short, fixed list of valuesSort fields only group and filter project reports. A short fixed list keeps reports readable; anything that must reach the general ledger belongs in a financial dimension instead.What should the project sort fields classify?Using sort fields for data that finance needs in the ledger. Sort fields are not posted, so ledger reports can't show them.Test: Projects group by sort field

Feature management and licence

Licence or add-inOn the live system, Project supervisor maintains this page.

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: Values can be changed at any time; they only affect report grouping.
If you change it laterReports group and filter projects by the sort field values on the project. Renaming a value changes the grouping on later report runs; projects keep the value already entered. Microsoft data model
Technical architect

6Technical

Menu itemProjSorting Checked in Dynamics 365
FormProjSorting Checked in Dynamics 365
TableProjSortingShown as “Sorting” in Record infoKey field: sortingIdChecked in Dynamics 365
Data entitiesProjProjectReportSortFieldsEntityProject report sort fields Microsoft data model
Who can open itPrivilegesMaintain project report sorting criteria ProjSortingMaintainView project report sorting criteria ProjSortingViewDutiesEnable project accounting process ProjProjectAccountingProcessEnableInquire into project accounting reference data ProjProjectAccountingReferenceDataInqui
1 security roleProject supervisor ProjProjectSupervisor
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itProject supervisor ProjProjectSupervisorGive people one of these roles. On this system, 1 role 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=ProjSorting
Integrate withProjProjectReportSortFieldsEntity data entity Microsoft data model
Data migrationProjProjectReportSortFieldsEntity Project report sort fields, loaded for each company.Load order: Load the sort field values before projects, because a project stores the value in its sort field.Load first: Legal entitiesMicrosoft Learn
Table definitionProjSorting columns and relations Microsoft data model
Everyone

8Sources

To cite this step: PM-SETUP-040, Set up Project report sort fields. Beyond ERP Atlas Hub, 2026-11-11. https://www.beyonderp.cloud/atlas/step/PM-SETUP-040