Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0049703Openbravo ERP04. Warehouse managementpublic2022-07-01 18:052022-08-08 10:44
Reporteraxelmercado 
Assigned ToAtulOpenbravo 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product VersionPR22Q2 
Target VersionFixed in VersionPR22Q4 
Merge Request Statusapproved
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket45137
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0049703: Problem when processing physical inventory
DescriptionAn error is generated when trying to process a physical inventory with a product with a different attribute than the product that was previously sold, the latter remaining with negative stock.
Steps To Reproduce1 - In the "Attribute set" window, create a set of attributes with the same configuration as the video.
2 - In the "Attribute" window, create an attribute for the previous set of mandatory type.
3 - In the "Preference" window, activate attributes in Web POS.
4 - In the "Product" window, create a product with the attribute created above.
5 - In the "Assortment" window, add the product (1 unit) to the store.
6 - In the "Physical Inventory" window, create a physical inventory with the above product.
7 - In the "Warehouse and Storage Bins" window, change the status of the storage bin set in the product above to Undefined.
8 - In the Web POS, sell 2 units of the product with the created attribute.
9 - In the "Warehouse and Storage Bins" window, check that the product is in negative stock.
10 - We create another physical inventory with the same product but with another attribute and process it.

Video with the steps:https://www.youtube.com/watch?v=K459NToFEvU [^]

An error is returned without message that applying an existing patch on inventory errors we will notice that it is generated by the product that was in negative stock.
Proposed Solutionsrc/org/openbravo/materialmgmt/InventoryCountProcess.java

We believe that this is due to the fact that in the previously mentioned java that performs the check store function, it only observes the product without looking at the attribute, which when checking the product that was in negative stock, it returns the error.
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2022-07-01 18:05axelmercadoNew Issue
2022-07-01 18:05axelmercadoAssigned To => Triage Omni WMS
2022-07-01 18:05axelmercadoOBNetwork customer => OBPS
2022-07-01 18:05axelmercadoModules => Core
2022-07-01 18:05axelmercadoSupport ticket => 45137
2022-07-01 18:05axelmercadoTriggers an Emergency Pack => No
2022-07-01 18:35PracticsIssue Monitored: Practics
2022-07-15 16:55axelmercadoNote Added: 0139366
2022-08-02 10:19AtulOpenbravoAssigned ToTriage Omni WMS => AtulOpenbravo
2022-08-02 10:19AtulOpenbravoStatusnew => scheduled
2022-08-04 03:00hgbotMerge Request Status => open
2022-08-04 03:00hgbotNote Added: 0139864
2022-08-04 03:48AtulOpenbravoNote Added: 0139865
2022-08-08 10:43hgbotMerge Request Statusopen => approved
2022-08-08 10:44hgbotNote Added: 0139953
2022-08-08 10:44hgbotResolutionopen => fixed
2022-08-08 10:44hgbotStatusscheduled => closed
2022-08-08 10:44hgbotFixed in Version => PR22Q4
2022-08-08 10:44hgbotNote Added: 0139954

Notes
(0139366)
axelmercado   
2022-07-15 16:55   
Any news on this problem? We need it to be reviewed.
(0139864)
hgbot   
2022-08-04 03:00   
Merge Request created: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/667 [^]
(0139865)
AtulOpenbravo   
2022-08-04 03:48   
Test Plan

- For vallblanca user set Default Warehouse as "White Valley Spain Distribution Center"

- For Vall Blanca Store set Local Warehouse in the Retail Configuration as "White Valley Spain Distribution Center". Note: If this field is not displayed
please login as System Admin and set it as Displayed = Yes

- In the Warehouse Tab for "Vall Blanca Store" Organization make sure it has only one warehouse active i.e "White Valley Spain Distribution Center"

- In the "Attribute" window, create an attribute with mandatory flag = Yes.

- In the "Attribute set" window, Create Attribute Set with above Attribute in it.

- In the "Preference" window, activate attributes in Web POS.

- In the "Product" window, create a product with the attribute created above.

- In the "Assortment" window, add the product (1 unit) to the store.

- In the "Physical Inventory" window, create a physical inventory with the above product and active Warehouse Bin.

- In the "Warehouse and Storage Bins" window, change the status of the storage bin set in the product above to Undefined.

- In the Web POS, sell 2 units of the product with the created attribute.

- In the "Warehouse and Storage Bins" window, check that the product is in negative stock.

- Create another physical inventory with the same product but with another attribute and process it.

-Realize that Physical Inventory is processed successfully.
(0139953)
hgbot   
2022-08-08 10:44   
Merge request merged: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/667 [^]
(0139954)
hgbot   
2022-08-08 10:44   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/openbravo [^]
Changeset: f1bf5ab52db496c9ac844115831593a6fb1d379d
Author: Atul Gaware <atul.gaware@openbravo.com>
Date: 07-08-2022 22:00:51
URL: https://gitlab.com/openbravo/product/openbravo/-/commit/f1bf5ab52db496c9ac844115831593a6fb1d379d [^]

Fixed BUG-0049703: Problem when processing physical inventory

**When checking only negative Stock for the Bins of the Lines of
the Physical Inventory consider attribute set values in checkStock
method in Inventory Count Process

---
M src/org/openbravo/materialmgmt/InventoryCountProcess.java
---