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

Anonymous | Login

Project:

News | My View | View Issues | Roadmap | Summary

View Revisions: Issue #28565		[ Back to Issue ]
Summary	0028565: not possible to filter by LineNo field in Match LC Cost

Revision	2015-01-13 10:47 by alostale
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.

Revision	2015-01-13 10:47 by alostale
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 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 "Line No.". See that no data is displayed and the above error is triggered in the log.

Revision	2015-01-13 10:47 by alostale
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)

Revision	2015-01-13 10:47 by alostale
Description	Is not possible to filter Integer type columns on HQL Based Tables. 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)