Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0015796Openbravo ERP04. Warehouse managementpublic2011-01-27 13:262011-05-24 10:56
Reporteradrianromero 
Assigned Toadrianromero 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0015796: 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
TagsclosingMay2011
Relationships
related to defect 0017003pi closed dalsasua M_INOUT_CREATE, Products are not taken in the correct order. Movements between bins modifies the FIFO order. 
blocks backport 00155772.50MP26 closed adrianromero M_INOUT_CREATE - Products are taken in random order for Goods Shipment etc. 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-01-27 13:26adrianromeroNew Issue
2011-01-27 13:26adrianromeroAssigned To => adrianromero
2011-01-27 13:26adrianromeroModules => Core
2011-01-27 13:26adrianromeroOBNetwork customer => Yes
2011-01-27 13:26adrianromeroIssue generated from0015577
2011-01-27 13:26adrianromeroRelationship addedblocks 0015577
2011-01-27 13:27adrianromeroStatusnew => scheduled
2011-01-27 13:27adrianromerofix_in_branch => pi
2011-02-01 10:07hgbotCheckin
2011-02-01 10:07hgbotNote Added: 0033978
2011-02-01 10:07hgbotStatusscheduled => resolved
2011-02-01 10:07hgbotResolutionopen => fixed
2011-02-01 10:07hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/8b442a34aa81307e3fa9728bc416d4288a147cae [^]
2011-02-01 10:10adrianromeroNote Added: 0033979
2011-05-04 15:03adrianromeroRelationship addedrelated to 0017003
2011-05-24 10:08dalsasuaTag Attached: closingMay2011
2011-05-24 10:56dalsasuaStatusresolved => closed

Notes
(0033978)
hgbot   
2011-02-01 10:07   
Repository: erp/devel/pi
Changeset: 8b442a34aa81307e3fa9728bc416d4288a147cae
Author: Adrián Romero <adrianromero <at> openbravo.com>
Date: Tue Feb 01 10:06:48 2011 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/8b442a34aa81307e3fa9728bc416d4288a147cae [^]

Fixes issue 0015796: 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
---
(0033979)
adrianromero   
2011-02-01 10:10   
* Testing the issue

Kindly follow the steps to test and verify that now is taken from the locator where has the products created in first place.

* Other areas affected

No other areas affected. It has only been modified an ORDER BY clause in the M_INOUT_CREATE procedure.