Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0004769 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 09. Financial management | critical | always | 2008-08-30 14:50 | 2008-09-01 09:51 | |||
| Reporter | Wimt | View Status | public | |||||
| Assigned To | cromero | |||||||
| Priority | normal | Resolution | duplicate | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | |||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Linux 32 bit | Database | PostgreSQL | Java version | 1.6.0_06 | |||
| OS Version | Ubuntu 8.04 | Database version | 8.3 | Ant version | 1.7.0 | |||
| Product Version | 2.40beta | SCM revision | ||||||
| Merge Request Status | ||||||||
| Review Assigned To | ||||||||
| OBNetwork customer | No | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0004769: Unable to create Bank statement lines | |||||||
| Description | When I try to create bank statement lines I get an error: 14:41:15 [http-8180-Processor21] ERROR org.openbravo.erpWindows.BankStatement.LinesData - SQL error in query: SELECT (CASE WHEN C_CURRENCY_ID = ? THEN 'N' ELSE 'Y' END) FROM C_DEBT_PAYMENT WHERE C_DEBT_PAYMENT_ID = ? Exception:org.postgresql.util.PSQLException: The column name (CASEWHENC_CURRENCY_ID=:1THEN'N'ELSE'Y'END) was not found in this ResultSet. 14:41:15 [http-8180-Processor21] ERROR org.openbravo.base.secureApp.HttpSecureAppServlet - Error captured: javax.servlet.ServletException: @CODE=0@The column name (CASEWHENC_CURRENCY_ID=:1THEN'N'ELSE'Y'END) was not found in this ResultSet. This happens when I try to create a line manually and alos if if I do this via "Crealet Lines From" | |||||||
| Steps To Reproduce | Start with a new setup of BO 2.40 beta with no example data. Configure everything according "Little Setup Guide". 1 Create purchase order 2 Receive goods 3 Create purchase invoice manually 4 Create Bank Statement header 5 Create bank statement line and select the purchase invoice 6 Error occurs (see log). When you go to the bank statement header and select "Lines" you also get the error: (CASEWHENC_CURRENCY_ID=:1THEN'N'ELSE'Y'END) was not found in this ResultSet. You can now only click "Back" | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0008796) psarobe (viewer) 2008-09-01 09:51 |
Hi Wimt, The workaround is very easy. You have to compile the window writing: ant compile -Dtab=bankstatement Regards |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2008-08-30 14:50 | Wimt | New Issue | |
| 2008-08-30 14:50 | Wimt | Assigned To | => cromero |
| 2008-08-30 14:50 | Wimt | sf_bug_id | 0 => 2083946 |
| 2008-09-01 09:51 | psarobe | Regression testing | => No |
| 2008-09-01 09:51 | psarobe | Relationship added | duplicate of 0004626 |
| 2008-09-01 09:51 | psarobe | Status | new => closed |
| 2008-09-01 09:51 | psarobe | Note Added: 0008796 | |
| 2008-09-01 09:51 | psarobe | Duplicate ID | 0 => 4626 |
| 2008-09-01 09:51 | psarobe | Resolution | open => duplicate |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |