Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0005214Openbravo ERP09. Financial managementpublic2008-09-23 18:042009-01-26 10:16
Reporterrafaroda 
Assigned Torafaroda 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionUbuntu 7.10
Product Versionpi 
Target VersionFixed in Version2.35 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0005214: 'Generate Cash Flow Statement'/'Create Cash Flow Statement' does not work in PostgreSQL
Description'Generate Cash Flow Statement' (trunk) /'Create Cash Flow Statement' (branches 2.40 and 2.3x) does not work in PostgreSQL with errors:

1 - TRUNK)
17:48:39 [ajp-8009-10] ERROR org.openbravo.erpCommon.ad_process.CreateCashFlowStatementData - SQL error in query: INSERT INTO FACT_ACCT_CFS (FACT_ACCT_CFS_ID, FACT_ACCT_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY, UPDATED, UPDATEDBY, ACCOUNT_ID, AMOUNT, FACT_ACCT_REF_ID) VALUES (?,?,?,?,'Y',NOW(),?,NOW(),?,?,?,?)Exception:org.postgresql.util.PSQLException: ERROR: column "amount" is of type numeric but expression is of type character varying
17:48:39 [ajp-8009-10] WARN org.openbravo.erpCommon.ad_process.CreateCashFlowStatement - Rollback in transaction

2 - BRANCHES 2.40 - 2.3x
17:50:02 [ajp-8009-10] ERROR org.openbravo.erpCommon.ad_process.CreateCashFlowStatementData - SQL error in query: INSERT INTO FACT_ACCT_CFS (FACT_ACCT_CFS_ID, FACT_ACCT_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY, UPDATED, UPDATEDBY, ACCOUNT_ID, AMOUNT, FACT_ACCT_REF_ID) VALUES (?,?,?,?,'Y',NOW(),?,NOW(),?,?,?,?)Exception:org.postgresql.util.PSQLException: ERROR: column "fact_acct_cfs_id" is of type numeric but expression is of type character varying
17:50:02 [ajp-8009-10] WARN org.openbravo.erpCommon.ad_process.CreateCashFlowStatement - Rollback in transaction

Steps To Reproduce1 - TRUNK) Go to 'Financial Management || Accounting || Analysis Tools || Generate Cash Flow Statement'
2 - BRANCHES 2.40 - 2.3x) Go to 'Financial Management || Accounting || Analysis Tools || Create Cash Flow Statement'
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
has duplicate defect 0005456 closed cromero Create cash flow statement don't work 
blocks defect 0005212 closed rafaroda 'Generate Cash Flow Statement'/'Create Cash Flow Statement' does not work in PostgreSQL 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-09-23 18:04rafarodaNew Issue
2008-09-23 18:04rafarodaAssigned To => rafaroda
2008-09-23 18:04rafarodaStatusnew => scheduled
2008-09-25 11:58svnbotCheckin
2008-09-25 11:58svnbotNote Added: 0009189
2008-09-25 11:58svnbotStatusscheduled => resolved
2008-09-25 11:58svnbotResolutionopen => fixed
2008-09-25 11:58svnbotsvn_revision => 7883
2008-09-25 17:20ewilliamsIssue Monitored: ewilliams
2008-10-13 10:18psarobeRelationship addedhas duplicate 0005456
2009-01-26 10:16psarobeRegression testing => No
2009-01-26 10:16psarobeStatusresolved => closed
2009-01-26 10:16psarobeFixed in Version2.35MP10 => 2.35

Notes
(0009189)
svnbot   
2008-09-25 11:58   
Repository: openbravo
Revision: 7883
Author: rafaroda
Date: 2008-09-25 11:58:06 +0200 (Thu, 25 Sep 2008)

Fixes bug 0005214 Added missing TO_NUMBER(?) to CreateCashFlowStatement_data.xsql.

---
U branches/r2.3x/src/org/openbravo/erpCommon/ad_process/CreateCashFlowStatement_data.xsql
---

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