Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0009475
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementminoralways2009-06-15 13:162009-07-18 00:00
ReporternetworkbView Statuspublic 
Assigned Tovinothbabu 
PriorityimmediateResolutionfixedFixed in Versionpi
StatusclosedFix in branchpiFixed in SCM revisionda6a63faba6a
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version2.40MP3SCM revision 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0009475: 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);
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0009394 closedrajagopal C_BankStatement_Post process fail when Settlement sequence has a preffix and/or suffix 
related to defect 0009420 closedharikrishnan DocumentType variables declared as number but a document type can contains non-numeric chars (prefix,suffix) 
depends on backport 0009490 closedvinothbabu C_Cash_Post fails when Settlement sequence contains a preffix or suffix with letters 

-  Notes
(0017526)
hgbot (developer)
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 (viewer)
2009-07-17 14:34

 Tested working fine

- Issue History
Date Modified Username Field Change
2009-06-15 13:16 networkb New Issue
2009-06-15 13:16 networkb Assigned To => rafaroda
2009-06-15 13:16 networkb OBNetwork customer => Yes
2009-06-16 08:52 rafaroda Relationship added related to 0009394
2009-06-16 08:52 rafaroda Assigned To rafaroda => rajagopal
2009-06-16 08:53 rafaroda Status new => scheduled
2009-06-16 08:53 rafaroda fix_in_branch => pi
2009-06-16 11:05 rafaroda Relationship added related to 0009420
2009-06-16 12:39 rajagopal Assigned To rajagopal => vinothbabu
2009-06-22 14:06 hgbot Checkin
2009-06-22 14:06 hgbot Note Added: 0017526
2009-06-22 14:06 hgbot Status scheduled => resolved
2009-06-22 14:06 hgbot Resolution open => fixed
2009-06-22 14:06 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/da6a63faba6ae8c5f70edcff6a3dfdf5f24052c3 [^]
2009-07-17 14:34 sureshbabu Status resolved => closed
2009-07-17 14:34 sureshbabu Note Added: 0018369
2009-07-17 14:34 sureshbabu Fixed in Version => pi
2009-07-18 00:00 anonymous sf_bug_id 0 => 2823343

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker