Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0009490Openbravo ERP09. Financial managementpublic2009-06-15 13:162009-07-01 12:51
Reporternetworkb 
Assigned Tovinothbabu 
PriorityimmediateSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.40MP3 
Target VersionFixed in Version2.40MP7 
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
Summary0009490: 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 backport 0009397 closed vinothbabu C_BankStatement_Post process fail when Settlement sequence has a preffix and/or suffix 
blocks 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-16 08:53rafarodaTypedefect => backport
2009-06-16 08:53rafarodafix_in_branch => 2.40
2009-06-16 08:53rafarodaRelationship addedrelated to 0009397
2009-06-16 12:39rajagopalAssigned Torajagopal => vinothbabu
2009-06-22 13:53hgbotCheckin
2009-06-22 13:53hgbotNote Added: 0017524
2009-06-22 13:53hgbotStatusscheduled => resolved
2009-06-22 13:53hgbotResolutionopen => fixed
2009-06-22 13:53hgbotFixed in SCM revision => http://code.openbravo.com/erp/stable/2.40/rev/4e31669cf7c7ad0b925490d64360f687424535c6 [^]
2009-07-01 12:51sureshbabuStatusresolved => closed
2009-07-01 12:51sureshbabuNote Added: 0017734
2009-07-01 12:51sureshbabuFixed in Version => 2.40MP7

Notes
(0017524)
hgbot   
2009-06-22 13:53   
Repository: erp/stable/2.40
Changeset: 4e31669cf7c7ad0b925490d64360f687424535c6
Author: Vinoth Babu <vinoth.babu <at> openbravo.com>
Date: Mon Jun 22 17:18:58 2009 +0530
URL: http://code.openbravo.com/erp/stable/2.40/rev/4e31669cf7c7ad0b925490d64360f687424535c6 [^]

Fixes bug 9490 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
---
(0017734)
sureshbabu   
2009-07-01 12:51   
Tested working fine