c2c-oerpscenario team mailing list archive

[Sikiwawa <802526@xxxxxxxxxxxxxxxxxx>]

Hi fellow openerp users/dev,

I have noticed the following: 
when click on stock moves in the right-side-bar, I notice that the problematic products are listed in the stock move view page with status as done and with source location (inventory loss) to destination location (stock)

I've tried to delete the moves but couldn't since it gave a warning
saying "only draft moves can be deleted"

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

Title:
  update button in new product page->real stock value creates directly a
  product which cannot be deleted

Status in OpenERP Server:
  New

Bug description:
  I tried to create a new product of type stockable
  The real stock was set by clicking on the update button next to it
  however, the apply button opens a new webpage where it shows that the product was directly edited
  problem is that this unwanted and still-yet-to-be-edited instance cannot be deleted giving the following error:

  ERROR:db.cursor:bad query: delete from product_template where id IN (4)
  Traceback (most recent call last):
    File "/usr/local/openerp-server-6.0.2/bin/sql_db.py", line 131, in execute
      res = self._obj.execute(query, params)
  IntegrityError: null value in column "product_id" violates not-null constraint
  CONTEXT:  SQL statement "UPDATE ONLY "public"."stock_move" SET "product_id" = NULL WHERE $1 OPERATOR(pg_catalog.=) "product_id""

  Kindly note that the inventory entry corresponding to this undesired
  product instance can be successfully deleted

  platform: ubuntu
  version used: 6.0.2

To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-server/+bug/802526/+subscriptions