I just got a requirement to separate the older data as we close a fiscal year. Do anybody has an idea or knows how we can separate the data of say 2013 on closing fiscal year 2013 and save space.
You would need to elaborate your question well, so we can help you out.
I have requirement for my client, they want to create a new database for the new financial year and in the new database they want to have opening balances(closing entries of previous fiscal year) as well. Means close a fiscal year, generate opening balances for all the products, partners, taxes and then in new database get the entries.