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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0010710
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 04. Warehouse managementminoralways2009-09-23 11:112009-10-08 00:00
ReporternetworkbView Statuspublic 
Assigned Toharikrishnan 
PriorityhighResolutionfixedFixed in Version2.50MP7
StatusclosedFix in branchFixed in SCM revisionf6c9422cb897
ProjectionnoneETAnoneTarget Version2.40MP11
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version2.40SCM revision 
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
Summary

0010710: Warehouse control report does not filter properly if serial number is used

DescriptionIf a product has a serial number, and its value is used to filter this report, does not find any record. The problem is that it is stored, as serial number, the number + '_'. So, if you fill 154 as serial number, the report does not show any record. However, if you enter 154_, the report shows the product.

Also, if the product has expiration date (154_01-01-2010), does not find any record, even using _ after serial number. In addition to this, it is not possible to enter the whole serial number (154_01-01-2010) in serial number field, so report will ever show this product.
Steps To ReproduceGo to Master Data Management > Product Setup > Serial Number Sequence. Create a new record (just fill name field). Save it.
Go to Master Data Management > Product Setup > Attribute Set. Create a new record. Enter a name, and check Serial No, and Expiration Date. Select as Serial No Control, the existing one. As guaranteed days, 365. Save it.
Go to Master Data Management > Product. Create a new one. Enter its name and select as Attribute Set, the created one.
Go to Warehouse management > Transactions > Physical Inventory. Create a new record. Save it.
Go to its lines. Select as a product, the new one (uncheck "With stock" in the selector). As Attribute Set Value, enter a Serial Number (154) and Expiration date (01-01-2010). Save it.
Go to Header, and press "Process Inventory Count".
Go to Warehouse Management > Analysis Tools > Warehouse control report. Enter as Serial Number, 154. Report does not show any record.
Do not fill Serial number field, and search. The product will appear. Copy its serial number (154_01-01-2010) and try to paste it into Serial Number field. It is not possible because of its length.
Proposed SolutionMake in the HTML the Serial Number field accept much more characters (50).

And the Serial Number comparison should not be equal but like.
In https://code.openbravo.com/erp/devel/pi/file/97dd457bbb50/src/org/openbravo/erpCommon/ad_reports/ReportWarehouseControl_data.xsql [^]
Replace:
<Parameter name="reference" optional="true" after="AND 1=1"><![CDATA[ AND M_ATTRIBUTESETINSTANCE.DESCRIPTION = ?]]></Parameter>
by
<Parameter name="reference" optional="true" after="AND 1=1"><![CDATA[ AND UPPER(M_ATTRIBUTESETINSTANCE.DESCRIPTION) LIKE '%'||UPPER(?)||'%']]></Parameter>
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
depends on backport 00107112.40MP11 closedrafaroda Warehouse control report does not filter properly if serial number is used 

-  Notes
(0020687)
hgbot (developer)
2009-10-05 07:04

 Repository: erp/devel/pi
Changeset: f6c9422cb897ce4af2fda0137f3706da8d1588f6
Author: Harikrishnan Raja <harikrishnan.raja <at> openbravo.com>
Date: Mon Oct 05 10:29:59 2009 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/f6c9422cb897ce4af2fda0137f3706da8d1588f6 [^]

Fixes Issue 10710: Warehouse control report does not filter properly if serial number is used.

---
M src/org/openbravo/erpCommon/ad_reports/ReportWarehouseControl.html
M src/org/openbravo/erpCommon/ad_reports/ReportWarehouseControl_data.xsql
---
(0020809)
sureshbabu (viewer)
2009-10-07 08:29

 Tested working fine, right now report shows the product for all the combination (only serial no, serial no_, serial no_expiry date, serial no%)

- Issue History
Date Modified Username Field Change
2009-09-23 11:11 networkb New Issue
2009-09-23 11:11 networkb Assigned To => rafaroda
2009-09-23 11:11 networkb OBNetwork customer => Yes
2009-09-23 11:11 networkb Target Version => 2.40MP11
2009-09-23 11:59 rafaroda Priority immediate => high
2009-09-23 11:59 rafaroda Steps to Reproduce Updated
2009-09-23 11:59 rafaroda Status new => scheduled
2009-09-23 11:59 rafaroda fix_in_branch => pi
2009-09-23 12:07 rafaroda fix_in_branch pi =>
2009-09-23 12:07 rafaroda Steps to Reproduce Updated
2009-10-05 05:41 harikrishnan Assigned To rafaroda => harikrishnan
2009-10-05 07:04 hgbot Checkin
2009-10-05 07:04 hgbot Note Added: 0020687
2009-10-05 07:04 hgbot Status scheduled => resolved
2009-10-05 07:04 hgbot Resolution open => fixed
2009-10-05 07:04 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/f6c9422cb897ce4af2fda0137f3706da8d1588f6 [^]
2009-10-07 08:29 sureshbabu Status resolved => closed
2009-10-07 08:29 sureshbabu Note Added: 0020809
2009-10-07 08:29 sureshbabu Fixed in Version => 2.50MP7
2009-10-08 00:00 anonymous sf_bug_id 0 => 2874368

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker