Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0010473Openbravo ERP03. Procurement managementpublic2009-09-03 10:572010-04-19 21:11
Reporterroklenardic 
Assigned Tosivaraman 
PriorityhighSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50MP4 
Target Version2.50MP14Fixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0010473: Matched Purchase Order Filter
DescriptionWhen clicking the filter icon in the Procurement Management || Transactions || Matched Purchase Order window, the field types from "Matched PO From" and "To" are amounts. Probably Dates were meant to be entered here. Regardless, the calculator of the first field does not work anyway and if you enter any values and click OK you get the following error:
:
ERROR: operator does not exist: character varying >= numeric

Steps To Reproduce1a) Go to Procurement Management || Transactions || Matched Purchase Orders
1b) Go to Procurement Management || Transactions || Matched Purchase Orders
2) Click on Search button
Proposed SolutionThe filters must be:
Product
Transaction date

Other filters are impossible
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-09-03 10:57roklenardicNew Issue
2009-09-03 10:57roklenardicAssigned To => rafaroda
2009-09-03 10:57roklenardicOBNetwork customer => No
2009-09-14 13:31psarobeNote Added: 0019905
2009-09-14 13:31psarobeStatusnew => feedback
2009-09-14 13:44roklenardicNote Added: 0019907
2009-09-18 13:47rafarodaNote Added: 0020203
2009-09-18 13:47rafarodaAssigned Torafaroda => psarobe
2009-09-18 13:47rafarodaStatusfeedback => new
2009-09-18 13:47rafarodaProposed Solution updated
2009-10-01 18:41psarobeNote Added: 0020631
2009-10-01 18:41psarobePrioritynormal => high
2009-10-01 18:41psarobeStatusnew => scheduled
2009-10-01 18:41psarobeSteps to Reproduce Updated
2009-10-01 18:56roklenardicNote Added: 0020634
2009-10-02 09:01psarobeNote Added: 0020651
2010-01-04 09:40psarobeAssigned Topsarobe => rafaroda
2010-01-04 09:40psarobeTarget Version => 2.50MP13
2010-02-11 11:20rafarodaAssigned Torafaroda => adrianromero
2010-03-08 16:06jpabloaeTarget Version2.50MP13 => 2.50MP14
2010-03-29 06:56sivaramanAssigned Toadrianromero => sivaraman
2010-03-29 08:25hgbotCheckin
2010-03-29 08:25hgbotNote Added: 0025763
2010-03-29 08:25hgbotStatusscheduled => resolved
2010-03-29 08:25hgbotResolutionopen => fixed
2010-03-29 08:25hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/849d13feadc28b86b87009074d8ada5744d21d0f [^]
2010-03-29 08:42sivaramanNote Added: 0025764
2010-03-30 07:15hgbotCheckin
2010-03-30 07:15hgbotNote Added: 0025796
2010-03-30 07:15hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/849d13feadc28b86b87009074d8ada5744d21d0f [^] => http://code.openbravo.com/erp/devel/pi/rev/638a01be93f20ff58b115accd438e19e5f6651df [^]
2010-04-01 07:06arunkumarNote Added: 0025847
2010-04-01 07:06arunkumarStatusresolved => closed
2010-04-02 00:00anonymoussf_bug_id0 => 2980790
2010-04-19 21:11hudsonbotCheckin
2010-04-19 21:11hudsonbotNote Added: 0026396
2010-04-19 21:11hudsonbotCheckin
2010-04-19 21:11hudsonbotNote Added: 0026397

Notes
(0019905)
psarobe   
2009-09-14 13:31   
Rok

This window should be deprecated. Why are you using it or which is the reason for using it?

Regards
(0019907)
roklenardic   
2009-09-14 13:44   
i am using it for 2 reasons:
1) because it's there which clearly should not be
2) because it gives an overview of all purchases and the ones who are not complete yet or are in partially complete.
(0020203)
rafaroda   
2009-09-18 13:47   
Here there are two problems with this filter:
1) Functionality: it does not make sense to have the ID column as the filter column. Another column has to be proposed for the filtering.
2) Platform: in case that someone enables the table column ID as search, this should not lead to a calculator anymore since it will not work with UUIDs.
(0020631)
psarobe   
2009-10-01 18:41   
Hi Rok,

The filters must be:
Product
Transaction date

Other filters are impossible
(0020634)
roklenardic   
2009-10-01 18:56   
as you pointed out first, it should be deprecated right?
(0020651)
psarobe   
2009-10-02 09:01   
Hi rok,

AS you pointed out :-) if it is useful for the people let's keep it and just change the filters
(0025763)
hgbot   
2010-03-29 08:25   
Repository: erp/devel/pi
Changeset: 849d13feadc28b86b87009074d8ada5744d21d0f
Author: Sivaraman Rajagopal <sivaraman.rajagopal <at> openbravo.com>
Date: Mon Mar 29 12:03:20 2010 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/849d13feadc28b86b87009074d8ada5744d21d0f [^]

Fixes issue 10473: Matched Purchase Order Filter

---
M src-db/database/sourcedata/AD_COLUMN.xml
---
(0025764)
sivaraman   
2010-03-29 08:42   
The issue has been resolved. Hence, 'Filter window' will display the following fields.
1. Product
2. Transaction Date (From & To)

Steps to test:
1. Log on to Openbravo
2. Change role to Openbravo Admin
3. Go to Procurement Management || Transactions || Matched Purchase Orders
4. Click on Search button
(0025796)
hgbot   
2010-03-30 07:15   
Repository: erp/devel/pi
Changeset: 638a01be93f20ff58b115accd438e19e5f6651df
Author: Sivaraman Rajagopal <sivaraman.rajagopal <at> openbravo.com>
Date: Tue Mar 30 10:53:57 2010 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/638a01be93f20ff58b115accd438e19e5f6651df [^]

Fixes issue 10473: Matched Purchase Order Filter

---
M src-db/database/sourcedata/AD_COLUMN.xml
---
(0025847)
arunkumar   
2010-04-01 07:06   
Tested & working fine
(0026396)
hudsonbot   
2010-04-19 21:11   
A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/849d13feadc2 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/91d98bda46c1 [^]
Tests: http://builds.openbravo.com/view/devel-int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.17088.obx [^]
(0026397)
hudsonbot   
2010-04-19 21:11   
A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/638a01be93f2 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/91d98bda46c1 [^]
Tests: http://builds.openbravo.com/view/devel-int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.17088.obx [^]