0029278: The Cash Up report fails on the backend if it is has not been closed

Description

The Cash Up report fails on 15Q1.1 if it is has not been closed if it has been already closed it prints the report

* On 14Q2 You can create the report of an active cashUp
* On 14Q3 You cannot create the report of an active cashUp
* On 15Q1 If you click the report button on an active cash Up the following error appears on the window.

c59635e2 272808 [http-8080-7] ERROR org.hibernate.hql.PARSER - <AST>:0:0: unexpected end of subtree
c59635e2 272811 [http-8080-7] ERROR org.openbravo.retail.posterminal.ad_reports.CashUpReport - Error captured:
org.hibernate.hql.ast.QuerySyntaxException: unexpected end of subtree [select abs(sum(ordLine.lineNetAmount)) from OrderLine as ordLine where exists (select 1 from FIN_Payment_ScheduleDetail d where d.orderPaymentSchedule.order = ordLine.salesOrder and exists (select 1 from FIN_Finacc_Transaction t where t.reconciliation.id in () and t.finPayment = d.paymentDetails.finPayment))and ordLine.orderedQuantity > 0]
    at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:54)
    at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:47)
    at org.hibernate.hql.ast.ErrorCounter.throwQueryException(ErrorCounter.java:82)
    at org.hibernate.hql.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:261)
    at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:185)
    at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:136)
    at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:101)
    at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:80)
    at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:124)
    at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:156)
    at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:135)
    at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1770)
    at org.openbravo.retail.posterminal.ad_reports.CashUpReport.doPost(CashUpReport.java:543)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
    at org.openbravo.base.HttpBaseServlet.serviceInitialized(HttpBaseServlet.java:222)
    at org.openbravo.base.secureApp.HttpSecureAppServlet.service(HttpSecureAppServlet.java:449)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.openbravo.utils.SessionExpirationFilter.doFilter(SessionExpirationFilter.java:66)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.openbravo.utils.CharsetFilter.doFilter(CharsetFilter.java:35)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.openbravo.client.kernel.KernelFilter$1.doAction(KernelFilter.java:62)
    at org.openbravo.dal.core.ThreadHandler.run(ThreadHandler.java:46)
    at org.openbravo.client.kernel.KernelFilter.doFilter(KernelFilter.java:71)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.openbravo.dal.core.DalRequestFilter$1.doAction(DalRequestFilter.java:81)
    at org.openbravo.dal.core.ThreadHandler.run(ThreadHandler.java:46)
    at org.openbravo.dal.core.DalRequestFilter.doFilter(DalRequestFilter.java:103)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:291)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)
    at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
    at java.lang.Thread.run(Thread.java:701)

* On PI the button does not appear

Steps To Reproduce

* Login on a 15Q1.1
* Go to POS Terminal Window
* Go to Cash Up History tab
* Select a record that has not been closed

Cash Up Report button appears and if you click it the error appears (See image attached)

Issue History
Date Modified	Username	Field	Change
2015-03-13 19:44	guillermogil	New Issue
2015-03-13 19:44	guillermogil	Assigned To	=> marvintm
2015-03-13 19:44	guillermogil	File Added: Screenshot from 2015-03-13 19:34:03.png
2015-03-13 19:44	guillermogil	OBNetwork customer	=> No
2015-03-13 19:44	guillermogil	Triggers an Emergency Pack	=> No
2015-03-13 19:48	guillermogil	Summary	The Cash Up report fails on the backend on 15Q1.1 if it is has not been closed => The Cash Up report fails on the backend if it is has not been closed
2015-03-16 08:53	guillermogil	Description Updated	View Revisions
2015-03-30 09:27	malsasua	Relationship added	duplicate of 0028335
2015-03-30 09:27	malsasua	Status	new => closed
2015-03-30 09:27	malsasua	Resolution	open => duplicate
2015-03-30 09:27	malsasua	Fixed in Version	=> RR15Q2

Notes
There are no notes attached to this issue.