Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0036723Openbravo ERP04. Warehouse managementpublic2017-08-25 16:502017-10-02 17:58
Reportermarkmm82 
Assigned ToAtulOpenbravo 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0PR17Q4Fixed in Version3.0PR17Q4 
Merge Request Status
Review Assigned Toaferraz
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0036723: New storage bins are created with Undefined-Overissue inventory status instead of Undefined by default
DescriptionWhen new storage bin is created, it set as Undefined-Overissue its inventory
status by default. This allow negative stock in those locators and it shouldn't be the default behaviour.

By default, new storage bins created should be set with Undefined inventory status to don't allow negative stock.

Note: InitializeInventoryStatus.java modulescript should be adapted to set the inventory status with Undefined-Overissue if related client allows negative stock. Right now it is setting inventory status as Undefined if client doesn't allows negative stock.
Steps To ReproduceCreate a new warehouse.
Create a new Storage Bin to it, and notice inventory status field has Undefined-Overissue status by default.
Proposed SolutionSet Undefined as default inventory status when a new storagebin is created.
Additional Information
TagsNo tags attached.
Relationships
related to feature request 0036086 closed dmiguelez Add Inventory Status functionality 
depends on backport 00369553.0PR17Q3.1 closed AtulOpenbravo New storage bins are created with Undefined-Overissue inventory status instead of Undefined by default 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2017-08-25 16:50markmm82New Issue
2017-08-25 16:50markmm82Assigned To => markmm82
2017-08-25 16:50markmm82Modules => Core
2017-08-25 16:50markmm82Triggers an Emergency Pack => No
2017-08-25 17:02markmm82Description Updatedbug_revision_view_page.php?rev_id=15724#r15724
2017-08-25 17:08markmm82SummaryNew storage bins are created with Undefined-Overissue status instead of Undefined by default => New storage bins are created with Undefined-Overissue inventory status instead of Undefined by default
2017-08-25 17:08markmm82Description Updatedbug_revision_view_page.php?rev_id=15725#r15725
2017-08-25 17:08markmm82Steps to Reproduce Updatedbug_revision_view_page.php?rev_id=15727#r15727
2017-08-25 17:08markmm82Proposed Solution updated
2017-09-20 21:14AtulOpenbravoStatusnew => scheduled
2017-09-20 21:14AtulOpenbravoNote Added: 0099193
2017-09-21 19:37hgbotCheckin
2017-09-21 19:37hgbotNote Added: 0099435
2017-09-21 19:37hgbotStatusscheduled => resolved
2017-09-21 19:37hgbotResolutionopen => fixed
2017-09-21 19:37hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/757a15bcdfb8a4fef656859cca918e07c9011e36 [^]
2017-09-21 19:38hgbotCheckin
2017-09-21 19:38hgbotNote Added: 0099436
2017-09-21 19:39aferrazReview Assigned To => aferraz
2017-09-21 19:39aferrazNote Added: 0099437
2017-09-21 19:39aferrazStatusresolved => closed
2017-09-21 19:39aferrazFixed in Version => 3.0PR17Q4
2017-09-22 03:19hudsonbotCheckin
2017-09-22 03:19hudsonbotNote Added: 0099453
2017-09-22 03:19hudsonbotCheckin
2017-09-22 03:19hudsonbotNote Added: 0099454
2017-09-26 13:28hgbotCheckin
2017-09-26 13:28hgbotNote Added: 0099577
2017-09-26 13:59hgbotCheckin
2017-09-26 13:59hgbotNote Added: 0099579
2017-09-26 13:59aferrazRelationship addedrelated to 0036086
2017-09-26 14:04aferrazStatusclosed => new
2017-09-26 14:04aferrazResolutionfixed => open
2017-09-26 14:04aferrazFixed in Version3.0PR17Q4 =>
2017-09-26 14:06aferrazStatusnew => scheduled
2017-09-26 14:07aferrazTarget Version => 3.0PR17Q4
2017-09-26 14:08aferrazStatusscheduled => resolved
2017-09-26 14:08aferrazFixed in Version => 3.0PR17Q4
2017-09-26 14:08aferrazResolutionopen => fixed
2017-09-26 14:08aferrazStatusresolved => closed
2017-09-26 14:10aferrazAssigned Tomarkmm82 => AtulOpenbravo
2017-09-27 00:09hudsonbotCheckin
2017-09-27 00:09hudsonbotNote Added: 0099610
2017-09-27 00:09hudsonbotCheckin
2017-09-27 00:09hudsonbotNote Added: 0099611
2017-10-02 12:40hgbotCheckin
2017-10-02 12:40hgbotNote Added: 0099691
2017-10-02 17:58hudsonbotCheckin
2017-10-02 17:58hudsonbotNote Added: 0099703

