Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0009397 | Openbravo ERP | 09. Financial management | public | 2009-06-08 18:50 | 2009-07-13 10:51 |
|
| Reporter | networkb | |
| Assigned To | vinothbabu | |
| Priority | immediate | Severity | minor | Reproducibility | always |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 5 | OS Version | |
| Product Version | 2.40 | |
| Target Version | | Fixed in Version | 2.40MP7 | |
| 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 | 0009397: 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 | 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 |
| 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) | | related to | backport | 0009490 | | closed | vinothbabu | C_Cash_Post fails when Settlement sequence contains a preffix or suffix with letters | | blocks | defect | 0009394 | | closed | rajagopal | C_BankStatement_Post process fail when Settlement sequence has a preffix and/or suffix |
|
| Attached Files | |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2009-06-09 09:04 | rafaroda | Type | defect => backport |
| 2009-06-09 09:04 | rafaroda | fix_in_branch | => 2.40 |
| 2009-06-10 13:49 | shuehner | Relationship added | related to 0009420 |
| 2009-06-10 19:00 | psarobe | Proposed Solution updated | |
| 2009-06-16 08:53 | rafaroda | Relationship added | related to 0009490 |
| 2009-06-23 09:23 | rafaroda | Assigned To | vmromanos => rajagopal |
| 2009-06-23 14:09 | rajagopal | Assigned To | rajagopal => vinothbabu |
| 2009-06-24 13:07 | hgbot | Checkin | |
| 2009-06-24 13:07 | hgbot | Note Added: 0017562 | |
| 2009-06-24 13:07 | hgbot | Status | scheduled => resolved |
| 2009-06-24 13:07 | hgbot | Resolution | open => fixed |
| 2009-06-24 13:07 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/stable/2.40/rev/87dd6f66cd7d5dd0d733b60f09a5e15dc8412466 [^] |
| 2009-07-01 12:44 | sureshbabu | Status | resolved => new |
| 2009-07-01 12:44 | sureshbabu | Resolution | fixed => open |
| 2009-07-01 12:44 | sureshbabu | Note Added: 0017730 | |
| 2009-07-01 13:16 | psarobe | Status | new => scheduled |
| 2009-07-01 13:16 | psarobe | fix_in_branch | 2.40 => pi |
| 2009-07-09 07:40 | vinothbabu | Note Added: 0018031 | |
| 2009-07-09 07:40 | vinothbabu | Status | scheduled => resolved |
| 2009-07-09 07:40 | vinothbabu | fix_in_branch | pi => |
| 2009-07-09 08:00 | sureshbabu | Status | resolved => closed |
| 2009-07-09 08:00 | sureshbabu | Note Added: 0018034 | |
| 2009-07-09 08:00 | sureshbabu | Fixed in Version | => pi |
| 2009-07-10 11:19 | plujan | Status | closed => new |
| 2009-07-10 11:19 | plujan | Note Added: 0018087 | |
| 2009-07-10 11:19 | plujan | Fixed in Version | pi => |
| 2009-07-10 11:20 | plujan | Status | new => scheduled |
| 2009-07-10 11:20 | plujan | fix_in_branch | => pi |
| 2009-07-10 11:20 | plujan | Status | scheduled => resolved |
| 2009-07-10 11:20 | plujan | Resolution | open => fixed |
| 2009-07-11 04:14 | vinothbabu | Note Added: 0018126 | |
| 2009-07-13 10:02 | psarobe | Fixed in Version | => 2.40MP7 |
| 2009-07-13 10:02 | psarobe | fix_in_branch | pi => 2.40 |
| 2009-07-13 10:51 | sureshbabu | Status | resolved => closed |
| 2009-07-13 10:51 | sureshbabu | Note Added: 0018154 | |
|
Notes |
|
|
(0017562)
|
|
hgbot
|
|
2009-06-24 13:07
|
|
Repository: erp/stable/2.40
Changeset: 87dd6f66cd7d5dd0d733b60f09a5e15dc8412466
Author: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com>
Date: Wed Jun 17 19:31:04 2009 +0200
URL: http://code.openbravo.com/erp/stable/2.40/rev/87dd6f66cd7d5dd0d733b60f09a5e15dc8412466 [^]
Fixes 0009397: C_BankStatement_Post process fail when Settlement sequence has a preffix and/or suffix
---
M src-db/database/model/functions/C_BANKSTATEMENT_POST.xml
---
|
|
|
|
|
i can able to reproduce the error, after i added both prefix and suffix.
"Error: Invalid input syntax for type numeric: "PR10027SF" |
|
|
|
|
|
I was not able to reproduce in the latest version |
|
|
|
|
|
|
|
(0018087)
|
|
plujan
|
|
2009-07-10 11:19
|
|
|
|
|
|
|
Tested 2.40 Environment also . It is working fine |
|
|
|
|
|