Openbravo Issue Tracking System - Openbravo ERP | ||||||||||||
| View Issue Details | ||||||||||||
| ID | Project | Category | View Status | Date Submitted | Last Update | |||||||
| 0049551 | Openbravo ERP | 04. Warehouse management | public | 2022-06-14 11:51 | 2022-07-26 11:25 | |||||||
| Reporter | gorkaion | |||||||||||
| Assigned To | mtaal | |||||||||||
| Priority | high | Severity | major | Reproducibility | always | |||||||
| Status | closed | Resolution | fixed | |||||||||
| Platform | OS | 5 | OS Version | |||||||||
| Product Version | ||||||||||||
| Target Version | Fixed in Version | PR22Q4 | ||||||||||
| Merge Request Status | approved | |||||||||||
| Review Assigned To | ||||||||||||
| OBNetwork customer | Gold | |||||||||||
| Web browser | ||||||||||||
| Modules | Core | |||||||||||
| Support ticket | 42835 | |||||||||||
| Regression level | ||||||||||||
| Regression date | ||||||||||||
| Regression introduced in release | ||||||||||||
| Regression introduced by commit | ||||||||||||
| Triggers an Emergency Pack | No | |||||||||||
| Summary | 0049551: No storage detail automatically removed when the product does not have attribute set | |||||||||||
| Description | The m_update_inventory process is removing from the system the storage details with all the quantities in zero. There is an exception when the product has an attribute set defined as Specification and the attribute set has the flag to require at least one value disabled. There is a bug implementing the exception as it does a full join to the attribute set. So it only consider for deletion products using attributes. | |||||||||||
| Steps To Reproduce | Failure test: - Create a product that does not use attributes - Create a shipment line with that product (leave in draft the shipment). - Check in the database that a storage detail is created. - Delete the shipment line - Check in the database that the storage detail is not deleted. Working test: - Create a product and set an attribute set that has the require at least one value flag enabled. and leave the "use attribute set value as" field empty. - Create a shipment line with that product (leave in draft the shipment). - Check in the database that a storage detail is created. - Delete the shipment line - Check in the database that the storage detail is deleted. | |||||||||||
| Proposed Solution | modify the query to use a left join on attribute set table. | |||||||||||
| Additional Information | ||||||||||||
| Tags | No tags attached. | |||||||||||
| Relationships |
| |||||||||||
| Attached Files | ||||||||||||
| Issue History | ||||||||||||
| Date Modified | Username | Field | Change | |||||||||
| 2022-06-14 11:51 | gorkaion | New Issue | ||||||||||
| 2022-06-14 11:51 | gorkaion | Assigned To | => Triage Omni WMS | |||||||||
| 2022-06-14 11:51 | gorkaion | OBNetwork customer | => No | |||||||||
| 2022-06-14 11:51 | gorkaion | Modules | => Core | |||||||||
| 2022-06-14 11:51 | gorkaion | Support ticket | => 42835 | |||||||||
| 2022-06-14 11:51 | gorkaion | Triggers an Emergency Pack | => No | |||||||||
| 2022-06-28 09:25 | gorkaion | OBNetwork customer | No => Gold | |||||||||
| 2022-07-13 10:29 | mtaal | Note Added: 0139294 | ||||||||||
| 2022-07-13 10:30 | mtaal | Assigned To | Triage Omni WMS => mtaal | |||||||||
| 2022-07-18 11:53 | hgbot | Merge Request Status | => open | |||||||||
| 2022-07-18 11:53 | hgbot | Note Added: 0139381 | ||||||||||
| 2022-07-20 09:01 | hgbot | Merge Request Status | open => approved | |||||||||
| 2022-07-20 09:01 | hgbot | Resolution | open => fixed | |||||||||
| 2022-07-20 09:01 | hgbot | Status | new => closed | |||||||||
| 2022-07-20 09:01 | hgbot | Note Added: 0139439 | ||||||||||
| 2022-07-20 09:01 | hgbot | Fixed in Version | => PR22Q4 | |||||||||
| 2022-07-20 09:01 | hgbot | Note Added: 0139440 | ||||||||||
| 2022-07-26 11:25 | hgbot | Note Added: 0139604 | ||||||||||
| 2022-11-15 17:07 | vmromanos | Relationship added | related to 0050776 | |||||||||
| Notes | |||||
|
|
|||||
|
|
||||
|
|
|||||
|
|
||||
|
|
|||||
|
|
||||
|
|
|||||
|
|
||||
|
|
|||||
|
|
||||