← Back to team overview

openerp-india team mailing list archive

[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