BeyondERP.Newsletter
Menu

Setup page · Project management and accounting

Resource/category validation groups

A setup page where you group resources and categories so that workers can only use the categories allowed for them in journals and timesheets.

Used by
Project supervisor
Business process
Manage project delivery
Menu item
ProjValTableEmplCategory
Main table
ProjValEmplCategoryTable
Data entity
ProjValEmplCategoryEntity
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 categories so that workers can only use the categories allowed for them in journals and timesheets.
What you do hereUse this page to control which categories each worker or group of workers can enter.
ExampleFor example, BEAT's group JUNIOR-SALES lists its 5 junior salespeople and only the expense categories MILEAGE and MEALS, so their expense journals offer only those two categories.
Resource/category 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/category 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/category 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/category validation groups1 screen

Use this page to control which categories each worker or group of workers can enter.

  1. Screen 1

    Create a resource and category validation group

    Go to Project management and accounting > Setup > Validation > Resource/category 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 categories they may enter
    1Resource/categoryBEAT-RCV
    2NameResource category validation
    Create a resource and category validation group (zoomed on the outlined fields)
    Show the full screenCreate a resource and category 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/category 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 workers and categories on the Worker and Categories 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/categoryThe unique ID of the resource and category validation group.Microsoft data model JUNIOR-SALESGroupId
NameThe name of the validation group.Microsoft data model Junior sales expense categoriesName

Common errors and fixes

MessageWhat to do
A category is refused on a worker's journal line.Validation is on for the worker and the category isn't in the worker's resource/category group. Add the category to the group. Microsoft data model

Test checklist

  1. Create group JUNIOR-SALES with worker 000310 and the categories MILEAGE and MEALS.
  2. Turn on category validation for worker 000310.
  3. Enter an expense for 000310 on HOTEL and check it is refused.
  4. Enter one on MILEAGE and check it is accepted.

Source: Microsoft data model

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Resource/category validation groupsValidation for groups of workers whose allowed costs are limited by policy, such as junior staffThe group limits the categories a worker can enter, but only after validation is turned on for the worker.Restrict resource/category combinations with validation groups?Forgetting new categories: once validation is on, a category not in the group can't be used by those workers.Test: Resource/category 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 itemProjValTableEmplCategory Checked in Dynamics 365
FormProjValTableEmplCategory Checked in Dynamics 365
TableProjValEmplCategoryTableShown as “Employee/category validation group” in Record infoKey field: GroupId, NameChecked in Dynamics 365
Data entitiesProjValEmplCategoryEntityProject resource/category 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=ProjValTableEmplCategory
Integrate withProjValEmplCategoryEntity data entity Microsoft data model
Data migrationProjValEmplCategoryEntity (Project resource/category 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/category 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 definitionProjValEmplCategoryTable columns and relations Microsoft data model
Everyone

8Sources