Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0009475Openbravo ERP09. Financial managementpublic2009-06-15 13:162009-07-18 00:00
Reporternetworkb 
Assigned Tovinothbabu 
PriorityimmediateSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.40MP3 
Target VersionFixed in Versionpi 
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
Summary0009475: C_Cash_Post fails when Settlement sequence contains a preffix or suffix with letters
DescriptionWhen Settlement (or Liquidación de efectos) sequence has a preffix or suffix with letters, C_Cash_Post fails.

This bug is related to https://issues.openbravo.com/view.php?id=9394 [^]

The problem is in C_Cash_Post, when this variable is defined:

v_DocumentNo NUMERIC(10) ;

It must be VARCHAR(40)
Steps To ReproduceGo to Financial Management > Accounting > Setup > Document sequence.
Search "Liquidación de efectos" row.
Add a preffix or suffix with letters.
Go to Financial Management > Receivables and Payables > Funds transfer.
Select one organization. In "From", select a Cash. In "To" select a bank.
Select any Payment rule, date and amount.
Process it.
Go to Cash Journal.
Add a new one.
Go to Lines.
Select as Cash type: debt/payment.
In Payment selector, search the one created by Funds Transfer process.
Save the row.
Go to the Header, try to process it. An error will appear.
Proposed Solutionv_DocumentNo VARCHAR(40);
Additional Information
TagsNo tags attached.
Relationships
related to defect 0009394 closed rajagopal C_BankStatement_Post process fail when Settlement sequence has a preffix and/or suffix 
related to defect 0009420 closed harikrishnan DocumentType variables declared as number but a document type can contains non-numeric chars (prefix,suffix) 
depends on backport 0009490 closed vinothbabu C_Cash_Post fails when Settlement sequence contains a preffix or suffix with letters 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-06-15 13:16networkbNew Issue
2009-06-15 13:16networkbAssigned To => rafaroda
2009-06-16 08:52rafarodaRelationship addedrelated to 0009394
2009-06-16 08:52rafarodaAssigned Torafaroda => rajagopal
2009-06-16 08:53rafarodaStatusnew => scheduled
2009-06-16 08:53rafarodafix_in_branch => pi
2009-06-16 11:05rafarodaRelationship addedrelated to 0009420
2009-06-16 12:39rajagopalAssigned Torajagopal => vinothbabu
2009-06-22 14:06hgbotCheckin
2009-06-22 14:06hgbotNote Added: 0017526
2009-06-22 14:06hgbotStatusscheduled => resolved
2009-06-22 14:06hgbotResolutionopen => fixed
2009-06-22 14:06hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/da6a63faba6ae8c5f70edcff6a3dfdf5f24052c3 [^]
2009-07-17 14:34sureshbabuStatusresolved => closed
2009-07-17 14:34sureshbabuNote Added: 0018369
2009-07-17 14:34sureshbabuFixed in Version => pi
2009-07-18 00:00anonymoussf_bug_id0 => 2823343

Notes
(0017526)
hgbot   
2009-06-22 14:06   
Repository: erp/devel/pi
Changeset: da6a63faba6ae8c5f70edcff6a3dfdf5f24052c3
Author: Vinoth Babu <vinoth.babu <at> openbravo.com>
Date: Mon Jun 22 17:32:13 2009 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/da6a63faba6ae8c5f70edcff6a3dfdf5f24052c3 [^]

Fixes bug 9475 Resolved C_Cash_Post fails when Settlement sequence contains a preffix or suffix with letters

---
M src-db/database/model/functions/C_CASH_POST.xml
---
(0018369)
sureshbabu   
2009-07-17 14:34   
Tested working fine