Am 2013-04-30 16:23, schrieb Marc Rechté: > > I'd say accounting in Tryton is better than in OpenERP: > > You misunderstood me, I did not intend to compare the functional > aspect of the two products. OpenERP may have more real case > implementations than Tryton and therefore is faced with practical > considerations like performance and simplicity of SQL. Have you > checked the SQL implication of such move.period.fiscalyear.company > clause ? This would be acceptable in a few queries, but company > filtering is necessary in most accesses to data. Writing a module or a > report should be made as simple as possible (RAD), denormalizing would > help I think.
If you need something easier to query manually, why not create a view? performance (at least with postgresql) should not be an issue, number of periods times number of companies per database is virtually guaranteed to be small. mfg Robert
