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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0011692
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] Z. Othersmajorhave not tried2009-12-09 08:372010-01-20 23:25
ReporterarunkumarView Statuspublic 
Assigned Toharikrishnan 
PrioritynormalResolutionfixedFixed in Versionpi
StatusclosedFix in branchpiFixed in SCM revision4f1b01ae6572
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

0011692: Amount filter does not work properly in Order line selector

DescriptionIn 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.
Steps To ReproduceLogin 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.
Proposed Solution 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.
Tagspage data grid
Attached Files

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

-  Notes
(0023011)
harikrishnan (reporter)
2009-12-22 13:13

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

Tested & Working fine
(0023410)
hgbot (developer)
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 (developer)
2010-01-14 13:45

Closed since already tested and approved by QA.
(0023646)
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/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 [^]

- Issue History
Date Modified Username Field Change
2009-12-09 08:37 arunkumar New Issue
2009-12-09 08:37 arunkumar Assigned To => rafaroda
2009-12-09 10:28 arunkumar Tag Attached: page data grid
2009-12-12 11:09 rafaroda Status new => scheduled
2009-12-12 11:09 rafaroda fix_in_branch => pi
2009-12-22 13:13 harikrishnan Assigned To rafaroda => harikrishnan
2009-12-22 13:13 harikrishnan Note Added: 0023011
2009-12-22 13:13 harikrishnan Status scheduled => resolved
2009-12-22 13:13 harikrishnan Fixed in SCM revision => https://code.openbravo.com/erp/devel/pi-pageddatagrid/rev/4f1b01ae6572 [^]
2009-12-22 13:13 harikrishnan Resolution open => fixed
2009-12-28 12:50 arunkumar Note Added: 0023109
2009-12-28 12:50 arunkumar Status resolved => closed
2009-12-28 12:50 arunkumar Fixed in Version => pi
2009-12-29 00:00 anonymous sf_bug_id 0 => 2922536
2010-01-14 11:27 hgbot Checkin
2010-01-14 11:27 hgbot Note Added: 0023410
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/4f1b01ae6572 [^] => http://code.openbravo.com/erp/devel/pi/rev/4f1b01ae6572d4319dae587c0ec67008558e5a84 [^]
2010-01-14 13:44 rafaroda Status resolved => closed
2010-01-14 13:45 rafaroda Note Added: 0023442
2010-01-20 23:25 hudsonbot Checkin
2010-01-20 23:25 hudsonbot Note Added: 0023646


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker