Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0014929Openbravo ERP01. General setuppublic2010-10-20 07:412011-05-24 10:57
Reportereintelau 
Assigned Toadrianromero 
PrioritylowSeveritytrivialReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS Version5.2
Product Versionpi 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0014929: "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)
Additional Information
TagsclosingMay2011
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-10-20 07:41eintelauNew Issue
2010-10-20 07:41eintelauAssigned To => adrianromero
2010-10-27 17:54hgbotCheckin
2010-10-27 17:54hgbotNote Added: 0032269
2010-10-27 17:54hgbotStatusnew => resolved
2010-10-27 17:54hgbotResolutionopen => fixed
2010-10-27 17:54hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/6592d59a0205f053020576df72f06334cc567fc5 [^]
2010-11-05 12:44hudsonbotCheckin
2010-11-05 12:44hudsonbotNote Added: 0032432
2010-11-17 15:51sureshbabuNote Added: 0032676
2011-05-24 10:02dalsasuaTag Attached: closingMay2011
2011-05-24 10:57dalsasuaStatusresolved => closed

Notes
(0032269)
hgbot   
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   
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   
2010-11-17 15:51   
@Adrian, i have tested the fix, but i am not able to view the alert.