Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0055527Openbravo ERP04. Warehouse managementpublic2024-05-20 14:522024-06-13 09:10
sdossantos 
AtulOpenbravo 
normalmajoralways
closedfixed 
5
pi 
PR24Q3 
approved
OBPS
Core
98737
No
0055527: Return to Vendor Issue
With a warehouse with a bin with status scrap, we have the following error in the Return to Vendor:
In line 10, the Storage Bin of the Line has a Not Available Inventory Status. It is not possible to issue a Product from a Not Available Storage Bin

Relation
https://issues.openbravo.com/view.php?id=36796 [^]
1. We define a warehouse with a bin with status scrap
2. We define the routing and routing assignment for issue SO
3. We have stock in bin
4. We make a return to vendor for the item in the scrap bin
5. We make a return to vendor shipment for the previous return
6. When completing the document we get the following error:
Error:
In line 10, the Storage Bin of the Line has a Not Available Inventory Status. It is not possible to issue a Product from a Not Available Storage Bin
No tags attached.
related to defect 0036796 closed dmiguelez Not possible to receive a Return Material for a Bin in a not available status 
? returnToVendorIssue.mp4 (3,344,621) 2024-05-22 20:38
https://issues.openbravo.com/file_download.php?file_id=19809&type=bug
Issue History
2024-05-20 14:52sdossantosNew Issue
2024-05-20 14:52sdossantosAssigned To => Triage Omni WMS
2024-05-20 14:52sdossantosOBNetwork customer => OBPS
2024-05-20 14:52sdossantosModules => Core
2024-05-20 14:52sdossantosSupport ticket => 98737
2024-05-20 14:52sdossantosTriggers an Emergency Pack => No
2024-05-20 15:32PracticsIssue Monitored: Practics
2024-05-22 20:38axelmercadoFile Added: returnToVendorIssue.mp4
2024-05-28 13:55sdossantosReproducibilityhave not tried => always
2024-06-05 15:46AtulOpenbravoStatusnew => scheduled
2024-06-05 15:46AtulOpenbravoAssigned ToTriage Omni WMS => AtulOpenbravo
2024-06-05 15:46AtulOpenbravoRelationship addedrelated to 0036796
2024-06-05 16:03AtulOpenbravoNote Added: 0165620
2024-06-06 05:29hgbotMerge Request Status => open
2024-06-06 05:29hgbotNote Added: 0165622
2024-06-07 12:02AtulOpenbravoNote Added: 0165690
2024-06-07 12:12AtulOpenbravoNote Added: 0165691
2024-06-07 12:12AtulOpenbravoNote Edited: 0165620bug_revision_view_page.php?bugnote_id=0165620#r28074
2024-06-07 12:12AtulOpenbravoNote Edited: 0165690bug_revision_view_page.php?bugnote_id=0165690#r28076
2024-06-07 12:15AtulOpenbravoNote Edited: 0165620bug_revision_view_page.php?bugnote_id=0165620#r28077
2024-06-07 12:16AtulOpenbravoNote Deleted: 0165620
2024-06-07 12:17AtulOpenbravoNote Edited: 0165690bug_revision_view_page.php?bugnote_id=0165690#r28078
2024-06-07 12:18AtulOpenbravoNote Edited: 0165691bug_revision_view_page.php?bugnote_id=0165691#r28080
2024-06-13 09:09hgbotMerge Request Statusopen => approved
2024-06-13 09:10hgbotResolutionopen => fixed
2024-06-13 09:10hgbotStatusscheduled => closed
2024-06-13 09:10hgbotFixed in Version => PR24Q3
2024-06-13 09:10hgbotNote Added: 0165888
2024-06-13 09:10hgbotNote Added: 0165889

Notes
(0165622)
hgbot   
2024-06-06 05:29   
Merge Request created: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/1268 [^]
(0165690)
AtulOpenbravo   
2024-06-07 12:02   
(edited on: 2024-06-07 12:17)
Test Plan A (Goods Shipment / Return From Customer / Return Material Receipt)

- Login as F%B Internal Group Admin
- Go to Warehouse and Storage Bins window
  * Select US West Coast Warehouse
- Move to Storage Bins Tab
  * Select WC-0-0-0 Strorage bin
- Click on Change Status button and select Scrap or any status which does not have Available flag checked. Click on Done.
- Go to Goods Shipment window and create a new record with:
  * Organization: F&B US West Coast
  * Business Partner: Healthy Food Supermarkets, Co.
  * Rest of the fields as defaulted
