Hi,

> I am sure people here have had to report data from multiple years as well
> as reports like Stock Ledger which
> mostly requires the current set but starts with summarized data for
> Opening Stock. What have they done?

Hi, my experience is having all years on same database, but I'm don't have
idea if you should change the way you do it as it have beem working good for
you.

As I understand all you need is summary data from previus years, than, my
sugestion would be to create those "sumary data" tables you need on your
current (year) database and use something as and ETL tool to
extract/transform data from previus database (years) to the current one.

That way you don't change anything and have the data you need for this
specific report.


Regards,
Anderson