← Back to team overview

c2c-oerpscenario team mailing list archive

[Bug 807525] Re: POS REFUND (Integrity Error - res.partner.address)

 

Hello Cosubo,

I have tested you scenario at my end.

But all are working fine and I am not able to faced any type of error.

So would you please elaborate more information on this or provide the
proper steps.

I have attached a video for your reference so would you please check it
and notify us where did you face the problem.

Thanks and waiting for your reply!

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

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

Status in OpenERP Modules (addons):
  Incomplete

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


References