Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0006708Openbravo ERP03. Procurement managementpublic2008-12-21 21:512008-12-22 15:36
Reporterjreymol 
Assigned Torafaroda 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionduplicate 
PlatformOS20OS VersionrPath Linux
Product Version 
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
Summary0006708: Relation from Purchase Invoice to Purchase Order is broken
DescriptionOn

Procurement Management || Transactions || Purchase Invoice || Header >> Lines

there is a command button that link to:

http://192.168.213.129/openbravo/PurchaseInvoice/Lines_Relation.html?Command=DEFAULT# [^]

This command button is located under Organization and belong to Purchase Order Line. When I click on it I get twice the message: ERROR: operator does not exist: numeric >= character varying

Steps To Reproduce
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
duplicate of defect 0006662 closed shuehner Order Line selector: Field field "Total Amount From" does not work on postgresql 8.3 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-12-21 21:51jreymolNew Issue
2008-12-21 21:51jreymolAssigned To => rafaroda
2008-12-21 21:51jreymolsf_bug_id0 => 2456567
2008-12-22 13:29shuehnerNote Added: 0011652
2008-12-22 13:29shuehnerStatusnew => feedback
2008-12-22 14:39jreymolNote Added: 0011658
2008-12-22 14:46shuehnerNote Added: 0011660
2008-12-22 15:09jreymolNote Added: 0011663
2008-12-22 15:12shuehnerRegression testing => No
2008-12-22 15:12shuehnerRelationship addedduplicate of 0006662
2008-12-22 15:12shuehnerStatusfeedback => closed
2008-12-22 15:12shuehnerNote Added: 0011664
2008-12-22 15:12shuehnerDuplicate ID0 => 6662
2008-12-22 15:12shuehnerResolutionopen => duplicate
2008-12-22 15:14jreymolNote Added: 0011665
2008-12-22 15:36shuehnerNote Added: 0011667

Notes
(0011652)
shuehner   
2008-12-22 13:29   
Question to clarify which button/link is the problem:

1.) Link left of the Order Line field which should open the corresponding Order Line (Link label sales order line)?

or

2.) Button right of this field which should open the Sales Order Line Selector?
(0011658)
jreymol   
2008-12-22 14:39   
Button right of this field which should open the Sales Order Line Selector
(0011660)
shuehner   
2008-12-22 14:46   
Can you please check if the "Total Amount From" or "Total Amount to" fields in the selector are filled?
If yes please remove the values from the field and press search in the selector and report if the error vanishes then.
(0011663)
jreymol   
2008-12-22 15:09   
You are right.

Both fields had 2.20. I cleared both fields. Clicked search button and an order line appeard
(0011664)
shuehner   
2008-12-22 15:12   
This has already been fixed in issue 6662 (trunk). The fix is now available from trunk and will be included in the next alpha-release.
(0011665)
jreymol   
2008-12-22 15:14   
If I wipe the box "Sales Order Line" before clicking button Sales Order Line Selector appears with no error and shows an Order Line in the grid
(0011667)
shuehner   
2008-12-22 15:36   
The bug is in the selector when the Amount From filter field is used on postgresql 8.3 . When you wipe the box the filter will not be filled so bug does no appear. The bug itself in the selector is fixed, but just not yet in alpha5