0029239: can't filter by Returned in Return Orphan Lines P&E window

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0029239

Openbravo ERP

07. Sales management

public

2015-03-11 10:52

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

0029239: can't filter by Returned in Return Orphan Lines P&E window

Description

When the user tries to filter the Return Orphan Lines Pick and Execute grid using the returned column, not results are returned and the following exception is shown in the log:

3860171 [http-8080-11] ERROR org.hibernate.util.JDBCExceptionReporter - ERROR: no existe la columna «returned»
  Position: 13261
3860172 [http-8080-11] 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)
    at org.openbravo.service.datasource.ReadOnlyDataSourceService.fetchJSONObject(ReadOnlyDataSourceService.java:137)

Steps To Reproduce

As F&B Admin:
- Set the RM Allow Orphan Line preference to Y
- Refresh the window to reload the preferences
- Open the Return from Customer window
- Create a record in the header tab.
- Add a new orphan line using the Insert Orphan Line button
- Click on the Pick/Edit Lines button
- Try to filter the Orphan Lines grid by using the Returned column. It will not work and an exception will be shown in the log.

Proposed Solution

Additional Information

Tags

No tags attached.

Relationships

related to	defect	0029224	closed	AugustoMauch	can't filter by Return Reason in Return P&E windows
related to	defect	0029235	new	Triage Omni OMS	can't filter by Writeoff in Order/Invoice P&E window
related to	defect	0029237	new	Triage Omni OMS	Can't filter by Affinity or Matched Document on Match Statement P&E Window