Openbravo Issue Tracking System - POS2
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0053917POS2POSpublic2023-11-13 12:162023-11-19 11:27
Reportermeriem_azaf 
Assigned Tomeriem_azaf 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version24Q1 
Merge Request Status
Review Assigned To
OBNetwork customer
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0053917: Error when trying to opening a ticket with two returned lines
DescriptionWhen we create a ticket with two returned lines, and then opening it in the Orders window.
An error showed "ERROR in PaidReceipts: query did not return a unique result:2".
Steps To Reproduce1- Login POS2.
2- Create a new ticket with two products( you can choose what you want).
3- Click in return line button for the two products and try to fill in the inputs in return line dialog.
4- Go to order window and click on the ticket that you did.

An error showed "ERROR in PaidReceipts: query did not return a unique result:2".
 
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
caused by feature request 0053576 closed Triage Platform Base User Action Inputs improvements 
Attached Filespng unnamed (1).png (119,107) 2023-11-13 12:16
https://issues.openbravo.com/file_download.php?file_id=19145&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2023-11-13 12:16meriem_azafNew Issue
2023-11-13 12:16meriem_azafAssigned To => Retail
2023-11-13 12:16meriem_azafFile Added: unnamed (1).png
2023-11-13 12:16meriem_azafTriggers an Emergency Pack => No
2023-11-13 12:16meriem_azafAssigned ToRetail => meriem_azaf
2023-11-13 12:16meriem_azafStatusnew => scheduled
2023-11-13 12:20meriem_azafSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=27109#r27109
2023-11-13 12:25hgbotNote Added: 0157092
2023-11-13 12:31caristuRelationship addedcaused by 0053576
2023-11-14 17:38hgbotNote Added: 0157147
2023-11-19 10:24hgbotResolutionopen => fixed
2023-11-19 10:24hgbotStatusscheduled => closed
2023-11-19 10:24hgbotFixed in Version => 24Q1
2023-11-19 10:24hgbotNote Added: 0157303
2023-11-19 10:24hgbotNote Added: 0157304
2023-11-19 11:27hgbotNote Added: 0157307
2023-11-19 11:27hgbotNote Added: 0157308

Notes
(0157092)
hgbot   
2023-11-13 12:25   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2/-/merge_requests/2234 [^]
(0157147)
hgbot   
2023-11-14 17:38   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2.sampledata/-/merge_requests/68 [^]
(0157303)
hgbot   
2023-11-19 10:24   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2.sampledata [^]
Changeset: 63ba81acfc8a9caf6aefd896364fd3d2c907ab8a
Author: Meriem Azaf <meriem.azaf@openbravo.com>
Date: 16-11-2023 10:32:33
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2.sampledata/-/commit/63ba81acfc8a9caf6aefd896364fd3d2c907ab8a [^]

Fixes ISSUE-53917: Prepare sampledata for approval reason history, approval inputs history, c_order and c_orderLine

---
A referencedata/sampledata/The_White_Valley_Group/C_ORDER.xml
A referencedata/sampledata/The_White_Valley_Group/C_ORDERLINE.xml
A referencedata/sampledata/The_White_Valley_Group/OBC2_APPROVAL_INPUTS_HIST.xml
A referencedata/sampledata/The_White_Valley_Group/OBC2_APPROVAL_REASON_HIST.xml
M src-db/database/sourcedata/AD_DATASET_TABLE.xml
---
(0157304)
hgbot   
2023-11-19 10:24   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2.sampledata/-/merge_requests/68 [^]
(0157307)
hgbot   
2023-11-19 11:27   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2 [^]
Changeset: fdd83b82f40fe8b2c79a81a967cac2653a940c2e
Author: Meriem Azaf <meriem.azaf@openbravo.com>
Date: 19-11-2023 10:31:51
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2/-/commit/fdd83b82f40fe8b2c79a81a967cac2653a940c2e [^]

Fixes ISSUE-53917: Error when trying to opening a ticket with two returned lines

When we create a ticket with two returned lines, and then opening it in the Orders window.
An error showed "ERROR in PaidReceipts: query did not return a unique result:2".

The problem was in the "getApprovalReasonHistory" that was returning a unique result instead of a list.

---
A src-test/org/openbravo/pos2/hook/paidreceipt/AddInputInfoToPaidReceiptTest.java
M src-test/org/openbravo/pos2/StandaloneTestSuite.java
M src/org/openbravo/pos2/hook/paidreceipt/AddInputInfoToPaidReceipt.java
---
(0157308)
hgbot   
2023-11-19 11:27   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2/-/merge_requests/2234 [^]