Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0005213Openbravo ERP09. Financial managementpublic2008-09-23 18:042008-12-11 14:10
Reporterrafaroda 
Assigned Torafaroda 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionUbuntu 7.10
Product Versionpi 
Target VersionFixed in Version 
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
Summary0005213: '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
Tags2.40 MP1 candidate
Relationships
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:00svnbotCheckin
2008-09-25 11:00svnbotNote Added: 0009187
2008-09-25 11:00svnbotStatusscheduled => resolved
2008-09-25 11:00svnbotResolutionopen => fixed
2008-09-25 11:00svnbotsvn_revision => 7878
2008-09-29 18:38cromeroTag Attached: 2.40 MP1 candidate
2008-09-29 18:38cromeroTag Detached: 2.40 MP1 candidate
2008-09-29 18:38cromeroTag Attached: 2.40 MP1 candidate
2008-12-11 14:10psarobeRegression testing => No
2008-12-11 14:10psarobeStatusresolved => closed
2008-12-11 14:10psarobeNote Added: 0011182

Notes
(0009187)
svnbot   
2008-09-25 11:00   
Repository: openbravo
Revision: 7878
Author: rafaroda
Date: 2008-09-25 11:00:39 +0200 (Thu, 25 Sep 2008)

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

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

https://dev.openbravo.com/websvn/openbravo/?rev=7878&sc=1 [^]
(0011182)
psarobe   
2008-12-11 14:10   
No error comes up