Finance | Project Operations, Human Resources, ...

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

(0) Share

Report

Posted on by YOG

414

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)

All responses (6)

Answers (0)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

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

Was this reply helpful? Yes No
YOG 414 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Junaid Idrees on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Suggested answer

André Arnaud de Cal... 301,020 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello YOG,

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

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

Best regards,

Ludwig

Was this reply helpful? Yes No
Suggested answer

MhaU on at

Like (0)

Report

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.

Was this reply helpful? Yes No