Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0006662Openbravo ERP07. Sales managementpublic2008-12-18 18:322009-04-21 11:09
Reportershuehner 
Assigned Toshuehner 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target VersionFixed in Version 
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
Summary0006662: Order Line selector: Field field "Total Amount From" does not work on postgresql 8.3
Description... because of missing to_number calls
Steps To ReproduceGo to: Information -> Order line
Use the Total Amount From filter on postgresql 8.3
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
depends on backport 0006663 closed shuehner Order Line selector: Field field "Total Amount From" does not work on postgresql 8.3 
has duplicate defect 0006708 closed rafaroda Relation from Purchase Invoice to Purchase Order is broken 
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 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-12-18 18:32shuehnerNew Issue
2008-12-18 18:32shuehnerAssigned To => shuehner
2008-12-18 18:32shuehnersf_bug_id0 => 2445769
2008-12-18 18:32shuehnerRegression testing => No
2008-12-18 18:38shuehnerSummarySales Order Line selector: Field field "Total Amount From" does not work on postgresql 8.3 => Order Line selector: Field field "Total Amount From" does not work on postgresql 8.3
2008-12-18 18:38shuehnerProposed Solution updated
2008-12-18 18:41shuehnerStatusnew => scheduled
2008-12-18 18:41shuehnerfix_in_branch => trunk
2008-12-18 18:42svnbotCheckin
2008-12-18 18:42svnbotNote Added: 0011558
2008-12-18 18:42svnbotStatusscheduled => resolved
2008-12-18 18:42svnbotResolutionopen => fixed
2008-12-18 18:42svnbotsvn_revision => 11395
2008-12-19 16:34shuehnerRelationship addedrelated to 0005674
2008-12-22 15:12shuehnerRelationship addedhas duplicate 0006708
2008-12-31 14:17lakshmiNote Added: 0011796
2008-12-31 15:18shuehnerNote Added: 0011801
2009-04-21 11:09psarobeStatusresolved => closed

Notes
(0011558)
svnbot   
2008-12-18 18:42   
Repository: openbravo
Revision: 11395
Author: huehner
Date: 2008-12-18 18:42:56 +0100 (Thu, 18 Dec 2008)

Fixed 6662
add missing to_number calls to filter field to fix it on postgresql 8.3

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

https://dev.openbravo.com/websvn/openbravo/?rev=11395&sc=1 [^]
(0011796)
lakshmi   
2008-12-31 14:17   
I couldn't find "Total Amount From" field in the sales order Line. In sales order lines, "Line Net Amount" Field is there for the amount of (Quantity*Price). Need more steps for retesting this issue.
(0011801)
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.