Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0037201
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 04. Warehouse managementmajoralways2017-10-31 16:012017-11-02 18:22
ReporterngarciaView Statuspublic 
Assigned Todmiguelez 
PriorityurgentResolutionfixedFixed in Version3.0PR18Q1
StatusclosedFix in branchFixed in SCM revisiona3731e13318b
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Todmiguelez
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0037201: It is not possible to remove negative stock if it exists in more than one warehouse of the same organization

DescriptionIt is not possible to remove negative stock if it exists in more than one warehouse of the same organization

You need for instance Openbravo For Retail to obtain negative stock without allowing it

M_CHECK_STOCK database function is checking if the product has negative stock in the m_storage_detail table filtering by organization. Analyze which filter should be used for checking it: storage bin, warehouse...
Steps To ReproduceIn an environment with Openbravo For Retail installed:

In the backend:
   Create a new warehouse for Vall Blanca Store
   Add a locator to it
   Set it's status to OverIssue = 'N' (not allowing negative stock)
   Change the status of all the storage bins of Vall Blanca Store Warehouse warehouse to OverIssue = 'N'. If you get an error that negative stock already exists, leave it as 0 with a physical inventory.
   Set both warehouses as on hand warehouses for Vall Blanca Store and set different priority to them. Remove others.
   Create a new product and add it to 'The White Valley Group Sale Price List' and 'White Valley Group Product List' assortment

In the POS:
   Create a new receipt, add the previously created product and complete it

In the backend:
   Check the goods shipment has been done for the warehouse with highest priority (lowest value in priority field)
   Change the priority of the warehouses in order to modify the order

In the POS:
   Log out and log in again
   Create a new receipt, add the previously created product and complete it

In the backend:
   Check the goods shipment has been done for the warehouse with highest priority (different than the previous one)

At this moment we have negative stock of the same product in two different warehouses of the same organization

Try to increase the stock of one of the warehouses by different documents such as physical inventory, goods movement or goods receipt
Check the following error message is shown:

Insufficient stock for Product <> with UOM <> and Storage Bin <>

You should increase the stock on all the warehouses at once. In documents with warehouse at header level it could cause inconsistent data
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0035009 closedcollazoandy4 in m_storage_detail, the organization should not be updated 
related to defect 0037168 closeddmiguelez Negative Stock can be obtained although the storage bin is defined as OverIssue = N (not allowing negative stock) 

-  Notes
(0100221)
dmiguelez (developer)
2017-11-02 16:40

 Test Plan:

1. Prepare scenario:

In an environment with Openbravo For Retail installed:

In the backend:
   Create a new warehouse for Vall Blanca Store
   Add a locator to it
   Set it's status to OverIssue = 'N' (not allowing negative stock)
   Change the status of all the storage bins of Vall Blanca Store Warehouse warehouse to OverIssue = 'N'. If you get an error that negative stock already exists, leave it as 0 with a physical inventory.
   Set both warehouses as on hand warehouses for Vall Blanca Store and set different priority to them. Remove others.
   Create a new product and add it to 'The White Valley Group Sale Price List' and 'White Valley Group Product List' assortment

In the POS:
   Create a new receipt, add the previously created product and complete it

In the backend:
   Check the goods shipment has been done for the warehouse with highest priority (lowest value in priority field)
   Change the priority of the warehouses in order to modify the order

In the POS:
   Log out and log in again
   Create a new receipt, add the previously created product and complete it

In the backend:
   Check the goods shipment has been done for the warehouse with highest priority (different than the previous one)

At this moment we have negative stock of the same product in two different warehouses of the same organization

2. Physical Inventory (first follow Prepare Scenario steps):

Create a new Physical Inventory for any of the Warehouses with negative Stock of the Product
Create a new Line and set booked quantity = 0
Process the Physical Inventory.
Process completed successfully.

3. Goods Receipt (first follow Prepare Scenario steps):

Create a new Goods Receipt for any of the Warehouses with negative Stock of the Product
Create a new Line with quantity = 1
Process the Goods Receipt
Process completed successfully

4. Goods Movement (first follow Prepare Scenario steps):

First, create a new Physical Inventory to create positive Stock for the Product for any of the two Warehouses
Now, there is positive Stock in one Warehouse and negative stock in the other.

Create a new Goods Movement.
Create a line in which Stock is moved from the Warehouse with positive Stock to the Warehouse with negative Stock.

Try to move more quantity than available Stock.
When completing the Goods Movement it fails.

Try to move the same quantity as the available Stock.
The Goods Movement can be completed successfully.
(0100230)
dmiguelez (developer)
2017-11-02 18:21

 https://code.openbravo.com/erp/devel/pi/rev/a3731e13318b [^]
(0100231)
dmiguelez (developer)
2017-11-02 18:21

 Related to Issue:

https://code.openbravo.com/erp/devel/pi/rev/e0ae38b3f82b [^]
(0100234)
dmiguelez (developer)
2017-11-02 18:22

 Code Review + Testing Ok

- Issue History
Date Modified Username Field Change
2017-10-31 16:01 ngarcia New Issue
2017-10-31 16:01 ngarcia Assigned To => Triage Finance
2017-10-31 16:01 ngarcia Modules => Core
2017-10-31 16:01 ngarcia Resolution time => 1511132400
2017-10-31 16:01 ngarcia Triggers an Emergency Pack => No
2017-10-31 17:25 ngarcia Description Updated View Revisions
2017-10-31 17:25 ngarcia Issue Monitored: networkb
2017-10-31 17:26 ngarcia Relationship added related to 0035009
2017-11-02 13:08 dmiguelez Relationship added related to 0037168
2017-11-02 13:25 dmiguelez Assigned To Triage Finance => dmiguelez
2017-11-02 16:40 dmiguelez Note Added: 0100221
2017-11-02 17:03 dmiguelez Status new => scheduled
2017-11-02 18:21 dmiguelez Note Added: 0100230
2017-11-02 18:21 dmiguelez Status scheduled => resolved
2017-11-02 18:21 dmiguelez Fixed in SCM revision => https://code.openbravo.com/erp/devel/pi/rev/a3731e13318b [^]
2017-11-02 18:21 dmiguelez Resolution open => fixed
2017-11-02 18:21 dmiguelez Note Added: 0100231
2017-11-02 18:21 dmiguelez Fixed in Version => 3.0PR18Q1
2017-11-02 18:22 dmiguelez Review Assigned To => dmiguelez
2017-11-02 18:22 dmiguelez Note Added: 0100234
2017-11-02 18:22 dmiguelez Status resolved => closed

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker