Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0025421Openbravo ERP04. Warehouse managementpublic2014-01-02 13:022015-02-04 20:34
extra 
AtulOpenbravo 
immediateminoralways
closedfixed 
20Ubuntu
 
pi 
umartirena
Mozilla Firefox
Core
No
0025421: Stock availability not updated when a product has no previous stock transaction
When a product is entered in Openbravo and, immediately after, a sales order is placed for that order, Openbravo does not update the available quantity until a first stock transaction is not performed.
It's typical scenario of companies working in "made to order" mode.
Create two or more products.
Immediately after, create an order for all those products and book it.
For the first product perform an inventory count in order to force a stock movement, then a second inventory count to set back the on hand quantity to zero.
When opening the product selector (see attached picture), for the first product the available quantity is correctly set to a negative number, for the other items is zero (which is wrong since there is a reserved quantity because of an order).
No tags attached.
png Screenshot from 2014-01-02 12:37:21.png (103,372) 2014-01-02 13:02
https://issues.openbravo.com/file_download.php?file_id=6599&type=bug
png
Issue History
2014-01-02 13:02extraNew Issue
2014-01-02 13:02extraAssigned To => dmiguelez
2014-01-02 13:02extraFile Added: Screenshot from 2014-01-02 12:37:21.png
2014-01-02 13:02extraWeb browser => Mozilla Firefox
2014-01-02 13:02extraModules => Core
2014-01-02 13:02extraTriggers an Emergency Pack => No
2014-01-02 13:03extraIssue Monitored: extra
2015-01-22 10:59ngarciaWeb browserMozilla Firefox => Mozilla Firefox
2015-01-22 10:59ngarciaResolution time => 1422226800
2015-01-22 10:59ngarciaAssigned Todmiguelez => Sandrahuguet
2015-01-22 10:59ngarciaPrioritynormal => immediate
2015-01-22 10:59ngarciaversion3.0MP30 =>
2015-01-22 10:59ngarciaIssue Monitored: networkb
2015-01-22 11:19ngarciaIssue Monitored: ngarcia
2015-01-22 13:07SandrahuguetAssigned ToSandrahuguet => AtulOpenbravo
2015-01-29 18:15hgbotCheckin
2015-01-29 18:15hgbotNote Added: 0073915
2015-01-29 18:15hgbotStatusnew => resolved
2015-01-29 18:15hgbotResolutionopen => fixed
2015-01-29 18:15hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/66b7801263ab41bd58deebe36c2f2624ae7f4d6f [^]
2015-01-29 18:17umartirenaReview Assigned To => umartirena
2015-01-29 18:17umartirenaNote Added: 0073916
2015-01-29 18:17umartirenaStatusresolved => closed
2015-01-29 18:17umartirenaFixed in Version => pi
2015-02-04 20:34hudsonbotCheckin
2015-02-04 20:34hudsonbotNote Added: 0074198

Notes
(0073915)
hgbot   
2015-01-29 18:15   
Repository: erp/devel/pi
Changeset: 66b7801263ab41bd58deebe36c2f2624ae7f4d6f
Author: Atul Gaware <atul.gaware <at> openbravo.com>
Date: Thu Jan 22 23:38:18 2015 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/66b7801263ab41bd58deebe36c2f2624ae7f4d6f [^]

Fixes Issue 25421:Stock availability not updated when a product has no
previous stock transaction

If product does not have records in m_storage_detail then they are skipped
in the view as m_storage_pending come after left join.

A solution implements a union of m_storage_detail and m_storage_pending
and grouping is done for qtyonhand, qtyordered, qtyreserved based on
m_product_id and m_warehouse_id

---
M src-db/database/model/views/M_PRODUCT_WAREHOUSE_QTYS_V.xml
---
(0073916)
umartirena   
2015-01-29 18:17   
Code Review + Testing OK
(0074198)
hudsonbot   
2015-02-04 20:34   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/f36c91d0ad63 [^]
Maturity status: Test