Skip to main content

Notifications

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

  • PenV Profile Picture
    PenV 5 on at
    RE: Consolidation transactions not deleting

    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
    PenV 5 on at
    RE: Consolidation transactions not deleting

    Hi Sourav,

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

    pastedimage1673902526453v1.png

    Thanks,

    Pen

  • Suggested answer
    SouravDam Profile Picture
    SouravDam 11,723 on at
    RE: Consolidation transactions not deleting

    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
    RE: Consolidation transactions not deleting

    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,723 on at
    RE: Consolidation transactions not deleting

    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

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,074 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,900 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans