Anonymous | Login

Project:

News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ]

[ Issue History ] [ Print ]

ID

0015577

Type

Category

Severity

Reproducibility

Date Submitted

Last Update

backport

[Openbravo ERP] 04. Warehouse management

major

always

2011-01-05 11:19

2011-02-28 19:35

Reporter

xabiermerino

View Status

public

Assigned To

adrianromero

Priority

urgent

Resolution

fixed

Fixed in Version

2.50MP27

Status

closed

Fix in branch

Fixed in SCM revision

Projection

none

ETA

none

Target Version

2.50MP26

OS

Any

Database

Any

Java version

OS Version

Database version

Ant version

Product Version

2.50MP25

SCM revision

Review Assigned To

Web browser

Modules

Core

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

No

Summary

0015577: M_INOUT_CREATE - Products are taken in random order for Goods Shipment etc.

Description

Selection 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;

Tags

No tags attached.

Relationships [ Relation Graph ] [ Dependency Graph ]

depends on

defect

closed

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