Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0000594Openbravo ERP08. Project and service managementpublic2008-06-11 11:262008-12-02 13:01
rafaroda 
rafaroda 
normalminoralways
closedfixed 
20Ubuntu 7.10
pi 
2.402.40alpha-r3 
Core
No
0000594: ExpenseSOrder and RequisitionToOrder processes fail in PostgreSQL
ExpenseSOrder and RequisitionToOrder processes fail in PostgreSQL because in their XSQL, date passed to M_GET_OFFERS_PRICE function do not have a to_date().
1) Create an Expense Sheet.
2) Create an Expense Sheet Line (with Reinvoicing ticked) and select a Business Partner
3) Go back to Expense Sheet header and process this expense.
4) Create Sales Order form Expenses for the Business Partner.

In the log, message 'ERROR: function m_get_offers_price(timestamp with time zone, numeric, numeric, numeric, numeric, numeric) does not exist' displays.
PostgreSQL
Issue History
2008-06-11 11:26rafarodaNew Issue
2008-06-11 11:26rafarodaAssigned To => rafaroda
2008-06-11 11:27rafarodaStatusnew => scheduled
2008-06-11 11:32svnbotCheckin
2008-06-11 11:32svnbotNote Added: 0000497
2008-06-11 11:32svnbotStatusscheduled => resolved
2008-06-11 11:32svnbotResolutionopen => fixed
2008-06-11 11:32svnbotsvn_revision => 4948
2008-06-11 12:43cromeroFixed in Version => 2.40alpha r3
2008-06-11 12:46cromeroTarget Version => 2.40
2008-07-10 12:09plujanTag Attached: PostgreSQL
2008-11-09 22:59psarobeRegression testing => No
2008-11-09 22:59psarobeStatusresolved => closed
2008-12-02 13:01jaimetorresf_bug_id0 => 2377034

Notes
(0000497)
svnbot   
2008-06-11 11:32   
Repository: openbravo
Revision: 4948
Author: rafaroda
Date: 2008-06-11 11:32:25 +0200 (Wed, 11 Jun 2008)

Fixes bug 0000594 Added to_date() to M_GET_OFFERS_PRICE() function in ExpenseSOrder_data.xsql and RequisitionToOrder_data.xsql files.

---
U trunk/src/org/openbravo/erpCommon/ad_actionButton/ExpenseSOrder_data.xsql
U trunk/src/org/openbravo/erpCommon/ad_forms/RequisitionToOrder_data.xsql
---

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