web
You’re offline. This is a read only version of the page.
close
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) / table hierarchy incons...
Microsoft Dynamics GP (Archived)

table hierarchy inconsistency

(0) ShareShare
ReportReport
Posted on by Community Member

hi,

I used Dexterity to make some new forms, tables, reports etc in dynamics.dic.  Everything was working fine and still works in dexterity runtime but when i create the chunk and put it in GP I get table inconsistency error. I am pretty sure i didn't change any of the relationships between tables exept that i added a new relationship between one of my tables and Item Master. Also one more thing that looks weird, if I go to report writer for that chunk and open tables I get different names for 2 of my tables (names i used before but later changed them) and 2 others are listed as table not found, but the program is using them fine.  I deleted the tables and stored procedures created by the chunk and re-installed it but still i get the same thing.

thanks in advance

*This post is locked for comments

I have the same question (0)
  • Leago Katlholo Profile Picture
    Leago Katlholo 35 on at

     

    HI, Try this article it might help- KB 856203 (Table Hierarchy Inconsistency errors)
  • Community Member Profile Picture
    Community Member on at

    actually the tables that I created and cannot be found are not even used in the reports but only on lookup forms, so they shouldnt affect the tables or be added to the reports etc. I am using the dynamics.dic so all other relationships between tables should be there

     

  • winthropdc Profile Picture
    winthropdc on at

    I believe you are receiving the errors because of the cause described in the KB article I wrote: 

     Information about table hierarchy inconsistency errors in Dexterity in Microsoft Dynamics GP

     https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?scid=kb;en-us;921637

    David Musgrave [MSFT]
    Escalation Engineer - Microsoft Dynamics GP
    Microsoft Dynamics Support - Asia Pacific

    Microsoft Dynamics (formerly Microsoft Business Solutions)
    http://www.microsoft.com/Dynamics

    mailto:David.Musgrave@online.microsoft.com
    http://blogs.msdn.com/DevelopingForDynamicsGP

    Any views contained within are my personal views and not necessarily Microsoft policy.
    This posting is provided "AS IS" with no warranties, and confers no rights. 

  • Community Member Profile Picture
    Community Member on at

    It looks like i had added a relationship on IV_Item_MSTR that i completely forgot about. Don't know whether I should add the relationship through report writer since it is between existing GP tables and not tables of my own ( I don't want to mess the GP tables). In any case I removed the table from my report and everything works fine

     thanks for helping out

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Hi IAMET,

    Please dont make custom relationship in standard dynamics dictionary. mostly it runs in dexterity runtime. while deploying the chunk it results as hierarchy inconsistency error.

    use custom RW_function to add the external table field values.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans