Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0012134Openbravo ERP04. Warehouse managementpublic2010-02-04 13:122010-04-19 21:11
Reporternetworkb 
Assigned Toharikrishnan 
PriorityhighSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.40MP11 
Target Version2.40MP12Fixed 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
Summary0012134: Expiration Date Report does not filter data properly
DescriptionWhen you run Expiration Date Report filtering by "Product Expires before" field, more rows than expected are obtained.
Steps To Reproduce1. Warehouse Management || Analysis Tools || Expiration Date Report || Expiration Date Report
2. Set "Product Expires before"= 04-12-2006
3. Run the report
4. Realize that products with date=05-12-2006 appear
Proposed SolutionComparison of dates should be AND COALESCE(M_ATTRIBUTESETINSTANCE.GUARANTEEDATE, TO_DATE('31/12/9999')) < to_date(?) in line https://code.openbravo.com/erp/devel/pi/file/tip/src/org/openbravo/erpCommon/ad_reports/ReportGuaranteeDate_data.xsql#l49 [^]
Additional Information
TagsNo tags attached.
Relationships
depends on backport 00121712.40MP12 closed harikrishnan Expiration Date Report does not filter data properly 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-02-04 13:12networkbNew Issue
2010-02-04 13:12networkbAssigned To => rafaroda
2010-02-08 12:38rafarodaProposed Solution updated
2010-02-08 12:39rafarodaStatusnew => scheduled
2010-02-08 12:39rafarodafix_in_branch => pi
2010-02-11 11:07rafarodaAssigned Torafaroda => adrianromero
2010-03-25 08:22harikrishnanAssigned Toadrianromero => harikrishnan
2010-03-25 08:57hgbotCheckin
2010-03-25 08:57hgbotNote Added: 0025718
2010-03-25 08:57hgbotStatusscheduled => resolved
2010-03-25 08:57hgbotResolutionopen => fixed
2010-03-25 08:57hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/4532bed7aa871e6c7281035e3c4f55a6024e72a8 [^]
2010-03-25 08:57harikrishnanNote Added: 0025719
2010-04-01 07:15arunkumarNote Added: 0025850
2010-04-01 07:15arunkumarStatusresolved => closed
2010-04-02 00:00anonymoussf_bug_id0 => 2980792
2010-04-19 21:11hudsonbotCheckin
2010-04-19 21:11hudsonbotNote Added: 0026386

Notes
(0025718)
hgbot   
2010-03-25 08:57   
Repository: erp/devel/pi
Changeset: 4532bed7aa871e6c7281035e3c4f55a6024e72a8
Author: Harikrishnan Raja <harikrishnan.raja <at> openbravo.com>
Date: Thu Mar 25 13:35:48 2010 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/4532bed7aa871e6c7281035e3c4f55a6024e72a8 [^]

Fixes Issue 12134: Expiration Date Report does not filter data properly.

---
M src/org/openbravo/erpCommon/ad_reports/ReportGuaranteeDate_data.xsql
---
(0025719)
harikrishnan   
2010-03-25 08:57   
Steps to test:
* Go to Warehouse Management || Analysis Tools || Expiration Date Report || Expiration Date Report
* In Product Expires Before field give "04-12-2006" it ll bring the record before the date.
(0025850)
arunkumar   
2010-04-01 07:15   
Tested & working fine
(0026386)
hudsonbot   
2010-04-19 21:11   
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/4532bed7aa87 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/91d98bda46c1 [^]
Tests: http://builds.openbravo.com/view/devel-int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.17088.obx [^]