Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0028335 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Retail Modules] Cash up | major | always | 2014-12-02 12:47 | 2015-04-16 15:17 | |||
| Reporter | malsasua | View Status | public | |||||
| Assigned To | mario_castello | |||||||
| Priority | high | Resolution | fixed | Fixed in Version | RR15Q2 | |||
| Status | closed | Fix in branch | pi | Fixed in SCM revision | a90ac2423927 | |||
| Projection | none | ETA | none | Target Version | ||||
| OS | Linux 32 bit | Database | PostgreSQL | Java version | 1.6.0_18 | |||
| OS Version | Community Appliance | Database version | 8.3.9 | Ant version | 1.7.1 | |||
| Product Version | SCM revision | |||||||
| Merge Request Status | ||||||||
| Review Assigned To | adrianromero | |||||||
| OBNetwork customer | No | |||||||
| 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] | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|||||||||||||||
|
|||||||||||||||
 Relationships |
|
Notes |
|
|
(0072255) malsasua (viewer) 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 (developer) 2015-02-04 17:51 |
Repository: erp/pmods/org.openbravo.retail.posterminal Changeset: 2d720a2fe3967ab3faae81ff538daecc0ced9c07 Author: Mario Castello <mario.castello <at> peoplewalking.com> Date: Wed Feb 04 10:50:49 2015 -0600 URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/2d720a2fe3967ab3faae81ff538daecc0ced9c07 [^] 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 --- |
|
(0074718) migueldejuana (viewer) 2015-02-20 13:34 |
Tested and reviewed in 98cbad1907b7 |
|
(0076108) malsasua (viewer) 2015-03-30 09:25 |
reopened to create backport |
|
(0076452) hgbot (developer) 2015-04-10 15:03 |
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 --- |
|
(0076591) adrianromero (viewer) 2015-04-16 15:17 |
Verified. Now if the cashup is not processed yet, it cannot be printed. |
|
Notes |
|
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 | OBNetwork customer | => No |
| 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 | View Revisions |
| 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 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |