Skip to main content

Notifications

Community site session details

Community site session details

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

Trial Balance Opening Balances not updating

(0) ShareShare
ReportReport
Posted on by 92

Hi,

I have posted journals in FY19 which had already been closed.

I then re ran the financial year close after the journals were posted, however the trial balance for FY20 opening balances are all Zero.

I then rebuilt the balances through the below steps as this has fixed this issue before however it did not work this time.

6747.pastedimage1599735738082v1.png

Is there anything else i can do to update the opening balances?

Any help would be greatly appreciated.

Thanks

Mairead

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Trial Balance Opening Balances not updating

    Hello Mairead,

    There have been a number of replies been provided and I wonder if you need any other information/help to get this issue fixed.

    Would be great if you could keep us updated.

    Many thanks and best regards,

    Ludwig

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Trial Balance Opening Balances not updating

    Hi Neeraj,

    Why don't you add a voucher in the closing form?

    Also, I would not recommend undoing (deleting) the previous voucher.

    In my home country it is not allowed deleting vouchers.

    Would be great if you could some additional tests with a voucher number entered in a demo/test system first to see if this makes a difference.

    Best regards,

    Ludwig

  • Suggested answer
    SouravDam Profile Picture
    11,723 on at
    RE: Trial Balance Opening Balances not updating

    I think the link shared by Nuno and highlighted by Neeraj are triggering to the same direction. Hopefully it will solve your case.

    Also check in GL parameters form what setup you have done there. Please set as below and keep us posted on this.

    0310.JPG

    Regards,
    Sourav

  • Suggested answer
    Neeraj Kumar Acxiom Profile Picture
    50 on at
    RE: Trial Balance Opening Balances not updating

    Undo-Previous-Close.PNG

    Hi Mairead!

    What was the transfer method for "Undo Previous Close" while closing the fiscal year? Tried this by making "Yes".

    Regards,

    Neeraj 

  • Suggested answer
    Ramit Paul Profile Picture
    22,473 Most Valuable Professional on at
    RE: Trial Balance Opening Balances not updating

    Hello,

    If you have rebuilt the set, you need to make sure, the batch is actually completed.

    Kindly check from batch job if your rebuilt batch is completed without error.

    If not, find out the error and fix it.

    Regards,

    Ramit

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Trial Balance Opening Balances not updating

    Hello Mairead,

    How have you been able to post something into a closed period?

    Can you share details how you run the trial balance and what parameters have been selected?

    Is it possible that you were just hiding the opening balance column?

    Best regards,

    Ludwig

  • Suggested answer
    nunomaia Profile Picture
    11 Moderator on at
    RE: Trial Balance Opening Balances not updating

    Check this is this your issue

    community.dynamics.com/.../trial-balance-opening-balance-is-0-after-running-year-end-close

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 294,000 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,850 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Product updates

Dynamics 365 release plans