Openbravo Issue Tracking System - POS2
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0055171POS2POSpublic2024-04-11 13:262024-06-04 13:12
ReporterMarkel_Iruretagoyena 
Assigned ToRajesh_18 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version24Q3 
Merge Request Statusapproved
Review Assigned To
OBNetwork customerOBPS
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0055171: [24Q2] Cash up and Order errors after adding a new address with a large number or string in the postal code field
DescriptionAdd 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 Reproduce1. 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
TagsNo tags attached.
Relationships
duplicate of defect 0055170 closed Rajesh_18 POS2 [24Q2] When creating a customer with a name that is too long, there is no error message and the customer is apparently created 
related to defect 0054544pi closed Rajesh_18 Retail Modules Capency: On customer screen the system allow to add a postal code more than 10 digit and EWI is generated 
depends on backport 005567024Q2 closed Rajesh_18 POS2 [24Q2] Cash up and Order errors after adding a new address with a large number or string in the postal code field 
depends on backport 005567124Q1.3 closed Rajesh_18 POS2 [24Q2] Cash up and Order errors after adding a new address with a large number or string in the postal code field 
has duplicate defect 0055648 closed Rajesh_18 Retail Modules When creating a customer on POS with too long name, ticket go in EWI 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2024-04-11 13:26Markel_IruretagoyenaNew Issue
2024-04-11 13:26Markel_IruretagoyenaAssigned To => Retail
2024-04-11 13:26Markel_IruretagoyenaOBNetwork customer => No
2024-04-11 13:26Markel_IruretagoyenaTriggers an Emergency Pack => No
2024-04-11 13:37Markel_IruretagoyenaSeveritymajor => critical
2024-05-06 16:40lorenzofidalgoTarget Version => 24Q2
2024-05-22 10:45guilleaerStatusnew => acknowledged
2024-05-22 10:50guilleaerOBNetwork customerNo => OBPS
2024-05-22 10:50guilleaerNote Added: 0164948
2024-05-22 10:58Rajesh_18Assigned ToRetail => Rajesh_18
2024-05-22 10:58Rajesh_18Statusacknowledged => scheduled
2024-05-22 11:00Rajesh_18Relationship addedrelated to 0054544
2024-05-23 14:38hgbotMerge Request Status => open
2024-05-23 14:38hgbotNote Added: 0165027
2024-05-23 15:01hgbotNote Added: 0165028
2024-05-24 15:48hgbotNote Added: 0165110
2024-05-26 21:14guilleaerRelationship addedduplicate of 0055170
2024-05-26 21:15guilleaerTarget Version24Q2 =>
2024-05-27 11:19hgbotMerge Request Statusopen => approved
2024-05-27 11:20hgbotResolutionopen => fixed
2024-05-27 11:20hgbotStatusscheduled => closed
2024-05-27 11:20hgbotFixed in Version => PR24Q3
2024-05-27 11:20hgbotNote Added: 0165158
2024-05-27 11:20hgbotNote Added: 0165159
2024-05-27 11:20hgbotNote Added: 0165160
2024-05-27 11:20hgbotNote Added: 0165161
2024-05-27 11:20hgbotNote Added: 0165162
2024-05-27 11:20hgbotNote Added: 0165163
2024-05-27 12:21guillermogilNote Added: 0165166
2024-05-27 12:21guillermogilSeveritycritical => major
2024-05-27 12:21guillermogilFixed in VersionPR24Q3 =>
2024-05-27 12:22guillermogilFixed in SCM revision => PR24Q3
2024-06-04 13:11marvintmStatusclosed => new
2024-06-04 13:11marvintmResolutionfixed => open
2024-06-04 13:11marvintmStatusnew => acknowledged
2024-06-04 13:11marvintmStatusacknowledged => scheduled
2024-06-04 13:11marvintmStatusscheduled => resolved
2024-06-04 13:11marvintmFixed in Version => 24Q3
2024-06-04 13:11marvintmResolutionopen => fixed
2024-06-04 13:11marvintmStatusresolved => closed
2024-06-04 13:11marvintmStatusclosed => new
2024-06-04 13:11marvintmResolutionfixed => open
2024-06-04 13:11marvintmFixed in Version24Q3 =>
2024-06-04 13:11marvintmStatusnew => scheduled
2024-06-04 13:12marvintmStatusscheduled => resolved
2024-06-04 13:12marvintmFixed in Version => 24Q3
2024-06-04 13:12marvintmResolutionopen => fixed
2024-06-04 13:12marvintmStatusresolved => closed
2024-06-04 13:16Rajesh_18Relationship addedhas duplicate 0055648

Notes
(0164948)
guilleaer   
2024-05-22 10:50   
Marked as OBPS with due date 14 jun because they are major/critical issues reported by QA tagged for 24Q2.
(0165027)
hgbot   
2024-05-23 14:38   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2/-/merge_requests/2660 [^]
(0165028)
hgbot   
2024-05-23 15:01   
Merge Request created: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/1257 [^]
(0165110)
hgbot   
2024-05-24 15:48   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2.sampledata/-/merge_requests/89 [^]
(0165158)
hgbot   
2024-05-27 11:20   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/openbravo [^]
Changeset: 36c9bde3744123c66c4fed210b5d5ecfa626cd68
Author: Rajesh Senthilkumar <rajesh@qualiantech.com>
Date: 26-05-2024 08:17:52
URL: https://gitlab.com/openbravo/product/openbravo/-/commit/36c9bde3744123c66c4fed210b5d5ecfa626cd68 [^]

Fixed ISSUE-55171: Added new field length to validate input field

---
M src-db/database/model/tables/C_EXTBP_CONFIG_PROPERTY.xml
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_ELEMENT.xml
M src-db/database/sourcedata/AD_FIELD.xml
---
(0165159)
hgbot   
2024-05-27 11:20   
Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2 [^]
Changeset: d054bc2dce58f729363bba3ae6cad326fcdc7527
Author: Rajesh Senthilkumar <rajesh@qualiantech.com>
Date: 27-05-2024 09:19:19
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2/-/commit/d054bc2dce58f729363bba3ae6cad326fcdc7527 [^]

Related to ISSUE-55171: Added max length property to input field

---
M referencedata/standard/CRM_Connector_for_Openbravo_Customers.xml
M web-jspack/org.openbravo.pos2/src/components/Customer/CustomerUtils/CustomerFormHandlerUtils.js
M web-jspack/org.openbravo.pos2/src/services/crm/OBCustomerRelationshipManagement.js
---
(0165160)
hgbot   
2024-05-27 11:20   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2/-/merge_requests/2660 [^]
(0165161)
hgbot   
2024-05-27 11:20   
Merge request merged: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/1257 [^]
(0165162)
hgbot   
2024-05-27 11:20   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2.sampledata/-/merge_requests/89 [^]
(0165163)
hgbot   
2024-05-27 11:20   
Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2.sampledata [^]
Changeset: e86638526357150840f08ceac511d3391b35f562
Author: Rajesh Senthilkumar <rajesh@qualiantech.com>
Date: 23-05-2024 23:01:44
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2.sampledata/-/commit/e86638526357150840f08ceac511d3391b35f562 [^]

Related to ISSUE-55171: Added new field length in sample data

---
M referencedata/sampledata/The_White_Valley_Group/C_EXTBP_CONFIG_PROPERTY.xml
---
(0165166)
guillermogil   
2024-05-27 12:21   
Reducing severity as it is not a critical issue