Openbravo Issue Tracking System - Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0051294ModulesDistribution Order for Advanced Warehouse Operationspublic2023-01-05 14:582023-05-10 14:15
ReporterAtulOpenbravo 
Assigned ToAtulOpenbravo 
PrioritynormalSeveritymajorReproducibilityalways
StatusscheduledResolutionopen 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Regression date
Regression introduced by commit
Regression level
Review Assigned To
Support ticket
OBNetwork customer
Regression introduced in release
Summary0051294: Reserved Qty in Storage Detail is set negative when reducing quantity in Ongoing DO Line
DescriptionReserved Qty in Storage Detail is set negative when reducing quantity in Ongoing DO Line when DO Line for product without stock is created prior to having stock.
Steps To Reproduce- Login in Back Office using AWOQAAdmin role and US East Coast Organization
- Create a new Product. Do not create stock for it.
- Login into Front End using AWOQAAdmin user and US East Coast Organization
- Create a Distribution Order with above new product set Quantity as 5, Storage Bin as Food001
- Navigate to main menu using Back button do not remove DO.
- Create a Inventory Count for new Product with Quantity as 10, Storage Bin as Food001. Process the Inventory count, confirm the Inventory Count task.
- Realize in the Back Office, Stock Tab in the Product shows Quantity On Hand as 10, Reserved Qty as 0, Allocated Qty as 0.
- In Front End, navigate to Distribution Order that was created prior to create Inventory Count for new Product.
- Using - button in the DO Line reduce the Quantity by 3 i.e Qty is set as 2
- In Back Office realize that Reserved and Allocated Quantity is being set as Negative i.e -3
Proposed Solutionhttps://gitlab.com/openbravo/product/openbravo/-/merge_requests/800 [^]
Additional Information
TagsNo tags attached.
Relationships
related to defect 0050858 closed AtulOpenbravo Openbravo ERP Wrong quantity after an Inventory Count for products with stock 0 
Attached Filespng NegativeReservedQty.png (92,998) 2023-01-05 15:11
https://issues.openbravo.com/file_download.php?file_id=18000&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2023-01-05 14:58AtulOpenbravoNew Issue
2023-01-05 14:58AtulOpenbravoAssigned To => Triage Omni WMS
2023-01-05 15:01AtulOpenbravoSummaryReserved Qty in Storage Detail is set negative when reducing quantity in DO Line => Reserved Qty in Storage Detail is set negative when reducing quantity in Ongoing DO Line
2023-01-05 15:01AtulOpenbravoDescription Updatedbug_revision_view_page.php?rev_id=25352#r25352
2023-01-05 15:10AtulOpenbravoDescription Updatedbug_revision_view_page.php?rev_id=25353#r25353
2023-01-05 15:10AtulOpenbravoSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=25355#r25355
2023-01-05 15:11AtulOpenbravoFile Added: NegativeReservedQty.png
2023-01-05 15:25AtulOpenbravoProposed Solution updated
2023-05-04 10:35mtaalNote Added: 0149283
2023-05-04 10:36mtaalRelationship addedrelated to 0050858
2023-05-04 10:39mtaalNote Added: 0149284
2023-05-10 14:10hgbotNote Added: 0149564
2023-05-10 14:14AtulOpenbravoNote Deleted: 0149283
2023-05-10 14:15AtulOpenbravoStatusnew => scheduled
2023-05-10 14:15AtulOpenbravoNote Added: 0149566
2023-05-10 14:15AtulOpenbravoAssigned ToTriage Omni WMS => AtulOpenbravo

Notes
(0149284)
mtaal   
2023-05-04 10:39   
Note: possibly the solution has to be that the reserved qty/allocated qty should reflect the current allocations/reservations of current open distribution orders
(0149564)
hgbot   
2023-05-10 14:10   
Merge Request created: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/879 [^]
(0149566)
AtulOpenbravo   
2023-05-10 14:15   
- Login in Back Office using AWOQAAdmin role and US East Coast Organization
- Create a new Product. Do not create stock for it.
- Login into Front End using AWOQAAdmin user and US East Coast Organization
- Create a Distribution Order with above new product set Quantity as 5, Storage Bin as Food001
- Navigate to main menu using Back button do not remove DO.
- Create a Inventory Count for new Product with Quantity as 10, Storage Bin as Food001. Process the Inventory count, confirm the Inventory Count task.
- Realize in the Back Office, Stock Tab in the Product shows Quantity On Hand as 10, Reserved Qty as 0, Allocated Qty as 0.
- In Front End, navigate to Distribution Order that was created prior to create Inventory Count for new Product.
- Using - button in the DO Line reduce the Quantity by 3 i.e Qty is set as 2
- In Back Office realize that Reserved and Allocated Quantity is being set as Zero