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 AX (Archived) / 'IsConsolidationCo...
Microsoft Dynamics AX (Archived)

'IsConsolidationCompany' in table 'CompanyInfo' has not been explicitly selected

(0) ShareShare
ReportReport
Posted on by ninzer 650

I am getting this error when I try to post the AP invoice journal 

Stack trace: Field 'IsConsolidationCompany' in table 'CompanyInfo' has not been explicitly selected.

Stack trace

(S)\Data Dictionary\Tables\CompanyInfo\Methods\isConsolidationCompany - line 17
(S)\Classes\LedgerJournalTransUpdate\checkConsolidation - line 16
(S)\Classes\LedgerJournalTransUpdate\check - line 16
(S)\Classes\LedgerJournalTransUpdateLedger\check - line 14
(S)\Classes\LedgerJournalTransUpdate\ledgerVoucherCheck - line 67
(S)\Classes\LedgerJournalCheckPost\checkJournal - line 382
(S)\Classes\LedgerJournalCheckPost\run - line 142
(C)\Classes\LedgerJournalCheck\main - line 49
(C)\Classes\FormFunctionButtonControl\Clicked
(C)\Forms\LedgerJournalTransVendInvoice\Designs\DesignList\CheckJournal\Methods\Clicked - line 3

*This post is locked for comments

I have the same question (0)
  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 301,075 Super User 2025 Season 2 on at

    Hi Ninzer,

    Can you check the contents of the table CompanyInfo by opening the table browser from the AOT?

    Check if the field contains a checkbox or if it sais 'Unretrieved'.

    When it is unretrieved, you have to correct the data. I have done that before by opening the table DirPartyTable using SQL management studio and search for the records related to the legal entities. When the value is 'NULL' you have to make it {empty} or fill a value 0. This depends on the field type. The field IsConsolidation account should be filled with a zero.

    For more info and a possible SQL script, have a look at the blog from my collegue: www.axstart.com/unretrieved-values-on-the-companyinfo-table-in-ax-2012r2

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    I think that you have some setup issue.

    Please follow following links for more details and validate if you have valid setups

    technet.microsoft.com/.../gg231815.aspx

    Please verify and let us know your findings

  • Community Member Profile Picture
    Community Member on at

    Hi,

    I totally agree with Andre. Your case looks exactly as the one described in "solution 705138" on the LCS portal.

    In a few words - it happens if the legal entity has been created with "Consolidations" configuration key turned off but later the key was turned on. Workaround recommend by Andre is the easiest way to fix this issue.

  • Verified answer
    ninzer Profile Picture
    ninzer 650 on at

    I just updated the Dirparty table with this field to 0 instead of null that solved it.   Thanks andre for confirming this. appreciate it. 

  • munafkhatib Profile Picture
    munafkhatib 1,295 on at

    Thanks Andre for you solution.It helped.

  • Community Member Profile Picture
    Community Member on at

    Hello Andrew,

    I am also getting same errors when I try to post the Payment journal or JV.

    Stack trace: Field 'IsConsolidationCompany' in table 'CompanyInfo' has not been explicitly selected.

    Stack trace

    (S)\Data Dictionary\Tables\CompanyInfo\Methods\isConsolidationCompany - line 17
    (S)\Classes\LedgerJournalTransUpdate\checkConsolidation - line 35
    (S)\Classes\LedgerJournalTransUpdate\checkWhenPost - line 30
    (S)\Classes\LedgerJournalTransUpdateBank\checkWhenPost - line 10
    (S)\Classes\LedgerJournalCheckPost\postTrans - line 210
    (S)\Classes\LedgerJournalCheckPost\postJournal - line 907
    (S)\Classes\LedgerJournalCheckPost\run - line 155
    (S)\Classes\LedgerJournalPost\post - line 148
    (C)\Classes\LedgerJournalPost\main - line 26
    (C)\Classes\FormFunctionButtonControl\Clicked
    (C)\Forms\LedgerJournalTransDaily\Designs\DesignList\PostJournal\Methods\Clicked - line 7

    As suggested by you, I have seen table CompanyInfo and found that there is "Unretrieved" Value. I went to second table DirPartyTable but didn't found any value of Null. How to fix the issue. Please help.

    Many thanks in advance for your support.

    Munesh

  • Community Member Profile Picture
    Community Member on at

    Hi André,

    Thanks for your answers that solve many issues.

    But currently in AX 2012 R3 CU12, I am not able to find this field in DirPartyTable.

    Then how can I modify the value of this field?

    Thanks and kind regards,

    Josep

  • _MGP Profile Picture
    _MGP 506 on at

    Hi JosepCanet,
    I'm running CU12 also and have just fixed this.
    You won't be able to see these fields in the AOT but you need to go into SQL Mgt Studio and make the change there.

    Here is my script that I used but you may wish to check over any fields that already have values:

    UPDATE dpt
SET  
	   [VATNUM] = ''
      ,[IMPORTVATNUM] = ''
      ,[INTRASTATCODE] = ''
      ,[PACKMATERIALFEELICENSENUM] = ''
      ,[ISCONSOLIDATIONCOMPANY] = 0
      ,[ISELIMINATIONCOMPANY] = 0
      ,[ACCOUNTINGPERSONNEL_JP] = ''
      ,[COMPANYREPRESENTATIVE_JP] = ''
      ,[TAXAUTHORITY_RU] = ''
      ,[OMOPERATINGUNITTYPE] = 0
      ,[HCMWORKER] = 0
      ,[OMOPERATINGUNITNUMBER] = ''
      ,[INITIALS] = ''
      ,[CHILDRENNAMES] = ''
      ,[MARITALSTATUS] = 0
      ,[HOBBIES] = ''
      ,[GENDER] = 0
      ,[NAMESEQUENCE] = 0
      ,[PHONETICFIRSTNAME] = ''
      ,[PHONETICMIDDLENAME] = ''
      ,[PHONETICLASTNAME] = ''
      ,[PERSONALTITLE] = 0
      ,[PERSONALSUFFIX] = 0
      ,[PROFESSIONALTITLE] = ''
      ,[PROFESSIONALSUFFIX] = ''
      ,[BIRTHMONTH] = 0
      ,[BIRTHDAY] = 0
      ,[BIRTHYEAR] = 0
      ,[ANNIVERSARYMONTH] = 0
      ,[ANNIVERSARYDAY] = 0
      ,[ANNIVERSARYYEAR] = 0
      ,[COMMUNICATORSIGNIN] = 0
      ,[NUMBEROFEMPLOYEES] = 0
      ,[ORGNUMBER] = ''
      ,[ABC] = 0
      ,[TEAMMEMBERSHIPCRITERION] = 0
      ,[DESCRIPTION] = ''
      ,[ISACTIVE] = 0
      ,[TEAMADMINISTRATOR] = ''

  FROM [dbo].[DIRPARTYTABLE] as dpt
  where [DATAAREA] = 'yourcompany'


  • Community Member Profile Picture
    Community Member on at

    Thanks so much!.

    I really appreciate your post with this script!!

    Josep

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 AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans