Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0012171Openbravo ERP04. Warehouse managementpublic2010-02-04 13:122010-04-13 15:36
Reporternetworkb 
Assigned Toharikrishnan 
PriorityhighSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.40MP11 
Target Version2.40MP12Fixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0012171: 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
blocks defect 00121342.40MP12 closed harikrishnan Expiration Date Report does not filter data properly 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-02-08 12:39rafarodaTypedefect => backport
2010-02-08 12:39rafarodafix_in_branch => 2.40
2010-02-11 11:07rafarodaAssigned Torafaroda => adrianromero
2010-03-25 08:16harikrishnanAssigned Toadrianromero => harikrishnan
2010-03-25 08:18hgbotCheckin
2010-03-25 08:18hgbotNote Added: 0025716
2010-03-25 08:18hgbotStatusscheduled => resolved
2010-03-25 08:18hgbotResolutionopen => fixed
2010-03-25 08:18hgbotFixed in SCM revision => http://code.openbravo.com/erp/stable/2.40/rev/9890f907a69bfad63fd37b67bd2b736bafe60aed [^]
2010-03-25 08:19harikrishnanNote Added: 0025717
2010-04-13 15:36psarobeStatusresolved => closed

Notes
(0025716)
hgbot   
2010-03-25 08:18   
Repository: erp/stable/2.40
Changeset: 9890f907a69bfad63fd37b67bd2b736bafe60aed
Author: Harikrishnan Raja <harikrishnan.raja <at> openbravo.com>
Date: Thu Mar 25 12:56:18 2010 +0530
URL: http://code.openbravo.com/erp/stable/2.40/rev/9890f907a69bfad63fd37b67bd2b736bafe60aed [^]

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

---
M src/org/openbravo/erpCommon/ad_reports/ReportGuaranteeDate_data.xsql
---
(0025717)
harikrishnan   
2010-03-25 08:19   
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.