Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0055670
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[POS2] POSmajoralways2024-04-11 13:262024-06-05 12:21
ReporterMarkel_IruretagoyenaView Statuspublic 
Assigned ToRajesh_18 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revisionPR24Q3
ProjectionnoneETAnoneTarget Version24Q2
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
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
Summary

0055670: [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".
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
blocks defect 0055171 closedRajesh_18 [24Q2] Cash up and Order errors after adding a new address with a large number or string in the postal code field 

-  Notes
(0165529)
hgbot (developer)
2024-06-04 13:27

 Merge Request created: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/1266 [^]
(0165531)
hgbot (developer)
2024-06-04 13:39

 Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2/-/merge_requests/2696 [^]
(0165532)
hgbot (developer)
2024-06-04 13:40

 Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2.sampledata/-/merge_requests/90 [^]
(0165597)
hgbot (developer)
2024-06-05 12:21

 Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/openbravo [^]
Changeset: 75a68a213bd67bf5855a43bffd3cd83eadad6f3a
Author: Rajesh Senthilkumar <rajesh@qualiantech.com>
Date: 04-06-2024 16:54:00
URL: https://gitlab.com/openbravo/product/openbravo/-/commit/75a68a213bd67bf5855a43bffd3cd83eadad6f3a [^]

Fixed ISSUE-55670: 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
---
(0165598)
hgbot (developer)
2024-06-05 12:21

 Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2/-/merge_requests/2696 [^]
(0165599)
hgbot (developer)
2024-06-05 12:21

 Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2 [^]
Changeset: 550ffea1af650f4077a9bf8139f19664005fd379
Author: Rajesh Senthilkumar <rajesh@qualiantech.com>
Date: 04-06-2024 17:04:20
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2/-/commit/550ffea1af650f4077a9bf8139f19664005fd379 [^]

Related to ISSUE-55670: 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
---
(0165600)
hgbot (developer)
2024-06-05 12:21

 Merge request merged: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/1266 [^]
(0165601)
hgbot (developer)
2024-06-05 12:21

 Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2.sampledata/-/merge_requests/90 [^]
(0165602)
hgbot (developer)
2024-06-05 12:21

 Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2.sampledata [^]
Changeset: 109eb21e4decafa094a6fe4c37f9430659c9b850
Author: Rajesh Senthilkumar <rajesh@qualiantech.com>
Date: 04-06-2024 17:06:16
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2.sampledata/-/commit/109eb21e4decafa094a6fe4c37f9430659c9b850 [^]

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

---
M referencedata/sampledata/The_White_Valley_Group/C_EXTBP_CONFIG_PROPERTY.xml
---

- Issue History
Date Modified Username Field Change
2024-06-04 13:11 marvintm Type defect => backport
2024-06-04 13:11 marvintm Target Version => 24Q2
2024-06-04 13:27 hgbot Note Added: 0165529
2024-06-04 13:39 hgbot Note Added: 0165531
2024-06-04 13:40 hgbot Note Added: 0165532
2024-06-05 12:21 hgbot Resolution open => fixed
2024-06-05 12:21 hgbot Status scheduled => closed
2024-06-05 12:21 hgbot Fixed in Version => PR24Q2
2024-06-05 12:21 hgbot Note Added: 0165597
2024-06-05 12:21 hgbot Note Added: 0165598
2024-06-05 12:21 hgbot Note Added: 0165599
2024-06-05 12:21 hgbot Note Added: 0165600
2024-06-05 12:21 hgbot Note Added: 0165601
2024-06-05 12:21 hgbot Note Added: 0165602

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker