Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0005500Openbravo ERP03. Procurement managementpublic2008-10-11 12:232008-12-16 11:28
rafaroda 
rafaroda 
normalminoralways
closedfixed 
20Ubuntu 7.10
pi 
 
Core
No
0005500: Pending goods receipt does not wok in PostgreSQL
'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
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
Patch attached for ad_forms/MaterialReceiptPending_data.xsql
UUID project
diff patch-pending-goods.diff (2,534) 2008-10-11 12:23
https://issues.openbravo.com/file_download.php?file_id=318&type=bug
Issue History
2008-10-11 12:23rafarodaNew Issue
2008-10-11 12:23rafarodaAssigned To => rafaroda
2008-10-11 12:23rafarodasf_bug_id0 => 2159114
2008-10-11 12:23rafarodaFile Added: patch-pending-goods.diff
2008-10-11 12:23rafarodaRegression testing => No
2008-10-11 12:24rafarodaTag Attached: UUID project
2008-10-11 12:24svnbotCheckin
2008-10-11 12:24svnbotNote Added: 0009515
2008-10-11 12:24svnbotStatusnew => resolved
2008-10-11 12:24svnbotResolutionopen => fixed
2008-10-11 12:24svnbotsvn_revision => 8582
2008-12-16 11:28psarobeStatusresolved => closed

Notes
(0009515)
svnbot   
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 [^]