0055671: [24Q2] Cash up and Order errors after adding a new address with a large number or string in the postal code field

Openbravo Issue Tracking System - POS2

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0055671

POS2

POS

public

2024-04-11 13:26

2024-06-10 14:37

Reporter

Markel_Iruretagoyena

Assigned To

Rajesh_18

Priority

normal

Severity

major

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS Version

Product Version

Target Version

24Q1.3

Fixed in Version

Merge Request Status

approved

Review Assigned To

OBNetwork customer

OBPS

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

0055671: [24Q2] Cash up and Order errors after adding a new address with a large number or string in the postal code field

Description

Add a new address for a customer with large number or string in the postal code field and select it as the 'Invoicing Address'. After creating a ticket and doing the cash up, it will generate Cash Up and Order errors.

Steps To Reproduce

1. Login to POS
2. Click on 'VBS Customer' and search for any customer, e.g. Arturo Montoro
3. Click on 'Arturo Montoro' (or the customer you selected), then click on 'Manage Address(es)'
4. Click on 'NEW ADDRESS'
5. On 'Postal Code' type 59300 VALENCIENNES
6. Fill in the rest of the mandatory fields and check the 'Invoicing Address' checkbox
7. Click on 'SAVE AND ASSIGN'
8. Add a product to the ticket and pay for it
9. Do a cash up
10. Login to Backoffice, then go to the 'Errors While Importing POS Data' window

Note that you have the next Cash Up error: org.openbravo.base.exception.OBException: There are errors related to non-created customers, orders, or cash management movements pending to be processed. Process them before processing the cash ups...

And also the next Order error: org.postgresql.util.PSQLException: ERROR: insert or update on table "c_order" violates foreign key constraint "c_order_billto"
Detail: Key (billto_id)=(279D36FB44608B06620A640DDF363AD3) is not present in table "c_bpartner_location".

Proposed Solution

Additional Information