Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0009394 | Openbravo ERP | 09. Financial management | public | 2009-06-08 18:50 | 2009-06-23 09:23 |
|
| Reporter | networkb | |
| Assigned To | rajagopal | |
| Priority | immediate | Severity | minor | Reproducibility | always |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 5 | OS Version | |
| Product Version | 2.40 | |
| Target Version | | Fixed in Version | pi | |
| Merge Request Status | |
| Review Assigned To | |
| OBNetwork customer | OBPS |
| Web browser | |
| Modules | Core |
| Support ticket | |
| Regression level | |
| Regression date | |
| Regression introduced in release | |
| Regression introduced by commit | |
| Triggers an Emergency Pack | No |
|
| Summary | 0009394: C_BankStatement_Post process fail when Settlement sequence has a preffix and/or suffix |
| Description | If 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 Reproduce | Go to Financial Management > Accounting > Setup > Document Sequence > Settlement.
Add a preffix or suffix (letters, please)
Try to complete a Bank statement.
Process fails. |
| Proposed Solution | v_DocumentNo NVARCHAR(60) ; |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | | 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 | 0009397 | | closed | vinothbabu | C_BankStatement_Post process fail when Settlement sequence has a preffix and/or suffix | | related to | defect | 0009475 | | closed | vinothbabu | C_Cash_Post fails when Settlement sequence contains a preffix or suffix with letters |
|
| Attached Files | |
|
| 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-08 18:50 | networkb | OBNetwork customer | => Yes |
| 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 |
|
Notes |
|
|
|
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. |
|
|
|
|
|
What is the required information? |
|
|
|
|
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 |
|
|
|
|
|
Thanks Pablo, these are the steps I was asking for. |
|
|
|
(0017400)
|
|
hgbot
|
|
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
---
|
|