0029237: Can't filter by Affinity or Matched Document on Match Statement P&E Window

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0029237

Openbravo ERP

07. Sales management

public

2015-03-11 10:45

2017-05-29 13:45

Reporter

AugustoMauch

Assigned To

Triage Omni OMS

Priority

normal

Severity

minor

Reproducibility

have not tried

Status

new

Resolution

open

Platform

OS Version

Product Version

Target Version

Fixed in Version

Merge Request Status

Review Assigned To

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

0029237: Can't filter by Affinity or Matched Document on Match Statement P&E Window

Description

The following error is shown when the user tries to filter the Match Statement P&E using the Affinity column:

3227068 [http-8080-1] ERROR org.hibernate.util.JDBCExceptionReporter - ERROR: no existe la columna «affinity»
  Position: 3633
3227068 [http-8080-1] ERROR org.openbravo.service.datasource.DataSourceServlet - could not execute query
org.hibernate.exception.SQLGrammarException: could not execute query
    at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
    at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
    at org.hibernate.loader.Loader.doList(Loader.java:2536)
    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)

Probably it majes no sense to use that column to filter, it either should be disabled or ignored, but it should not throw an exception.

When the user tries to use the Matched Document column to filter the Match Statement P&E no error is shown in the console, but no results are returned

Steps To Reproduce

As F&B Admin:
- Open Financial Account
- Select the Cuenta de Banco account.
- Click on the Matched Statement button. If there are no records you might need to reactivate the last transaction
- Try to filter using the Affinity or the Matched Document column, it will not work properly

Proposed Solution

Additional Information

Tags

No tags attached.

Relationships

related to	defect	0029235		new	Triage Omni OMS	can't filter by Writeoff in Order/Invoice P&E window
related to	defect	0029239		new	Triage Omni OMS	can't filter by Returned in Return Orphan Lines P&E window