Hello Cosubo,

Would you please check this again with latest updated code.

Currently I am closing this issue and if you still face the problem then
you can reopen this with more information.

Thanks.


** Changed in: openobject-addons
       Status: Expired => Won't Fix

** Changed in: openobject-addons
       Status: Won't Fix => Invalid

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

Title:
  POS REFUND (Integrity Error - res.partner.address)

Status in OpenERP Addons (modules):
  Invalid

Bug description:
  I can't perform a POS REFUND due to this error, what I've been able to
  find is posted in the ERP forums (link below):

  The error message:

  "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: Partner Contact - res.partner.address]"

  The server log lines:

  "[2011-07-07 19:45:02,331][tst_v6-csb] ERROR:db.cursor:bad query: insert into 
"stock_picking" 
(id,"origin","address_id","number_of_packages","date_done","carrier_tracking_ref","carrier_id","volume","pos_order","date","invoice_type_id","location_id","stock_journal_id","purchase_id","backorder_id","name","auto_picking","move_type","sale_id","company_id","invoice_state","note","state","location_dest_id","type",create_uid,create_date)
 values (3695,E'POS/3925',2608,0,NULL,NULL,NULL,0.0,3047,E'2011-07-07 
19:45:01',NULL,NULL,NULL,NULL,NULL,E'POS/3925 
(return)',E'True',E'direct',NULL,1,E'none',E'POS notes 
',E'draft',NULL,E'in',1,now())
  Traceback (most recent call last):
    File "sql_db.pyo", line 131, in execute
  IntegrityError: insert or update on table "stock_picking" violates foreign 
key constraint "stock_picking_address_id_fkey"
  DETAIL:  Key (address_id)=(2608) is not present in table 
"res_partner_address"."

  The findings: http://www.openerp.com/forum/post87033.html#p87033

  Is this a bug??

  
  Thank you for your help,
  n.

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

_______________________________________________
Mailing list: https://launchpad.net/~c2c-oerpscenario
Post to     : [email protected]
Unsubscribe : https://launchpad.net/~c2c-oerpscenario
More help   : https://help.launchpad.net/ListHelp

Reply via email to