Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0009420Openbravo ERP09. Financial managementpublic2009-06-10 13:492009-07-23 00:00
Reportershuehner 
Assigned Toharikrishnan 
PriorityurgentSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.40 
Target VersionFixed in Version2.50MP3 
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
Summary0009420: 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
Tags250MP3releasecandidate, leo
Relationships
related to backport 0009397 closed vinothbabu C_BankStatement_Post process fail when Settlement sequence has a preffix and/or suffix 
depends on backport 0009571 closed harikrishnan DocumentType variables declared as number but a document type can contains non-numeric chars (prefix,suffix) 
related to defect 0009394 closed rajagopal C_BankStatement_Post process fail when Settlement sequence has a preffix and/or suffix 
related to defect 0009475 closed vinothbabu C_Cash_Post fails when Settlement sequence contains a preffix or suffix with letters 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-06-10 13:49shuehnerNew Issue
2009-06-10 13:49shuehnerAssigned To => rafaroda
2009-06-10 13:49shuehnerOBNetwork customer => No
2009-06-10 13:49shuehnerRelationship addedrelated to 0009397
2009-06-10 13:51shuehnerNote Added: 0017182
2009-06-10 17:43psarobePrioritynormal => urgent
2009-06-10 17:43psarobeStatusnew => scheduled
2009-06-10 17:57psarobeRelationship addedrelated to 0009394
2009-06-16 11:05rafarodaRelationship addedrelated to 0009475
2009-06-22 09:49rafarodaAssigned Torafaroda => sathiyan
2009-06-22 09:49rafarodaStatusscheduled => acknowledged
2009-06-22 09:49rafarodaStatusacknowledged => scheduled
2009-06-22 09:49rafarodafix_in_branch => pi
2009-06-23 07:02sathiyanAssigned Tosathiyan => harikrishnan
2009-06-30 13:05hgbotCheckin
2009-06-30 13:05hgbotNote Added: 0017671
2009-06-30 13:05hgbotStatusscheduled => resolved
2009-06-30 13:05hgbotResolutionopen => fixed
2009-06-30 13:05hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/c55fcd7030334a69a1665552440d9b56bfdf309f [^]
2009-07-21 16:24psarobeFixed in Version => 2.50MP3
2009-07-21 16:26psarobeTag Attached: 250MP3releasecandidate
2009-07-21 18:43psarobeTag Attached: leo
2009-07-22 07:42elopioStatusresolved => closed
2009-07-23 00:00anonymoussf_bug_id0 => 2825601

Notes
(0017182)
shuehner   
2009-06-10 13:51   
When changing the variable definition the best way is to use the %TYPE syntax do define the variable as one of the same type as the database field where it is saved into.

Example for this is the definition of v_SDocumentNo in the PL-file: C_DEBT_PAYMENT_CREATE.xml.

This definition should not be copied exactly but the real target-field of each variable should be used.
(0017671)
hgbot   
2009-06-30 13:05   
Repository: erp/devel/pi
Changeset: c55fcd7030334a69a1665552440d9b56bfdf309f
Author: harikrishnan
Date: Tue Jun 30 16:28:59 2009 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/c55fcd7030334a69a1665552440d9b56bfdf309f [^]

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

---
M src-db/database/model/functions/C_GENERATESOFROMPROJECTORDER.xml
M src-db/database/model/functions/C_REMITTANCE_POST.xml
M src-db/database/model/functions/C_TAXPAYMENT_POST.xml
---