0005499: Remittance Create Lines From does not work in PostgreSQL

Description

'Create Lines From' in 'Remittance' window does not work in PostgreSQL due to UUID issue:
ERROR: column "line" is of type numeric but expression is of type character varying

Steps To Reproduce

1) Login as Openbravo. Role different than System administrator
2) Go to Financial management || Receivables and payables || Transactions || Remittance
3) Click New and fill:
3.1) Name
3.2) Remittance type
3.3) Bank Account. Save
4) Click "Create lines from" and select the business partner
5) Click Search and select two payments. Click OK

ERROR: column "line" is of type numeric but expression is of type character varying

Proposed Solution

Patch attached for ad_actionButton/CreateFrom_CRemittance_data.xsql

Tags

UUID project

Attached Files

patch-remittance.diff [^] (1,317 bytes) 2008-10-11 11:55 [Show Content] [Hide Content]

### Eclipse Workspace Patch 1.0
#P openbravo
Index: src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_CRemittance_data.xsql
===================================================================
--- src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_CRemittance_data.xsql	(revision 8303)
+++ src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_CRemittance_data.xsql	(working copy)
@@ -12,7 +12,7 @@
  * under the License. 
  * The Original Code is Openbravo ERP. 
  * The Initial Developer of the Original Code is Openbravo SL 
- * All portions are Copyright (C) 2001-2006 Openbravo SL 
+ * All portions are Copyright (C) 2001-2008 Openbravo SL 
  * All Rights Reserved. 
  * Contributor(s):  ______________________________________.
  ************************************************************************
@@ -113,7 +113,7 @@
         insert into C_RemittanceLine(C_REMITTANCELINE_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, 
                                      CREATED, CREATEDBY, UPDATED, UPDATEDBY, C_REMITTANCE_ID, LINE, C_DEBT_PAYMENT_ID)
          SELECT ?,?, AD_ORG_ID ,'Y', 
-                now(), ?, now(), ?, ?,?, C_DEBT_PAYMENT_ID
+                now(), ?, now(), ?, ?,TO_NUMBER(?), C_DEBT_PAYMENT_ID
                 FROM C_DEBT_PAYMENT
                 WHERE C_DEBT_PAYMENT_ID = ?
         ]]>

Relationships [ Relation Graph ] [ Dependency Graph ]

Notes
(0009514) svnbot (reporter) 2008-10-11 11:57	Repository: openbravo Revision: 8581 Author: rafaroda Date: 2008-10-11 11:57:06 +0200 (Sat, 11 Oct 2008) Fixes bug 0005499 Now 'Create Lines From' button inside 'Remittance' window works in PostgreSQL. --- U trunk/src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_CRemittance_data.xsql --- https://dev.openbravo.com/websvn/openbravo/?rev=8581&sc=1 [^]

Issue History
Date Modified	Username	Field	Change
2008-10-11 11:55	rafaroda	New Issue
2008-10-11 11:55	rafaroda	Assigned To	=> rafaroda
2008-10-11 11:55	rafaroda	sf_bug_id	0 => 2159077
2008-10-11 11:55	rafaroda	File Added: patch-remittance.diff
2008-10-11 11:55	rafaroda	Regression testing	=> No
2008-10-11 11:56	rafaroda	Tag Attached: UUID project
2008-10-11 11:57	svnbot	Checkin
2008-10-11 11:57	svnbot	Note Added: 0009514
2008-10-11 11:57	svnbot	Status	new => resolved
2008-10-11 11:57	svnbot	Resolution	open => fixed
2008-10-11 11:57	svnbot	svn_revision	=> 8581
2008-12-16 11:29	psarobe	Status	resolved => closed