Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0055838 | Openbravo ERP | 02. Master data management | public | 2024-06-25 14:37 | 2024-09-06 08:45 |
|
| Reporter | gorkaion | |
| Assigned To | Retail | |
| Priority | high | Severity | major | Reproducibility | always |
| Status | scheduled | Resolution | open | |
| Platform | | OS | 5 | OS Version | |
| Product Version | | |
| Target Version | | Fixed in Version | | |
| Merge Request Status | |
| Review Assigned To | |
| OBNetwork customer | |
| Web browser | |
| Modules | Core |
| Support ticket | |
| Regression level | |
| Regression date | |
| Regression introduced in release | |
| Regression introduced by commit | |
| Triggers an Emergency Pack | No |
|
| Summary | 0055838: Inconsistent duplicate EAN validation |
| Description | When Multi UPC module is installed there is a validation that avoids having the same active ean code duplicated in the multi upc tab (obmupc_prod_multiupc). This validation is also considering ean code defined in the main product tab (m_product)
However there is no validation on the ean code defined in the Product table. So it is possible to have different products with the same EAN code. In case both products are loaded in a POS Terminal the barcode scan is unpreditable since the POS will add one of the products with no warning. While searching by the EAN code returns all the duplicated products. |
| Steps To Reproduce | Go to Product window and assign the same EAN code to at least 2 products that are in the same store assortment.
Go to POS and scan the EAN code. Note that the POS adds one of the products to the ticket.
Go to Search view and search by the EAN code. Note that the POS shows all the products sharing the EAN code. |
| Proposed Solution | The same no duplicated validation should be enforced in the Product EAN field and in the MultiUPC tab.
There should not be 2 different active products in the same organization tree sharing the same EAN code.
The validation should ignore deactivated products and deactivated multi upc records. |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | | related to | defect | 0055807 | | closed | Rajesh_18 | Retail Modules | Duplicate UPC/EAN includes same product and deactivated records in the check |
|
| Attached Files | |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2024-06-25 14:37 | gorkaion | New Issue | |
| 2024-06-25 14:37 | gorkaion | Assigned To | => Triage Omni OMS |
| 2024-06-25 14:37 | gorkaion | Modules | => Core |
| 2024-06-25 14:37 | gorkaion | Triggers an Emergency Pack | => No |
| 2024-06-25 14:39 | gorkaion | Relationship added | related to 0055807 |
| 2024-06-25 14:45 | frank_gonzalez | Note Added: 0166310 | |
| 2024-06-25 18:38 | marvintm | Assigned To | Triage Omni OMS => Retail |
| 2024-06-25 18:38 | marvintm | Status | new => acknowledged |
| 2024-06-25 18:52 | Rajesh_18 | Assigned To | Retail => Rajesh_18 |
| 2024-06-25 18:52 | Rajesh_18 | Status | acknowledged => scheduled |
| 2024-07-04 15:18 | hgbot | Note Added: 0166689 | |
| 2024-09-06 08:44 | guillermogil | Note Added: 0168849 | |
| 2024-09-06 08:44 | guillermogil | Type | defect => design defect |
| 2024-09-06 08:45 | guillermogil | Assigned To | Rajesh_18 => Retail |
| 2024-09-06 08:45 | guillermogil | Status | scheduled => acknowledged |
| 2024-09-06 08:45 | guillermogil | Status | acknowledged => scheduled |