When running Consolidate online, a handful of transactions were not reversed in our Consolidation Entity, therefore leaving duplicate transactions in some of our GL accounts.
This appears to be a for a specific group of days, ie not all transactions have been duplicated to our consolidated entity.
Through Consolidation transactions workspace, I've removed transactions for that specific company, however this has not removed the duplicate entries.
I've also re-consolidated the period in question, which doesn't remove the duplicate transactions.
Appreciate any leads on how this can be resolved.
Thanks,
Penelope
I've identified that this is a known bug within the D365 environment.
To resolve I received scripts from Microsoft to run over our database. These were loaded / run by our external D365 partner. I was then able to see the duplicate transactions in Consolidate Transactions, and was able to successfully remove them.
Best to reach out to Microsoft as soon as you become aware of the issue. They replied promptly, and we were able to resolve within 1 day.
Hi Sourav,
Below is a screen print of duplicated transactions. Note - data has been anonymised.
Thanks,
Pen
Hi PenV,
Can you please share the screen print of those duplicated entries you mentioned so that we can have a look?
Regards,
Sourav
Hi Sourav,
No, I don't have anything populated in that field in the company / entity.
How would this impact removing duplicate transactions that I'm unable to reverse from the Consolidation ledger using the build in functionality?
Thanks,
Pen
Hi PenV,
Can you check if you have set the default consolidation account in relevant main accounts in the Main accounts form?
Regards,
Sourav
André Arnaud de Cal...
292,074
Super User 2025 Season 1
Martin Dráb
230,900
Most Valuable Professional
nmaenpaa
101,156