openerp-india team mailing list archive

[javier loureiro varela <1039616@xxxxxxxxxxxxxxxxxx>]

# dpkg -s openerp
Package: openerp
Status: install ok installed
Priority: optional
Section: net
Installed-Size: 264456
Maintainer: OpenERP SA <al@xxxxxxxxxxx>
Architecture: all
Version: 6.1-20120820-233219-1
Replaces: openerp-server, openerp-web, tinyerp-server
Depends: adduser, python, postgresql-client, python-dateutil, python-feedparser, python-gdata, python-ldap, python-libxslt1, python-lxml, python-mako, python-openid, python-psycopg2, python-pybabel, python-pychart, python-pydot, python-pyparsing, python-reportlab, python-simplejson, python-tz, python-vatnumber, python-vobject, python-webdav, python-werkzeug, python-xlwt, python-yaml, python-zsi
Recommends: graphviz, ghostscript, postgresql, python-imaging, python-matplotlib
Conflicts: openerp-server, openerp-web, tinyerp-server
Conffiles:
 /etc/openerp/openerp-server.conf 3062ecf582095f318f64612454408e4e
 /etc/init.d/openerp 36c2f6c3f5fe206bb71ece1772051cbb
Description: OpenERP Enterprise Resource Management
 OpenERP, previously known as TinyERP, is a complete ERP and CRM. The main
 features are accounting (analytic and financial), stock management, sales and
 purchases management, tasks automation, marketing campaigns, help desk, POS,
 etc. Technical features include a distributed server, flexible workflows, an
 object database, a dynamic GUI, customizable reports, and NET-RPC and XML-RPC
 interfaces.
Homepage: http://www.openerp.com/

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