Notes
(0099193)
AtulOpenbravo   
2017-09-20 21:14   
- Login and F&B International Group Admin
- Create a new warehouse.
- Create a new Storage Bin to it.
- Realize that inventory status field has Undefined status by default.
(0099435)
hgbot   
2017-09-21 19:37   
Repository: erp/devel/pi
Changeset: 757a15bcdfb8a4fef656859cca918e07c9011e36
Author: Atul Gaware <atul.gaware <at> openbravo.com>
Date: Thu Sep 21 20:24:21 2017 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/757a15bcdfb8a4fef656859cca918e07c9011e36 [^]

Fixes issue 36723: New storage bins are created with Undefined-Overissue status
instead of Undefined by default

** Set id of Undefined inventory status as default value for column m_inventorystatus_id
in m_locator table as well as tables and columns in application dictionary

** Adapt Initialize Inventory Status modulescript to set Undefined-overdue status to
locator of the clients where allow negative stock flag is set as Yes

---
M src-db/database/model/tables/M_LOCATOR.xml
M src-db/database/sourcedata/AD_COLUMN.xml
M src-util/modulescript/build/classes/org/openbravo/modulescript/InitializeInventoryStatus.class
M src-util/modulescript/src/org/openbravo/modulescript/InitializeInventoryStatus.java
---
(0099436)
hgbot   
2017-09-21 19:38   
Repository: erp/devel/pi
Changeset: e2809fc56feeb1082298c840f6b764153cd634e2
Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
Date: Thu Sep 21 18:57:37 2017 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/e2809fc56feeb1082298c840f6b764153cd634e2 [^]

Related to issue 36723: Fix modulescript limits

---
M src-util/modulescript/build/classes/org/openbravo/modulescript/InitializeInventoryStatus.class
M src-util/modulescript/src/org/openbravo/modulescript/InitializeInventoryStatus.java
---
(0099437)
aferraz   
2017-09-21 19:39   
Code review + Testing OK
(0099453)
hudsonbot   
2017-09-22 03:19   
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/79f756868bba [^]
Maturity status: Test
(0099454)
hudsonbot   
2017-09-22 03:19   
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/79f756868bba [^]
Maturity status: Test
(0099577)
hgbot   
2017-09-26 13:28   
Repository: erp/devel/pi
Changeset: a0e824aa61a70518393fb06a472a963f8d5d0a29
Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
Date: Tue Sep 26 12:55:18 2017 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/a0e824aa61a70518393fb06a472a963f8d5d0a29 [^]

Related to issue 36723: Add preference to execute modulescript only once

---
M src-util/modulescript/build/classes/org/openbravo/modulescript/InitializeInventoryStatus.class
M src-util/modulescript/build/classes/org/openbravo/modulescript/InitializeInventoryStatusData.class
M src-util/modulescript/src/org/openbravo/modulescript/InitializeInventoryStatus.java
M src-util/modulescript/src/org/openbravo/modulescript/InitializeInventoryStatus_data.xsql
---
(0099579)
hgbot   
2017-09-26 13:59   
Repository: erp/devel/pi
Changeset: af3110240b935ee6bd02e5c3f92d2139e66ee171
Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
Date: Tue Sep 26 13:26:43 2017 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/af3110240b935ee6bd02e5c3f92d2139e66ee171 [^]

Related to issue 36723: Use attribute to create preference instead of property

---
M src-util/modulescript/build/classes/org/openbravo/modulescript/InitializeInventoryStatusData.class
M src-util/modulescript/src/org/openbravo/modulescript/InitializeInventoryStatus_data.xsql
---
(0099610)
hudsonbot   
2017-09-27 00:09   
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/f8aef32786fd [^]
Maturity status: Test
(0099611)
hudsonbot   
2017-09-27 00:09   
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/f8aef32786fd [^]
Maturity status: Test
(0099691)
hgbot   
2017-10-02 12:40   
Repository: erp/devel/pi
Changeset: cc49d8d5f46bf79bb1d3f43ee92bf165e625c33f
Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
Date: Mon Oct 02 12:02:08 2017 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/cc49d8d5f46bf79bb1d3f43ee92bf165e625c33f [^]

Related to issue 36723: Changes in M_Locator inventory status for QA client

---
M referencedata/sampledata/QA_Testing/M_LOCATOR.xml
---
(0099703)
hudsonbot   
2017-10-02 17:58   
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/44a89970274a [^]
Maturity status: Test