Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0019540Openbravo ERP08. Project and service managementpublic2012-01-23 12:032012-03-02 15:33
VictorVillar 
umartirena 
highminoralways
closedfixed 
5
3.0MP7.1 
3.0MP10 
Core
No
0019540: Long description when Creates Sales order from Project phase
When the user write a long description (255 characters) to a multiphase project, after create a phase, the Sales Order cannot be created because the Phase Name and the project description concatenation is longer than the Order description limit.
As group Admin role,
Go to Multiphase project window:
   - Create a new register
        name= kk
        Description: write the max number of character 255 to this field.
 Go to phase tab:
    - create a new register
Change Project status to Order
Click in Create the Sales Order from Project phase button
An error appears: "value too long for type character varying(255)"

We can see the C_GENERATESOFROMPROJECTPHASE.xml that concatenates the Phase name and the Project description to insert into the Sales order description field, and this value is too long, more than 255 characters
Use a substr in this process to control this situation.
No tags attached.
Issue History
2012-01-23 12:03VictorVillarNew Issue
2012-01-23 12:03VictorVillarAssigned To => alostale
2012-01-23 12:03VictorVillarModules => Core
2012-01-23 12:03VictorVillarResolution time => 1333663200
2012-01-23 12:04VictorVillarCategory00. Application dictionary => 08. Project and service management
2012-01-23 12:04VictorVillarAssigned Toalostale => jonalegriaesarte
2012-01-23 12:05VictorVillarIssue Monitored: networkb
2012-01-25 19:15jonalegriaesarteAssigned Tojonalegriaesarte => umartirena
2012-02-01 12:41hgbotCheckin
2012-02-01 12:41hgbotNote Added: 0044768
2012-02-01 12:41hgbotStatusnew => resolved
2012-02-01 12:41hgbotResolutionopen => fixed
2012-02-01 12:41hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/04c3080159a0a974cf60bc12d6e0a59514e4e0cc [^]
2012-02-17 09:14VictorVillarNote Added: 0045211
2012-02-17 09:14VictorVillarStatusresolved => closed
2012-03-02 15:33hudsonbotCheckin
2012-03-02 15:33hudsonbotNote Added: 0045716

Notes
(0044768)
hgbot   
2012-02-01 12:41   
Repository: erp/devel/pi
Changeset: 04c3080159a0a974cf60bc12d6e0a59514e4e0cc
Author: Unai Martirena <unai.martirena <at> openbravo.com>
Date: Thu Jan 26 10:49:03 2012 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/04c3080159a0a974cf60bc12d6e0a59514e4e0cc [^]

Fixes Issue 0019540: Long desc. when Creates Sales order from Project phase

---
M src-db/database/model/functions/C_GENERATESOFROMPROJECTPHASE.xml
---
(0045211)
VictorVillar   
2012-02-17 09:14   
Verified
(0045716)
hudsonbot   
2012-03-02 15:33   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/544d64e0c159 [^]

Maturity status: Test