openerp-india team mailing list archive
-
openerp-india team
-
Mailing list archive
-
Message #20527
[Bug 1094227] Re: [6.1 / 7.0 / trunk] bank statements with the duplicate numbers
Hello,
IMO, the importance should be higher than "low", since this can possibly
created a corrupted accounting database.
-sbi
--
You received this bug notification because you are a member of OpenERP
Indian Team, which is subscribed to OpenERP Addons.
https://bugs.launchpad.net/bugs/1094227
Title:
[6.1 / 7.0 / trunk] bank statements with the duplicate numbers
Status in OpenERP Addons (modules):
Confirmed
Bug description:
I tested this with 6.1 and 7.0 but it probably applies to 6.0 and
trunk too.
When the user creates a bank statement, he can assign the bank
statement number manually. When the bank statement is confirmed, the
generated accounting entries are derived from the bank statement
number by appending /+number. There is no constraint preventing two
bank statements to have the same number, therefore it becomes possible
to have journal entries with the same number too.
How to reproduce:
- 7.0 with demo data
- create a bank statement with one item and give it the name BS1 (instead of the default /)
- create a second bank statement with on item and give it the same name BS1 (instead of the default /)
- confirm both bank statements
-> two accounting entries with the same number BS1/1 are generated
Proposed fix: add the following constraint on account_bank_statement:
_sql_constraints = [
('name_journal_uniq', 'unique (name,journal_id)', 'The name of the Bank Statement must be unique per journal !')
]
-sbi
To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-addons/+bug/1094227/+subscriptions
References