Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0011758Openbravo ERPZ. Otherspublic2009-12-09 07:002010-01-14 13:45
arunkumar 
rafaroda 
normalmajorhave not tried
closedfixed 
5
2.40 
2.40 
Core
No
0011758: Amount filter does not work properly in Invoice line selector
In the Information -> Invoice line selector the amount filter does not work properly.We have two fields called "Total Amount From" and "To".By creating an invoice 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 Invoice
Create a sales invoice with 10 lines. Each have the amount as 10,20,30,40,50,60,70,80,90,100.
Complete the sales invoice.

Click Information -> Invoice line
The popup will appear.
Enter the recently created sales invoice 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 invoice. For example the grand total amount of the invoice comes around 600 if we enter the amount values as 550 in From filed and 650 in To field we will be able to see the 10 invoice lines there.

The filter should not consider the "Grand Total Amount" of the sales invoice.It should consider the summed line net amount of the invoice lines.
page data grid
blocks defect 0011687 closed rafaroda Amount filter does not work properly in Invoice line selector 
Issue History
2009-12-12 11:28rafarodaTypedefect => backport
2009-12-12 11:28rafarodafix_in_branch => 2.40
2009-12-12 11:28rafarodaTag Attached: page data grid
2009-12-22 11:02harikrishnanNote Added: 0023001
2009-12-22 11:02harikrishnanStatusscheduled => resolved
2009-12-22 11:02harikrishnanFixed in SCM revision => https://code.openbravo.com/erp/stable/2.40_pageddatagrid/rev/e788dc4969f8 [^]
2009-12-22 11:02harikrishnanResolutionopen => fixed
2009-12-28 08:51arunkumarNote Added: 0023101
2009-12-28 08:51arunkumarStatusresolved => closed
2009-12-28 08:51arunkumarFixed in Version => 2.40
2010-01-14 13:17hgbotCheckin
2010-01-14 13:17hgbotNote Added: 0023422
2010-01-14 13:17hgbotStatusclosed => resolved
2010-01-14 13:17hgbotFixed in SCM revisionhttps://code.openbravo.com/erp/stable/2.40_pageddatagrid/rev/e788dc4969f8 [^] => http://code.openbravo.com/erp/stable/2.40/rev/e788dc4969f8a4c0be9d06985339be6374562706 [^]
2010-01-14 13:44rafarodaStatusresolved => closed
2010-01-14 13:45rafarodaNote Added: 0023449

Notes
(0023001)
harikrishnan   
2009-12-22 11:02   
This issue is fixed and committed.
(0023101)
arunkumar   
2009-12-28 08:51   
Tested & Working fine
(0023422)
hgbot   
2010-01-14 13:17   
Repository: erp/stable/2.40
Changeset: e788dc4969f8a4c0be9d06985339be6374562706
Author: Harikrishnan Raja <harikrishnan.raja <at> openbravo.com>
Date: Tue Dec 22 15:12:16 2009 +0530
URL: http://code.openbravo.com/erp/stable/2.40/rev/e788dc4969f8a4c0be9d06985339be6374562706 [^]

Fixes Issue 11758: Amount filter does not work properly in Invoice line selector.

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