Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0011692Openbravo ERPZ. Otherspublic2009-12-09 08:372010-01-20 23:25
arunkumar 
harikrishnan 
normalmajorhave not tried
closedfixed 
5
2.40 
pi 
Core
No
0011692: Amount filter does not work properly in Order line selector
In the Information -> Order line selector the amount filter does not work properly.We have two fields called "Total Amount From" and "To".By creating an order with 10 lines each lines have the line net amount of 10,20,30,40,50,60,70,80,90,100. If you use the values 50 in "Total Amount From" and 80 in "To" fields you should be able to see four lines which have the amount of 50,60,70,80. But it does not display anything.
Login as Openbravo/openbravo and role as "Openbravo Admin".
Go to Sales Management -> Transactions -> Sales Order
Create a sales Order with 10 lines. Each have the amount as 10,20,30,40,50,60,70,80,90,100.
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 and Enter 50 as "Total Amount From" and 80 in "To" fields.
You will not see anything.
 It considers the Grand Total Amount of the sales order. For example the grand total amount of the invoice comes around 600 if we enter the amount values as 550 in From field and 650 in To field we will be able to see the 10 order lines there.

The filter should not consider the "Grand Total Amount" of the sales order header.It should consider the summed line net amount of the order lines.
page data grid
depends on backport 0011756 closed harikrishnan Amount filter does not work properly in Order line selector 
Issue History
2009-12-09 08:37arunkumarNew Issue
2009-12-09 08:37arunkumarAssigned To => rafaroda
2009-12-09 10:28arunkumarTag Attached: page data grid
2009-12-12 11:09rafarodaStatusnew => scheduled
2009-12-12 11:09rafarodafix_in_branch => pi
2009-12-22 13:13harikrishnanAssigned Torafaroda => harikrishnan
2009-12-22 13:13harikrishnanNote Added: 0023011
2009-12-22 13:13harikrishnanStatusscheduled => resolved
2009-12-22 13:13harikrishnanFixed in SCM revision => https://code.openbravo.com/erp/devel/pi-pageddatagrid/rev/4f1b01ae6572 [^]
2009-12-22 13:13harikrishnanResolutionopen => fixed
2009-12-28 12:50arunkumarNote Added: 0023109
2009-12-28 12:50arunkumarStatusresolved => closed
2009-12-28 12:50arunkumarFixed in Version => pi
2009-12-29 00:00anonymoussf_bug_id0 => 2922536
2010-01-14 11:27hgbotCheckin
2010-01-14 11:27hgbotNote Added: 0023410
2010-01-14 11:27hgbotStatusclosed => resolved
2010-01-14 11:27hgbotFixed in SCM revisionhttps://code.openbravo.com/erp/devel/pi-pageddatagrid/rev/4f1b01ae6572 [^] => http://code.openbravo.com/erp/devel/pi/rev/4f1b01ae6572d4319dae587c0ec67008558e5a84 [^]
2010-01-14 13:44rafarodaStatusresolved => closed
2010-01-14 13:45rafarodaNote Added: 0023442
2010-01-20 23:25hudsonbotCheckin
2010-01-20 23:25hudsonbotNote Added: 0023646

Notes
(0023011)
harikrishnan   
2009-12-22 13:13   
This issue is fixed and committed.
(0023109)
arunkumar   
2009-12-28 12:50   
Tested & Working fine
(0023410)
hgbot   
2010-01-14 11:27   
Repository: erp/devel/pi
Changeset: 4f1b01ae6572d4319dae587c0ec67008558e5a84
Author: Harikrishnan Raja <harikrishnan.raja <at> openbravo.com>
Date: Tue Dec 22 17:42:24 2009 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/4f1b01ae6572d4319dae587c0ec67008558e5a84 [^]

Fixes Issue 11692: Amount filter does not work properly in Order line selector.

---
M src/org/openbravo/erpCommon/info/SalesOrderLine_data.xsql
---
(0023442)
rafaroda   
2010-01-14 13:45   
Closed since already tested and approved by QA.
(0023646)
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/4f1b01ae6572 [^]
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 [^]