Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0004280Openbravo ERP07. Sales managementpublic2008-07-02 18:442008-09-03 22:10
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
Summary0004280: 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
blocks defect 0004279 closed cromero Create Invoices from Orders does not work for PostgreSQL 8.3 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-07-02 18:44cromeroNew Issue
2008-07-02 18:44cromeroAssigned To => cromero
2008-07-02 18:44cromeroStatusnew => scheduled
2008-07-02 18:46svnbotCheckin
2008-07-02 18:46svnbotNote Added: 0008138
2008-07-02 18:46svnbotStatusscheduled => resolved
2008-07-02 18:46svnbotResolutionopen => fixed
2008-07-02 18:46svnbotsvn_revision => 5574
2008-09-03 22:10psarobeRegression testing => No
2008-09-03 22:10psarobeStatusresolved => closed
2008-09-03 22:10psarobeFixed in Version => 2.40

Notes
(0008138)
svnbot   
2008-07-02 18:46   
Repository: openbravo
Revision: 5574
Author: cromeroherrero
Date: 2008-07-02 18:46:32 +0200 (Wed, 02 Jul 2008)

Fixed bug 4280: 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 branches/r2.40beta/src-db/database/model/functions/C_INVOICETODATE.xml
---

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