FrontAccounting forum — fiscal year

Re: fiscal year

null@example.com (itronics) — Mon, 12 Jul 2010 08:02:19 +0000

Maybe we should change this, but this require checking not only GL postings table but also a couple of other tables which store other 'transactions' like orders which do not generate any GL postings. Current way of maintenance of fiscal years is simplest one, other one would be more prone to errors after eventual future db structure changes.

Janusz

Re: fiscal year

null@example.com (huotg01) — Sat, 10 Jul 2010 11:10:55 +0000

Thanks Janusz

But, in the case of a fiscal year with no transaction, why is FA preventing the deletion of that fiscal year ? (trying to better understand).

Gaston

Re: fiscal year

null@example.com (itronics) — Fri, 09 Jul 2010 22:57:59 +0000

I have not found any real issue here. The only constraint is that before deleting some fiscal year all preceding year should be deleted. And before deleting you always have to close the year.

Janusz

Re: fiscal year

null@example.com (huotg01) — Fri, 09 Jul 2010 16:20:29 +0000

thhui wrote:

If you have data in any fiscal year before, you cannot delete any fiscal years after
in spiite of having no data in that fiscal year.
So, in order you can delete any fiscal year, you must have no data before it and
no fiscal year before it.

What would be the logic ?

mudassir wrote:

cant delete july 2011 - june 2012 but its ok for me....

Why would you delete it ?

Gaston

Re: fiscal year

null@example.com (mudassir) — Fri, 09 Jul 2010 13:41:33 +0000

ok thanks... now i have set the accounts from july 2010 - june 2011...

cant delete july 2011 - june 2012 but its ok for me...

Re: fiscal year

null@example.com (thhui) — Fri, 09 Jul 2010 13:30:05 +0000

If you have data in any fiscal year before, you cannot delete any fiscal years after
in spiite of having no data in that fiscal year.

So, in order you can delete any fiscal year, you must have no data before it and
no fiscal year before it.

Re: fiscal year

null@example.com (huotg01) — Fri, 09 Jul 2010 13:01:48 +0000

...you are right about demo data but a part of the questioning is regarding the error message:

"Cannot delete this fiscal year because thera are fiscal years before."

As said I tried myself to create a new fiscal year, and immediately deleted it (no transactions) and I got the same message as Mudassir. I was expecting Joe ou Janusz to explain why we have this message (may be the message is wrong ?).

Any clue about it ?

Gaston

Re: fiscal year

null@example.com (thhui) — Fri, 09 Jul 2010 12:48:16 +0000

Demo Data means having data.

You must have a fresh start without any data already included.
Only the fresh Chart of Account.
Install the Company without any data or using the backup restore to
restore any backup without any data on it.

You could edit the backup file to make it without data (This is indeed the trick!!!).

Re: fiscal year

null@example.com (mudassir) — Fri, 09 Jul 2010 01:01:51 +0000

installed with the demo data....

Re: fiscal year

null@example.com (huotg01) — Thu, 08 Jul 2010 17:18:16 +0000

Newly installed without demo data ?

Anyway I think we will wait for the answer from the administrators to the thread 1433:
https://frontaccounting.com/punbb/viewtopic.php?id=1433

As said, I noticed the same problem

Gaston

Re: fiscal year

null@example.com (mudassir) — Thu, 08 Jul 2010 12:45:01 +0000

there is no transaction recorded as it is newly installed....

Re: fiscal year

null@example.com (huotg01) — Thu, 08 Jul 2010 11:56:47 +0000

We will wait an answer on thread 1433 before going on.

I have the same problem when trying to delete a newly created fiscal year.

Gaston

Re: fiscal year

null@example.com (huotg01) — Wed, 07 Jul 2010 16:24:17 +0000

You are right.
Quite special !

Do you have real transactions in your DB.

If there is nothing important, and if Janusz or Joe have nothing else to say, I will explain to you a trick that make use of the backup file to remove the undesired fiscal years.

Tell me about already registered transactions on theses fiscal years.

Gaston

Re: fiscal year

null@example.com (mudassir) — Wed, 07 Jul 2010 14:28:09 +0000

when i try to delete the fiscal year 01/01/2010 - 12/31/2010

the error message appear "Cannot delete this fiscal year because thera are fiscal years before."

Re: fiscal year

null@example.com (huotg01) — Wed, 07 Jul 2010 14:16:10 +0000

I see now.

First, set the company to fiscal year 01/01/2009 - 12/31/2009

Then delete the fiscal year 01/01/2010 - 12/31/2010 (hoping there is no transactions in it)

Then create a new fiscal year 01/01/2010 - 06/30/2010 (to fill the hole)

Then create 07/01/2010 to 06/30/2011

Then assign the company to fiscal year 07/01/2010 to 06/30/2011

Tell me if it doesn't work.

Gaston