Openbravo Issue Tracking System - Retail Modules |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0028335 | Retail Modules | Cash up | public | 2014-12-02 12:47 | 2015-04-16 15:17 |
|
| Reporter | malsasua | |
| Assigned To | mario_castello | |
| Priority | high | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 20 | OS Version | Community Appliance |
| Product Version | | |
| Target Version | | Fixed in Version | RR15Q2 | |
| Merge Request Status | |
| Review Assigned To | adrianromero |
| OBNetwork customer | |
| Support ticket | |
| Regression level | Coding ( Testing ) |
| Regression date | |
| Regression introduced in release | |
| Regression introduced by commit | |
| Triggers an Emergency Pack | No |
|
| Summary | 0028335: in backoffice, the cash up report does not work when the cashup includes quotations |
| Description | The 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 | |
| Tags | No tags attached. |
| Relationships | | depends on | backport | 0029451 | RR15Q1.3 | closed | mario_castello | in backoffice, the cash up report does not work when the cashup includes quotations | | has duplicate | defect | 0029278 | | closed | marvintm | The Cash Up report fails on the backend if it is has not been closed |
|
| Attached Files | |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2014-12-02 12:47 | malsasua | New Issue | |
| 2014-12-02 12:47 | malsasua | Assigned To | => marvintm |
| 2014-12-02 12:47 | malsasua | Triggers an Emergency Pack | => No |
| 2014-12-02 19:03 | malsasua | Regression level | => Coding ( Testing ) |
| 2014-12-02 19:26 | malsasua | Note Added: 0072255 | |
| 2014-12-02 19:28 | malsasua | Note Edited: 0072255 | bug_revision_view_page.php?bugnote_id=0072255#r7205 |
| 2015-01-08 15:31 | mario_castello | Assigned To | marvintm => mario_castello |
| 2015-01-08 15:32 | mario_castello | Status | new => scheduled |
| 2015-01-08 15:32 | mario_castello | fix_in_branch | => pi |
| 2015-02-04 17:51 | hgbot | Checkin | |
| 2015-02-04 17:51 | hgbot | Note Added: 0074091 | |
| 2015-02-04 17:51 | hgbot | Status | scheduled => resolved |
| 2015-02-04 17:51 | hgbot | Resolution | open => fixed |
| 2015-02-04 17:51 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/2d720a2fe3967ab3faae81ff538daecc0ced9c07 [^] |
| 2015-02-20 13:34 | migueldejuana | Review Assigned To | => migueldejuana |
| 2015-02-20 13:34 | migueldejuana | Note Added: 0074718 | |
| 2015-02-20 13:34 | migueldejuana | Status | resolved => closed |
| 2015-03-30 09:24 | malsasua | Status | closed => new |
| 2015-03-30 09:24 | malsasua | Resolution | fixed => open |
| 2015-03-30 09:24 | malsasua | Status | new => scheduled |
| 2015-03-30 09:24 | malsasua | Status | scheduled => resolved |
| 2015-03-30 09:24 | malsasua | Fixed in Version | => RR15Q2 |
| 2015-03-30 09:24 | malsasua | Resolution | open => fixed |
| 2015-03-30 09:25 | malsasua | Note Added: 0076108 | |
| 2015-03-30 09:25 | malsasua | Status | resolved => closed |
| 2015-03-30 09:27 | malsasua | Relationship added | has duplicate 0029278 |
| 2015-04-10 15:03 | hgbot | Checkin | |
| 2015-04-10 15:03 | hgbot | Note Added: 0076452 | |
| 2015-04-10 15:03 | hgbot | Status | closed => resolved |
| 2015-04-10 15:03 | hgbot | Fixed in SCM revision | http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/2d720a2fe3967ab3faae81ff538daecc0ced9c07 [^] => http://code.openbravo.com/retail/backports/3.0RR15Q1.3/org.openbravo.retail.posterminal/rev/a90ac2423927e1ce7ef84ca55f97b6b0916eb3b8 [^] |
| 2015-04-16 15:17 | adrianromero | Review Assigned To | migueldejuana => adrianromero |
| 2015-04-16 15:17 | adrianromero | Note Added: 0076591 | |
| 2015-04-16 15:17 | adrianromero | Status | resolved => closed |
|
Notes |
|
|
(0072255)
|
|
malsasua
|
2014-12-02 19:26
(edited on: 2014-12-02 19:28) |
|
with the development that the cashup always is synced with backend, in pos terminal window, in cashup report tab, the last cashup is the present cashup, it is not finished yet, then when you try to print the report of this cashup, the error reported is returned
|
|
|
|
(0074091)
|
|
hgbot
|
|
2015-02-04 17:51
|
|
|
|
|
|
|
Tested and reviewed in 98cbad1907b7 |
|
|
|
|
|
reopened to create backport |
|
|
|
(0076452)
|
|
hgbot
|
|
2015-04-10 15:03
|
|
|
|
|
|
|
Verified. Now if the cashup is not processed yet, it cannot be printed. |
|