openerp-india team mailing list archive

[javier loureiro varela <1039616@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

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'))

** Affects: openobject-addons
     Importance: Undecided
         Status: New

-- 
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):
  New

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