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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0009394
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementminoralways2009-06-08 18:502009-06-23 09:23
ReporternetworkbView Statuspublic 
Assigned Torajagopal 
PriorityimmediateResolutionfixedFixed in Versionpi
StatusclosedFix in branchpiFixed in SCM revisionc98f8502ce4e
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version2.40SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0009394: C_BankStatement_Post process fail when Settlement sequence has a preffix and/or suffix

DescriptionIf Settlement sequence is modified in order to add a suffix or preffix, C_BankStatement_Post process fails.

In C_BankStatement_Post process, in line

v_DocumentNo NUMBER(10) ;

This variable is used to insert a value in a varchar column.
Steps To ReproduceGo to Financial Management > Accounting > Setup > Document Sequence > Settlement.
Add a preffix or suffix (letters, please)
Try to complete a Bank statement.
Process fails.
Proposed Solutionv_DocumentNo NVARCHAR(60) ;
TagsNo tags attached.
Attached Files

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

-  Notes
(0017132)
vmromanos (manager)
2009-06-09 11:41

Please, could you update the steps to reproduce? Moreover, could you write the detailed steps to reproduce this bug?

For example, Financial Management > Accounting > Setup > Settlement does not exist.
(0017191)
networkb (developer)
2009-06-10 17:58

What is the required information?
(0017194)
psarobe (manager)
2009-06-10 18:59

The required information is to have clear steps in order to reproduce the bug. I will do it but this is the last time. Next issues will be reject or change to feedback asking for a better steps to reproduce

1. Go to Financial management->Accounting->Setup->Document type
2. Select the document type Debt/Payment Settlement. Enter in form view
3. Click in document sequence
4. Add a prefix and a suffix. Save
5. Go to Sales management->Transactions->Sales invoice. Click new
6. Fill the mandatory fields
7. Move to lines. Select a product and save
8. Complete the sales invoice
9. Go to Financial management->Receivables and payables->Transactions->Bankstatement
10. Click new and save. Click on create lines from button and select the payment created above. click ok
11. Process the Bankstatement

you will see the error
(0017196)
vmromanos (manager)
2009-06-10 19:32

Thanks Pablo, these are the steps I was asking for.
(0017400)
hgbot (developer)
2009-06-17 18:44

Repository: erp/devel/pi
Changeset: c98f8502ce4e258fa71197552a773a9f2c467339
Author: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com>
Date: Wed Jun 17 18:42:48 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/c98f8502ce4e258fa71197552a773a9f2c467339 [^]

Fixes bug 0009394: C_BankStatement_Post process fail when Settlement sequence has a preffix and/or suffix

---
M src-db/database/model/functions/C_BANKSTATEMENT_POST.xml
---

- Issue History
Date Modified Username Field Change
2009-06-08 18:50 networkb New Issue
2009-06-08 18:50 networkb Assigned To => rafaroda
2009-06-09 09:03 rafaroda Assigned To rafaroda => vmromanos
2009-06-09 09:04 rafaroda Status new => scheduled
2009-06-09 09:04 rafaroda fix_in_branch => pi
2009-06-09 11:41 vmromanos Note Added: 0017132
2009-06-09 11:41 vmromanos Status scheduled => feedback
2009-06-09 12:02 networkb Status feedback => new
2009-06-09 12:02 networkb fix_in_branch pi =>
2009-06-09 12:02 networkb Proposed Solution updated
2009-06-10 17:56 psarobe Status new => feedback
2009-06-10 17:57 psarobe Relationship added related to 0009420
2009-06-10 17:58 networkb Note Added: 0017191
2009-06-10 18:38 networkb Status feedback => new
2009-06-10 18:59 psarobe Note Added: 0017194
2009-06-10 19:00 psarobe Status new => scheduled
2009-06-10 19:00 psarobe fix_in_branch => pi
2009-06-10 19:32 vmromanos Note Added: 0017196
2009-06-16 08:52 rafaroda Relationship added related to 0009475
2009-06-17 18:44 hgbot Checkin
2009-06-17 18:44 hgbot Note Added: 0017400
2009-06-17 18:44 hgbot Status scheduled => resolved
2009-06-17 18:44 hgbot Resolution open => fixed
2009-06-17 18:44 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/c98f8502ce4e258fa71197552a773a9f2c467339 [^]
2009-06-19 12:42 sureshbabu Status resolved => closed
2009-06-19 12:42 sureshbabu Fixed in Version => pi
2009-06-20 00:00 anonymous sf_bug_id 0 => 2809275
2009-06-23 09:23 rafaroda Assigned To vmromanos => rajagopal


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker