openerp-expert-accounting team mailing list archive

[Ferdinand Gassauer <office@xxxxxxxxxx>]

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