BeyondERP.Newsletter
Menu

Setup page · Project management and accounting

Project/group line properties

A setup page where you assign default line properties to projects, project groups, categories and category groups.

Used by
Project accountant, Project supervisor
Business process
Manage project financials
Menu item
ProjLinePropertySetup
Main table
ProjLinePropertySetup
Data entity
ProjectLinePropertySetupEntity
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 assign default line properties to projects, project groups, categories and category groups.
What you do hereUse this page to set which line property is filled in automatically on journal lines, so it doesn't have to be entered by hand.
ExampleFor example, BEAT sets CHARGE for the project group TM-STD and NOCHARGE for project PRJ-0077 only, so a 6.00-hour line on PRJ-0077 defaults to NOCHARGE while other TM-STD projects default to CHARGE.
Project/group line properties 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 financials
Menu pathProject management and accounting › Setup › Line properties › Project/group line properties
Set up firstLine properties Microsoft Learn Set up Project groupsSet up Line properties
Used next byHour journal Microsoft Learn
Related pagesAll projects 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.

Step by step, with screenshots

Set up Project/group line properties1 screen

Use this page to set which line property is filled in automatically on journal lines, so it doesn't have to be entered by hand.

  1. Screen 1

    Set a line property for a project group

    Go to Project management and accounting > Setup > Line properties > Project/group line properties

    1. Make sure the project group and the line property exist
    2. Select New
    3. Set Valid for to Group and select the project group
    4. Leave the category as All, or narrow it to a category or category group
    5. Select the line property
    6. Select Save
    1Project relationBEAT-PG
    Valid forGroup
    Line propertyBEAT-LP
    Set a line property for a project group (zoomed on the outlined fields)
    Show the full screenSet a line property for a project group
    page title tab to open what to set or check

Steps from Microsoft

  1. Go to Project management and accounting > Setup > Line properties > Project/group line properties.
  2. Select New and choose in Valid for whether the row is for one project (Table), a project group (Group) or all projects (All).
  3. Select the project or project group in Project relation, and the category or category group the row covers.
  4. Select the Line property to default, then add project-level rows only for the exceptions.
  5. Create an hour journal line on a project in the group and check the defaulted line property.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExampleTable column
Valid forWhether the default line property applies to a single project, a project group or all projects.Microsoft Learn Group
Project relationThe project, project group or category that the default line property is assigned to.Microsoft Learn TM-STDProjRelation
Line propertyThe line property that is applied by default.Microsoft Learn CHARGELinePropertyId

Common errors and fixes

MessageWhat to do
A journal line defaults to the wrong line property.A more specific row wins: a project row beats a group row, and a group row beats an All row. Check for a project-level row before changing the group row. Microsoft Learn

Test checklist

  1. Add a row for a project group with a Chargeable line property and a row for one project in that group with Nonchargeable.
  2. Create an hour journal line for another project in the group and check it defaults to Chargeable.
  3. Create a line for the project with its own row and check which line property defaults.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Project/group line propertiesSet a default line property for each project group, and add project-level rows only for exceptionsProject groups carry default transaction line properties, and the default is added automatically to new project lines, which minimizes repetitive entry.Where should default line properties be set?A wrong default (for example a nonchargeable property on a billable group) flows onto every new line, so the work isn't picked up for invoicing until each line is adjusted.Test: Project row wins over the group row

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: Default rows can be changed or removed at any time and apply to new lines. Posted transactions are changed only through Adjust transactions. Microsoft Learn
If you change it laterA line property set for one project wins over a group line property and over one set for all projects. Microsoft Learn
Technical architect

6Technical

Menu itemProjLinePropertySetup Checked in Dynamics 365
FormProjLinePropertySetup Checked in Dynamics 365
TableProjLinePropertySetupShown as “Line property setup” in Record infoKey field: ProjCode, ProjRelation, CategoryCode, CategoryRelationChecked in Dynamics 365
Data entitiesProjectLinePropertySetupEntityProject line properties Microsoft data model
Who can open itPrivilegesMaintain line properties ProjLinePropertyMaintainView line properties ProjLinePropertyViewDutiesInquire 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=ProjLinePropertySetup
Integrate withProjectLinePropertySetupEntity data entity Microsoft data model
Data migrationProjectLinePropertySetupEntity (Project line properties): loaded for each company, in Microsoft's default template 650 - Project accounting.Load order: Microsoft's default template 650 - Project accounting loads Project line properties at execution unit 1, level 650, sequence 30. 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 Expense management)Microsoft Learn
Table definitionProjLinePropertySetup columns and relations Microsoft data model
Everyone

8Sources