Data import related error when importing Project work breakdown structure – Draft entity in Dynamics 365 For Finance and Operations

Data import related error when importing Project work breakdown structure – Draft entity in Dynamics 365 For Finance and Operations

Here is a quick tip for an error related to data import of Project work breakdown structure – Draft entity using the Data Management framework  in Dynamics 365 For Finance and Operations.

If you are trying to import the Project work breakdown structure – Draft entity(ProjProjectWBSDraftEntity) and you are getting the error below, then follow the steps below to get around this issue.

Results. Field ‘Project category’ must be filled in.
Results. Matching record for the read only data source ‘ProjPlanVersionDetail’ does not exist

WBS Draft Import Error

Steps to Work around this error:

  1. Navigate to Project Management and Accounting > Setup > Projects > Work breakdown structure templates.
  2. Create  a new record
  3. Enter a  Name and Description
  4. Make sure the Active checkbox is marked.
  5. Click OK.
  6. That’s it. You do not need to create the details under the WBS template.

WBS Template

With this default WBS template record in place, if you try to import the roject work breakdown structure – Draft entity, system will import the data just fine.

NOTE: This is an issue in the July 2017 release with Platform update 12 and I have not validated this in the Spring release yet. To me, it looks like a glitch/bug in the DMF entity that needs to be reported to Microsoft. But i just wanted to share this info in case any of you are dealing with this issue and trying to find a solution.

Regards,

Sandeep

Advertisements

The Work breakdown Structure(WBS) functionality for Projects in Microsoft Dynamics AX 2012:

Dear Readers,

In today’s post, let us explore the new work breakdown structure functionality for Projects in Microsoft dynamics AX 2012.

Looking for a better ERP for your organization ? Click here

Every professional services organization in today’s competitive world of business, wants to be more accurate in terms of managing each descending level of activities/tasks in the projects they carry out, to manage the costs and revenue efficiently and become more profitable. Breaking down the individual tasks and activities on projects and tracking costs, revenues, managing resources at each task level etc. helps in this.

The work breakdown structure of dynamics AX 2012 is a hierarchical representation of the activities  and child activities in a project and helps the project managers to do the following.

  • Define the overall work scope of the projects.
  • Each descending level of the hierarchy represents increasingly detailed information about the project work.
  • It helps identifying and creating milestones in the project.
  • It also helps managers to soft/hard commit resources to the activities/tasks.
  • Project managers can create WBS templates and use them any time they want to plan a new project. They can also create the WBS directly on a project.

Let us first learn how we can view and create the work breakdown structure template for our organization. The following steps will depict the steps to create new WBS template.

  1. Navigate to Project Management and Accounting > Common > Activities > Work breakdown structure template.
  2. Click New > New work breakdown structure template.

image

image

3. On the Work breakdown structure details screen, click “New” button to create the hierarchy of activities/tasks in the project.

4. Create Planning as the new activity and click New button again by keeping the focus on this activity. Provide activity name, it’s priority and a brief description about it in the designated fields.

image

5. On the right hand side, expand the various fast tabs to fill in information about this activity. Expand  the Schedule tab and key in the Duration in days, effort in hours, a default category etc. as shown as an example in the screen above.

6. Expand the Activity requirements tab and setup the resource requirements for this activity in terms of Education, skills, certification, experience etc. This information can be used if you want to make use of the resource scheduling functionality of AX 2012.

7. Setup the estimated costs and revenues for this activity by creating new records under this tab.

image

8. Similarly, complete the end to end hierarchy for this WBS template and setup the above explained parameters for each of the activities/tasks.

9. Now that we have created and setup a template for a software development project, let us create a new project and try to use this template in the project to define the task hierarchy for this.

10. For this, create the new project and click Plan tab > Work breakdown structure. Click Copy from button. System will show all the available templates in the system. Select the template and click Ok button.

image

11. System will then load the activity hierarchy structure for the project which you can modify as the current project needs. For example you may wish to assign different resources to the activities and the cost and revenue estimates may be different for this project.

The project manager can also carry out the resource assignment task from the WBS screen and by clicking the Assign resources button.

The project managers can also make use of the WBS right from the project quotations level which will help them in automating most of the project planning tasks such as WBS management, budgeting, resource assignments etc.

Please feel free to ask any queries you have regarding the WBS management for projects in AX 2012 and I will be happy to answer.

Thanks

Keep DAXING Smile