Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0049527Retail ModulesMobile Warehouse operationspublic2022-06-10 08:082022-07-04 08:56
Reporterkousalya_r 
Assigned Toradhakrishnan 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in VersionRR22Q4 
Merge Request Status
Review Assigned To
OBNetwork customer
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0049527: Negative stock when products are ungrouped
DescriptionStock goes to negative when products are ungrouped and when we have stocks in diff bin.
Steps To Reproduce1. In product window uncheck 'Grouped product' checkbox
2. In a warehouse put a stock one unit in one bin and one more unit in another bin.
3. In POS do a sales for 2units.
4. Now check in Product window - Stock tab the product goes to negative stock for a bin which has priority. The customer shipment takes place in single bin but it should happened from both bins.
Proposed SolutionIn ShipmentUtils.java when the product is grouped we have single orderline for a product and the for loop checks one time and StockProposed table returns both bin and in while loop it fetches both bins

In case of ungrouped product we have two orderlines and for loop checks two times and StockProposed criteria query run again so in while loop it always fetches first bin and it goes to negative stock.

Proposed soln. might be check the stock if stock not present break a loop and get next bin.
Additional Information
TagsNo tags attached.
Relationships
Attached Filespng Screenshot from 2022-06-10 11-29-14.png (361,879) 2022-06-10 08:08
https://issues.openbravo.com/file_download.php?file_id=17143&type=bug
png Screenshot from 2022-06-10 11-29-35.png (341,896) 2022-06-10 08:09
https://issues.openbravo.com/file_download.php?file_id=17144&type=bug
png Screenshot from 2022-06-10 11-29-23.png (460,553) 2022-06-10 08:09
https://issues.openbravo.com/file_download.php?file_id=17145&type=bug
Issue History
Date ModifiedUsernameFieldChange
2022-06-10 08:08kousalya_rNew Issue
2022-06-10 08:08kousalya_rAssigned To => Retail
2022-06-10 08:08kousalya_rFile Added: Screenshot from 2022-06-10 11-29-14.png
2022-06-10 08:08kousalya_rTriggers an Emergency Pack => No
2022-06-10 08:09kousalya_rFile Added: Screenshot from 2022-06-10 11-29-35.png
2022-06-10 08:09kousalya_rFile Added: Screenshot from 2022-06-10 11-29-23.png
2022-06-14 15:45radhakrishnanAssigned ToRetail => radhakrishnan
2022-06-14 15:45radhakrishnanStatusnew => scheduled
2022-06-21 13:33hgbotNote Added: 0138593
2022-07-04 08:54hgbotResolutionopen => fixed
2022-07-04 08:54hgbotStatusscheduled => resolved
2022-07-04 08:54hgbotNote Added: 0138992
2022-07-04 08:54hgbotFixed in Version => RR22Q4
2022-07-04 08:54hgbotNote Added: 0138993
2022-07-04 08:56aaroncaleroStatusresolved => closed

Notes
(0138593)
hgbot   
2022-06-21 13:33   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/merge_requests/829 [^]
(0138992)
hgbot   
2022-07-04 08:54   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/merge_requests/829 [^]
(0138993)
hgbot   
2022-07-04 08:54   
Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal [^]
Changeset: 99d654f0e49c3cffa72e87cfc3e993dde698a7c7
Author: Radhakrishnan Seeman <radhakrishnan@qualiantech.com>
Date: 04-07-2022 06:51:39
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/commit/99d654f0e49c3cffa72e87cfc3e993dde698a7c7 [^]

Fixed ISSUE-49527:Added validation to consume same product in different bins

---
M src/org/openbravo/retail/posterminal/utility/ShipmentUtils.java
---