Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0011755Openbravo ERPZ. Otherspublic2009-12-09 08:492010-01-14 13:45
Reporterarunkumar 
Assigned Toharikrishnan 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.40 
Target VersionFixed in Version2.40 
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
Summary0011755: 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
blocks defect 0011693 closed harikrishnan Date filter does not work properly in Order line selector 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-12-12 11:09rafarodaTypedefect => backport
2009-12-12 11:09rafarodafix_in_branch => 2.40
2009-12-12 11:09rafarodaTag Attached: page data grid
2009-12-23 07:55harikrishnanAssigned Torafaroda => harikrishnan
2009-12-23 07:56harikrishnanNote Added: 0023026
2009-12-23 07:56harikrishnanStatusscheduled => resolved
2009-12-23 07:56harikrishnanFixed in SCM revision => https://code.openbravo.com/erp/stable/2.40_pageddatagrid/rev/5f7c41a8f54a [^]
2009-12-23 07:56harikrishnanResolutionopen => fixed
2009-12-28 07:41arunkumarNote Added: 0023095
2009-12-28 07:41arunkumarStatusresolved => closed
2009-12-28 07:41arunkumarFixed in Version => 2.40
2010-01-14 13:17hgbotCheckin
2010-01-14 13:17hgbotNote Added: 0023426
2010-01-14 13:17hgbotStatusclosed => resolved
2010-01-14 13:17hgbotFixed in SCM revisionhttps://code.openbravo.com/erp/stable/2.40_pageddatagrid/rev/5f7c41a8f54a [^] => http://code.openbravo.com/erp/stable/2.40/rev/5f7c41a8f54ab9a323c26864cc5f4401f34ea49d [^]
2010-01-14 13:44rafarodaStatusresolved => closed
2010-01-14 13:45rafarodaNote Added: 0023441

Notes
(0023026)
harikrishnan   
2009-12-23 07:56   
This issue is fixed and committed.
(0023095)
arunkumar   
2009-12-28 07:41   
Tested & Working fine
(0023426)
hgbot   
2010-01-14 13:17   
Repository: erp/stable/2.40
Changeset: 5f7c41a8f54ab9a323c26864cc5f4401f34ea49d
Author: Harikrishnan Raja <harikrishnan.raja <at> openbravo.com>
Date: Wed Dec 23 12:07:01 2009 +0530
URL: http://code.openbravo.com/erp/stable/2.40/rev/5f7c41a8f54ab9a323c26864cc5f4401f34ea49d [^]

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

---
M src/org/openbravo/erpCommon/info/SalesOrderLine_data.xsql
---
(0023441)
rafaroda   
2010-01-14 13:45   
Closed since already tested and approved by QA.