FrontAccounting forum — Deleting a fiscal year

Re: Deleting a fiscal year

null@example.com (diventi.enterprises) — Fri, 09 Feb 2018 20:54:23 +0000

Thanks for the prompt reply and suggestion. I'd rather not mess with the SQL tables...way out of my comfort zone.

I have been working on understanding/correcting GL entries and now have the GL correct. I'm left with just a few open issues. I have numerous posts on the forum, so I won't duplicate those matters on this post.

Thanks again.

Re: Deleting a fiscal year

null@example.com (apmuthu) — Fri, 09 Feb 2018 20:28:29 +0000

All fiscal years must be in the order of the id field as well. Only then will deletion take place. You will need to take a full backup and restore it into another install and work on the MySQL tables carefully possibly in conjunction with a MySQL client such as phpMyAdmin or SQLyog. Also make a list of the plugins and their versions in use. This is not for the faint of heart - take professional assistance if unsure. Post a bounty in the Job offers board.

How many years do you have loaded on your system? Export out the fiscal_years table and see whether the id field is in the same order as the start date of the fiscal years order.

You may also contact the Support Consultants for assistance.

Re: Deleting a fiscal year

null@example.com (diventi.enterprises) — Fri, 09 Feb 2018 18:16:58 +0000

Thanks. FA still will not let me delete it. For clarification:

- all previous fiscal years are closed
- all closed fiscal years have a red X indicating that it can be deleted
- when I click the X FA prompts 'Are you sure?'
- when I click OK I get the msg "Cannot delete this fiscal year because there are fiscal years before."
- now I have a 2019 fiscal year which is considered the 'current' fiscal year and I cannot delete it

Re: Deleting a fiscal year

null@example.com (notrinos) — Fri, 09 Feb 2018 17:11:09 +0000

Try to create a new one for 2019 active it then close the 2018 one and it can be deleted.
But I guess not all transactions will be cleared.

Deleting a fiscal year

null@example.com (diventi.enterprises) — Fri, 09 Feb 2018 16:20:56 +0000

Hi. I would like to delete the current fiscal year and start over with a new one. FA will not let me delete the current year. It states, "Cannot delete this fiscal year because there are fiscal years before.".

My goal is to clear the GL of all 2018 transactions, of which there are few, and re-enter them.

I do not have a backup for the end of 2017 (I know, I know).

Are there other options?