0056980: API Product - Error when updating a related product

Description

Following the implementation of contributions, management is carried out through the related product and the multiplier field.

However, this field must be able to be updated when the contribution is revised

Currently when I want to update a multiplier I get the error message below:

ERROR: duplicate key value violates unique constraint "m_product_service_prod"
Detail: Key (m_product_id, m_related_product_id)=(358807CC49444D5DB82C0FD66AE7F678, 7A763395EA494A13B0D5FF4D920B48DF) already exists

Steps To Reproduce

Create a related product to a contribution like that :

[
   {
      "client":"TERRENA",
      "organization":"*",
      "searchKey":"Contribution RPD",
      "relatedProducts":[{
         "product":"1200900",
         "multiplicator":1.14,
         "active":true
         }
      ]
   }

]

Try to change the multiplicator field (Put 1.25 instead of 1.14) :

[
   {
      "client":"TERRENA",
      "organization":"*",
      "searchKey":"Contribution RPD",
      "relatedProducts":[{
         "product":"1200900",
         "multiplicator":1.25,
         "active":true
         }
      ]
   }

]

Proposed Solution

It would be necessary to be able to update the related products if they already exist.

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

Notes
(0171754) jonae (developer) 2024-11-11 11:32	https://openbravo.atlassian.net/browse/RM-19004 [^]

Issue History
Date Modified	Username	Field	Change
2024-11-05 11:55	hbrasme	New Issue
2024-11-05 11:55	hbrasme	Assigned To	=> Retail
2024-11-05 11:55	hbrasme	Triggers an Emergency Pack	=> No
2024-11-05 15:05	jorgewederago	Assigned To	Retail => jorgewederago
2024-11-05 15:05	jorgewederago	Status	new => acknowledged
2024-11-06 21:26	fofarril	Assigned To	jorgewederago => fofarril
2024-11-06 21:26	fofarril	Status	acknowledged => scheduled
2024-11-07 12:53	jorgewederago	Assigned To	fofarril => Triage Omni OMS
2024-11-07 12:53	jorgewederago	Status	scheduled => feedback
2024-11-07 12:53	jorgewederago	Status	feedback => new
2024-11-11 11:29	jonae	Assigned To	Triage Omni OMS => kousalya_r
2024-11-11 11:32	jonae	Note Added: 0171754
2024-11-19 11:35	jonae	Assigned To	kousalya_r => jgalarza