0005500: Pending goods receipt does not wok in PostgreSQL

Description

'Pending Goods Receipt' process does not work in PostgreSQL due to UUID.

ERROR: column "freightamt" 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 Procurement management || Transactions || Pending goods receipt
3) Select value "*" in organization combo box. Then click Search
4) Select a purchase order
5) Click Process button

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

Proposed Solution

Patch attached for ad_forms/MaterialReceiptPending_data.xsql

Tags

UUID project

Attached Files

patch-pending-goods.diff [^] (2,534 bytes) 2008-10-11 12:23 [Show Content] [Hide Content]

### Eclipse Workspace Patch 1.0
#P openbravo
Index: src/org/openbravo/erpCommon/ad_forms/MaterialReceiptPending_data.xsql
===================================================================
--- src/org/openbravo/erpCommon/ad_forms/MaterialReceiptPending_data.xsql	(revision 8303)
+++ src/org/openbravo/erpCommon/ad_forms/MaterialReceiptPending_data.xsql	(working copy)
@@ -80,8 +80,22 @@
   <SqlMethod name="insert" connection="true" type="preparedStatement" return="rowCount">
     <SqlMethodComment></SqlMethodComment>
     <Sql>
-      INSERT INTO M_INOUT(M_INOUT_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY, UPDATED, UPDATEDBY, ISSOTRX, DOCUMENTNO, DOCACTION, DOCSTATUS, POSTED, PROCESSING, PROCESSED, C_DOCTYPE_ID, DESCRIPTION, C_ORDER_ID, DATEORDERED, ISPRINTED, MOVEMENTTYPE, MOVEMENTDATE, DATEACCT, C_BPARTNER_ID, C_BPARTNER_LOCATION_ID, M_WAREHOUSE_ID, POREFERENCE, DELIVERYRULE, FREIGHTCOSTRULE, FREIGHTAMT, DELIVERYVIARULE, M_SHIPPER_ID, C_CHARGE_ID, CHARGEAMT, PRIORITYRULE, DATEPRINTED, C_INVOICE_ID, CREATEFROM, GENERATETO, AD_USER_ID, SALESREP_ID, NOPACKAGES, PICKDATE, SHIPDATE, TRACKINGNO, AD_ORGTRX_ID, C_PROJECT_ID, C_CAMPAIGN_ID, C_ACTIVITY_ID, USER1_ID, USER2_ID, UPDATELINES, ISLOGISTIC, GENERATELINES)
-      VALUES(?,?,?,?,now(),?,now(),?,?,?,?,?,?,?,?,?,?,?,TO_DATE(?),?,?,TO_DATE(?),TO_DATE(?),?,?,?,?,?,?,?,?,?,?,?,?,NULL,NULL,?,?,?,?,NULL,NULL,NULL,NULL,?,?,?,?,?,?,?,?,?)
+      INSERT INTO M_INOUT(M_INOUT_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY, UPDATED, UPDATEDBY, 
+      	ISSOTRX, DOCUMENTNO, DOCACTION, DOCSTATUS, POSTED, PROCESSING, PROCESSED, 
+      	C_DOCTYPE_ID, DESCRIPTION, C_ORDER_ID, DATEORDERED, ISPRINTED, MOVEMENTTYPE, MOVEMENTDATE, 
+      	DATEACCT, C_BPARTNER_ID, C_BPARTNER_LOCATION_ID, M_WAREHOUSE_ID, POREFERENCE, 
+      	DELIVERYRULE, FREIGHTCOSTRULE, FREIGHTAMT, DELIVERYVIARULE, M_SHIPPER_ID, C_CHARGE_ID, CHARGEAMT, 
+      	PRIORITYRULE, DATEPRINTED, C_INVOICE_ID, CREATEFROM, GENERATETO, AD_USER_ID, SALESREP_ID, NOPACKAGES, 
+      	PICKDATE, SHIPDATE, TRACKINGNO, AD_ORGTRX_ID, C_PROJECT_ID, C_CAMPAIGN_ID, C_ACTIVITY_ID, 
+      	USER1_ID, USER2_ID, UPDATELINES, ISLOGISTIC, GENERATELINES)
+      VALUES(?,?,?,?,now(),?,now(),?,
+      	?,?,?,?,?,?,?,
+      	?,?,?,TO_DATE(?),?,?,TO_DATE(?),
+      	TO_DATE(?),?,?,?,?,
+      	?,?,TO_NUMBER(?),?,?,?,TO_NUMBER(?),
+      	?,NULL,NULL,?,?,?,?,NULL,
+      	NULL,NULL,NULL,?,?,?,?,
+      	?,?,?,?,?)
       </Sql>
       <Parameter name="mInoutId"/>
       <Parameter name="adClientId"/>

Relationships [ Relation Graph ] [ Dependency Graph ]

Notes
(0009515) svnbot (reporter) 2008-10-11 12:24	Repository: openbravo Revision: 8582 Author: rafaroda Date: 2008-10-11 12:24:52 +0200 (Sat, 11 Oct 2008) Fixes bug 0005500 'Pending Goods Receipt' process now works in PostgreSQL. --- U trunk/src/org/openbravo/erpCommon/ad_forms/MaterialReceiptPending_data.xsql --- https://dev.openbravo.com/websvn/openbravo/?rev=8582&sc=1 [^]

Issue History
Date Modified	Username	Field	Change
2008-10-11 12:23	rafaroda	New Issue
2008-10-11 12:23	rafaroda	Assigned To	=> rafaroda
2008-10-11 12:23	rafaroda	sf_bug_id	0 => 2159114
2008-10-11 12:23	rafaroda	File Added: patch-pending-goods.diff
2008-10-11 12:23	rafaroda	Regression testing	=> No
2008-10-11 12:24	rafaroda	Tag Attached: UUID project
2008-10-11 12:24	svnbot	Checkin
2008-10-11 12:24	svnbot	Note Added: 0009515
2008-10-11 12:24	svnbot	Status	new => resolved
2008-10-11 12:24	svnbot	Resolution	open => fixed
2008-10-11 12:24	svnbot	svn_revision	=> 8582
2008-12-16 11:28	psarobe	Status	resolved => closed