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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0015577
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] 04. Warehouse managementmajoralways2011-01-05 11:192011-02-28 19:35
ReporterxabiermerinoView Statuspublic 
Assigned Toadrianromero 
PriorityurgentResolutionfixedFixed in Version2.50MP27
StatusclosedFix in branchFixed in SCM revisionf8519a39d483
ProjectionnoneETAnoneTarget Version2.50MP26
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version2.50MP25SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0015577: 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;

TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
depends on defect 0015796 closedadrianromero M_INOUT_CREATE - Products are taken in random order for Goods Shipment etc. 

-  Notes
(0033985)
hgbot (developer)
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 (reporter)
2011-02-28 19:35

Verfied

- Issue History
Date Modified Username Field Change
2011-01-05 11:19 xabiermerino New Issue
2011-01-05 11:19 xabiermerino Assigned To => adrianromero
2011-01-05 11:19 xabiermerino Modules => Core
2011-01-05 11:19 xabiermerino Issue Monitored: networkb
2011-01-19 11:02 dmitry_mezentsev Issue Monitored: dmitry_mezentsev
2011-01-27 13:26 adrianromero Status new => scheduled
2011-01-27 13:26 adrianromero fix_in_branch => pi
2011-01-27 13:26 adrianromero Type defect => backport
2011-01-27 13:26 adrianromero fix_in_branch pi =>
2011-01-27 13:26 adrianromero Issue cloned 0015796
2011-01-27 13:26 adrianromero Relationship added depends on 0015796
2011-02-01 12:17 hgbot Checkin
2011-02-01 12:17 hgbot Note Added: 0033985
2011-02-01 12:17 hgbot Status scheduled => resolved
2011-02-01 12:17 hgbot Resolution open => fixed
2011-02-01 12:17 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/stable/2.50/rev/f8519a39d483ac1cb007ce2bd57ac0be061f6183 [^]
2011-02-28 19:35 jonalegriaesarte Note Added: 0034442
2011-02-28 19:35 jonalegriaesarte Status resolved => closed
2011-02-28 19:35 jonalegriaesarte Fixed in Version => 2.50MP27


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker