Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0028563Openbravo ERP04. Warehouse managementpublic2015-01-12 12:012015-02-04 20:33
Reporterumartirena 
Assigned Toumartirena 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0PR15Q2 
Merge Request Status
Review Assigned ToSandrahuguet
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0028563: Some filters in "Match LC Costs" P&E are not working
DescriptionSome filters in "Match LC Costs" P&E are not working
Steps To ReproduceIn QA Testing Client navigate to Landed Cost window, create a new one for "Spain" organization dated on 07/01/2015.

Go to "Cost" tab and create a new record.
Select a landed cost type (of "Product" type), for instance "Transportation Cost", enter an Amount of 140.00
Create a new record, select same landed cost type and enter a new amount for instance of 50.00
Repeat above step 2 times more.

Go to "Receipt" tab and create a new record. Select a receipt in the field "Goods Receipt". Save.

Go back to the Landed Cost header and process and post landed cost document.

Go to Purchase order window and create a new one. Select the product set as product landed cost type and enter an invoiced quatity = 1, Net Unit Price = 290. Complete the invoice.

In the line click on "Match LC Cost" process button.

Try to filter by the following columns:
 * Line No.
 * Matched In Others
 * Currency
 * Receipt Lines
 * Products
 * Matched Amt
 * Other Match Invoice Lines
 * Matched
 * Is Matching Adjusted
 * Process Matching

Realize that the filtering is not working
Proposed SolutionThis grid has been implemented using an hql query based table.

Add a correct Entity Alias on all this columns in Tables and Columns window.
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2015-01-12 12:01umartirenaNew Issue
2015-01-12 12:01umartirenaAssigned To => dmiguelez
2015-01-12 12:01umartirenaModules => Core
2015-01-12 12:01umartirenaTriggers an Emergency Pack => No
2015-01-12 12:02umartirenaAssigned Todmiguelez => umartirena
2015-01-12 12:10hgbotCheckin
2015-01-12 12:10hgbotNote Added: 0073415
2015-01-12 12:10hgbotStatusnew => resolved
2015-01-12 12:10hgbotResolutionopen => fixed
2015-01-12 12:10hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/58a649b1671a45b3351e699fcf3bfc6f84efa1e0 [^]
2015-01-14 13:06SandrahuguetReview Assigned To => Sandrahuguet
2015-01-14 13:06SandrahuguetNote Added: 0073488
2015-01-14 13:06SandrahuguetStatusresolved => closed
2015-01-14 13:06SandrahuguetFixed in Version => 3.0PR15Q2
2015-02-04 20:33hudsonbotCheckin
2015-02-04 20:33hudsonbotNote Added: 0074134

Notes
(0073415)
hgbot   
2015-01-12 12:10   
Repository: erp/devel/pi
Changeset: 58a649b1671a45b3351e699fcf3bfc6f84efa1e0
Author: Unai Martirena <unai.martirena <at> openbravo.com>
Date: Mon Jan 12 12:07:15 2015 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/58a649b1671a45b3351e699fcf3bfc6f84efa1e0 [^]

Fixes bug 28563: Filters in Match LC Costs P&E now are working

This grid has been implemented using an hql query based table. The entity alias field was empty for all this columns, and it is necessary to correct implementation of the filtering, so the left part of the select has been added on all of them.

---
M src-db/database/sourcedata/AD_COLUMN.xml
---
(0073488)
Sandrahuguet   
2015-01-14 13:06   
Code review + testing OK
(0074134)
hudsonbot   
2015-02-04 20:33   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/f36c91d0ad63 [^]
Maturity status: Test