Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0004792Openbravo ERP09. Financial managementpublic2008-09-02 10:282008-09-04 16:18
ReporterjacoboGiralt 
Assigned Tocromero 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version2.40 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0004792: Remittance Cancellation/Return doesn't work with PostgresSQL
DescriptionWhen you cancel a remittance in this window it fails with the following error:

function ad_get_doctype (character varying, character varying, "unknown") does not exist.
Steps To Reproduce1. Create a Remittance
2. Complete it
3. Go to Remittance Cancellation/Return window and select the generated payments
4. Fill the form and click return.
Proposed SolutionIt seems to be the typical issue with oracle/postgres differences. Some to_number() are needed. Not only in the calls to ad_get_doctype but also in the inserts for every numeric column.

The file that should be changed is: org/openbravo/erpCommon/ad_forms/RemittanceCancel_data.xsql
Additional Information
TagsNo tags attached.
Relationships
blocks defect 0004789 closed cromero Remittance Cancellation/Return doesn't work with PostgresSQL 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-09-02 10:28cromeroNew Issue
2008-09-02 10:28cromeroAssigned To => cromero
2008-09-02 10:28cromeroStatusnew => scheduled
2008-09-02 17:03svnbotCheckin
2008-09-02 17:03svnbotNote Added: 0008852
2008-09-02 17:03svnbotStatusscheduled => resolved
2008-09-02 17:03svnbotResolutionopen => fixed
2008-09-02 17:03svnbotsvn_revision => 6743
2008-09-04 16:18psarobeRegression testing => No
2008-09-04 16:18psarobeStatusresolved => closed
2008-09-04 16:18psarobeFixed in Version => 2.40

Notes
(0008852)
svnbot   
2008-09-02 17:03   
Repository: openbravo
Revision: 6743
Author: cromeroherrero
Date: 2008-09-02 17:03:42 +0200 (Tue, 02 Sep 2008)

Fixed bug 4792: Remittance Cancellation/Return doesn't work with PostgresSQL

---
U branches/r2.40/src/org/openbravo/erpCommon/ad_forms/RemittanceCancel.java
U branches/r2.40/src/org/openbravo/erpCommon/ad_forms/RemittanceCancel_data.xsql
U branches/r2.40/src/org/openbravo/erpCommon/utility/DocumentNo_data.xsql
U branches/r2.40/src/org/openbravo/erpCommon/utility/SequenceIdData.java
U branches/r2.40/src/org/openbravo/erpCommon/utility/Sequence_data.xsql
U branches/r2.40/src/org/openbravo/erpCommon/utility/Utility.java
---

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