Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0011693Openbravo ERPZ. Otherspublic2009-12-09 08:492010-01-20 23:25
Reporterarunkumar 
Assigned Toharikrishnan 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.40 
Target VersionFixed in Versionpi 
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
Summary0011693: 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).
Additional Information
Tagspage data grid
Relationships
depends on backport 0011755 closed harikrishnan Date filter does not work properly in Order line selector 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-12-09 08:49arunkumarNew Issue
2009-12-09 08:49arunkumarAssigned To => rafaroda
2009-12-09 10:28arunkumarTag Attached: page data grid
2009-12-12 11:08rafarodaDescription Updated
2009-12-12 11:08rafarodaProposed Solution updated
2009-12-12 11:08rafarodaSteps to Reproduce Updated
2009-12-12 11:09rafarodaStatusnew => scheduled
2009-12-12 11:09rafarodafix_in_branch => pi
2009-12-23 07:59harikrishnanAssigned Torafaroda => harikrishnan
2009-12-23 08:00harikrishnanNote Added: 0023027
2009-12-23 08:00harikrishnanStatusscheduled => resolved
2009-12-23 08:00harikrishnanFixed in SCM revision => https://code.openbravo.com/erp/devel/pi-pageddatagrid/rev/16aec5ef498e [^]
2009-12-23 08:00harikrishnanResolutionopen => fixed
2009-12-28 12:49arunkumarNote Added: 0023108
2009-12-28 12:49arunkumarStatusresolved => closed
2009-12-28 12:49arunkumarFixed in Version => pi
2009-12-29 00:00anonymoussf_bug_id0 => 2922537
2010-01-14 11:27hgbotCheckin
2010-01-14 11:27hgbotNote Added: 0023411
2010-01-14 11:27hgbotStatusclosed => resolved
2010-01-14 11:27hgbotFixed in SCM revisionhttps://code.openbravo.com/erp/devel/pi-pageddatagrid/rev/16aec5ef498e [^] => http://code.openbravo.com/erp/devel/pi/rev/16aec5ef498ef2c19373c5f72987fd9050c66a6f [^]
2010-01-14 13:44rafarodaStatusresolved => closed
2010-01-14 13:45rafarodaNote Added: 0023440
2010-01-20 23:25hudsonbotCheckin
2010-01-20 23:25hudsonbotNote Added: 0023647

Notes
(0023027)
harikrishnan   
2009-12-23 08:00   
This issue is fixed and committed.
(0023108)
arunkumar   
2009-12-28 12:49   
Tested & Working fine
(0023411)
hgbot   
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   
2010-01-14 13:45   
Closed since already tested and approved by QA.
(0023647)
hudsonbot   
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 [^]