Skip to main content

MS Project client integration with AX 2012

This post covers the integration of MS Project Client with MS Dynamics AX 2012 R2 CU7.

Services setup in AX 2012

1. For the first time setup we have to deploy AifProjWBS service group from AOT in AX 2012
























Project management and accounting parameters in AX 2012

2. Setup appropriate parameter for storing MS project files. In this example I am using Archive directory other option can be Sharepoint.
3. Folder path for Microsoft Project files to sit. It can be local directory path or UNC path. Please make sure UNC path must be accessible from the user you are logged-in in AX.

















Default project categories

4. On the Journal tab of the Project management and accounting parameter screen, specifiy the default category for Hour transaction type.
Important: This is the category value that will be assigned to tasks when you sync with project file. Without this default value rows from Microsoft project file will not be imported into AX.

















Setup project in AX 2012

5. Create a new project and make sure to specify the calendar












6. Click on Open in Microsoft Project.








7. MS project file opens













Optional: You can verify this file is generated in a path which you set in step 3.

8. Add new tasks here; in this example I have added "Sales" task and select default category "Hour"












9. Click on Publish; you will be notified by three options
  •     Publish New Project: You have to provide Project ID which will be imported into AX on sync
  •     Replace Existing Project: Be careful in selecting this option as it does exactly what it says. It REPLACES all activities in AX
  •     Save a template: This will create a new project template
10. On successful sync it will create/update the work breakdown structure for a project in AX 2012











11. You will notice yellow bar on top on WBS indicating that WBS is linked with MS project client and cannot be modified from AX client. 
12. At the same time you can see another button "Unlink from Microsoft Project" is enable which will allow you to edit your WBS in AX but this will break the link between AX and the project file generated.
Labels:

Comments

  1. AnonymousMay 11, 2015 at 8:43 PM

    I think the things you covered through the post are quiet impressive, good job and great efforts. I found it very interesting and enjoyed reading all of it.
    Microsoft Dynamics CRM Online Training | Microsoft Dynamics AX Training

    ReplyDelete

Post a Comment

I will appreciate your comments !

Popular posts from this blog

The Dual Write implementation - Part 1 - Understand and Setup

What is Dual-write? Tightly couples – complete at one transaction level Near real time Bi-directional Master data and business documents – Customer records you are creating and modifying and at this document we are talking about sales orders or quotes and invoice. Master data could be reference data e.g. customer groups and tax information Why Dual-write and why not Data Integrator? Data Integrator is Manual or Scheduled One directional Now, Let's deep dive and understand what is required for Dual-write setup and from where to start. First thing first, check you have access to https://make.powerapps.com/ Choose right environment of CDS (CE) Make sure you have access to the environment too, click on gear icon and Admin Center  Look for required environment and Open it, you must have access as going forward you are going to configure dual write steps in the environment user the same user you are logged in now. Now, go back to power platform admin center and...
55 comments
Read more

D365FO: Entity cannot be deleted while dependent Entities for a processing group exist. Delete dependent Entities for a processing group and try again.

Scenario: There are times when you want to delete an entity from target entity list and when you do so, you face an error message which does not tell you where exactly the entity has been used.  "Entity cannot be deleted while dependent Entities for the processing group exist. Delete dependent Entities for a processing group and try again. " Solution: Browse the environment by appending this part  /?mi=SysTableBrowser&TableName=DMFDefinitionGroupEntity&cmp=USMF   at the end.  For example; if the environment URL is  https://daxture.sandbox.operations.dynamics.com then the complete URL will be https://daxture.sandbox.operations.dynamics.com/?mi=SysTableBrowser&TableName=DMFDefinitionGroupEntity&cmp=USMF Filter for Entity and it will give you the DefinitionGroup where the entity has been added or used in data management import/export projects. Get the DefinitionGroup name and search in the export/import projects under data management and either del...
4 comments
Read more

Dual-write connection set error: An item with the same key has already been added

If you happen to see this error message then you have duplicate records in cdm_company entity in CDS environment. Check for cdm_companycode field this is normally not allowed but have a look and delete the ones with duplicates.
1 comment
Read more