Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0009571Openbravo ERP09. Financial managementpublic2009-06-10 13:492009-07-10 13:19
Reportershuehner 
Assigned Toharikrishnan 
PriorityurgentSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.40 
Target VersionFixed in Version2.40MP7 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0009571: DocumentType variables declared as number but a document type can contains non-numeric chars (prefix,suffix)
DescriptionIn several PL-files some variables used to hold a documentNo are defined as numbers. This will break then the matching DocumentType is defined to contain a non-numeric prefix and/or suffix.

./C_CASH_POST.xml: v_DocumentNo is NUMBER(10)
./C_REMITTANCE_POST.xml: v_DocumentNo NUMBER;
./C_TAXPAYMENT_POST.xml: v_gljdocumentno:, v_sdocumentno NUMBER
./GENERATESOFROMPROJECTORDER.xml: v_DocumentNo NUMBER
Steps To ReproduceDescription of reproducible steps will need to be done when changing the doctype as the changed code shows which DocType /Sequence definition needs to be changed.

Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
blocks defect 0009420 closed harikrishnan DocumentType variables declared as number but a document type can contains non-numeric chars (prefix,suffix) 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-06-22 09:49rafarodaTypedefect => backport
2009-06-22 09:49rafarodafix_in_branch => 2.40
2009-06-23 07:03sathiyanAssigned Tosathiyan => harikrishnan
2009-06-29 16:25hgbotCheckin
2009-06-29 16:25hgbotNote Added: 0017646
2009-06-29 16:25hgbotStatusscheduled => resolved
2009-06-29 16:25hgbotResolutionopen => fixed
2009-06-29 16:25hgbotFixed in SCM revision => http://code.openbravo.com/erp/stable/2.40/rev/e81f115b5facceb24b2c0551ef8596cd467d22c0 [^]
2009-07-10 13:19sureshbabuStatusresolved => closed
2009-07-10 13:19sureshbabuNote Added: 0018102
2009-07-10 13:19sureshbabuFixed in Version => 2.40MP7

Notes
(0017646)
hgbot   
2009-06-29 16:25   
Repository: erp/stable/2.40
Changeset: e81f115b5facceb24b2c0551ef8596cd467d22c0
Author: Harikrishnan Raja <harikrishnan.raja <at> openbravo.com>
Date: Mon Jun 29 19:48:57 2009 +0530
URL: http://code.openbravo.com/erp/stable/2.40/rev/e81f115b5facceb24b2c0551ef8596cd467d22c0 [^]

Fixes Issue 9571: DocumentType variables declared as number but a document type can contains non-numeric chars (prefix,suffix)

---
M src-db/database/model/functions/C_REMITTANCE_POST.xml
M src-db/database/model/functions/C_TAXPAYMENT_POST.xml
M src-db/database/model/functions/GENERATESOFROMPROJECTORDER.xml
---
(0018102)
sureshbabu   
2009-07-10 13:19   
Tested working fine