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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0011693
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] Z. Othersmajorhave not tried2009-12-09 08:492010-01-20 23:25
ReporterarunkumarView Statuspublic 
Assigned Toharikrishnan 
PrioritynormalResolutionfixedFixed in Versionpi
StatusclosedFix in branchpiFixed in SCM revision16aec5ef498e
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version2.40SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0011693: Date filter does not work properly in Order line selector

DescriptionCreating sales order with the order date as 09-12-2009.Create two lines one with order date as 09-12-2010 and another with 09-12-2010.Complete the sales order.If you see the order line selector for this sales order, if you filter by date 01-01-2010 you don't see the lines. If you filter by date 01-01-2009 you can see for both lines date is 09-12-2009.
Steps To ReproduceLogin as Openbravo/openbravo and role as "Openbravo Admin".
Go to Sales Management -> Transactions -> Sales Order. Order date is 09-12-2009 in header.
Create a sales Order with 2 lines.
One line has the order date as 09-12-2010.
Another line has the order date as 09-12-2010.
Complete the sales order.

Click Information -> Order line
The popup will appear.
Enter the recently created sales order document number in the "Doc No" field, set From Date = 01-01-2010 and click Search
Nothing appears.
Change From Date to 01-01-2009 and click Search
You will not see both lines are being displayed there with date 09-12-2009
Proposed SolutionSince this is the order line selector it should consider the order date field in the sales order lines not in sales order header.

Use the Order date in the sales order lines and filter according to that (if order line date is null use order date).
Tagspage data grid
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
depends on backport 0011755 closedharikrishnan Date filter does not work properly in Order line selector 

-  Notes
(0023027)
harikrishnan (reporter)
2009-12-23 08:00

This issue is fixed and committed.
(0023108)
arunkumar (reporter)
2009-12-28 12:49

Tested & Working fine
(0023411)
hgbot (developer)
2010-01-14 11:27

Repository: erp/devel/pi
Changeset: 16aec5ef498ef2c19373c5f72987fd9050c66a6f
Author: Harikrishnan Raja <harikrishnan.raja <at> openbravo.com>
Date: Wed Dec 23 12:27:55 2009 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/16aec5ef498ef2c19373c5f72987fd9050c66a6f [^]

Fixes Issue 11693: Date filter does not work properly in Order line selector.

---
M src/org/openbravo/erpCommon/info/SalesOrderLine_data.xsql
---
(0023440)
rafaroda (developer)
2010-01-14 13:45

Closed since already tested and approved by QA.
(0023647)
hudsonbot (developer)
2010-01-20 23:25

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/16aec5ef498e [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/fa6621f85351 [^]
Tests: http://builds.openbravo.com/view/devel-int/ [^]
OBX: http://builds.openbravo.com/erp/obx/core/OpenbravoERP-2.50CI.15942.obx [^]

- Issue History
Date Modified Username Field Change
2009-12-09 08:49 arunkumar New Issue
2009-12-09 08:49 arunkumar Assigned To => rafaroda
2009-12-09 10:28 arunkumar Tag Attached: page data grid
2009-12-12 11:08 rafaroda Description Updated
2009-12-12 11:08 rafaroda Proposed Solution updated
2009-12-12 11:08 rafaroda Steps to Reproduce Updated
2009-12-12 11:09 rafaroda Status new => scheduled
2009-12-12 11:09 rafaroda fix_in_branch => pi
2009-12-23 07:59 harikrishnan Assigned To rafaroda => harikrishnan
2009-12-23 08:00 harikrishnan Note Added: 0023027
2009-12-23 08:00 harikrishnan Status scheduled => resolved
2009-12-23 08:00 harikrishnan Fixed in SCM revision => https://code.openbravo.com/erp/devel/pi-pageddatagrid/rev/16aec5ef498e [^]
2009-12-23 08:00 harikrishnan Resolution open => fixed
2009-12-28 12:49 arunkumar Note Added: 0023108
2009-12-28 12:49 arunkumar Status resolved => closed
2009-12-28 12:49 arunkumar Fixed in Version => pi
2009-12-29 00:00 anonymous sf_bug_id 0 => 2922537
2010-01-14 11:27 hgbot Checkin
2010-01-14 11:27 hgbot Note Added: 0023411
2010-01-14 11:27 hgbot Status closed => resolved
2010-01-14 11:27 hgbot Fixed in SCM revision https://code.openbravo.com/erp/devel/pi-pageddatagrid/rev/16aec5ef498e [^] => http://code.openbravo.com/erp/devel/pi/rev/16aec5ef498ef2c19373c5f72987fd9050c66a6f [^]
2010-01-14 13:44 rafaroda Status resolved => closed
2010-01-14 13:45 rafaroda Note Added: 0023440
2010-01-20 23:25 hudsonbot Checkin
2010-01-20 23:25 hudsonbot Note Added: 0023647


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker