Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0009192 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 03. Procurement management | major | always | 2009-05-27 02:12 | 2009-05-29 00:00 | |||
| Reporter | gkfabs | View Status | public | |||||
| Assigned To | rafaroda | |||||||
| 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_11 | |||
| OS Version | rPath Linux | Database version | 8.3.5 | Ant version | 1.7.1 | |||
| Product Version | 2.50 | 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 | 0009192: When completing a purchase invoice I get an error | |||||||
| Description | When completing a purchase invoice I get the error Postgresql logs 2009-05-26 14:16:03 MDT NOTICE: Creating C_Cash 2009-05-26 14:16:03 MDT CONTEXT: SQL statement "SELECT C_INVOICE_POST( $1 , NULL)" PL/pgSQL function "c_invoice_post0" line 27 at PERFORM 2009-05-26 14:16:03 MDT NOTICE: @ERROR=operator does not exist: character varying = numeric | |||||||
| Steps To Reproduce | Create a new purchase invoice from a purchase order from a requirement. Try to complete it. | |||||||
| Proposed Solution | In the file ./src-db/database/model/functions/C_INVOICE_POST.xml Line 1457 Replace: v_CB_Curr NUMBER; With v_CB_Curr VARCHAR2(32); The v_CB_Curr is used to keep an id. Id are not numerics, they are chars because of the uuid change. | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
| There are no notes attached to this issue. |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2009-05-27 02:12 | gkfabs | New Issue | |
| 2009-05-27 02:12 | gkfabs | Assigned To | => rafaroda |
| 2009-05-28 12:14 | psarobe | Relationship added | duplicate of 0008758 |
| 2009-05-28 12:14 | psarobe | Status | new => closed |
| 2009-05-28 12:14 | psarobe | Duplicate ID | 0 => 8758 |
| 2009-05-28 12:14 | psarobe | Resolution | open => duplicate |
| 2009-05-29 00:00 | anonymous | sf_bug_id | 0 => 2798140 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |