0052664: Cash Up in Errors While Importing POS Data cannot be saved again if the amount counted is higher than the amount to keep

Openbravo Issue Tracking System - Retail Modules

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0052664

Retail Modules

Web POS

public

2023-06-05 12:35

2023-06-14 13:06

Reporter

ngarcia

Assigned To

ranjith_qualiantech_com

Priority

urgent

Severity

major

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS Version

Product Version

Target Version

Fixed in Version

RR23Q3

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

Summary

0052664: Cash Up in Errors While Importing POS Data cannot be saved again if the amount counted is higher than the amount to keep

Description

Cash Up in Errors While Importing POS Data cannot be saved again if the amount counted is higher than the amount to keep.

The problem seems to be in the associateTransactions of CashCloseProcessor class

Steps To Reproduce

Used 23Q2 as I was not able to log in in newest versions:
https://livebuilds.openbravo.com/context/pos2_mp_23Q2 [^]

In the backoffice:

In Open/Close Period, select current period (jun-23) and Close period

In the POS:
https://livebuilds.openbravo.com/context/pos2_mp_23Q2/web/org.openbravo.retail.posterminal/?terminal=VBS-1 [^]

Add a product and pay it with Cash
Do a cash up:
Count more cash than the expected one (higher than 200)
Select 200 as the amount to keep

In the backoffice:
Check the order is stuck in Errors While Importing POS Data with the following error:
The Period does not exist or it is not opened

Check the cash up is stuck with the following error
There are errors related to non-created customers, orders, or cash management movements pending to be processed. Process them before processing the cash ups

Check you are logged in with * Organization

In Open/Close Period, select current period (jun-23) and Open period

In Errors While Importing POS Data, Save Again the order
Try to Save Again the cash-up and check the following error is shown:

org.openbravo.base.exception.OBException: Couldn't enable triggers:
    at org.openbravo.dal.core.TriggerHandler.enable(TriggerHandler.java:98)
    at org.openbravo.retail.posterminal.ProcessCashClose.doReconciliationAndInvoices(ProcessCashClose.java:507)
    at org.openbravo.retail.posterminal.ProcessCashClose.saveRecord(ProcessCashClose.java:189)
    ...
Caused by: javax.persistence.OptimisticLockException: Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1; statement executed: update FIN_Finacc_Transaction set AD_Client_ID=?, AD_Org_ID=?, Created=?, Createdby=?, Updated=?, Updatedby=?, Isactive=?, C_Currency_ID=?, Fin_Financial_Account_ID=?, Line=?, Fin_Payment_ID=?, DateAcct=?, C_Glitem_ID=?, Status=?, Paymentamt=?, Depositamt=?, Processed=?, Processing=?, Posted=?, C_Project_ID=?, C_Campaign_ID=?, C_Activity_ID=?, User1_ID=?, User2_ID=?, Trxtype=?, Statementdate=?, Description=?, FIN_Reconciliation_ID=?, CreatedByAlgorithm=?, Foreign_Currency_ID=?, Foreign_Convert_Rate=?, Foreign_Amount=?, C_Bpartner_ID=?, M_Product_ID=?, C_Salesregion_ID=?, C_Costcenter_ID=?, EM_Aprm_Processed=?, EM_Obpos_App_Cashup_ID=?, EM_Aprm_Finacc_Trans_Origin=? where Fin_Finacc_Transaction_ID=?
...
Caused by: org.hibernate.StaleStateException: Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1; statement executed: update FIN_Finacc_Transaction set AD_Client_ID=?, AD_Org_ID=?, Created=?, Createdby=?, Updated=?, Updatedby=?, Isactive=?, C_Currency_ID=?, Fin_Financial_Account_ID=?, Line=?, Fin_Payment_ID=?, DateAcct=?, C_Glitem_ID=?, Status=?, Paymentamt=?, Depositamt=?, Processed=?, Processing=?, Posted=?, C_Project_ID=?, C_Campaign_ID=?, C_Activity_ID=?, User1_ID=?, User2_ID=?, Trxtype=?, Statementdate=?, Description=?, FIN_Reconciliation_ID=?, CreatedByAlgorithm=?, Foreign_Currency_ID=?, Foreign_Convert_Rate=?, Foreign_Amount=?, C_Bpartner_ID=?, M_Product_ID=?, C_Salesregion_ID=?, C_Costcenter_ID=?, EM_Aprm_Processed=?, EM_Obpos_App_Cashup_ID=?, EM_Aprm_Finacc_Trans_Origin=? where Fin_Finacc_Transaction_ID=?
...

Change the login organization to the touchpoint's organization and check the Cashup can be saved again properly

Proposed Solution

Additional Information