Openbravo Issue Tracking System - Openbravo Localizations
View Issue Details
0037458Openbravo LocalizationsLocalization Mexicopublic2017-12-12 10:222020-08-28 13:29
ngarcia 
tegik_forge 
highminoralways
closedfixed 
5
 
 
0037458: [Contabilidad en Medios Electronicos]: length of variables in conele_docnum_trg should be defined relative to fact_acct columns
[Contabilidad en Medios Electronicos]: size of variables in conele_docnum_trg should be defined relative to fact_acct columns.

Thus, if a user increases the size of a column, the variable could save its value
As system admin role:
   Increase the length of the following columns:
      c_bpartner.name
      fact_acct.em_conele_namebp

   Create a business partner and add a name longer than 60 characters
   Create a sales invoice for that business partner
   Try to post it and check the following error message is shown:
      "Process failed during execution"

   The log shows:
      ERROR org.openbravo.erpCommon.ad_forms.FactLineData - SQL error in query: INSERT INTO Fact_Acct ...
Exception:org.postgresql.util.PSQLException: ERROR: value too long for type character varying(60) Where: PL/pgSQL function conele_docnum_trg() line 115 at SQL statement
   
No tags attached.
Issue History
2017-12-12 10:22ngarciaNew Issue
2017-12-12 10:22ngarciaAssigned To => tegik_forge
2017-12-12 17:12psanjuanNote Added: 0101001
2017-12-12 17:22ngarciaIssue Monitored: networkb
2017-12-14 09:02psanjuanNote Added: 0101030
2017-12-14 09:02psanjuanStatusnew => scheduled
2017-12-14 09:02psanjuanStatusscheduled => resolved
2017-12-14 09:03psanjuanNote Edited: 0101030bug_revision_view_page.php?bugnote_id=0101030#r16435
2020-08-28 13:29psanjuanStatusresolved => closed
2020-08-28 13:29psanjuanResolutionopen => fixed

Notes
(0101001)
psanjuan   
2017-12-12 17:12   
issue reported in Tegik support tool as:
https://tegikjira.atlassian.net/servicedesk/customer/portal/2/SUPPORT-7206 [^]
(0101030)
psanjuan   
2017-12-14 09:02   
(edited on: 2017-12-14 09:03)
Module updated with the fix of this issue. Install version 1.5.8

http://centralrepository.openbravo.com/openbravo/org.openbravo.forge.ui/sso/ForgeModuleVersionDetail?moduleVersionId=B7AB6B37C40C477AA5AF6DBA8F5D523E [^]