Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0036796Openbravo ERP04. Warehouse managementpublic2017-09-05 17:562017-09-21 16:49
dmiguelez 
dmiguelez 
urgentmajoralways
closedfixed 
30Openbravo Appliance 14.04
 
3.0PR17Q4 
aferraz
Core
QA functional test
2017-04-07
main
https://code.openbravo.com/erp/devel/pi/rev/094c025e0735 [^]
No
0036796: Not possible to receive a Return Material for a Bin in a not available status
It is not possible to receive a Return Material for a Bin in a not available status. However, this restriction should only be applied when the stock is leaving the Warehouse, not when is entering it)
Login as F&B Admin

1.-
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

2.-
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 Blocked. Click on Done.

3.-
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 in the grid
click on done and then on Book and Ok.

4.-
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 in the grid
click on done and then on Complete and Ok.

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
No tags attached.
depends on backport 00367983.0PR17Q3 closed dmiguelez Not possible to receive a Return Material for a Bin in a not available status 
caused by feature request 0036086 closed dmiguelez Add Inventory Status functionality 
Issue History
2017-09-05 17:56dmiguelezNew Issue
2017-09-05 17:56dmiguelezAssigned To => Triage Finance
2017-09-05 17:56dmiguelezModules => Core
2017-09-05 17:56dmiguelezTriggers an Emergency Pack => No
2017-09-05 17:57dmiguelezNote Added: 0098841
2017-09-05 18:02dmiguelezNote Added: 0098845
2017-09-05 18:02dmiguelezNote Edited: 0098845bug_revision_view_page.php?bugnote_id=0098845#r15819
2017-09-05 18:09dmiguelezRegression level => QA functional test
2017-09-05 18:09dmiguelezRegression date => 2017-04-07
2017-09-05 18:09dmiguelezRegression introduced in release => main
2017-09-05 18:09dmiguelezRegression introduced by commit => https://code.openbravo.com/erp/devel/pi/rev/094c025e0735 [^]
2017-09-05 18:47dmiguelezStatusnew => scheduled
2017-09-05 18:47dmiguelezAssigned ToTriage Finance => dmiguelez
2017-09-06 08:51hgbotCheckin
2017-09-06 08:51hgbotNote Added: 0098856
2017-09-06 08:51hgbotStatusscheduled => resolved
2017-09-06 08:51hgbotResolutionopen => fixed
2017-09-06 08:51hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/704736d841a9c576a92c1083d7bc4f982ec709c9 [^]
2017-09-06 09:04aferrazRelationship addedcaused by 0036086
2017-09-06 16:56aferrazReview Assigned To => aferraz
2017-09-06 16:56aferrazNote Added: 0098867
2017-09-06 16:56aferrazStatusresolved => closed
2017-09-06 16:56aferrazFixed in Version => 3.0PR17Q4
2017-09-21 16:49hudsonbotCheckin
2017-09-21 16:49hudsonbotNote Added: 0099362

Notes
(0098841)
dmiguelez   
2017-09-05 17:57   
Test Plan

First Test:

Login as F&B Admin

1.-
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

2.-
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 Blocked. Click on Done.

3.-
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 in the grid
click on done and then on Book and Ok.

4.-
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 in the grid
click on done and then on Complete and Ok.

The process is completed successfully
(0098845)
dmiguelez   
2017-09-05 18:02   
Second test plan:

Login as F&B Admin

1.-
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 Blocked. Click on Done.

2.-
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

3.-
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.

4.-
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 and Product as the Return From Customer created previously
* Set 10 as returned in the grid
click on done and then on Complete and Ok.

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

5.-
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 Available. Click on Done.

6.-
Move back to Return To Vendor Shipment and select the previous record.
Complete the document and now the process is successful

(0098856)
hgbot   
2017-09-06 08:51   
Repository: erp/devel/pi
Changeset: 704736d841a9c576a92c1083d7bc4f982ec709c9
Author: David Miguelez <david.miguelez <at> openbravo.com>
Date: Tue Sep 05 18:46:27 2017 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/704736d841a9c576a92c1083d7bc4f982ec709c9 [^]

Fixes Issue 36796. Check that the Inventory Status of the Bin has the
Available flag checked for Goods Shipments and Return To Vendor Shipments
(outgoing warehouse transactions in the M_INOUT_POST)

---
M src-db/database/model/functions/M_INOUT_POST.xml
---
(0098867)
aferraz   
2017-09-06 16:56   
Code review OK
(0099362)
hudsonbot   
2017-09-21 16:49   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/9750b78d3e5c [^]
Maturity status: Test