Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0006664Openbravo ERP07. Sales managementpublic2008-12-18 19:062009-01-02 14:35
shuehner 
shuehner 
normalmajorhave not tried
closedfixed 
5
pi 
 
Core
No
0006664: Order selector: Field field "Total Amount From" does not work on postgresql 8.3
.. because of missing to_number calls
Go to Information -> Order selector
use the total amount from filter field on postgresql 8.3
No tags attached.
depends on backport 0006692 closed shuehner Order selector: Field field "Total Amount From" does not work on postgresql 8.3 
related to defect 00056742.50 closed shuehner Audit for missing to_number in XSQL for Postgresql from v8.3 and excessive to_number in ID fields 
Issue History
2008-12-18 19:06shuehnerNew Issue
2008-12-18 19:06shuehnerAssigned To => shuehner
2008-12-18 19:06shuehnersf_bug_id0 => 2445836
2008-12-18 19:06shuehnerRegression testing => No
2008-12-19 16:01shuehnerStatusnew => scheduled
2008-12-19 16:01shuehnerfix_in_branch => trunk
2008-12-19 16:02svnbotCheckin
2008-12-19 16:02svnbotNote Added: 0011603
2008-12-19 16:02svnbotStatusscheduled => resolved
2008-12-19 16:02svnbotResolutionopen => fixed
2008-12-19 16:02svnbotsvn_revision => 11421
2008-12-19 16:34shuehnerRelationship addedrelated to 0005674
2008-12-31 15:00lakshmiNote Added: 0011798
2008-12-31 15:18shuehnerNote Added: 0011802
2009-01-02 14:35lakshmiStatusresolved => closed
2009-01-02 14:35lakshmiNote Added: 0011859

Notes
(0011603)
svnbot   
2008-12-19 16:02   
Repository: openbravo
Revision: 11421
Author: huehner
Date: 2008-12-19 16:02:16 +0100 (Fri, 19 Dec 2008)

Fixed 6664
add missing to_number calls to fix amount filter on pgsql 8.3

---
U trunk/src/org/openbravo/erpCommon/info/SalesOrder_data.xsql
---

https://dev.openbravo.com/websvn/openbravo/?rev=11421&sc=1 [^]
(0011798)
lakshmi   
2008-12-31 15:00   
In Sales order, i couldn't able to find the field "Total Amount From". Need more steps for retesting this issue.
(0011802)
shuehner   
2008-12-31 15:18   
The field is a filter field in the Popup/Selector "Sales Order" / "Order" in the Information menu-group. Not a field in the Sales Order window itself.
(0011859)
lakshmi   
2009-01-02 14:35   
Verified the issue and it works in Openbravo 2.50 (r11619). The "Total Amount Field" filters the amount value correctly. So i closed the issue