Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0015577Openbravo ERP04. Warehouse managementpublic2011-01-05 11:192011-02-28 19:35
Reporterxabiermerino 
Assigned Toadrianromero 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50MP25 
Target Version2.50MP26Fixed in Version2.50MP27 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0015577: M_INOUT_CREATE - Products are taken in random order for Goods Shipment etc.
DescriptionSelection of products for Goods Shipment is based on PRIORITYNO and M_ATTRIBUTESETINSTANCE_ID which is more or less randomly generated (UUID).

To support FIFO method for taking product instances from warehouse M_INOUT_CREATE function should be based on date of creation field.
Steps To Reproduce- AS Openbravo Admin go to Warehouse Management || Analysis Tools || Stock Report
- Select Foodkit.
- Realize that there are no Foodkit in the Secondary Warehouse
- Go to Warehouse Management || Transactions || Incoming Shipment
- Create two records:
     1.- Header:
             - BP: McGiver
             - Movement Date and Accounting Date: 01-01-2011
             - Warehouse: Secondary Warehouse
       - Line:
             - Storage bin: SL1
             - Product: Beer
             - Attribute Set Value: LB_01-05-2011
             - Movement Quantity: 50
     2.- Header:
             - BP: McGiver
             - Movement Date and Accounting Date: 03-01-2011
             - Warehouse: Secondary Warehouse
       - Line:
             - Storage bin: SL2
             - Product: Beer
             - Attribute Set Value: LA_03-05-2011
             - Movement Quantity: 400
- Complete them
- Now the stock is:
    Beer; 50,00; LB_01-05-2011; Secondary Warehouse;
    Beer; 400,00; LA_03-05-2011; Secondary Warehouse;

- Go to Sales Management || Transactions || Sales Order
- Create a new record:
    - Header:
        - Transaction Document: Standard Order
        - McGiver
        - Order Date: 05-01-2011
        - Warehouse: Secondary warehouse
    - Lines:
        - Product: Beer
        - Warehouse: Secondary Warehouse
        - Ordered Quantity: 23
- Complete it
- Go to Sales Management || Transactions || Create Shipments from Orders
- Select the order created and process.
- Go to Warehouse Management || Analysis Tools || Stock Report
- Select Beer.
- Now the stock is:
    Beer; 50,00; LB_01-05-2011; Secondary Warehouse;
    Beer; 377,00; LA_03-05-2011; Secondary Warehouse;

Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
depends on defect 0015796 closed adrianromero M_INOUT_CREATE - Products are taken in random order for Goods Shipment etc. 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-01-05 11:19xabiermerinoNew Issue
2011-01-05 11:19xabiermerinoAssigned To => adrianromero
2011-01-05 11:19xabiermerinoModules => Core
2011-01-05 11:19xabiermerinoIssue Monitored: networkb
2011-01-19 11:02dmitry_mezentsevIssue Monitored: dmitry_mezentsev
2011-01-27 13:26adrianromeroStatusnew => scheduled
2011-01-27 13:26adrianromerofix_in_branch => pi
2011-01-27 13:26adrianromeroTypedefect => backport
2011-01-27 13:26adrianromerofix_in_branchpi =>
2011-01-27 13:26adrianromeroIssue cloned0015796
2011-01-27 13:26adrianromeroRelationship addeddepends on 0015796
2011-02-01 12:17hgbotCheckin
2011-02-01 12:17hgbotNote Added: 0033985
2011-02-01 12:17hgbotStatusscheduled => resolved
2011-02-01 12:17hgbotResolutionopen => fixed
2011-02-01 12:17hgbotFixed in SCM revision => http://code.openbravo.com/erp/stable/2.50/rev/f8519a39d483ac1cb007ce2bd57ac0be061f6183 [^]
2011-02-28 19:35jonalegriaesarteNote Added: 0034442
2011-02-28 19:35jonalegriaesarteStatusresolved => closed
2011-02-28 19:35jonalegriaesarteFixed in Version => 2.50MP27

Notes
(0033985)
hgbot   
2011-02-01 12:17   
Repository: erp/stable/2.50
Changeset: f8519a39d483ac1cb007ce2bd57ac0be061f6183
Author: Adrián Romero <adrianromero <at> openbravo.com>
Date: Tue Feb 01 10:04:02 2011 +0100
URL: http://code.openbravo.com/erp/stable/2.50/rev/f8519a39d483ac1cb007ce2bd57ac0be061f6183 [^]

Fixes issue 0015577: M_INOUT_CREATE - Products are taken in random order for Goods Shipment etc.
It has been modified the SQL sentence to take first the stocks created in first place based on the CREATED field

---
M src-db/database/model/functions/M_INOUT_CREATE.xml
---
(0034442)
jonalegriaesarte   
2011-02-28 19:35   
Verfied