Skip to main content

Notifications

Announcements

Share Your Journey with Power Pages and Help Shape Its Future!
News and Announcements icon
Dynamics 365 Community / Forums / Business Central forum / Consolidation snapshot
Business Central forum
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:
Administration and permissions
Other
Financial Management
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 22,129 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 22,129 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. 1,604 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

News and Announcements

Share Your Journey with Power Pages and Help Shape Its Future!

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

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

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

more Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,522 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,441 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans