← Back to team overview

openerp-expert-accounting team mailing list archive

Re: Openerp accounting constraints module -> ideas?

 

A Dimarts, 11 de setembre de 2012 11:46:23, Frédéric Clementi va escriure:
> Dear All,
> 
> Our experience with accounting on OpenERP shown us that the system is,
> today, not trustable enough since it allows user to do many mistakes.
> 
> So, at Camptocamp, we plan to create a module for (v5 and v6.1)
> adding constraints to Openerp accounting in the core source code ;  we
> want, at the same time, to stick as much as possible to the standard so
> anyone will be able to install it on top of a standard configuration.
> 
> In other word, our goal is to press on very few buttons...but, if possible,
> the right ones :)
> 
> Here are the first set of ideas we have gathered :
> 
> * Account :
> - For Openerp v5 only, forbid to modify the type to 'view' if journal
> entries have been already posted on this account.
> - Forbid to modify the code of an account if journal entries have been
> already posted on this account.
> 
> * Reconcile
> - Forbid the reconciliation between move lines if partner is not the same.
> - Forbid partner name duplication -> can generate errors on reconcile
> - Force account with type 'recevable' or 'payable' to have a partner on
> journal entry

We implemented that in nan_account_extension, but used a new boolean field 
instead of rely on account type. The reason is that there are cases in which 
it is ok (at least in Spain) that you have a payable/receivable account with 
no partner (for example, for taxes).

> * Date/Period
> - Forbid the possibility to post a journal entry on the wrong fiscal year
> in the core of the source code.
> - Forbid the possibility to get date outside the periode : this flexibility
> given generates too many problems (ie: filters or journal entry posted on
> the wrong month or worst  wrong year). This features already exists
> (checkbox in journal) -> we want to hide this option.

Agreed.

> * Fiscal year
> - Forbid the possibility to have more than 1 special period (=opening
> period)
> - This special period must be one day only
> - This special period must be on the very first day of the fy

In Spain, the latter is not true because there are 3 special periods: Opening 
but also P&L and Closing. In fact, even if you can manage to work with it, the 
whole period structure doesn't match very well Spanish needs.

> *Closing fiscal year wizard
> - Forbid to close a fy if : 1 - total debit <> total credit  2 -
> All previous fy are not closed 3 - All period in the fy must be closed 4 -
> All journal entries must be validated (already check in v6 when closing
> period but not in v5)
> 
> * Journal entries
> - Forbid the modification / deletion on a automatic journal entries (ie:
> generated by an invoice, bank statement, voucher, cash,... ?)
> - Forbid to post any entries except on journals with type 'general' in
> order to force users to good practices (create invoices and use banks
> statement for ex.)
> 
> Of course, it has to be challenged and completed with new ideas so we count
> on your help.
> 
> Thank you all,
> 
> Frédéric CLEMENTI
> Business Solutions
> Camptocamp SA
> Tel : + 41 (0)21 619 1041
> http://www.camptocamp.com
> 
>  <frederic.clementi@xxxxxxxxxxxxxx>

-- 
Albert Cervera i Areny
http://www.NaN-tic.com
Tel: +34 93 553 18 03

http://twitter.com/albertnan 
http://www.nan-tic.com/blog

Follow ups

References