Openbravo Issue Tracking System - Modules |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0050981 | Modules | Distribution Order for Advanced Warehouse Operations | public | 2022-11-23 12:06 | 2023-04-17 12:05 |
|
| Reporter | gorkaion | |
| Assigned To | AtulOpenbravo | |
| Priority | high | Severity | major | Reproducibility | always |
| 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 | 0050981: confirm issue list of distribution order does not pick all the lines when it has more than 100 |
| Description | Having a Distribution Order Issue with more than 100 lines.
When the issue list is confirmed the issued quantity field in the distribution order lines is not updated for all the lines. Only 100 are updated. |
| Steps To Reproduce | 1. Create a Distribution Order Issue with more than 100 lines. On a configuration using Transit warehouse.
2. Book it
3. Issue it
4. Go to Issue List window and check the generated task list. Confirm that there are as many tasks as lines in the Distribution Order.
5. Confirm the issue list.
6. Check the Goods Movement generated has all the lines.
7. Go back to Distribution Order and check that only 100 lines have the issued qty updated and the remaining lines is still zero. |
| Proposed Solution | |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | |
| Attached Files |  50981_ScriptToCreateDOIssueWith100PlusLines.txt (943) 2023-02-23 19:25
https://issues.openbravo.com/file_download.php?file_id=18165&type=bug |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2022-11-23 12:06 | gorkaion | New Issue | |
| 2022-11-23 12:06 | gorkaion | Assigned To | => Triage Omni WMS |
| 2022-12-15 11:24 | vmromanos | Assigned To | Triage Omni WMS => Triage Platform Base |
| 2022-12-20 11:31 | alostale | Assigned To | Triage Platform Base => Triage Platform Conn |
| 2022-12-27 09:32 | adrianromero | Assigned To | Triage Platform Conn => ignacio_deandres |
| 2022-12-27 09:52 | ignacio_deandres | Note Added: 0145017 | |
| 2022-12-27 12:30 | ignacio_deandres | Note Deleted: 0145017 | |
| 2023-01-09 10:47 | adrianromero | Status | new => scheduled |
| 2023-01-17 11:51 | ignacio_deandres | Assigned To | ignacio_deandres => Triage Omni WMS |
| 2023-01-18 08:28 | vmromanos | Assigned To | Triage Omni WMS => mtaal |
| 2023-02-23 10:12 | AtulOpenbravo | Assigned To | mtaal => AtulOpenbravo |
| 2023-02-23 19:14 | hgbot | Note Added: 0146941 | |
| 2023-02-23 19:21 | AtulOpenbravo | Note Added: 0146942 | |
| 2023-02-23 19:25 | AtulOpenbravo | File Added: 50981_ScriptToCreateDOIssueWith100PlusLines.txt | |
| 2023-04-17 11:29 | mtaal | Note Added: 0148465 | |
| 2023-04-17 12:05 | hgbot | Resolution | open => fixed |
| 2023-04-17 12:05 | hgbot | Status | scheduled => closed |
| 2023-04-17 12:05 | hgbot | Note Added: 0148471 | |
| 2023-04-17 12:05 | hgbot | Note Added: 0148472 | |
|
Notes |
|
|
(0146941)
|
|
hgbot
|
|
2023-02-23 19:14
|
|
|
|
|
|
Test Plan
- In AWO FE, do a inventory count for product Ale Beer Qty = 110, Storage Bin : Food001, Warehouse: US West Coast, Confirm the IC.
- Confirm the Inventory Count task for Qty 110 so that stock is available for the product.
- In Back Office login with AWOQAAdmin, Organization: US West Coast, Warehouse : US West Coast
- Create a Distribution Order Issue for US West Coast Org, Warehouse Issue: US West Coast, Warehouse Receipt: US East Coast.
- Add a line for product Ale Beer Qty 1.
- Copy more than 100 lines for same product using script. for eg: 103 lines.
- Book the DO Issue.
- Click of Pick button in DO header. Realize that Picking List document no generated.
- Navigate to Picking List window and for above document no, Confirm the Picking List.
- Go back to DO Issue window.
- Click on Issue button in DO header. Realize that Issue List document no. generated.
- Navigate to Issue List window and for above document no, Confirm the Issue List.
- Go back to Distribution Order Issue window.
- Realize that Issue Status in the header is 100%.
- Realize that all the DO Lines are updated with Issue Quantity as 1. |
|
|
|
(0148465)
|
|
mtaal
|
|
2023-04-17 11:29
|
|
Discussed the expected volumes with David M. Common case is 100s, max is 1000s.
Performance testing on 2.6Ghz processor, millis. Conclusion:
for common case upto hunderds of lines is not-doing-clear faster. With 1000+ lines it becomes slower. But to solve the issue without doing clear we would need to add new queries which would also slow down the solution.
With clear (current approach):
> 202 lines in DO
confirm picking: 8437
confirm issue: 8124
> 1002 lines in DO
confirm picking: 32329
confirm issue: 38321
Removing clear (which solves the issue):
> 202 lines:
confirm picking: 3007
confirm issue: 8836
> 1002 lines:
confirm picking: 29434
confirm issue: 125889 |
|
|
|
(0148471)
|
|
hgbot
|
|
2023-04-17 12:05
|
|
|
|
|
(0148472)
|
|
hgbot
|
|
2023-04-17 12:05
|
|
|