Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0032876Retail ModulesWeb POSpublic2016-05-05 17:132016-05-18 16:37
ReporterdaniOpenbravo 
Assigned Toranjith_qualiantech_com 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS30OS Version14.04
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned Tomigueldejuana
OBNetwork customerOBPS
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0032876: [SERQA 1063] Cashup error related to searchkey colum of OBPOS_paymentmethodcashup
DescriptionColumn Searchkey of OBPOS_Paymentmethodcashup table is defined with the following values in application dictionary:
- Lenght: 32
- Reference: String
This causes a problem if we have defined a Payment Method with a value that contains more than 32 characters, raising an error in the cashup.
Steps To Reproduce* Having a payment method defined with a value higher than 32 characters (for example: "BUTPM_payment.cartecadeaugenerique")

1. Log in Web POS
2. At the time we have to count the cash amount in order to open the store, click on Done.
3. The following error is raised: "searchkey: Value (BUTPM_payment.cartecadeaugenerique) is too long, it has length 34, the maximum allowed length is 32"
Proposed Solution
Additional Information
TagsSER-QA
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2016-05-05 17:13daniOpenbravoNew Issue
2016-05-05 17:13daniOpenbravoAssigned To => Retail
2016-05-05 17:13daniOpenbravoOBNetwork customer => Yes
2016-05-05 17:13daniOpenbravoResolution time => 1463608800
2016-05-05 17:13daniOpenbravoTriggers an Emergency Pack => No
2016-05-05 17:13daniOpenbravoTag Attached: SER-QA
2016-05-05 17:36daniOpenbravoIssue Monitored: daniOpenbravo
2016-05-05 17:59OrekariaSummary[SER QA 1063]Cashup error related to searchkey colum of OBPOS_paymentmethodcashup => [SERQA 1063] Cashup error related to searchkey colum of OBPOS_paymentmethodcashup
2016-05-10 10:38OrekariaStatusnew => acknowledged
2016-05-12 09:06ranjith_qualiantech_comAssigned ToRetail => ranjith_qualiantech_com
2016-05-12 09:06ranjith_qualiantech_comStatusacknowledged => scheduled
2016-05-13 08:21hgbotCheckin
2016-05-13 08:21hgbotNote Added: 0086432
2016-05-13 08:21hgbotStatusscheduled => resolved
2016-05-13 08:21hgbotResolutionopen => fixed
2016-05-13 08:21hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/a2c01a56159da46d55ae6b980b39d45a3e5550cf [^]
2016-05-18 16:37migueldejuanaReview Assigned To => migueldejuana
2016-05-18 16:37migueldejuanaNote Added: 0086554
2016-05-18 16:37migueldejuanaStatusresolved => closed

Notes
(0086432)
hgbot   
2016-05-13 08:21   
Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: a2c01a56159da46d55ae6b980b39d45a3e5550cf
Author: Ranjith S R <ranjith <at> qualiantech.com>
Date: Fri May 13 11:50:57 2016 +0530
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/a2c01a56159da46d55ae6b980b39d45a3e5550cf [^]

Fixes issue 32876 : Increasing Column size from 32 to 40 for the column "searchkey" in OBPOS_PAYMENTMETHODCASHUP Table

---
M src-db/database/model/tables/OBPOS_PAYMENTMETHODCASHUP.xml
M src-db/database/sourcedata/AD_COLUMN.xml
---
(0086554)
migueldejuana   
2016-05-18 16:37   
Tested and reviewed in ec98fed2ca51