On Thursday 01 April 2010 07:22:36 Luc Maurer wrote: > Hello, > > I just made some relexions about your post and I thing you right Ferdinand, > we should add this period sum on OpenERP by default => I think it is not > relevant now has OpenERP is mostly used by SME companies, but if we want to > promote the solution to big companies, I will be important. And if we do > not have it now we will have to rebuilt everything. > > Regarding the question of opening entries, I am not sure it is mandatory in > Switzerland, but I think it is a good think to have them. In fact if we > have such entries, we really have a complete view of a fiscal year without > having to see the past => if we export all entries, we really have the > right amounts. > > I suggest to make a swiss compromise ;-) : we push OpenERP to add this > period sum to improve balance calculation for big companies, but we do not > change the closing process that create opening entries. In fact with the > new closing process of the 5.0 version, it is really very easy to refresh > the opening entries so it is not a big problem. > > What do you thing about my proposition ? > > Regards > > Luc Maurer 2 issues
* moves in draft mode > @Borja I wrote earlier that it is easy to add sums for moves in draft - probably it's not ** my current implementation the period sums are updated avoids dead locks because the the moves_lines are sorted by id during the update of the sums - so postgres should be able to detect and solve conflicts. (at least ORACLE did so) ** IMHO it does not make sense to include draft moves as long these are not balanced and / or completely entered. *** work around - it we really decide that "draft" moves should be included in debit_draft and credit_draft, we probably should optionally modify the workflow form **** draft - posted to **** draft - balanced - posted and include only balanced moves in the sums * opening balance @Luc my current module is compatible (may be not yet bug free) with the current situation. ** my proposal is to automatically calculate opening balance (and store the value in a special period 'yyyy00' ** exclude the closing and opening move_lines (using a special flag in the closing/opening journal(s) ) from this automatic calculation => result : whether a company creates closing and opening moves or not - the period sums are correct and hold only period values - hence also for "closed years" general ledger, balances etc can be reproduced.using the period sums. still an open issue - but can be solved - many companies require additional 13th, 14th and so on - virtual closingperiods during the fy closing this can be accomplished by * using different journals - but this is a hassle to select/exclude for reports * automatically create a new "virtual" period with 1 day length at the end of the fy if the real or virtual period for this day is already closed. (my preferred solution) -- regards Ferdinand Gassauer ChriCar Beteiligungs- und Beratungs- GmbH Official OpenERP Partner _______________________________________________ Mailing list: https://launchpad.net/~openerp-expert-accounting Post to : [email protected] Unsubscribe : https://launchpad.net/~openerp-expert-accounting More help : https://help.launchpad.net/ListHelp
