Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Consolidation snapshot
Small and medium business | Business Central, N...
Answered

Consolidation snapshot

(1) ShareShare
ReportReport
Posted on by Ross Bateman 7
Hello
When running the consolidation on a monthly basis it gets rid of the last month's consolidation postings. For example, if the consolidations were run for Jan-June, the previous month's posting in May for Jan-May would be removed.
 
My question is, is it possible for these postings not to be removed and instead reversed in the following month once the new consolidation is run? For example, the Jan-May consolidation would be posted on 31/05/24 and reversed on 01/06/24. This way all the historical figures would be snapshotted on the system, which is what I want from reporting.
 
Thanks in advance,
Ross
Categories:
Business Central
Business Central
Business Central
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 24,816 Super User 2024 Season 2 on at
    Consolidation snapshot
    Typically you would only run consolidations monthly, this way you have your numbers for each month. Is there a reason you run it YTD?
     
  • Ross Bateman Profile Picture
    Ross Bateman 7 on at
    Consolidation snapshot
    Valentin, thanks for your reply. Do you know of a way around this, such as manually posting the same journal that the consolidation creates and then manually reversing at a later date?
     
    Thanks
  • Verified answer
    Valentin Castravet Profile Picture
    Valentin Castravet 24,816 Super User 2024 Season 2 on at
    Consolidation snapshot
    No it's not possible out of the box. When you run a consolidation for a date range that's already been run, the system zeros out the previous run.
     
  • Ross Bateman Profile Picture
    Ross Bateman 7 on at
    Consolidation snapshot
    Hi Khushbu,
    The entries will be posted automatically as part of the consolidation functionality and will be removed automatically once the year-to-date consolidation is run in the following month. 
     
    I'm trying to discover if there is a way for the original posting not to be removed so it can then be reversed with a different timing.
  • Khushbu Rajvi. Profile Picture
    Khushbu Rajvi. 4,598 on at
    Consolidation snapshot
    As per my knowledge. Yes, it is possible to reverse (Manual) entries for past consolidations if you want to preserve historical data while updating for new consolidations. Standard functionality does not automatically handle the reversal of previous month’s consolidation postings.

     

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans