Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0004279Openbravo ERP07. Sales managementpublic2008-07-02 18:442008-09-03 22:11
Reportercromero 
Assigned Tocromero 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS Version2.40alpha
Product Versionpi 
Target VersionFixed in Version2.40 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0004279: Create Invoices from Orders does not work for PostgreSQL 8.3
DescriptionWhen you try to create an Invoice from an Order in PostgreSQL 8.3 it throws an error message:
Process completed successfully
@ERROR=el operador no existe: text <> numeric

Steps To Reproduce
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
depends on backport 0004280 closed cromero Create Invoices from Orders does not work for PostgreSQL 8.3 
Attached Filespng Pantallazo-3.png (200,696) 2008-07-02 18:47
https://issues.openbravo.com/file_download.php?file_id=142&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2008-07-02 18:44cromeroNew Issue
2008-07-02 18:44cromeroAssigned To => cromero
2008-07-02 18:44cromerosf_bug_id0 => 2008973
2008-07-02 18:44cromeroOBNetwork customer => No
2008-07-02 18:44cromeroStatusnew => scheduled
2008-07-02 18:44cromerofix_in_branch => trunk
2008-07-02 18:45svnbotCheckin
2008-07-02 18:45svnbotNote Added: 0008137
2008-07-02 18:45svnbotStatusscheduled => resolved
2008-07-02 18:45svnbotResolutionopen => fixed
2008-07-02 18:45svnbotsvn_revision => 5573
2008-07-02 18:47cromeroStatusresolved => new
2008-07-02 18:47cromeroResolutionfixed => open
2008-07-02 18:47cromeroFile Added: Pantallazo-3.png
2008-07-02 18:47cromeroStatusnew => scheduled
2008-07-02 18:47cromeroStatusscheduled => resolved
2008-07-02 18:47cromeroResolutionopen => fixed
2008-09-03 22:11psarobeRegression testing => No
2008-09-03 22:11psarobeStatusresolved => closed
2008-09-03 22:11psarobeFixed in Version => 2.40

Notes
(0008137)
svnbot   
2008-07-02 18:45   
Repository: openbravo
Revision: 5573
Author: cromeroherrero
Date: 2008-07-02 18:45:38 +0200 (Wed, 02 Jul 2008)

Fixed bug 4279: Create Invoices from Orders does not work for PostgreSQL 8.3. Problem located in C_InvoiceToDate function because a lack of a TO_NUMBER in a comparation.

---
U trunk/src-db/database/model/functions/C_INVOICETODATE.xml
---

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