BeyondERP.Newsletter
Menu

Setup page · Project management and accounting

Resource/project validation groups

A setup page where you group resources and projects so that workers can only record time and costs on the projects allowed for them.

Used by
Project supervisor
Business process
Manage project delivery
Menu item
ProjValTableEmplProj
Main table
ProjValEmplProjTable
Data entity
ProjValEmplProjEntity
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 group resources and projects so that workers can only record time and costs on the projects allowed for them.
What you do hereUse this page to control which projects each worker or group of workers can enter in journals and timesheets.
ExampleFor example, BEAT's group LISBON-TEAM lists its 9 Lisbon consultants and the projects PRJ-0042 and PRJ-0057, so when validation is on for those workers they can't record hours on PRJ-0090.
Resource/project validation groups 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 › Setup › Validation › Resource/project validation groups
Set up firstProject management and accounting parameters Microsoft Learn Set up Project management and accounting parameters
Used next byHour journal Microsoft data model
Related pagesResource/project validation report 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 Resource/project validation groups1 screen

Use this page to control which projects each worker or group of workers can enter in journals and timesheets.

  1. Screen 1

    Create a resource and project validation group

    Go to Project management and accounting > Setup > Validation > Resource/project validation groups

    1. Select New
    2. Enter the group code and name
    3. Select Save
    4. Move the workers the group applies to into Selected resources, then add the projects they may enter
    1Resource/projectBEAT-RPV
    2NameResource project validation
    Create a resource and project validation group (zoomed on the outlined fields)
    Show the full screenCreate a resource and project validation group
    page title tab to open what to set or check

Steps from Microsoft

  1. Go to Project management and accounting > Setup > Validation > Resource/project validation groups.
  2. Select New and enter the group ID and Name.
  3. In Legal entity, select the company to take workers from, then add the projects and workers on the Projects and Worker FastTabs.
  4. Turn on the matching validation for the projects or workers on their own pages, then enter a test journal line.

Source: Microsoft data model

Fields on the page

FieldWhat it meansExampleTable column
Resource/projectThe unique ID of the resource and project validation group.Microsoft data model LISBON-TEAMGroupId
NameThe name of the validation group.Microsoft data model Lisbon team projectsName

Common errors and fixes

MessageWhat to do
A worker's hours on a project are refused.Validation is on for the worker and the project isn't in any of the worker's resource/project groups. Add the project to the group. Microsoft data model

Test checklist

  1. Create group LISBON-TEAM with worker 000245 and project PRJ-0042.
  2. Turn on project validation for worker 000245.
  3. Enter hours for 000245 on PRJ-0090 and check they are refused.
  4. Enter hours on PRJ-0042 and check they are accepted.

Source: Microsoft data model

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Resource/project validation groupsValidation only for workers who must book on a closed list of projects, such as subcontractorsThe group limits the projects a worker can book on, but only after validation is turned on for the worker.Restrict resource/project combinations with validation groups?Turning validation on for workers before their projects are in the group; they then can't book any time.Test: Resource/project validation blocks a line outside the group

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: Groups can be changed or validation turned off at any time; posted transactions are not rechecked. Microsoft data model
If you change it laterLines entered on journals and timesheets are checked against the group only where validation is turned on (on the project for project/category groups, on the worker for resource groups). Lines already posted are not rechecked. Microsoft data model
Technical architect

6Technical

Menu itemProjValTableEmplProj Checked in Dynamics 365
FormProjValTableEmplProj Checked in Dynamics 365
TableProjValEmplProjTableShown as “Worker/project validation group” in Record infoKey field: GroupId, NameChecked in Dynamics 365
Data entitiesProjValEmplProjEntityProject resource/project validation group Microsoft data model
Who can open itPrivilegesMaintain project validation setup ProjTableValidationMaintainView project validation setup ProjTableValidationViewDutiesEnable project accounting process ProjProjectAccountingProcessEnable
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=ProjValTableEmplProj
Integrate withProjValEmplProjEntity data entity Microsoft data model
Data migrationProjValEmplProjEntity (Project resource/project validation group): loaded for each company, in Microsoft's default template 650 - Project accounting.Load order: Microsoft's default template 650 - Project accounting loads Project resource/project validation group 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 definitionProjValEmplProjTable columns and relations Microsoft data model
Everyone

8Sources