Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0006995Openbravo ERP09. Financial managementpublic2009-01-19 14:002009-04-21 12:36
PavelPonomarev 
Hennadzi 
normalminoralways
closedfixed 
10Vista x64
pi 
pi 
Core
No
0006995: Error in "User Defined Accounting Report"
When generating a "User Defined Accounting Report" the following error occurs:

      
ERROR: IN types character varying and integer cannot be matched.

View screen shot.
1. Navigate to "Financial Management || Accounting || Analysis Tools || User Defined Accounting Report Setup".
2. Create a new record (ex. UDAR 2) and Save.
3. Navigate to "Financial Management || Accounting || Analysis Tools || User Defined Accounting Report || User Defined Accounting Report".
4. Fill in all mandatory fields using the drop downs.
5. Click "OK".
6. Error.
No tags attached.
jpg UserDefinedAccountingReport.jpg (107,647) 2009-01-19 14:00
https://issues.openbravo.com/file_download.php?file_id=667&type=bug
jpg
Issue History
2009-01-19 14:00PavelPonomarevNew Issue
2009-01-19 14:00PavelPonomarevAssigned To => Hennadzi
2009-01-19 14:00PavelPonomarevsf_bug_id0 => 2519714
2009-01-19 14:00PavelPonomarevFile Added: UserDefinedAccountingReport.jpg
2009-01-19 14:00PavelPonomarevRegression testing => No
2009-01-19 14:01HennadziStatusnew => scheduled
2009-01-19 14:01Hennadzifix_in_branch => trunk
2009-01-19 14:04svnbotCheckin
2009-01-19 14:04svnbotNote Added: 0012338
2009-01-19 14:04svnbotStatusscheduled => resolved
2009-01-19 14:04svnbotResolutionopen => fixed
2009-01-19 14:04svnbotsvn_revision => 12001
2009-01-19 16:46svnbotCheckin
2009-01-19 16:46svnbotNote Added: 0012356
2009-01-19 16:46svnbotsvn_revision12001 => 12015
2009-04-21 12:36psarobeStatusresolved => closed

Notes
(0012338)
svnbot   
2009-01-19 14:04   
Repository: openbravo
Revision: 12001
Author: hennadzi
Date: 2009-01-19 14:04:08 +0100 (Mon, 19 Jan 2009)

Fixed bug 0006995: Error in "User Defined Accounting Report"

---
U trunk/src/org/openbravo/erpCommon/ad_process/CreateAccountingReport.java
U trunk/src/org/openbravo/erpCommon/ad_process/CreateAccountingReport_data.xsql
---

https://dev.openbravo.com/websvn/openbravo/?rev=12001&sc=1 [^]
(0012356)
svnbot   
2009-01-19 16:46   
Repository: openbravo
Revision: 12015
Author: hennadzi
Date: 2009-01-19 16:46:53 +0100 (Mon, 19 Jan 2009)

Fixed bug 0006995: Error in "User Defined Accounting Report"

---
U trunk/src/org/openbravo/erpCommon/ad_process/CreateAccountingReport.java
---

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