Question Status

Verified
Lonex asked a question on 3 Feb 2012 10:44 AM

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

Reply
Verified Answer
Roger Lainé responded on 4 Feb 2012 9:03 AM

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.

Reply
Suggested Answer
Lonex responded on 5 Feb 2012 10:12 PM

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.  

Reply
Anton Ivanov responded on 4 Feb 2012 5:30 AM

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

Reply
Verified Answer
Roger Lainé responded on 4 Feb 2012 9:03 AM

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.

Reply
Lonex responded on 4 Feb 2012 12:06 PM

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

Reply
Roger Lainé responded on 5 Feb 2012 12:56 AM

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

Reply
Lonex responded on 5 Feb 2012 8:36 PM

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

Reply
Suggested Answer
Lonex responded on 5 Feb 2012 10:12 PM

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.  

Reply
Santiago Calle responded on 8 Apr 2013 3:23 PM

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!

Reply