Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0035009Openbravo ERP04. Warehouse managementpublic2017-01-19 11:042017-10-25 18:37
Reportermalsasua 
Assigned Tocollazoandy4 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0PR17Q2 
Merge Request Status
Review Assigned Tomarkmm82
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0035009: in m_storage_detail, the organization should not be updated
Descriptionwhen one operation affects to the stock, the organization of m_storage_detail affected is updated, but it should not be changed
Steps To Reproducein F&B
. go to Warehouse & Storage bins window:
 . new record: Warehouse Central Spain
 . tab storage bin:
  . new record

. go to Product window:
 . new product:
   . name: test
   . type: Item
   . stocked: Y
  . Tab: price:
    . new record:
      Tarifa Ventas
. go to organization window
 . record F&B Spain
  . tab: Warehouse
   . new record: Warehouse Central Spain
 . record F&B Spain - Region Norte
  . tab: Warehouse
   . new record: Warehouse Central Spain
 . record F&B Spain - Region Sur
  . tab: Warehouse
   . new record: Warehouse Central Spain
. go to inventory window:
 . new record:
  . organization: F&B España
  . warehouse: Warehouse Central Spain
 . new line:
  . product: test
  . Storage bin: Warehouse Central Spain
  . qty 1000
 . process inventory
(new m_storage_detail record has been created to organization F&B España)
. go to goods shipments window
 . new record:
  . organization: F&B Spain - Region Norte
 . new line:
  . product: test
  . qty: 5
(the organization of m_storage_detail record has been changed to F&B Spain - Region Norte)

The organization of m_storage_detail should not be changed
 
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0037201 closed dmiguelez It is not possible to remove negative stock if it exists in more than one warehouse of the same organization 
causes defect 0037168 closed dmiguelez Negative Stock can be obtained although the storage bin is defined as OverIssue = N (not allowing negative stock) 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2017-01-19 11:04malsasuaNew Issue
2017-01-19 11:04malsasuaAssigned To => Triage Finance
2017-01-19 11:04malsasuaModules => Core
2017-01-19 11:04malsasuaResolution time => 1486422000
2017-01-19 11:04malsasuaTriggers an Emergency Pack => No
2017-01-19 15:36markmm82Assigned ToTriage Finance => collazoandy4
2017-01-30 15:49collazoandy4Note Added: 0093936
2017-01-30 15:49collazoandy4Statusnew => scheduled
2017-01-30 22:21hgbotCheckin
2017-01-30 22:21hgbotNote Added: 0093949
2017-01-30 22:21hgbotStatusscheduled => resolved
2017-01-30 22:21hgbotResolutionopen => fixed
2017-01-30 22:21hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/f9f49f3556986cc7b54e3613706455723655c595 [^]
2017-01-30 22:22markmm82Review Assigned To => markmm82
2017-01-30 22:22markmm82Note Added: 0093950
2017-01-30 22:22markmm82Statusresolved => closed
2017-01-30 22:22markmm82Fixed in Version => 3.0PR17Q2
2017-01-31 14:43hgbotCheckin
2017-01-31 14:43hgbotNote Added: 0093957
2017-03-15 20:18hudsonbotCheckin
2017-03-15 20:18hudsonbotNote Added: 0095145
2017-03-15 20:18hudsonbotCheckin
2017-03-15 20:18hudsonbotNote Added: 0095148
2017-10-25 18:37eugeniIssue Monitored: eugeni
2017-10-30 16:14collazoandy4Relationship addedcauses 0037168
2017-10-31 17:26ngarciaRelationship addedrelated to 0037201

Notes
(0093936)
collazoandy4   
2017-01-30 15:49   
As System Administrator
 Go to Module window:
  Select core module and check In development flag
 Go to Windows, tabs and fields
  Select Warehouse & Storage bins record
  Select Bins Content tab
  In the field tab check displayed for Organization field
  Save it

As F&B International Group Admin Role
 - Go to Warehouse & Storage bins window:
    Create a new Record:
      Organization: *
      Name: Warehouse Central Spain
      Location / Address: Central Ave. Spain
      Save it
    Select tab Storage bin
    Create a new Record:
      Search key: central
      Row (x): 10
      Stack (Y): 5
      Level (Z): 0
      Save it
- Go to Product window:
    Create a new Record
      Organization: F&B Spaña SA
      name: test
      type: Item
      stocked: Y
  . Tab: price:
      Create a new record
        Price List Version: Tarifa Ventas
        Unit Price: 5
        List Price: 5
- Go to organization window
    Select the record F&B Spain SA
    Select Warehouse Tab
        Create a new record: Warehouse Central Spain
    Select the record F&B Spain - Region Norte
    Select Warehouse Tab
        Create a new record: Warehouse Central Spain
    Select the record F&B Spain - Region Sur
    Select Warehouse Tab
      Create a new record: Warehouse Central Spain
- Go to Physical inventory window:
    Create a new record
      Organization: F&B España
      Warehouse: Warehouse Central Spain
    Select line tab
    Create a new record
      Product: test
      Storage bin: Warehouse Central Spain
      Quantity count: 1000
    Process inventory
- Check that a new record in Bin contents tab of Warehouse and Storage bin window was created for the organization F&B Spaña
- Go to goods shipments window
  Create a new record
    Organization: F&B Spain - Region Norte
    BP: Alimentos y super mercados, SA
  Create a new line
    Product: test
    Movement quantity: 5
  Process the shipment
- Check that the record created in Bin contents tab of warehouse and Storage bin windows doesn't change the organization to F&B Spain - Region Norte
(0093949)
hgbot   
2017-01-30 22:21   
Repository: erp/devel/pi
Changeset: f9f49f3556986cc7b54e3613706455723655c595
Author: Armaignac <collazoandy4 <at> gmail.com>
Date: Sat Jan 28 10:58:54 2017 -0500
URL: http://code.openbravo.com/erp/devel/pi/rev/f9f49f3556986cc7b54e3613706455723655c595 [^]

Fixes issue 35009: The organization of m_storage_detail affected is updated

Remove from the update of m_storage_detail the organization

---
M src-db/database/model/functions/M_UPDATE_INVENTORY.xml
---
(0093950)
markmm82   
2017-01-30 22:22   
Code review + Testing OK
(0093957)
hgbot   
2017-01-31 14:43   
Repository: erp/devel/pi
Changeset: f73edb66b3eb7d313890626a8cf0bdc5f8b0cb77
Author: Mark <markmm82 <at> gmail.com>
Date: Tue Jan 31 08:39:38 2017 -0500
URL: http://code.openbravo.com/erp/devel/pi/rev/f73edb66b3eb7d313890626a8cf0bdc5f8b0cb77 [^]

Related to issue 35009: Updated copyright

---
M src-db/database/model/functions/M_UPDATE_INVENTORY.xml
---
(0095145)
hudsonbot   
2017-03-15 20:18   
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/54e102bef53e [^]
Maturity status: Test
(0095148)
hudsonbot   
2017-03-15 20:18   
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/54e102bef53e [^]
Maturity status: Test