Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0053344Openbravo ERP04. Warehouse managementpublic2023-08-31 11:312023-10-04 12:01
Reporterphilippe_mui 
Assigned ToAtulOpenbravo 
PrioritylowSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in VersionPR23Q4 
Merge Request Statusapproved
Review Assigned To
OBNetwork customerGold
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0053344: 0 and negative stocks are not shown in Lookup
DescriptionProducts with stock=0 or negative stock are not shown in Lookup menu

(No Jira linked to this mantis)
Steps To ReproduceLog in AWO
Scan a product with stock=0 or with stock =-2

Current behavior : Nothing is displayed

Expected behavior : Stock of the product is displayed even it is 0 or negative
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2023-08-31 11:31philippe_muiNew Issue
2023-08-31 11:31philippe_muiAssigned To => Triage Omni WMS
2023-08-31 11:31philippe_muiOBNetwork customer => Gold
2023-08-31 11:31philippe_muiModules => Core
2023-08-31 11:31philippe_muiTriggers an Emergency Pack => No
2023-09-06 15:27mtaalAssigned ToTriage Omni WMS => agusti_gallego
2023-09-08 10:58mtaalAssigned Toagusti_gallego => AtulOpenbravo
2023-09-12 15:17AtulOpenbravoStatusnew => scheduled
2023-09-12 15:20hgbotMerge Request Status => open
2023-09-12 15:20hgbotNote Added: 0154736
2023-09-12 15:24AtulOpenbravoNote Added: 0154737
2023-09-12 21:02AtulOpenbravoNote Added: 0154752
2023-09-13 11:24hgbotMerge Request Statusopen => approved
2023-09-13 11:27hgbotResolutionopen => fixed
2023-09-13 11:27hgbotStatusscheduled => closed
2023-09-13 11:27hgbotNote Added: 0154779
2023-09-13 11:27hgbotNote Added: 0154780
2023-10-04 12:01mtaalFixed in Version => PR23Q4

Notes
(0154736)
hgbot   
2023-09-12 15:20   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations/-/merge_requests/172 [^]
(0154737)
AtulOpenbravo   
2023-09-12 15:24   
Test Plan

- Login in AWO Back Office
- Set preference Show zero and negative stock products in lookup as Y
- Login in AWO Front End
- Create a DO OTF for product which has stock and make sure quantity in DO is set such that the stock of product turns out to be negative.
- Confirm the DO.
- Navigate to Lookup.
- Try to search product used in above DO that has negative stock.
- Realize that records for such products are shown in the list.
(0154752)
AtulOpenbravo   
2023-09-12 21:02   
http://wiki.openbravo.com/wiki/Modules:Advanced_Warehouse_Operations#Preference:_Show_zero_and_negative_stock_products_in_lookup [^]
(0154779)
hgbot   
2023-09-13 11:27   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations [^]
Changeset: 3bc0787010d3aa409f7971a4ac810e9fb7f28d36
Author: Atul Gaware <atul.gaware@openbravo.com>
Date: 12-09-2023 13:20:45
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations/-/commit/3bc0787010d3aa409f7971a4ac810e9fb7f28d36 [^]

Fixes BUG-0053344: 0 and negative stocks are not shown in Lookup

**New preference added to handle this requirement to show zero
and negative stock products in Lookup. If the preference is
set with value Y then quantityOnHand > 0 condition is not
added in the query, if preference is not set or is set to N
then query is added with condition quantityOnHand > 0.

---
M src-db/database/sourcedata/AD_REF_LIST.xml
M src/org/openbravo/warehouse/advancedwarehouseoperations/mobile/datasources/Inventory.java
---
(0154780)
hgbot   
2023-09-13 11:27   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations/-/merge_requests/172 [^]