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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0009490
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] 09. Financial managementminoralways2009-06-15 13:162009-07-01 12:51
ReporternetworkbView Statuspublic 
Assigned Tovinothbabu 
PriorityimmediateResolutionfixedFixed in Version2.40MP7
StatusclosedFix in branch2.40Fixed in SCM revision4e31669cf7c7
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version2.40MP3SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0009490: 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 backport 0009397 closedvinothbabu C_BankStatement_Post process fail when Settlement sequence has a preffix and/or suffix 
blocks defect 0009475 closedvinothbabu C_Cash_Post fails when Settlement sequence contains a preffix or suffix with letters 

-  Notes
(0017524)
hgbot (developer)
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 (reporter)
2009-07-01 12:51

Tested working fine

- Issue History
Date Modified Username Field Change
2009-06-16 08:53 rafaroda Type defect => backport
2009-06-16 08:53 rafaroda fix_in_branch => 2.40
2009-06-16 08:53 rafaroda Relationship added related to 0009397
2009-06-16 12:39 rajagopal Assigned To rajagopal => vinothbabu
2009-06-22 13:53 hgbot Checkin
2009-06-22 13:53 hgbot Note Added: 0017524
2009-06-22 13:53 hgbot Status scheduled => resolved
2009-06-22 13:53 hgbot Resolution open => fixed
2009-06-22 13:53 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/stable/2.40/rev/4e31669cf7c7ad0b925490d64360f687424535c6 [^]
2009-07-01 12:51 sureshbabu Status resolved => closed
2009-07-01 12:51 sureshbabu Note Added: 0017734
2009-07-01 12:51 sureshbabu Fixed in Version => 2.40MP7


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker