Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0005212Openbravo ERP09. Financial managementpublic2008-09-23 18:032008-12-16 12:23
Reporterrafaroda 
Assigned Torafaroda 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionUbuntu 7.10
Product Versionpi 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0005212: '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
depends on backport 0005213 closed rafaroda 'Generate Cash Flow Statement'/'Create Cash Flow Statement' does not work in PostgreSQL 
depends on backport 0005214 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:03rafarodaNew Issue
2008-09-23 18:03rafarodaAssigned To => rafaroda
2008-09-23 18:03rafarodasf_bug_id0 => 2124822
2008-09-23 18:03rafarodaRegression testing => No
2008-09-23 18:04rafarodaStatusnew => scheduled
2008-09-23 18:04rafarodafix_in_branch => trunk
2008-09-25 12:05svnbotCheckin
2008-09-25 12:05svnbotNote Added: 0009190
2008-09-25 12:05svnbotStatusscheduled => resolved
2008-09-25 12:05svnbotResolutionopen => fixed
2008-09-25 12:05svnbotsvn_revision => 7885
2008-12-16 12:23psarobeStatusresolved => closed

Notes
(0009190)
svnbot   
2008-09-25 12:05   
Repository: openbravo
Revision: 7885
Author: rafaroda
Date: 2008-09-25 12:05:27 +0200 (Thu, 25 Sep 2008)

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

---
U trunk/src/org/openbravo/erpCommon/ad_process/CreateCashFlowStatement_data.xsql
---

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