Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0029451 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| backport | [Retail Modules] Cash up | major | always | 2014-12-02 12:47 | 2015-04-22 09:33 | |||
| Reporter | malsasua | View Status | public | |||||
| Assigned To | mario_castello | |||||||
| Priority | high | Resolution | fixed | Fixed in Version | RR15Q1.3 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | 2d720a2fe396 | ||||
| Projection | none | ETA | none | Target Version | RR15Q1.3 | |||
| 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 | |||||||
| Review Assigned To | adrianromero | |||||||
| Regression level | Coding ( Testing ) | |||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0029451: 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 | Approved | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0076463) Orekaria (administrator) 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 (manager) 2015-04-13 17:45 |
Verified. Now if the cashup is not processed yet, it cannot be printed. |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2015-03-30 09:24 | malsasua | Type | defect => backport |
| 2015-03-30 09:24 | malsasua | Target Version | => RR15Q1.3 |
| 2015-03-30 09:27 | dmitry_mezentsev | Tag Attached: Approved | |
| 2015-04-01 13:33 | malsasua | Assigned To | mario_castello => Retail |
| 2015-04-01 13:33 | malsasua | fix_in_branch | pi => |
| 2015-04-13 11:44 | Orekaria | Note Added: 0076463 | |
| 2015-04-13 11:44 | Orekaria | Status | scheduled => resolved |
| 2015-04-13 11:44 | Orekaria | Fixed in Version | => RR15Q1.3 |
| 2015-04-13 11:44 | Orekaria | Resolution | open => fixed |
| 2015-04-13 17:45 | adrianromero | Review Assigned To | migueldejuana => adrianromero |
| 2015-04-13 17:45 | adrianromero | Note Added: 0076498 | |
| 2015-04-13 17:45 | adrianromero | Status | resolved => closed |
| 2015-04-22 09:33 | marvintm | Assigned To | Retail => mario_castello |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |