c2c-oerpscenario team mailing list archive

["mra \(Open ERP\)" <mra@xxxxxxxxxxx>]

** Changed in: openobject-addons
       Status: Confirmed => In Progress

** Changed in: openobject-addons
    Milestone: None => 6.0

-- 
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to the OpenERP Project Group.
https://bugs.launchpad.net/bugs/697702

Title:
  Unable to delete "open" invoice

Status in OpenObject Addons Modules:
  In Progress

Bug description:
  Version : OpenERP 6.0 RC2

I'm unable to delete an opened (not paid) invoice.

- I installed the module "account_cancel".
- I set the option "Allow Cancelling Entries" to true on the journal used by the invoice.

But I get the following SQL error

Error message (server side) :

[2011-01-05 16:02:29,347][swissdotnet_prod] ERROR:db.cursor:bad query: delete from account_move where id IN (2)
Traceback (most recent call last):
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/sql_db.py", line 129, in execute
    res = self._obj.execute(query, params)
IntegrityError: update or delete on table "account_move" violates foreign key constraint "account_invoice_move_id_fkey" on table "account_invoice"
DETAIL:  Key (id)=(2) is still referenced from table "account_invoice".

Error message (client side) : 

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: Invoice - account.invoice]

Could you reproduce it ?