Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0010473
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 03. Procurement managementminoralways2009-09-03 10:572010-04-19 21:11
ReporterroklenardicView Statuspublic 
Assigned Tosivaraman 
PriorityhighResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision638a01be93f2
ProjectionnoneETAnoneTarget Version2.50MP14
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version2.50MP4SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0010473: 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
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0019905)
psarobe (manager)
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 (developer)
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 (developer)
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 (manager)
2009-10-01 18:41

Hi Rok,

The filters must be:
Product
Transaction date

Other filters are impossible
(0020634)
roklenardic (developer)
2009-10-01 18:56

as you pointed out first, it should be deprecated right?
(0020651)
psarobe (manager)
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 (developer)
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 (reporter)
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 (developer)
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 (reporter)
2010-04-01 07:06

Tested & working fine
(0026396)
hudsonbot (developer)
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 (developer)
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 [^]

- Issue History
Date Modified Username Field Change
2009-09-03 10:57 roklenardic New Issue
2009-09-03 10:57 roklenardic Assigned To => rafaroda
2009-09-14 13:31 psarobe Note Added: 0019905
2009-09-14 13:31 psarobe Status new => feedback
2009-09-14 13:44 roklenardic Note Added: 0019907
2009-09-18 13:47 rafaroda Note Added: 0020203
2009-09-18 13:47 rafaroda Assigned To rafaroda => psarobe
2009-09-18 13:47 rafaroda Status feedback => new
2009-09-18 13:47 rafaroda Proposed Solution updated
2009-10-01 18:41 psarobe Note Added: 0020631
2009-10-01 18:41 psarobe Priority normal => high
2009-10-01 18:41 psarobe Status new => scheduled
2009-10-01 18:41 psarobe Steps to Reproduce Updated
2009-10-01 18:56 roklenardic Note Added: 0020634
2009-10-02 09:01 psarobe Note Added: 0020651
2010-01-04 09:40 psarobe Assigned To psarobe => rafaroda
2010-01-04 09:40 psarobe Target Version => 2.50MP13
2010-02-11 11:20 rafaroda Assigned To rafaroda => adrianromero
2010-03-08 16:06 jpabloae Target Version 2.50MP13 => 2.50MP14
2010-03-29 06:56 sivaraman Assigned To adrianromero => sivaraman
2010-03-29 08:25 hgbot Checkin
2010-03-29 08:25 hgbot Note Added: 0025763
2010-03-29 08:25 hgbot Status scheduled => resolved
2010-03-29 08:25 hgbot Resolution open => fixed
2010-03-29 08:25 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/849d13feadc28b86b87009074d8ada5744d21d0f [^]
2010-03-29 08:42 sivaraman Note Added: 0025764
2010-03-30 07:15 hgbot Checkin
2010-03-30 07:15 hgbot Note Added: 0025796
2010-03-30 07:15 hgbot Fixed in SCM revision http://code.openbravo.com/erp/devel/pi/rev/849d13feadc28b86b87009074d8ada5744d21d0f [^] => http://code.openbravo.com/erp/devel/pi/rev/638a01be93f20ff58b115accd438e19e5f6651df [^]
2010-04-01 07:06 arunkumar Note Added: 0025847
2010-04-01 07:06 arunkumar Status resolved => closed
2010-04-02 00:00 anonymous sf_bug_id 0 => 2980790
2010-04-19 21:11 hudsonbot Checkin
2010-04-19 21:11 hudsonbot Note Added: 0026396
2010-04-19 21:11 hudsonbot Checkin
2010-04-19 21:11 hudsonbot Note Added: 0026397


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker