How can I clear Consolidations/Reset balances for just the one month

SUGGESTED

Lomg story short, I am still learning Sage 200 c Professional, in Jun I ran Consolidations for the first half of the year under one route, (using a certain Exchange rate that had been advised checked and all great.

Ran it the same way for July. and found it doesn't match, only to find the rate from July had been changed without me knowing. So now I have incorrect/non-matching values from the workbooks of my colleagues to sage. 

The question mainly is, is there a way to just clear the consolidations / Reset the values for July, so that I do not have to clear every single entry and start the whole lengthy process all over again. (To put in time and size, I have about 15 companies that get consolidated)

This really is such a nuisance if there is no other way other than clearing ALL consolidations. 

  • 0
    SUGGESTED

    Morning Steve. Moderating Sage City, I can see your post has not been replied to yet. Please accept our apologies for the delay.

    It's not possible to clear the consolidated amounts / reset nominal balances for just one month. When consolidated amounts are cleared from the subsidiary company, the next time consolidation is run, the entire trial balance will get posted to the parent company up to the month chosen.

    With regards to running the Zero Balances routine, you do have the ability to reset the balances for an individual Cost Centre so, if each subsidiary posts its consolidated values to its own Cost Centre in the parent company, you can effectively run this process on just one company's Cost Centre so that you won't then need to re-run it for all 15 companies.

    It may still be worth contacting your Business Partner for support as, depending on your particular set-up, they may be able to investigate and offer a workaround.

    Hope this helps.

    Kind regards,

    Chris