web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / AX - How to get openin...
Microsoft Dynamics AX (Archived)

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

(0) ShareShare
ReportReport
Posted on by Lonex 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

I have the same question (0)
  • Anton Ivanov Profile Picture
    Anton Ivanov on at

    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

  • Verified answer
    Roger Laine Profile Picture
    Roger Laine 350 on at

    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.

  • Lonex Profile Picture
    Lonex 140 on at

    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

  • Roger Laine Profile Picture
    Roger Laine 350 on at

    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

    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

  • Suggested answer
    Lonex Profile Picture
    Lonex 140 on at

    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.  

  • Santiago Calle Profile Picture
    Santiago Calle 115 on at

    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!

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Priya_K Profile Picture

Priya_K 4

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#3
Scott_itD Profile Picture

Scott_itD 2 Community Manager

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans