Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0029451Retail ModulesCash uppublic2014-12-02 12:472015-04-22 09:33
Reportermalsasua 
Assigned Tomario_castello 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionCommunity Appliance
Product Version 
Target VersionRR15Q1.3Fixed in VersionRR15Q1.3 
Merge Request Status
Review Assigned Toadrianromero
OBNetwork customer
Support ticket
Regression levelCoding ( Testing )
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0029451: in backoffice, the cash up report does not work when the cashup includes quotations
DescriptionThe report of cashup, in the backoffice, does not work when the cashup includes quotations.
Error is returned:

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]
Steps To Reproduce. in webpos (terminal VBS-1):
 . create a receipt
 . pay and close it
 . create a quotation
 . confirm it (under evaluation is displayed)
 . close the quotation
 . do a cashup

. in backoffice
 . go to terminal VBS-1
 . print the previous cashup
error is returned:

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]
Proposed Solution
Additional Information
TagsApproved
Relationships
blocks defect 0028335 closed mario_castello in backoffice, the cash up report does not work when the cashup includes quotations 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2015-03-30 09:24malsasuaTypedefect => backport
2015-03-30 09:24malsasuaTarget Version => RR15Q1.3
2015-03-30 09:27dmitry_mezentsevTag Attached: Approved
2015-04-01 13:33malsasuaAssigned Tomario_castello => Retail
2015-04-01 13:33malsasuafix_in_branchpi =>
2015-04-13 11:44OrekariaNote Added: 0076463
2015-04-13 11:44OrekariaStatusscheduled => resolved
2015-04-13 11:44OrekariaFixed in Version => RR15Q1.3
2015-04-13 11:44OrekariaResolutionopen => fixed
2015-04-13 17:45adrianromeroReview Assigned Tomigueldejuana => adrianromero
2015-04-13 17:45adrianromeroNote Added: 0076498
2015-04-13 17:45adrianromeroStatusresolved => closed
2015-04-22 09:33marvintmAssigned ToRetail => mario_castello

Notes
(0076463)
Orekaria   
2015-04-13 11:44   
Repository: retail/backports/3.0RR15Q1.3/org.openbravo.retail.posterminal
Changeset: a90ac2423927e1ce7ef84ca55f97b6b0916eb3b8
Author: Mario Castello <mario.castello <at> peoplewalking.com>
Date: Wed Feb 04 10:50:49 2015 -0600
URL: http://code.openbravo.com/retail/backports/3.0RR15Q1.3/org.openbravo.retail.posterminal/rev/a90ac2423927e1ce7ef84ca55f97b6b0916eb3b8 [^] [^]

fixed issue 28335: in backoffice, the cash up report does not work when the cashup includes quotations

---
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_FIELD.xml
(0076498)
adrianromero   
2015-04-13 17:45   
Verified. Now if the cashup is not processed yet, it cannot be printed.