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, ... / Consolidation transact...
Finance | Project Operations, Human Resources, ...
Suggested Answer

Consolidation transactions not deleting

(0) ShareShare
ReportReport
Posted on by PenV 5

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 have the same question (0)
  • Suggested answer
    SouravDam Profile Picture
    SouravDam 11,730 on at

    Hi PenV,

    Can you check if you have set the default consolidation account in relevant main accounts in the Main accounts form?

    pastedimage1673848244260v1.png

    Regards,
    Sourav

  • PenV Profile Picture
    PenV 5 on at

    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

  • Suggested answer
    SouravDam Profile Picture
    SouravDam 11,730 on at

    Hi PenV,

    Can you please share the screen print of those duplicated entries you mentioned so that we can have a look?

    Regards,
    Sourav

  • PenV Profile Picture
    PenV 5 on at

    Hi Sourav,

    Below is a screen print of duplicated transactions. Note - data has been anonymised. 

    pastedimage1673902526453v1.png

    Thanks,

    Pen

  • PenV Profile Picture
    PenV 5 on at

    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.

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!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

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

#1
André Arnaud de Calavon Profile Picture

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

#2
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 386

#3
Adis Profile Picture

Adis 259 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans