Dynamics Community Forum Thread Details

Asset managment module hour journal cost rpice not populating

To ensure the cost (amount) is displayed correctly in the Work Order journal for hours in the Asset Management Module of Dynamics 365 Finance, you need to configure several settings related to resources and project categories:

Resource Setup:

Go to Organization Management > Resources > Resources tab.
Create and define resources and their types here. Only resources of type "Human Resource" will appear in the list for work order journals.
Cost Price Configuration:

Set the cost price for the project category in Project Management and Accounting > Settings > Price > Cost Price.
You can also configure the journal and hour utilization in Project Management and Accounting > Settings > Project Management and Accounting Parameters.
The cost price defined for the project category will affect the amount shown in the last column of the journal.
Resource List and Price Information:

Define the list and price information in Project Management and Accounting > Project resources > Resources list.
Set up prices for hours in Project Management and Accounting > Setup > Prices > Cost price (hour) & Sales price (hour).
Work Order Job Project Setup:

When you create a work order job, the work order project is determined by the setup of the parent project for work orders.
This is configured in Asset Management > Setup > Work orders > Project setup.
The project ID and related activity number are used to track costs related to the work order job and the selected asset.
Note:
If you have multiple work order job lines and the price is not refreshing automatically when updating hours, you may need to click on a field in the same line (such as line property, category, resource, or work order job) to trigger the amount to refresh. This is a known behavior in the system1.

By ensuring these configurations are set up, the cost (amount) should display correctly in the Work Order journal for hours in Asset Management

Categories:

Dynamics 365 Project Operations

Dynamics 365 Human Resources

Microsoft Dynamics AX

Dynamics 365 Finance

Hi CU-09010607-0,

1) Issue
In Dynamics 365 Finance (Asset Management module), the cost (amount) for hours in the Work Order journal is not displaying correctly or is missing.

The requirement is to ensure that the correct cost value is calculated and reflected when posting hour transactions in Work Order journals.

2) Reason
The Work Order journal in Asset Management relies on the Project Accounting framework for cost calculation.
The amount shown for hour transactions is derived from:
- Project category cost price
- Resource configuration
- Project and work order setup

If any of these configurations are incomplete or inconsistent, the system cannot calculate the correct cost.

Typical root causes:
A) Missing or incorrect resource setup
- Only resources linked to Human Resource type are considered
- Missing or incorrect resource assignments result in missing cost values

B) Missing cost price setup
- Cost is derived from:
~ Project Management and Accounting > Cost price

- If no cost price exists for:
- Category
- Resource
- Legal entity

→ The system cannot calculate the amount

C) Project category linkage
- Work order journals use:
- Project categories mapped via project setup

- If category is missing or misconfigured:
→ No cost is calculated

D) Work order project configuration
- Asset Management uses a project integration model
- Work order jobs post to:
- A project defined in:
~ Asset Management > Setup > Work orders > Project setup

- Incorrect setup leads to:
- Missing category/resource mappings
- Incorrect cost derivation

E) UI refresh limitation (known behavior)
- Amount fields may not update automatically when:
- Hours are entered or modified

- The system recalculates cost only when:
- Another field is changed (resource, category, line property, etc.)

3) Resolution
Step 1: Validate resource setup
- Navigate to:
~ Organization Administration > Resources

- Ensure:
- Resource exists
- Resource type = Human Resource
- Resource is linked to worker

Step 2: Configure cost prices
- Navigate to:
~ Project Management and Accounting > Setup > Prices > Cost price

- Define:
- Cost per hour
- By:
- Category
- Resource (if applicable)
- Legal entity

Step 3: Verify project category
- Ensure:
- Category is assigned in Work Order journal line
- Category has cost price defined

Step 4: Validate project setup for work orders
- Navigate to:
~ Asset Management > Setup > Work orders > Project setup

- Verify:
- Project ID
- Activity number
- Category mappings

Step 5: Check resource price setup (optional but recommended)
- Navigate to:
~ Project Management and Accounting > Project resources > Resource list

- Confirm:
- Resource is included
- Price setup is correct

Step 6: Trigger recalculation
- After entering hours:
- Modify another field (e.g., category or resource)
- Or reselect the same value

This forces the system to recalculate the cost amount

Optional: Validate parameters
- Navigate to:
~ Project Management and Accounting > Parameters

- Confirm:
- Hour journal setup
- Cost price usage settings

---

Summary

The cost in Work Order journals for hours is calculated via Project Accounting using:
- Resource (Human Resource type)
- Project category cost price
- Work order project configuration

If any of these elements are missing or misconfigured, the cost will not display correctly.

Additionally, the UI may require manual interaction to refresh the calculated amount, which is a known system behavior.

For a more detailed answer, please provide more information.

Rg,

Alexander

*Due to the complex and different possibilities of deploying Dynamics 365 I highly recommend not to setup the application without some expert/partner or support. (For more information contact me under anassl@inno-solutions.info or visit www.inno-solutions.de)

*The Information comes directly from the manufacturer or provider and are validated (not guaranteed) up to date of creation of the posting.

References: