Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Error when selecting a...
Microsoft Dynamics GP (Archived)

Error when selecting account category in row definition "The account code specified is not valid". Management reporter

(0) ShareShare
ReportReport
Posted on by Community Member

Hi All,

I am creating report based on account category, there are 2-3 categories on which system is giving error "The account code specified is not valid". I am using management reporter with GP 2013 R2. Please let me know if some one has any solution how to resolve this error or someone has encountered this error.

Thanks in advance.

Nauman

*This post is locked for comments

  • Valeria Montagut Profile Picture
    Valeria Montagut 734 on at
    RE: Error when selecting account category in row definition "The account code specified is not valid". Management reporter

    Hello Nauman and Kevin, I'm with the same trouble. I have a dimension code P&L and I tried to replace that with 'P and L' and 'PandL' but it did not work. How did you replace it? Thanks!

  • Community Member Profile Picture
    Community Member on at
    RE: Error when selecting account category in row definition "The account code specified is not valid". Management reporter

    Hi Kevin,

    Thanks for your reply. After replacing special character, my issue is resolved.

    Thanks for your help.

    Nauman

  • Verified answer
    Community Member Profile Picture
    Community Member on at
    RE: Error when selecting account category in row definition "The account code specified is not valid". Management reporter

    IF the Account Category has any special characters.  That will generate that type of message.  Check for a & sign.  Replace the & with the word and.  

  • Community Member Profile Picture
    Community Member on at
    RE: Error when selecting account category in row definition "The account code specified is not valid". Management reporter

    Can you please guide me what is the process of changing data mart to legacy system

    Thanks

    Nauman

  • Suggested answer
    soma Profile Picture
    soma 24,410 on at
    RE: Error when selecting account category in row definition "The account code specified is not valid". Management reporter

    Try to change your adapter Datamart to Legacy and check the categories in MR.

    Note: I faced same issue for one client, and changed the adapter, then it was worked.

    Hope this helps!!!

  • Community Member Profile Picture
    Community Member on at
    RE: Error when selecting account category in row definition "The account code specified is not valid". Management reporter

    Thanks for your reply.

    Actually we have migrated from FRX to MR and using data mart configuration. Migration goes successful and no error comes during migration. I am using MR CU12 and i have not changed the categories after migration.

    Any other thought for this.

    Thanks

    Nauman

  • Suggested answer
    soma Profile Picture
    soma 24,410 on at
    RE: Error when selecting account category in row definition "The account code specified is not valid". Management reporter

    When did you created that 2-3 categories? before or After MR configuration?

    What type of adapter are you using? Legacy or Data mart?

    If you using Legacy it will update immediately to MR. But, sometimes data mart wont update properly for new categories, you need to re-build.

    If your adapter is Data mart, then try to change to Legacy and check the categories in MR.

    Hope this helps!!!

  • Community Member Profile Picture
    Community Member on at
    RE: Error when selecting account category in row definition "The account code specified is not valid". Management reporter

    Hi Somakarpagamoorthy,

    Thanks for your reply.

    I newly installed management reporter on my server with GP 2013 R2. Is there anything else which i can check to resolve the issue.

    Regards,

    Nauman

  • soma Profile Picture
    soma 24,410 on at
    RE: Error when selecting account category in row definition "The account code specified is not valid". Management reporter

    Its seems like your GP is not properly synchronized with Management Reporter. Please follow the below link to re-build your management reporter and try again.

    community.dynamics.com/.../rebuilding-the-management-reporter-data-mart

    Hope this helps!!!

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,575 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,493 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans