0056911: org.hibernate.execption when launching "Issue Order" function in a Sale with 2 deposit invoices

Openbravo Issue Tracking System - POS2
View Issue Details

ID	Project	Category	View Status	Date Submitted	Last Update
0056911	POS2	POS	public	2024-10-28 09:38	2024-11-20 10:33

Reporter	psanjuan
Assigned To	radhakrishnan
Priority	urgent	Severity	major	Reproducibility	always
Status	new	Resolution	open
Platform		OS	30	OS Version	Openbravo Appliance 14.04
Product Version
Target Version		Fixed in Version
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 Pack	No

Summary	0056911: org.hibernate.execption when launching "Issue Order" function in a Sale with 2 deposit invoices
Description	org.hibernate.exeception when launching "Issue Order" function in a Sale with 2 deposit invoices. See image attached.
Steps To Reproduce	In livebuilds (modules_pgsql backend) Configure deposit invoice feature by: - selecting "Generate Simplified Invoice" and "Enable Deposit Invoice" in the channel touchpoint type" - enable Prepayment and Partial Payments in the store, and entering the "prepayment percentage", and "prepayment percentage limit" (50 - 50 for instance) - selecting "After Delivery" invoice term in Arturo Montoro - entering de prefix for the Deposit Invoice in the channel touchpoint (ie. DI) - creating a deposit item (resource type) which must be included also in the store in the field "Deposit Item". - configuring a Deposit Invoice DocumentType as AR_Invoice, and selecting this document type in the POS Order of the Store. After that: Create an order for Arturo Montoro, of a product with "Pick up in Store" delivery term. Pay partially 50% Complete the order Go to the Orders menu and select the order. Pay it completely (50%) Go to the Orders menu and select the order and the option "Issue Order". The error attached is shown.
Proposed Solution	No error should be shown. It should be possible to deliver the order.
Additional Information
Tags	No tags attached.
Relationships
Attached Files	Screenshot 2024-10-28 092857.png (177,954) 2024-10-28 09:39 https://issues.openbravo.com/file_download.php?file_id=20384&type=bug Screenshot 2024-10-28 092952.png (68,044) 2024-10-28 09:39 https://issues.openbravo.com/file_download.php?file_id=20385&type=bug

Issue History
Date Modified	Username	Field	Change
2024-10-28 09:38	psanjuan	New Issue
2024-10-28 09:38	psanjuan	Assigned To	=> Retail
2024-10-28 09:38	psanjuan	Triggers an Emergency Pack	=> No
2024-10-28 09:39	psanjuan	Steps to Reproduce Updated	bug_revision_view_page.php?rev_id=28682#r28682
2024-10-28 09:39	psanjuan	File Added: Screenshot 2024-10-28 092857.png
2024-10-28 09:39	psanjuan	File Added: Screenshot 2024-10-28 092952.png
2024-10-28 09:47	psanjuan	Assigned To	Retail => Triage Omni OMS
2024-10-28 13:18	aferraz	Assigned To	Triage Omni OMS => radhakrishnan
2024-10-28 13:19	aferraz	Note Added: 0171049
2024-11-20 10:33	hgbot	Note Added: 0172307

Notes