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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0025421
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 04. Warehouse managementminoralways2014-01-02 13:022015-02-04 20:34
ReporterextraView Statuspublic 
Assigned ToAtulOpenbravo 
PriorityimmediateResolutionfixedFixed in Versionpi
StatusclosedFix in branchFixed in SCM revision66b7801263ab
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabasePostgreSQLJava version
OS VersionUbuntuDatabase version9.1Ant version
Product VersionSCM revision 
Review Assigned Toumartirena
Web browserMozilla Firefox
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0025421: Stock availability not updated when a product has no previous stock transaction

DescriptionWhen 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 ReproduceCreate 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).
TagsNo tags attached.
Attached Filespng file icon Screenshot from 2014-01-02 12:37:21.png [^] (103,372 bytes) 2014-01-02 13:02

- Relationships Relation Graph ] Dependency Graph ]

-  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 (reporter)
2015-01-29 18:17

Code Review + Testing OK
(0074198)
hudsonbot (developer)
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

- 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 Web browser Mozilla Firefox => Mozilla Firefox
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


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker