Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0010710 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 04. Warehouse management | minor | always | 2009-09-23 11:11 | 2009-10-08 00:00 | |||
| Reporter | networkb | View Status | public | |||||
| Assigned To | harikrishnan | |||||||
| Priority | high | Resolution | fixed | Fixed in Version | 2.50MP7 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | f6c9422cb897 | ||||
| Projection | none | ETA | none | Target Version | 2.40MP11 | |||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | 2.40 | SCM revision | ||||||
| Review Assigned To | ||||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0010710: Warehouse control report does not filter properly if serial number is used | |||||||
| Description | If 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 Reproduce | Go 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 Solution | Make 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> | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
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 (reporter) 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%) |
|
Notes |
|
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 | 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 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |