openerp-india team mailing list archive
-
openerp-india team
-
Mailing list archive
-
Message #14758
[Bug 1039616] Re: Integrity Error on Bank Statements
I see that on my current version, the class account_bank_statement_line
in python does not define a "state" field. But he database has one.
Maybe I upgraded the openerp source, and that field has become
deprecated?
--
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/1039616
Title:
Integrity Error on Bank Statements
Status in OpenERP Addons (modules):
Incomplete
Bug description:
Hello!
I am using OpenERP 6.1
Today I created a new Bank Statement. I created a new Statement line,
filled the fields as usual, but when I click "save", or "Compute
balance", I get this error:
Integrity Error
The operation cannot be completed, probably due to the following:
- deletion: you may be trying to delete a record while other records still reference it
- creation/update: a mandatory field is not correctly set
[object with reference: state - state]
If I dont create any statement line, I can save without problems.
Of course, all mandatery fields are set. I tried with almost
everything :
Date: today , or dates in the past
Communication: writing anything, a simple "hello"
Reference: blank, or writing a "hello", or numbers
Partner: blank, or anything from the database
Type: general, supplier, customer
Account: many, clients, suppliers, taxes, whatever
Analytic account: blank, I dont use them at the moment
Amount: any negative, zero, or positive value
Payment: blank. If I select a past payment, same error
So, at this point, I can not insert Bank Statements.
I checked the PostgresSQL log, and I found the error:
2012-08-20 12:37:03 UTC ERROR: null value in column "state" violates not-null constraint
2012-08-20 12:37:03 UTC STATEMENT: insert into "account_bank_statement_line" (id,"analytic_account_id","partner_id","name","type","account_id","date","amount","voucher_id","ref","statement_id",create_uid,create_date) values (288,NULL,NULL,'qq','general',5,'2012-08-17','60.00',NULL,NULL,28,1,(now() at time zone 'UTC'))
To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-addons/+bug/1039616/+subscriptions
References