Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0025421 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 04. Warehouse management | minor | always | 2014-01-02 13:02 | 2015-02-04 20:34 | |||
| Reporter | extra | View Status | public | |||||
| Assigned To | AtulOpenbravo | |||||||
| Priority | immediate | Resolution | fixed | Fixed in Version | pi | |||
| Status | closed | Fix in branch | Fixed in SCM revision | 66b7801263ab | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Linux 32 bit | Database | PostgreSQL | Java version | ||||
| OS Version | Ubuntu | Database version | 9.1 | Ant version | ||||
| Product Version | SCM revision | |||||||
| Merge Request Status | ||||||||
| Review Assigned To | umartirena | |||||||
| OBNetwork customer | OBPS | |||||||
| Web browser | Mozilla Firefox | |||||||
| Modules | Core | |||||||
| Support ticket | 33729 | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0025421: Stock availability not updated when a product has no previous stock transaction | |||||||
| Description | 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. | |||||||
| Steps To Reproduce | 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). | |||||||
| Tags | No tags attached. | |||||||
| Attached Files |  Screenshot from 2014-01-02 12:37:21.png [^] (103,372 bytes) 2014-01-02 13:02
| |||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0073915) hgbot (developer) 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 (viewer) 2015-01-29 18:17 |
Code Review + Testing OK |
|
(0074198) hudsonbot (viewer) 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 |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2014-01-02 13:02 | extra | New Issue | |
| 2014-01-02 13:02 | extra | Assigned To | => dmiguelez |
| 2014-01-02 13:02 | extra | File Added: Screenshot from 2014-01-02 12:37:21.png | |
| 2014-01-02 13:02 | extra | Web browser | => Mozilla Firefox |
| 2014-01-02 13:02 | extra | Modules | => Core |
| 2014-01-02 13:02 | extra | Triggers an Emergency Pack | => No |
| 2014-01-02 13:03 | extra | Issue Monitored: extra | |
| 2015-01-22 10:59 | ngarcia | OBNetwork customer | => Yes |
| 2015-01-22 10:59 | ngarcia | Web browser | Mozilla Firefox => Mozilla Firefox |
| 2015-01-22 10:59 | ngarcia | Support ticket | => 33729 |
| 2015-01-22 10:59 | ngarcia | Resolution time | => 1422226800 |
| 2015-01-22 10:59 | ngarcia | Assigned To | dmiguelez => Sandrahuguet |
| 2015-01-22 10:59 | ngarcia | Priority | normal => immediate |
| 2015-01-22 10:59 | ngarcia | version | 3.0MP30 => |
| 2015-01-22 10:59 | ngarcia | Issue Monitored: networkb | |
| 2015-01-22 11:19 | ngarcia | Issue Monitored: ngarcia | |
| 2015-01-22 13:07 | Sandrahuguet | Assigned To | Sandrahuguet => AtulOpenbravo |
| 2015-01-29 18:15 | hgbot | Checkin | |
| 2015-01-29 18:15 | hgbot | Note Added: 0073915 | |
| 2015-01-29 18:15 | hgbot | Status | new => resolved |
| 2015-01-29 18:15 | hgbot | Resolution | open => fixed |
| 2015-01-29 18:15 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/66b7801263ab41bd58deebe36c2f2624ae7f4d6f [^] |
| 2015-01-29 18:17 | umartirena | Review Assigned To | => umartirena |
| 2015-01-29 18:17 | umartirena | Note Added: 0073916 | |
| 2015-01-29 18:17 | umartirena | Status | resolved => closed |
| 2015-01-29 18:17 | umartirena | Fixed in Version | => pi |
| 2015-02-04 20:34 | hudsonbot | Checkin | |
| 2015-02-04 20:34 | hudsonbot | Note Added: 0074198 | |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |