Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0050981
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Modules] Distribution Order for Advanced Warehouse Operationsmajoralways2022-11-23 12:062023-04-17 12:05
ReportergorkaionView Statuspublic 
Assigned ToAtulOpenbravo 
PriorityhighResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Regression date
Regression introduced by commit
Regression level
Review Assigned To
Regression introduced in release
Summary

0050981: confirm issue list of distribution order does not pick all the lines when it has more than 100

DescriptionHaving 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 Reproduce1. 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.
TagsNo tags attached.
Attached Filestxt file icon 50981_ScriptToCreateDOIssueWith100PlusLines.txt [^] (943 bytes) 2023-02-23 19:25 [Show Content]

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0146941)
hgbot (developer)
2023-02-23 19:14

Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations/-/merge_requests/113 [^]
(0146942)
AtulOpenbravo (developer)
2023-02-23 19:21

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 (manager)
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 (developer)
2023-04-17 12:05

Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations [^]
Changeset: f1f1317a2be18f7bf56888d4f5a921d6e0d4cca3
Author: Atul Gaware <atul.gaware@openbravo.com>
Date: 17-04-2023 10:05:21
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations/-/commit/f1f1317a2be18f7bf56888d4f5a921d6e0d4cca3 [^]

Fixed BUG-0050981: confirm issue list of distribution order does not pick all the lines when it has more than 100

---
M src/org/openbravo/warehouse/advancedwarehouseoperations/centralbroker/GroupOfTasksConfirmator.java
---
(0148472)
hgbot (developer)
2023-04-17 12:05

Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations/-/merge_requests/113 [^]

- 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


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker