Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

Project CategoryID/CategoryName Not Being Displayed

Posted on by 680

Hi,

I recently created a new project category in Proj Mngt & Acct.  Problem I'm having is that I can view the corresponding Shared Category under Shared Categories but cannot see the Project Category in the list under Project Categories.   When I try to create it again, i get the error message: "The record cannot be created because it already exists in either the Project accounting, Expense management, or Production application."

I did a lookup in the ProjCategoy table but the entry does not exists there.  I also searched the Category table but still to no avail.   Can anyone point me in the right direction to getting passed this.  Is there any other table in the DB where this entry is created.  

Thanks

*This post is locked for comments

  • Junaid Idrees Profile Picture
    Junaid Idrees 12,746 on at
    RE: Project CategoryID/CategoryName Not Being Displayed

    Hi CuongNguyen ,

    It's a very old thread. Do you mind to create new one to let community help you out. Thanks.

  • CuongNguyen Profile Picture
    CuongNguyen 5 on at
    RE: Project CategoryID/CategoryName Not Being Displayed

    Would you mind showing me more details about your solution. Thank you a lot!

  • Lina Balande Profile Picture
    Lina Balande on at
    RE: Project CategoryID/CategoryName Not Being Displayed

    I have cleared user usage data and project categories appeared in the Project Category form.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Project CategoryID/CategoryName Not Being Displayed

    I had exactly the same problem as described above.   However, no amount of playing, recreating data helped in my instance.  Here is my problem, play-by-play:

    1. Opened Project Categories form (ProjCategory)
    2. Right click over Category ID, select View Details --> Shared Categories form opens
    3. Added shared category "Marketing" into Shared Categories, and marked for "Can be used in Project"
    4. Hit Close on Shared Categories form
    5. Hit F5 to refresh Project Categories form
    6. The drop down list shows "Marketing" and I add the record
    7. Close on Project Categories form    ****NOW, at this point you should think "Marketing" should appear in Project Categories
    8. Open Project Categories form ---> There is no "Marketing" item
    9. "Marketing" is not in the dropdown list, but I add it anyway.  
    10. Clicking out of the record gives me "The record cannot be created because it already exists in either the Project accounting, Expense management, or Production application."

    Here was my SOLUTION:

    1. Open the dbo.PROJCATEGORY table (via SSMS) -- note there is no record for "Marketing"
    2. Manually insert a record for "Marketing" using a negative RECID and default values
      • we are planning to delete this record and re-create the real one, so negative RECID's should not be tied to anything real, at least in my DB
    3. In the AX client, open the Project Categories form -- note the record for "Marketing" appears!....but I can't trust this record, call me paranoid.
    4. Delete the record through the AX client, as normal.
    5. Re-create the "Marketing" record.   Now it sticks!   

    Why I had to go through this doesn't make sense.   Perhaps the client didn't like me adding the shared category with the Project Categories form open.   Maybe this helps someone.   

  • Nemesis Profile Picture
    Nemesis 680 on at
    RE: Project CategoryID/CategoryName Not Being Displayed

    Weirdest thing. I went back to play with this some more and I recreated everything and it was there.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Project CategoryID/CategoryName Not Being Displayed

    Have you made sure the shared categories entry includes check/enabled "used in project"? I've stumbled over this a few times myself, very confusing to have so many different entry points in the various modules, having to first define them as a common "shared" category, then as a module-specific category, then further check-enabling from one module to allow it to be used in another module.

  • Nemesis Profile Picture
    Nemesis 680 on at
    RE: Project CategoryID/CategoryName Not Being Displayed

    Baber,

    With regard to 1)...........this is correct.  2) .........this is correct as well, however the CategoryID is not in the CategoryTable.  3)  Still not seeing it in there.  This is weird.

  • Suggested answer
    syed baber Profile Picture
    syed baber 11,627 on at
    RE: Project CategoryID/CategoryName Not Being Displayed

    Hi Nemesis,

    Please check the following:

    1) You said, you created a category in SharedCategories form. As a result of this, the record should get created in SharedCategory table.

    2) The drop down for Category ID shows the record from CategoryTable table for which there is no categoryId matching with CategoryId in SharedCategory (Not exists Join). Make sure that the category Id you created does not exist in CategoryTable table.

    3) Now if you open the Project categories form, you should see the new category Id in drop down, you can select it and should be able to save the record.

    Please verify and let me know how it goes.

    Thanks,

    Baber.

  • Nemesis Profile Picture
    Nemesis 680 on at
    RE: Project CategoryID/CategoryName Not Being Displayed

    Hi Baber Owais,

    Thing is, I created it first in the Shared Categories form.  Actually, AX would not allow me to create it in the Project Categories form without it first being created in Shared Categories.  And I went through the process of selecting it in the drop down of the Proj Cat form.  

    It's just that....... Its not in the proj. cat.  list and AX is telling me that it already exists, yet its not visible in UI nor in the ProjCategory table.

  • Suggested answer
    syed baber Profile Picture
    syed baber 11,627 on at
    RE: Project CategoryID/CategoryName Not Being Displayed

    Hi Nemesis,

    Where you have created the project category? You need to create a project category first in Shared categories form and then it should be visible in the drop down of CategoryID on Project categories form. I just tried in AX 2012 R2 environment and it worked. Please take a look at below post related to this:

    sandeepchaudhury.wordpress.com/.../quick-tip-about-shared-categories-in-microsoft-dynamics-ax-2012

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans