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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0012171
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] 04. Warehouse managementminoralways2010-02-04 13:122010-04-13 15:36
ReporternetworkbView Statuspublic 
Assigned Toharikrishnan 
PriorityhighResolutionfixedFixed in Version
StatusclosedFix in branch2.40Fixed in SCM revision9890f907a69b
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

0012171: 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 ]
blocks defect 00121342.40MP12 closedharikrishnan Expiration Date Report does not filter data properly 

-  Notes
(0025716)
hgbot (developer)
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 (reporter)
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.

- Issue History
Date Modified Username Field Change
2010-02-08 12:39 rafaroda Type defect => backport
2010-02-08 12:39 rafaroda fix_in_branch => 2.40
2010-02-11 11:07 rafaroda Assigned To rafaroda => adrianromero
2010-03-25 08:16 harikrishnan Assigned To adrianromero => harikrishnan
2010-03-25 08:18 hgbot Checkin
2010-03-25 08:18 hgbot Note Added: 0025716
2010-03-25 08:18 hgbot Status scheduled => resolved
2010-03-25 08:18 hgbot Resolution open => fixed
2010-03-25 08:18 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/stable/2.40/rev/9890f907a69bfad63fd37b67bd2b736bafe60aed [^]
2010-03-25 08:19 harikrishnan Note Added: 0025717
2010-04-13 15:36 psarobe Status resolved => closed

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker