Openbravo Issue Tracking System - Modules |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0056354 | Modules | Advanced Warehouse Operations | public | 2024-09-04 03:52 | 2024-09-18 16:23 |
|
| Reporter | axelmercado | |
| Assigned To | Sandrahuguet | |
| Priority | high | Severity | major | Reproducibility | sometimes |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 5 | OS Version | |
| Product Version | | |
| Target Version | | Fixed in Version | | |
| Merge Request Status | |
| Regression date | |
| Regression introduced by commit | |
| Regression level | |
| Review Assigned To | |
| Support ticket | |
| OBNetwork customer | |
| Regression introduced in release | |
|
| Summary | 0056354: Problem with subquery in productSelector.java file when getting more than 1 record. |
| Description | In the Maisadour client, which is in version 22Q4.2, we encountered a problem when 2 records are configured in the "Alternative UOM" tab and one is deactivated because there is an eventHandler that does not allow having 2 active records with the "Logistics" field with value "Primary".
The subquery that fails is the one shown in the attached screenshot.
As can be seen, it does not filter between assets, so having 2 records, even if one is deactivated, both are brought and the error occurs. |
| Steps To Reproduce | N/A |
| Proposed Solution | Filtering between active records should solve the problem. |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | |
| Attached Files |  imagen.png (10,103) 2024-09-04 03:52
https://issues.openbravo.com/file_download.php?file_id=20127&type=bug
|
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2024-09-04 03:52 | axelmercado | New Issue | |
| 2024-09-04 03:52 | axelmercado | Assigned To | => Triage Omni WMS |
| 2024-09-04 03:52 | axelmercado | File Added: imagen.png | |
| 2024-09-09 09:26 | mtaal | Assigned To | Triage Omni WMS => Sandrahuguet |
| 2024-09-11 11:19 | hgbot | Note Added: 0169067 | |
| 2024-09-11 12:49 | Sandrahuguet | Note Added: 0169076 | |
| 2024-09-11 13:18 | Sandrahuguet | Note Edited: 0169076 | bug_revision_view_page.php?bugnote_id=0169076#r28434 |
| 2024-09-11 13:54 | Sandrahuguet | Status | new => scheduled |
| 2024-09-18 16:23 | hgbot | Resolution | open => fixed |
| 2024-09-18 16:23 | hgbot | Status | scheduled => closed |
| 2024-09-18 16:23 | hgbot | Note Added: 0169322 | |
| 2024-09-18 16:23 | hgbot | Note Added: 0169323 | |
|
Notes |
|
|
(0169067)
|
|
hgbot
|
|
2024-09-11 11:19
|
|
|
|
|
(0169076)
|
|
Sandrahuguet
|
2024-09-11 12:49
(edited on: 2024-09-11 13:18) |
|
Test Plan
In backoffice using AWO-QA Admin client
Go to Product select AUMMultiplesTest001 and navigate to Alternate UOM tab
set box as inactive
and create new record-> UOM : Foot, conversion rate:15; sales: primary; purchase:primary; logistics: primary
Go to AWO
In the menu, select count and start count
add a product and search by AUMMultiplesTest001 notice that query now is not failing
In the nemu, select put away and search by AUMMultiplesTest001, notice that query now is not failing
In the menu, select Lookup and search by AUMMultiplesTest001, notice that query now is not failing
In the menu, select Status and search by AUMMultiplesTest001, notice that query now is not failing
In SSMS
go to requisition and create new and add item and search by AUMMultiplesTest001, notice that query now is not failing
|
|
|
|
(0169322)
|
|
hgbot
|
|
2024-09-18 16:23
|
|
|
|
|
(0169323)
|
|
hgbot
|
|
2024-09-18 16:23
|
|
|