- Move to Lines Tab and create a new record with:
  * Product: Cola
  * Movement Quantity: 10
  * Storage Bin: WC-0-0-0
  * Rest of the fields as defaulted
- Click on complete button and the Ok.

- Realize that the process fails with the message:
  "In line 10 the Storage Bin of the Line has a Not Available Inventory Status. It is not opssible to issue a Product from a Not Available Storage Bin"

- Go to Warehouse and Storage Bins window
  * Select US West Coast Warehouse
- Move to Storage Bins Tab
  * Select WC-0-0-0 Strorage bin
- Click on Change Status button and select any status that has Available flag checked. Click on Done.

- Process Shipment in previous step.
- Realize that shipment is successful.

- Go to Warehouse and Storage Bins window
  * Select US West Coast Warehouse
- Move to Storage Bins Tab
  * Select WC-0-0-0 Strorage bin
- Click on Change Status button and select Scrap or any status which does not have Available flag checked. Click on Done.

- Go to Return from Customer Window and create a new record with:
  * Organization: F&B US West Coast
  * Business Partner: Healthy Food Supermarkets, Co.
  * Rest of the fields as defaulted
- Click on Pick/Edit Lines
  * Select the record with the same document number and Product as the Goods Shipment created previously
  * Set 10 as returned quantity in the grid
- Click on done and then on Book and Ok.

- Go to Return Material Receipt Window and create a new record with:
  * Organization: F&B US West Coast
  * Business Partner: Healthy Food Supermarkets, Co.
  * Rest of the fields as defaulted
- Click on Pick/Edit Lines
  * Select the record with the same document number and Product as the Return From Customer created previously
  * Set 10 as returned quantity in the grid
- Click on done and then on Complete and Ok.
- Realize that Return Material Receipt is successful.

(0165691)
AtulOpenbravo   
2024-06-07 12:12   
(edited on: 2024-06-07 12:18)
Test Plan B (Goods Receipt / Return To Vendor / Return To Vendor Shipment)

- Login as F&B Admin
- Go to Warehouse and Storage Bins window
  * Select US East Coast Warehouse
- Move to Storage Bins Tab
  * Select EC-0-0-0 Strorage bin
- Click on Change Status button and select Scrap (any status whose Available flag is not checked). Click on Done.

- Go to Goods Receipt window and create a new record with:
  * Organization: F&B US East Coast
  * Business Partner: Be Soft Drinker, Inc.
  * Rest of the fields as defaulted
- Move to Lines Tab and create a new record with:
  * Product: Ale Beer
  * Movement Quantity: 10
  * Storage Bin: EC-0-0-0
  * Rest of the fields as defaulted
- Click on complete button and the Ok
- Realize that Goods Receipt is successful.

- Go to Return to Vendor Window and create a new record with:
  * Organization: F&B US East Coast
  * Business Partner: Be Soft Drinker, Inc.
  * Rest of the fields as defaulted
- Click on Pick/Edit Lines
  * Select the record with the same document number and Product as the Goods Shipment created previously
  * Set 10 as returned in the grid
- Click on done and then on Book and Ok.

- Go to Return to Vendor Shipment Window and create a new record with:
  * Organization: F&B US East Coast
  * Business Partner: Be Soft Drinker, Inc.
  * Rest of the fields as defaulted
- Click on Pick/Edit Lines
  * Select the record with the same document number, Product as in the Return From Customer created previously and Storage Bin as EC-0-0-0
  * Set 10 as returned in the grid
- Click on done and then on Complete and Ok.
- Realize that Return to Vendor Shipment is successful

(0165888)
hgbot   
2024-06-13 09:10   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/openbravo [^]
Changeset: c9d996baafb16bda33c3ed107d8aa89f8dcf6ba7
Author: Atul Gaware <atul.gaware@openbravo.com>
Date: 13-06-2024 07:10:30
URL: https://gitlab.com/openbravo/product/openbravo/-/commit/c9d996baafb16bda33c3ed107d8aa89f8dcf6ba7 [^]

Fixes ISSUE-55527: Allow return to vendor from scrap storage bin

---
M src-db/database/model/functions/M_INOUT_POST.xml
---
(0165889)
hgbot   
2024-06-13 09:10   
Merge request merged: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/1268 [^]