Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0041420Retail ModulesWeb POSpublic2019-07-22 19:112019-08-05 08:53
Reporterguillermogil 
Assigned Toalekosmp86 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in VersionRR19Q4 
Merge Request Status
Review Assigned Tomarvintm
OBNetwork customerGold
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0041420: Loading a ticket with a payment that is not configured fails
DescriptionThe payment type of the current payment is not configured for the webpos
The following error appears:

Caused by: java.lang.IllegalArgumentException: org.hibernate.hql.internal.ast.QuerySyntaxException: expecting EOF, found ')' near line 1, column 383 [select p.paymentMethod.name as name, p.account.id as account, obpos_currency_rate(p.account.currency, p.organization.currency, null, null, p.client.id, p.organization.id) as rate, obpos_currency_rate(p.organization.currency, p.account.currency, null, null, p.client.id, p.organization.id) as mulrate, p.account.currency.iSOCode as isocode from FIN_Payment as p where p.id=:paymentId)]
        at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:133) ~[hibernate-core-5.3.2.Final.jar:5.3.2.Final]
        at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:157) ~[hibernate-core-5.3.2.Final.jar:5.3.2.Final]
        at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:164) ~[hibernate-core-5.3.2.Final.jar:5.3.2.Final]
        at org.hibernate.internal.AbstractSharedSessionContract.createQuery(AbstractSharedSessionContract.java:715) ~[hibernate-core-5.3.2.Final.jar:5.3.2.Final]
        at org.hibernate.internal.AbstractSharedSessionContract.createQuery(AbstractSharedSessionContract.java:731) ~[hibernate-core-5.3.2.Final.jar:5.3.2.Final]
        at org.hibernate.internal.AbstractSharedSessionContract.createQuery(AbstractSharedSessionContract.java:105) ~[hibernate-core-5.3.2.Final.jar:5.3.2.Final]
        at org.openbravo.retail.posterminal.PaidReceipts.exec(PaidReceipts.java:460) ~[classes/:?]
        ... 53 more
Steps To ReproduceCreate a ticket with Credit card
Deconfigure the payment method
Reload Webpos
Load that ticket
Proposed SolutionSee diff attached
Additional Information
TagsNo tags attached.
Relationships
related to defect 0041622 closed rqueralta Invoices paid with inactive payment methods cannot be printed from WebPOS 
Attached Filesdiff Issue41420.diff (1,139) 2019-07-22 19:21
https://issues.openbravo.com/file_download.php?file_id=13163&type=bug
Issue History
Date ModifiedUsernameFieldChange
2019-07-22 19:11guillermogilNew Issue
2019-07-22 19:11guillermogilAssigned To => Retail
2019-07-22 19:11guillermogilOBNetwork customer => Gold
2019-07-22 19:11guillermogilResolution time => 1564783200
2019-07-22 19:11guillermogilTriggers an Emergency Pack => No
2019-07-22 19:21guillermogilFile Added: Issue41420.diff
2019-07-22 19:21guillermogilReproducibilityhave not tried => always
2019-08-01 20:54alekosmp86Assigned ToRetail => alekosmp86
2019-08-02 20:02hgbotCheckin
2019-08-02 20:02hgbotNote Added: 0113793
2019-08-02 20:02hgbotStatusnew => resolved
2019-08-02 20:02hgbotResolutionopen => fixed
2019-08-02 20:02hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/a58838d2da07b7ad137f0410f680c503677320a4 [^]
2019-08-05 08:53marvintmReview Assigned To => marvintm
2019-08-05 08:53marvintmStatusresolved => closed
2019-08-05 08:53marvintmFixed in Version => RR19Q4
2019-08-09 11:03aaroncaleroRelationship addedrelated to 0041622

Notes
(0113793)
hgbot   
2019-08-02 20:02   
Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: a58838d2da07b7ad137f0410f680c503677320a4
Author: Guillermo Gil <guillermo.gil <at> openbravo.com>
Date: Mon Jul 22 18:36:52 2019 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/a58838d2da07b7ad137f0410f680c503677320a4 [^]

Fixed issue 41420: Removed wrong ) on PaidReceipts

---
M src/org/openbravo/retail/posterminal/PaidReceipts.java
---