|
|
I see that Ofbiz follows Compiere "analytics" in GL. What I mean it maintains relation to party, inventory, payment etc. in acctg_trans table.
It is good for simple caes but in real world it is not good solution. It forces acccountant to split entries in GL by dimmensions values (e.g. separate
entry for each product line)
I think it would be better to maintain separate analytic table which will hold this information in form:
acctg_trans_id, dimmension_type, amount
In this way it would be possible to make one entry for each e.g. invoice in acctg_trans, and as many dimensions in analytics as we need. (e.g. analytics for product could
be split per line, and analitycs for same invoice per project could be fifty-fifty).
What do you think of it ?
Best regards,
Marek
|
Locked
