0015796: 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

closingMay2011

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

related to	defect	0017003	pi	closed	dalsasua	M_INOUT_CREATE, Products are not taken in the correct order. Movements between bins modifies the FIFO order.
blocks	backport	0015577	2.50MP26	closed	adrianromero	M_INOUT_CREATE - Products are taken in random order for Goods Shipment etc.

Notes
(0033978) hgbot (developer) 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 (manager) 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.

Issue History
Date Modified	Username	Field	Change
2011-01-27 13:26	adrianromero	New Issue
2011-01-27 13:26	adrianromero	Assigned To	=> adrianromero
2011-01-27 13:26	adrianromero	Modules	=> Core
2011-01-27 13:26	adrianromero	Issue generated from	0015577
2011-01-27 13:26	adrianromero	Relationship added	blocks 0015577
2011-01-27 13:27	adrianromero	Status	new => scheduled
2011-01-27 13:27	adrianromero	fix_in_branch	=> pi
2011-02-01 10:07	hgbot	Checkin
2011-02-01 10:07	hgbot	Note Added: 0033978
2011-02-01 10:07	hgbot	Status	scheduled => resolved
2011-02-01 10:07	hgbot	Resolution	open => fixed
2011-02-01 10:07	hgbot	Fixed in SCM revision	=> http://code.openbravo.com/erp/devel/pi/rev/8b442a34aa81307e3fa9728bc416d4288a147cae [^]
2011-02-01 10:10	adrianromero	Note Added: 0033979
2011-05-04 15:03	adrianromero	Relationship added	related to 0017003
2011-05-24 10:08	dalsasua	Tag Attached: closingMay2011
2011-05-24 10:56	dalsasua	Status	resolved => closed