0028565: not possible to filter by LineNo field in Match LC Cost

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0028565

Openbravo ERP

04. Warehouse management

public

2015-01-12 12:23

2015-02-04 20:34

Reporter

umartirena

Assigned To

umartirena

Priority

high

Severity

major

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS Version

Product Version

Target Version

Fixed in Version

3.0PR15Q2

Merge Request Status

Review Assigned To

Sandrahuguet

OBNetwork customer

Web browser

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

0028565: not possible to filter by LineNo field in Match LC Cost

Description

It is not possible to filter by LineNo field in Match LC Cost. While trying to filter a column of this type no data is displayed in the grid and an error appears in console.

ERROR org.openbravo.client.kernel.KernelUtils - java.lang.Long cannot be cast to java.math.BigDecimal
java.lang.ClassCastException: java.lang.Long cannot be cast to java.math.BigDecimal
    at org.hibernate.type.descriptor.java.BigDecimalTypeDescriptor.unwrap(BigDecimalTypeDescriptor.java:36)
    at org.hibernate.type.descriptor.sql.DecimalTypeDescriptor$1.doBind(DecimalTypeDescriptor.java:53)
    at org.hibernate.type.descriptor.sql.BasicBinder.bind(BasicBinder.java:91)
    at org.hibernate.type.AbstractStandardBasicType.nullSafeSet(AbstractStandardBasicType.java:282)
    at org.hibernate.type.AbstractStandardBasicType.nullSafeSet(AbstractStandardBasicType.java:277)
    at org.hibernate.param.NamedParameterSpecification.bind(NamedParameterSpecification.java:67)
    at org.hibernate.loader.hql.QueryLoader.bindParameterValues(QueryLoader.java:571)
    at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1716)
    at org.hibernate.loader.Loader.doQuery(Loader.java:801)
    at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
    at org.hibernate.loader.Loader.doList(Loader.java:2533)
    at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
    at org.hibernate.loader.Loader.list(Loader.java:2271)
    at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:452)
    at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363)
    at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
    at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268)
    at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
    at org.openbravo.service.datasource.HQLDataSourceService.getData(HQLDataSourceService.java:179)
    at org.openbravo.service.datasource.ReadOnlyDataSourceService.fetchJSONObject(ReadOnlyDataSourceService.java:137)
    at org.openbravo.service.datasource.ReadOnlyDataSourceService.fetch(ReadOnlyDataSourceService.java:70)
    at org.openbravo.service.datasource.DataSourceServlet.doFetch(DataSourceServlet.java:261)
    at org.openbravo.service.datasource.DataSourceServlet.doPost(DataSourceServlet.java:747)

Steps To Reproduce

In 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 Invoice 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 "Line No.". See that no data is displayed and the above error is triggered in the log.

Proposed Solution

Additional Information

Tags

No tags attached.

Relationships

related to	defect	0028545	closed	alostale	Some filters in Grids built on HQL Based Table they don't work any more
related to	defect	0028530	closed	alostale	Not possible to enter a matched amount while clicking on second landed cost line in "Match LC Costs" window.
related to	defect	0028600	closed	umartirena	API Break on Cost Adjustments Project (try-api 1152)