Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

AX - How to get opening balances for new year without closing previous one

Posted on by 140

Hello,

We are not ready to close the year yet till auditors go through the books and advise for adjustments. This process may take up to two months and in meantime I need to run trial balance with open balances.

Question: if we run year close and we need to make changes after that can it be done and how?

If this is not possible I am interested to know is any way to get opening balances in meantime from last year....

I need to know this asap, so I apprecaite your help

Lonex

*This post is locked for comments

  • Santiago Calle Profile Picture
    Santiago Calle 115 on at
    RE: AX - How to get opening balances for new year without closing previous one

    Hi Anton.

    Im trying to use your recomendations about building a report with the same structure as ledger trial balance, but im getting several troubles as long as it has a Controller Class which calls a Contract Class for parameters and stuff and im always getting an error saying that an object hasnt been initialized. have you any idea how two build the same report with out running through all these errors? maybe changing the class, or just creating just a new desing? your information will be very useful!

  • Suggested answer
    Lonex Profile Picture
    Lonex 140 on at
    Re: AX - How to get opening balances for new year without closing previous one

    I think issue is that I was selecting wen running report INCLUDE OPENING which was adding open transactiosn to the debits/credits columns and on opening balance was showing zero. Now when I run the report without this check box I get opening transactions on the opening balance column.  

  • Lonex Profile Picture
    Lonex 140 on at
    Re: AX - How to get opening balances for new year without closing previous one

    I am checking 'include opening' and I am not getting any luck in two companies but I get correct opening balance on another company. i even reset all usage data and still no luck. I really need to get this sorted and I am stuck so anybody has any suggestion is very much appreciated.

    Lonex

  • Roger Laine Profile Picture
    Roger Laine 350 on at
    Re: AX - How to get opening balances for new year without closing previous one

    Hi again Lenox

    You need to select 'Include Opening' in the Printout section of the report dialogue: this applies to several reports including FInancial Statements.  

    Your Usage data default for this report must be different in the different companies.

    Regards

    Roger

  • Lonex Profile Picture
    Lonex 140 on at
    Re: AX - How to get opening balances for new year without closing previous one

    Thanks for feedback,. After I wrote this yesterday,  I did do more research and found out what Roger is recommending here and it works fine at least for one company. i did set all those parameters on GL\Setup parameters except the check box for closing the year, this eay I caould transfer balances and make adjustments more than one time if necessary. when I run the Trial balance for Jan 2012 I could see the opeing balances. To get this I did check the box to show open balances.

    HOWEVER, this result I got only in one company, on other two companies I had same settings and I did run the same process and I cannot see open balances on Trial Balance report. If I select a ledger balance account from Ledger account details and click on Periods I can see open balance it just not showing on the trial balance report.

    Also theree is another report on GL\Reports\transactions\periodic\Balance list

    and I see open balances on this report.

    I appreciate if anybody has any advise on this

    Thanks

    Lonex

  • Verified answer
    Roger Laine Profile Picture
    Roger Laine 350 on at
    Re: AX - How to get opening balances for new year without closing previous one

    Hi Lonex

    Accounting Year Close/Opening transactions can be re-run as many times as required.

    Do NOT check 'Set accounting year status to Closed' until you really do want to Close the accounting year, which might be months after the end of the accounting year.

    DO check ' Delete close-of-year transactions during transfer' in ordedr to delete previous Close/Opening transactions each time you run the Close, otherwise you are left with a confusing set of transfer/reversal/transfer entries.

    I hope this is helpful.

  • Anton Ivanov Profile Picture
    Anton Ivanov on at
    Re: AX - How to get opening balances for new year without closing previous one

    Hi Lonex,

    In this case you could build a G/L Report that has the same structure as the trial balance. In columns you could specify the necessary periods (that cover transaction for a longer period).

    BR,

    Anton

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,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans