table hierarchy inconsistency

• 11-20-2008 12:41 AM

  IamET Joined on 10-15-2008 Posts 8

  table hierarchy inconsistency Reply Contact 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

  Tags: tables, inconsistency, hierarchy

• 11-20-2008 1:54 AM

  In reply to

  Leago Katlholo Joined on 11-18-2008 Posts 2	Re: table hierarchy inconsistency Reply Contact   HI, Try this article it might help- KB 856203 (Table Hierarchy Inconsistency errors)

• 11-20-2008 7:21 AM

  In reply to

  IamET Joined on 10-15-2008 Posts 8	Re: Re: table hierarchy inconsistency Reply Contact 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

• 11-20-2008 2:14 PM

  In reply to

  David Musgrave [MSFT] Joined on 07-03-2007 Posts 116

  Re: table hierarchy inconsistency Reply Contact 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.

  Tags: Dexterity, reports

• 11-24-2008 6:46 AM

  In reply to

  IamET Joined on 10-15-2008 Posts 8

  Re: Re: table hierarchy inconsistency Reply Contact 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