Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0029239
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 07. Sales managementminorhave not tried2015-03-11 10:522017-05-29 13:45
ReporterAugustoMauchView Statuspublic 
Assigned ToTriage Omni OMS 
PrioritynormalResolutionopenFixed in Version
StatusnewFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

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

DescriptionWhen 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 ReproduceAs 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.
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0029224 closedAugustoMauch can't filter by Return Reason in Return P&E windows 
related to defect 0029235 newTriage Omni OMS can't filter by Writeoff in Order/Invoice P&E window 
related to defect 0029237 newTriage Omni OMS Can't filter by Affinity or Matched Document on Match Statement P&E Window 

-  Notes
There are no notes attached to this issue.

- Issue History
Date Modified Username Field Change
2015-03-11 10:52 AugustoMauch New Issue
2015-03-11 10:52 AugustoMauch Assigned To => Sandrahuguet
2015-03-11 10:52 AugustoMauch Modules => Core
2015-03-11 10:52 AugustoMauch Triggers an Emergency Pack => No
2015-03-11 10:53 AugustoMauch Relationship added related to 0029224
2015-03-11 10:53 AugustoMauch Relationship added related to 0029235
2015-03-11 10:54 AugustoMauch Relationship added related to 0029237
2017-05-29 13:45 Sandrahuguet Assigned To Sandrahuguet => Triage Finance

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker