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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

Consolidation transactions not deleting

(0) ShareShare
ReportReport
Posted on by 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)
  • PenV Profile Picture
    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.

  • PenV Profile Picture
    5 on at

    Hi Sourav,

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

    pastedimage1673902526453v1.png

    Thanks,

    Pen

  • Suggested answer
    SouravDam Profile Picture
    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
    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
    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

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

News and Announcements

Season of Giving Solutions is Here!

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…

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

#1
Abhilash Warrier Profile Picture

Abhilash Warrier 867 Super User 2025 Season 2

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 514 Super User 2025 Season 2

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 348 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans