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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0014929
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 01. General setuptrivialalways2010-10-20 07:412011-05-24 10:57
ReportereintelauView Statuspublic 
Assigned Toadrianromero 
PrioritylowResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision6592d59a0205
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabasePostgreSQLJava version1.6
OS Version5.2Database version8.3Ant version1.7
Product VersionpiSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0014929: "Products under stock" alert does not fire when a product has no stock records

DescriptionWhen you enable the "Products under stock" alert and setup a minimum stock level for a new product, the alert is not fired even though there is zero stock for the product.

If you enter some stock for the product (shipment or inventory), then from that point on the alert will fire when the stock level fall below the minimum
Steps To Reproduce1) Enable the alerts process
2) Enable the products under stock alert
3) Create a new product (.e.g. Pen)
4) Set a minimum stock level for that product (e.g. 1000)
5) Wait for the alert to be fired - this never occurs

6) Enter some physical inventory for the product that is less that minimum (e.g. 2 units)
7) Wait for the alert to be fired - this time it works
Proposed SolutionAlter the sql for the products under stock alert to treat no stock records as equivalent to zero stock (instead of null)
TagsclosingMay2011
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]

-  Notes
(0032269)
hgbot (developer)
2010-10-27 17:54

 Repository: erp/devel/pi
Changeset: 6592d59a0205f053020576df72f06334cc567fc5
Author: Adrián Romero <adrianromero <at> openbravo.com>
Date: Wed Oct 27 17:54:27 2010 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/6592d59a0205f053020576df72f06334cc567fc5 [^]

Fixes issue 14929: If no storage records for product treat as zero stock
Alter the sql for the products under stock alert to treat no stock records as equivalent to zero stock (instead of null)
On behalf of Ben Sommerville

---
M src-db/database/sourcedata/referencedData/AD_ALERTRULE.xml
---
(0032432)
hudsonbot (developer)
2010-11-05 12:44

 A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/6592d59a0205 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/f2cf138fa03c [^]
Tests: http://builds.openbravo.com/view/int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.18797.obx [^]
(0032676)
sureshbabu (reporter)
2010-11-17 15:51

 @Adrian, i have tested the fix, but i am not able to view the alert.

- Issue History
Date Modified Username Field Change
2010-10-20 07:41 eintelau New Issue
2010-10-20 07:41 eintelau Assigned To => adrianromero
2010-10-27 17:54 hgbot Checkin
2010-10-27 17:54 hgbot Note Added: 0032269
2010-10-27 17:54 hgbot Status new => resolved
2010-10-27 17:54 hgbot Resolution open => fixed
2010-10-27 17:54 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/6592d59a0205f053020576df72f06334cc567fc5 [^]
2010-11-05 12:44 hudsonbot Checkin
2010-11-05 12:44 hudsonbot Note Added: 0032432
2010-11-17 15:51 sureshbabu Note Added: 0032676
2011-05-24 10:02 dalsasua Tag Attached: closingMay2011
2011-05-24 10:57 dalsasua Status resolved => closed

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker