#39 Multiple financial statements

[Torben S. Soerensen]

We need to revive the concept of multiple financial statements. E.g. so that FF can handle that you can have more than one financial statement.

I think we should keep the concept, than one database = one financial statement.

We have the following requirements for financial statements:

- It must be possible to take a copy - with or without data - of a financial statement

- It must be possible to have one source (database) for shared data, e.g. cmn_organisation, cmn_person, cmn_organisation_person and then the rest of the info from the financial statements in another database.

- The financial statement MUST include information about the default currency. The default currency must NOT be determined by the language of the underlying system or language.

[Anonymous]

Logged In: YES
user_id=1581493
Originator: NO

I dont think it is a good idea to split it up into multiple databases - it will be kind of messy to check persons, organisations and other stuff. I think we should keep it all in one database.

Also some ID's could get messed up.

[Torben S. Soerensen]

Logged In: YES
user_id=839926
Originator: YES

Ok, please design a solution where multiple financial statements are kept in the same database. You must be able to do the following

- Have different COAs in each financial statement
- Have different CDBs in each financial statement
- Users can have different rights in each financial statement
- Individual backup of each financial statement
- Make sure that a user only works in one financial statement a a time, but allows you to close a financial statement and open another without having to logout of FriFinans
- Basically all tables except organisations, persons and users should be related to the financial statement.