Openbravo Issue Tracking System - Retail Modules
View Issue Details
0055807Retail ModulesMulti UPC/EAN for Productpublic2024-06-20 13:282024-06-25 18:48
gorkaion 
Rajesh_18 
highmajoralways
closedfixed 
5
 
 
No
0055807: Duplicate UPC/EAN includes same product and deactivated records in the check
When an update wants to remove a EAN code defined in the multiupc tab the proper way is to deactivate it so the incremental refreshes in the POS can remove it from the cache.

The handler checking for duplicated eans is not taking into account the deactivated multiupc eans. This is wrong since it avoids to assign the deactivated ean code to a different product.

The handler is not allowing duplicates in the same product. Hving the same EAN code in the Product header and in the mutiupc tab of the same product should be allowed.

Use case is: Product has code EAN13A in the product and EAN13B in the multiupc. Now it is required to switch them since the EAN13B has become the main one. This results in EAN13B in the header as a deactivated record in the multiupc and the EAN13A inserted in the multiupc tab. If this change is done using an integration process usually all the changes are flushed a single time causing the handler to fail as it is consindering the multiupc EAN13B still active.
try to deactivate a multiupc ean and assign it to a different product or set it as the main ean of hte same product.
No tags attached.
related to design defect 0055838 scheduled Retail Openbravo ERP Inconsistent duplicate EAN validation 
Issue History
2024-06-20 13:28gorkaionNew Issue
2024-06-20 13:28gorkaionAssigned To => Retail
2024-06-20 13:28gorkaionTriggers an Emergency Pack => No
2024-06-20 13:29marvintmStatusnew => acknowledged
2024-06-20 14:45Rajesh_18Assigned ToRetail => Rajesh_18
2024-06-20 14:45Rajesh_18Statusacknowledged => scheduled
2024-06-24 10:25hgbotNote Added: 0166242
2024-06-25 14:39gorkaionRelationship addedrelated to 0055838
2024-06-25 18:48hgbotNote Added: 0166321
2024-06-25 18:48hgbotResolutionopen => fixed
2024-06-25 18:48hgbotStatusscheduled => closed
2024-06-25 18:48hgbotNote Added: 0166322

Notes
(0166242)
hgbot   
2024-06-24 10:25   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.multiupc/-/merge_requests/8 [^]
(0166321)
hgbot   
2024-06-25 18:48   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.multiupc/-/merge_requests/8 [^]
(0166322)
hgbot   
2024-06-25 18:48   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.multiupc [^]
Changeset: 6aae2a648b8bb8308e0818caf400fa61183c5228
Author: Rajesh Senthilkumar <rajesh@qualiantech.com>
Date: 24-06-2024 11:24:31
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.multiupc/-/commit/6aae2a648b8bb8308e0818caf400fa61183c5228 [^]

Fixed ISSUE-55807: Refactored multiupc event handler to check duplicate of upc

---
M src-db/database/model/tables/OBMUPC_PROD_MULTIUPC.xml
M src/org/openbravo/multiupc/event/NoDuplicateUpcHandler.java
---