BeyondERP.Newsletter
Menu

Setup step on the Line properties page · Project management and accounting

Set up Line properties

Use this page to set whether transactions are chargeable, whether revenue is accrued and whether costs are capitalized.

Used by
Maintenance clerk, Maintenance manager, Maintenance requester and 3 more roles
Business process
Manage project financials
Menu item
ProjLineProperty
Main table
ProjLineProperty
Data entity
ProjProjectLinePropertyEntity
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 line properties, which set how hour, fee, expense and item transaction lines are posted.
What you do hereUse this page to set whether transactions are chargeable, whether revenue is accrued and whether costs are capitalized.
ExampleFor example, BEAT keeps CHARGE (Chargeable, Accrue revenue) for billable work and NOCHARGE for warranty work, so 8.00 warranty hours on PRJ-0042 never reach the invoice proposal.
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

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 Line properties1 screen

Use this page to set whether transactions are chargeable, whether revenue is accrued and whether costs are capitalized.

  1. Screen 1

    Create a line property

    Go to Project management and accounting > Setup > Line properties > Line properties

    1. Select New
    2. Enter the line property code and name
    3. Choose whether transactions are chargeable, whether revenue is accrued and whether costs are capitalized
    4. Select Save
    1Line propertyBEAT-LP
    2NameLine property
    3ChargeableYes
    4Accrue revenueYes
    5Capitalize costYes
    Create a line property (zoomed on the outlined fields)
    Show the full screenCreate a line property
    page title tab to open what to set or check

Steps from Microsoft

  1. Go to Project management and accounting > Setup > Line properties > Line properties.
  2. Select New and enter the Line property ID and Name, such as CHARGE and Chargeable.
  3. Under General, set Chargeable, Accrue revenue and Capitalize cost for the way the lines must post.
  4. Enter a Cost percentage or Sales percentage only if the line property adds a markup.
  5. Select Project/group line properties to make the line property the default for a project group.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExampleTable column
ChargeableWhether transactions with this line property are invoiced.Microsoft Learn YesToBeInvoiced
Accrue revenuePosts to accrued revenue accounts, which creates an extra accounting entry when the transaction posts.Microsoft Learn YesToBeAccrued
Capitalize costPosts the cost to WIP accounts, overriding the project group setting.Microsoft Learn YesToBeCapitalize
Cost percentageAn extra cost percentage that can be added to project hour transactions.Microsoft Learn 10.00CostMarkup
Line propertyThe unique ID of the line property.Microsoft Learn CHARGELinePropertyId
NameThe name of the line property.Microsoft Learn ChargeableName

Common errors and fixes

MessageWhat to do
Billable hours don't show on the invoice proposal.The hour line has a line property with Chargeable cleared. Check the line property defaulted from Project/group line properties and adjust the posted line with Adjust transactions. Microsoft Learn

Test checklist

  1. Create Chargeable, Nonchargeable and Internal line properties.
  2. Post an hour journal on a Time and material project with each line property.
  3. Create an invoice proposal and check only the Chargeable line is offered for invoicing.
  4. Check the Chargeable line with Accrue revenue posted an accrued revenue voucher.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Line propertiesA small standard set: Chargeable (billable, accrue revenue), Nonchargeable (not billable, no revenue, straight to P&L) and Internal (no revenue, cost can be capitalized)These are the typical line properties Microsoft describes. Line properties are defaulted onto journal, invoice and other lines, so a short clear set cuts repetitive entry.How many line properties should the company keep?Expecting Chargeable or Accrue revenue to affect fixed-price or investment projects: on those project types the line property only decides whether cost is capitalized.Test: Only chargeable lines are invoiced

Feature management and licence

Licence or add-inOn the live system, Project supervisor maintains this page and Project accountant uses it; the page is also reachable from Maintenance roles (Maintenance requester, worker, clerk and manager).

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: Line properties are copied onto lines when transactions are created, so changes affect new lines. Posted transactions keep their line property unless you adjust them.
If you change it laterOn fixed-price and investment projects, a line property only changes whether costs are capitalized. Microsoft Learn
Technical architect

6Technical

Menu itemProjLineProperty Checked in Dynamics 365
FormProjLineProperty Checked in Dynamics 365
TableProjLinePropertyShown as “Line property” in Record infoKey field: LinePropertyIdChecked in Dynamics 365
Data entitiesProjProjectLinePropertyEntityProject line property Microsoft data model
Who can open itPrivileges EntAssetMobileSetupViewMaintain line properties ProjLinePropertyMaintainView line properties ProjLinePropertyViewDutiesInquire into project accounting policies ProjProjectAccountingPolicyInquireEnable project accounting process ProjProjectAccountingProcessEnable
6 security rolesMaintenance clerk EntAssetMaintenanceClerkMaintenance manager EntAssetMaintenanceManagerMaintenance requester EntAssetMaintenanceRequesterMaintenance worker EntAssetMaintenanceWorkerProject 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 ProjProjectAccountantMaintenance requester EntAssetMaintenanceRequesterMaintenance worker EntAssetMaintenanceWorkerMaintenance clerk EntAssetMaintenanceClerkMaintenance manager EntAssetMaintenanceManagerGive people one of these roles. On this system, 6 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=ProjLineProperty
Integrate withProjProjectLinePropertyEntity data entity Microsoft data model
Data migrationProjProjectLinePropertyEntity (Project line property): loaded for each company, in Microsoft's default template 650 - Project accounting.Load order: Microsoft's default template 650 - Project accounting loads Project line property 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 definitionProjLineProperty columns and relations Microsoft data model
Everyone

8Sources