Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0005521Openbravo ERP04. Warehouse managementpublic2008-10-14 16:092008-12-16 11:14
Reporterrafaroda 
Assigned Torafaroda 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionUbuntu 7.10
Product Versionpi 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0005521: 'Invoice Consignment Report' filter window fails in PostgreSQL
DescriptionDue to UUID changes, filter window of 'Invoice Consignment Report' does not work.
Steps To Reproduce1) Using PostgreSQL, go to 'Warehouse Management || Analysis Tools || Invoice Consignment Report'.

14:54:44 [http-8384-Processor24] ERROR org.openbravo.erpCommon.utility.ComboTableData - Error of SQL in query: SELECT td0.M_Warehouse_ID AS ID, (COALESCE(TO_CHAR(TO_CHAR(td0.Name)),'')) AS NAME, '' AS DESCRIPTION
FROM M_Warehouse td0
WHERE td0.AD_Client_ID IN (1000000)
AND td0.AD_Org_ID IN ('0','1000000')
AND td0.AD_Client_ID=?
AND (td0.isActive = 'Y' OR td0.M_Warehouse_ID = (?) )
ORDER BY 2Exception:org.postgresql.util.PSQLException: ERROR: operator does not exist: character varying = integer
14:54:44 [http-8384-Processor24] ERROR org.openbravo.erpCommon.ad_reports.ReportToInvoiceConsignmentJR - Error captured: javax.servlet.ServletException: 0

Proposed SolutionPatch attached for ad_reports/ReportToInvoiceConsignmentJR.java
Additional Information
TagsUUID project
Relationships
Attached Filesdiff patch-invoice-to-consignment.diff (1,229) 2008-10-14 16:09
https://issues.openbravo.com/file_download.php?file_id=326&type=bug
Issue History
Date ModifiedUsernameFieldChange
2008-10-14 16:09rafarodaNew Issue
2008-10-14 16:09rafarodaAssigned To => rafaroda
2008-10-14 16:09rafarodasf_bug_id0 => 2166221
2008-10-14 16:09rafarodaFile Added: patch-invoice-to-consignment.diff
2008-10-14 16:09rafarodaRegression testing => No
2008-10-14 16:12rafarodaTag Attached: UUID project
2008-10-14 16:13svnbotCheckin
2008-10-14 16:13svnbotNote Added: 0009564
2008-10-14 16:13svnbotStatusnew => resolved
2008-10-14 16:13svnbotResolutionopen => fixed
2008-10-14 16:13svnbotsvn_revision => 8717
2008-12-16 11:14psarobeStatusresolved => closed

Notes
(0009564)
svnbot   
2008-10-14 16:13   
Repository: openbravo
Revision: 8717
Author: rafaroda
Date: 2008-10-14 16:13:47 +0200 (Tue, 14 Oct 2008)

Fixes bug 0005521 Now 'Invoice Consignment Report' filter window works in PostgreSQL.

---
U trunk/src/org/openbravo/erpCommon/ad_reports/ReportToInvoiceConsignmentJR.java
---

https://dev.openbravo.com/websvn/openbravo/?rev=8717&sc=1 [^]