Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0009026Openbravo ERP02. Master data managementpublic2009-05-13 18:372009-05-17 00:00
Reporterlibin1231 
Assigned Torafaroda 
PriorityhighSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS10OS VersionWindows XP
Product Version2.50 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0009026: When renumbering price list schema lines, error: column "seqno" is of type numeric but expression is of type character varyin
DescriptionWhen trying to use "renumber" function on a price list schema Header page, below error pops up:

Error:
column "seqno" is of type numeric but expression is of type character varying
Steps To Reproduce1. Select from menu Master Data Management/Pricing/Price List Schema
2. create a schema if none is created
3. Click button renumber on the Header tab.
4. Click OK on the popup window
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Filesdiff issue_9026.diff (456) 2009-05-14 10:00
https://issues.openbravo.com/file_download.php?file_id=1306&type=bug
Issue History
Date ModifiedUsernameFieldChange
2009-05-13 18:37libin1231New Issue
2009-05-13 18:37libin1231Assigned To => rafaroda
2009-05-14 09:59shuehnerNote Added: 0016344
2009-05-14 10:00shuehnerFile Added: issue_9026.diff
2009-05-14 13:39rafarodaAssigned Torafaroda => sathiyan
2009-05-14 13:39rafarodaPrioritynormal => high
2009-05-14 13:39rafarodaStatusnew => scheduled
2009-05-14 14:24rafarodaAssigned Tosathiyan => rafaroda
2009-05-14 14:41hgbotCheckin
2009-05-14 14:41hgbotNote Added: 0016353
2009-05-14 14:41hgbotStatusscheduled => resolved
2009-05-14 14:41hgbotResolutionopen => fixed
2009-05-14 14:41hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/ee79b2ff6a6753d3f7f332e5afa61686c8145d2e [^]
2009-05-16 04:25libin1231Statusresolved => closed
2009-05-16 04:25libin1231Note Added: 0016405
2009-05-17 00:00anonymoussf_bug_id0 => 2792821

Notes
(0016344)
shuehner   
2009-05-14 09:59   
confirmed:

pl-function: M_DISCOUNTSCHEMA_RESEQ.xml

Attached patch should fix it.
(0016353)
hgbot   
2009-05-14 14:41   
Repository: erp/devel/pi
Changeset: ee79b2ff6a6753d3f7f332e5afa61686c8145d2e
Author: Rafa Roda Palacios <rafael.roda <at> openbravo.com>
Date: Thu May 14 14:26:44 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/ee79b2ff6a6753d3f7f332e5afa61686c8145d2e [^]

Fixes issue 0009026 Now \"Renumber\" button in a price list schema works with UUID.

---
M src-db/database/model/functions/M_DISCOUNTSCHEMA_RESEQ.xml
---
(0016405)
libin1231   
2009-05-16 04:25   
Verified. Thanks!