BeyondERP.Newsletter
Menu

Report page · Project management and accounting

Project/category validation

A report that lists project/category validation groups with the projects and categories they combine, for the project and transaction types you choose.

Business process
Manage project delivery
Menu item
output:ProjListValProjCategory
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 report that lists project/category validation groups with the projects and categories they combine, for the project and transaction types you choose.
What you do hereUse it to answer 'which project and category combinations does each validation group allow?' when you set up or audit validation groups.
ExampleBEAT's validation group VG-CONSULT allows categories CONSULT, TRAVEL and HOTEL on 9 Time and material projects; the report shows PRJ-0071 is missing from the group, which is why its travel lines are rejected.
Project/category validation 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 project delivery
Menu pathProject management and accounting › Inquiries and reports › Validation reports › Project/category validation
Set up firstProject/category validation groups Microsoft data model
Used next byProject/category validation groups (fix a group) Microsoft data model
Related pagesCategory validation Microsoft data model Resource/category validation Microsoft Learn
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.

When to run it

When to run itWhen you set up or audit project/category validation groups.
How oftenOn demand; after group changes.
What the output showsValidation groups with the projects and categories they combine.

Source: Microsoft data model

Setup steps on this page

Audit project/category validation groups

Check each group's projects and categories after setup changes.

Steps from Microsoft

  1. Go to Project management and accounting > Inquiries and reports > Validation reports > Project/category validation.
  2. Turn on the project types and transaction types that the validation groups cover.
  3. Run it and read each group's projects and categories side by side.
  4. Add a missing project or category to the group on Project/category validation groups.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
Include project typesWhich project types to report on; the dialog toggles Time and material, Fixed-price, Investment, Internal and cost (Internal and Cost project types) and Time.Checked in Dynamics 365Time and material and Fixed-price on
Include transaction typesWhich transaction types to report on: Hour, Expense, Item and Fee.Checked in Dynamics 365Hour and Expense on
ValidationUnder Layout: how the group setup is listed; the dialog suggests Project.Checked in Dynamics 365Project

Common errors and fixes

MessageWhat to do
A combination you set up isn't on the report.Turn on the transaction type of the category; a TRAVEL expense category needs Expense on. Checked in Dynamics 365

Test checklist

  1. Create group VG-CONSULT with PRJ-0042 and categories CONSULT and TRAVEL.
  2. Run the report for Time and material with Hour and Expense on.
  3. Check that the group lists PRJ-0042 with both categories.

Source: Microsoft data model

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Audit project/category validation groupsTurn on every project type and transaction type the groups cover, then read group by group.A combination is allowed only when both the project and the category are in the same group.How many project/category validation groups?Adding the category to the group but forgetting the project, so lines are still rejected.Test: Group shows its combinations

Feature management and licence

Licence or add-inOn the live system, Project accountant runs this report.

Checked in Dynamics 365

Solution architect

5Design impact

Shared or per companyPer company: validation groups and the projects, workers and categories in them belong to one legal entity. Microsoft data model
Can it be undoneReversible: The report changes no data. Microsoft Learn
If you change it laterAdding a project or category to a group allows the combination for lines entered afterwards. Microsoft data model
Technical architect

6Technical

Menu itemoutput:ProjListValProjCategory Checked in Dynamics 365
FormSysOperationTemplateForm Checked in Dynamics 365
Roles to set it up and use itTo use itProject accountant ProjProjectAccountantGive people one of these roles. On this system, 1 role can run this page.Checked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=output:ProjListValProjCategory
Data migrationLoad order: The Project/category validation report has no data entity in Data management: it prints validation setup. Load the validation groups with ProjValProjCategoryEntity after workers, projects and categories, then run the report to compare.Load first: ProjValProjCategoryEntityMicrosoft data model
Everyone

8Sources