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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0012134
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 04. Warehouse managementminoralways2010-02-04 13:122010-04-19 21:11
ReporternetworkbView Statuspublic 
Assigned Toharikrishnan 
PriorityhighResolutionfixedFixed in Version
StatusclosedFix in branchpiFixed in SCM revision4532bed7aa87
ProjectionnoneETAnoneTarget Version2.40MP12
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version2.40MP11SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0012134: 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 [^]
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
depends on backport 00121712.40MP12 closedharikrishnan Expiration Date Report does not filter data properly 

-  Notes
(0025718)
hgbot (developer)
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 (reporter)
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 (reporter)
2010-04-01 07:15

 Tested & working fine
(0026386)
hudsonbot (developer)
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 [^]

- Issue History
Date Modified Username Field Change
2010-02-04 13:12 networkb New Issue
2010-02-04 13:12 networkb Assigned To => rafaroda
2010-02-08 12:38 rafaroda Proposed Solution updated
2010-02-08 12:39 rafaroda Status new => scheduled
2010-02-08 12:39 rafaroda fix_in_branch => pi
2010-02-11 11:07 rafaroda Assigned To rafaroda => adrianromero
2010-03-25 08:22 harikrishnan Assigned To adrianromero => harikrishnan
2010-03-25 08:57 hgbot Checkin
2010-03-25 08:57 hgbot Note Added: 0025718
2010-03-25 08:57 hgbot Status scheduled => resolved
2010-03-25 08:57 hgbot Resolution open => fixed
2010-03-25 08:57 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/4532bed7aa871e6c7281035e3c4f55a6024e72a8 [^]
2010-03-25 08:57 harikrishnan Note Added: 0025719
2010-04-01 07:15 arunkumar Note Added: 0025850
2010-04-01 07:15 arunkumar Status resolved => closed
2010-04-02 00:00 anonymous sf_bug_id 0 => 2980792
2010-04-19 21:11 hudsonbot Checkin
2010-04-19 21:11 hudsonbot Note Added: 0026386

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker