How to add a new custom field in EPM which is integrated with Dyna

[jahandad]

How to add a new custom field in EPM which is also integrated with Dynamics
AX. Has anyone done it before ? please give me some direction on it.

 

[Rod Gill]

This can be done, but you will need customization to do it.

--

Rod Gill
Microsoft MVP for Project - http://www.project-systems.co.nz

Author of the only book on Project VBA, see: http://www.projectvbabook.com

How to add a new custom field in EPM which is also integrated with
Dynamics
AX. Has anyone done it before ? please give me some direction on it.

__________ Information from ESET Smart Security, version of virus
signature database 4780 (20100117) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 4780 (20100117) __________

The message was checked by ESET Smart Security.

http://www.eset.com

 

[jahandad]

Thanks for the reply Rod. Can you please tell me in detail because i have
tried to do this but no success.

I did following steps
I added a case in sysSetup: buildIntegratedfields() method of Dynamics AX
just like other integrated fields.
Manually added a row of it in projectServer Reporting table ->
DAXIntegratedfields table.
Manually added a row in Dynamcis AX table syncIntegratedField.
Added a case in ProjServerRefresh > buildAllHierarchy*() and
buildHierarchy*() methods.

But when i try to sync from AX to EPM it failed with following error

---ERROR MESSAGE---
An error occurred while synchronizing Project entity type of Name:"EPM Test"

---MORE DETAILS---
An error occurred while refreshing the Project compound entity of
EntityID:a6a4e849-6840-4cc4-99fc-5234f6a640b7, Name:"EPM Test" in project
server.
Guid should contain 32 digits with 4 dashes
(xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx).

Am i missing any step? and also what type of modification is required in
which classe to sync from EPM to AX b/c this modification will work only for
AX ->EPM.

Kindly reply to this thread atleast what you think. May be your response
give me some direction on it. Its really urgent and important.

Awaiting for your response.

 

[Gary Chefetz]

jahandad:

I do not have your answer for you, but it sounds like you're using a
third-party solution between Dynamics and Project Server, or perhaps working
with a starter solution of some sort. If so, you should specify that in your
post and tell people what all the moving parts are. If this is the case, it
makes a very big difference and you might be better off asking the people
who wrote the solution these questions.

 

[jahandad]

Dear Gary, I am not using any third party solution. I just want to add a
custom field in EPM which is also integrated with Dynamics Ax. I need to
perform certain action in Dynamics Ax based on this value. I have seen many
fields which are integrated just wanted to add a new integrated field for my
work.
Hope this will make the scenario clear. Kindly let me know if you need to
know any thing else in this regards by which i may got my answer.

 

[Gary Chefetz]

Depending on what you want to accomplish with field determines your
integration path. Extending the Project Server RDB doesn't give you much. I
think you want to write some code that synchronizes the value from a field
in Dynamics AX to a custom enterprise field in Project Server. If you're
lucky, maybe someone on the NG has nothing to do and will write the complete
solution for you, but normally people ask more specific questions like I'm
having a problem with this piece of the code, and post a code sample for
guidance. I think you need to get a little closer to a working solution.