web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Unable to turn off ...
Finance | Project Operations, Human Resources, ...
Suggested Answer

Unable to turn off 'Use for Financial consolidation process' button

(0) ShareShare
ReportReport
Posted on by YOG 420

Hi All,

we are getting below error posing invoice journal.

'It is not possible to post to the consolidated company account XXX'

I ran 'Clean ledger entries' cleanup job but still getting this error.

please can you advise.

I have the same question (0)
  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi YOG,

    You cannot create a posting manually in a consolidation company.

    If you need to post transactions at the consolidation level then you need to setup an additional 'dummy' company that you can then use for a second consolidation step where you consolidate the adjustments posted with the results from the first consolidation.

    (In my home country we use the term 'tree' based consolidation that Dynamics supports because you might need multiple 'branches', i.e. dummy companies for your consolidation)

    Best regards,

    Ludwig

  • YOG Profile Picture
    YOG 420 on at

    Hi Ludwig,

    i do not want this company to combine financial data. we had this option ticked and now missed to turn off. this is in our UAT environment

  • Suggested answer
    Junaid Idrees Profile Picture
    Junaid Idrees on at

    Hi YOG,

    What i understand from issue that you created a legal entity and mistakenly turn it on "Use for Financial consolidation process" option on Legal entity screen. And when you are trying to post invoice journal and selecting offset account as ledger or bank then system is not allowing you to proceed.

    The ledger account that you are trying to select in your invoice journal, Did you selected any default consolidaiton account for that ledger account in Chart of account screen?

    703454.PNG

  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 304,348 Super User 2026 Season 1 on at

    Hi YOG,

    On the legal entities form, you have to disable the option for consolidation purposes. You can only do this when you don't have ledger transactions for this legal entity. The clean-up job you mentioned is not deleting the ledger transactions; only the journal entries.

    As it is not a production environment, you can use the class SysDataBaseTransDelete to delete all data from this legal entity. Note that it will delete really all table contents. Or you can write a customer runnable class to delete the accounting entries and other transactions. Then you are able to disable the legal entity as consolidation company.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hello YOG, 

    I can activate and deactivate the parameter as I want in a 'fresh' environment. 

    fincon.png

    Is it possible that your user does not have sufficient user rights?

    Best regards, 

    Ludwig

  • Suggested answer
    MhaU Profile Picture
    MhaU Microsoft Employee on at

    Dear YOG

    Thank you for posting this issue to our community.

    The clean ledger entries will not clear the generaljournalentry/generaljournalaccountentry records if those exist for your legal entity. Was this legal entity ever used for consolidations? Do you have any data in generaljournalentry/generaljournalaccountentry for this legal entity? 

    As I understand from above the legal entity was set for consolidation then you switch this off and now you are trying to post an invoice journal receiving error 

    'It is not possible to post to the consolidated company account XXX'

    Can you please run this query and confirm that what you see in the form (control for consolidation switched off) is the same what it is in the database

    select * from OMLEGALENTITY where LegalEntityID='XXXX'

    Check the values for UseForFinancialConsolidationProcess and UseForFinancialEliminationProcess. If switched off, both should be zero.

    Looking forward for your next update.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 699

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 548 Super User 2026 Season 1

#3
CP04-islander Profile Picture

CP04-islander 301

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP
License usage reporting (in-app and PPAC) with Entra dynamic groups

Product updates

Dynamics 365 release plans