Openbravo Issue Tracking System - Openbravo ERP | ||||||||||||
| View Issue Details | ||||||||||||
| ID | Project | Category | View Status | Date Submitted | Last Update | |||||||
| 0004769 | Openbravo ERP | 09. Financial management | public | 2008-08-30 14:50 | 2008-09-01 09:51 | |||||||
| Reporter | Wimt | |||||||||||
| Assigned To | cromero | |||||||||||
| Priority | normal | Severity | critical | Reproducibility | always | |||||||
| Status | closed | Resolution | duplicate | |||||||||
| Platform | OS | 20 | OS Version | Ubuntu 8.04 | ||||||||
| Product Version | 2.40beta | |||||||||||
| Target Version | Fixed in Version | |||||||||||
| 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" | |||||||||||
| Proposed Solution | ||||||||||||
| Additional Information | ||||||||||||
| Tags | No tags attached. | |||||||||||
| Relationships |
| |||||||||||
| Attached Files | ||||||||||||
| 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 | |||||||||
| Notes | |||||
|
|
|||||
|
|
||||