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

(0) Share

Report

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

All responses (7)

Answers (1)

Santiago Calle 115 on at

Like (0)

Report

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 140 on at

Like (0)

Report

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 140 on at

Like (0)

Report

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 350 on at

Like (0)

Report

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 140 on at

Like (0)

Report

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 350 on at

Like (0)

Report

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 on at

Like (0)

Report

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