Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0007924 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| backport | [Openbravo ERP] 09. Financial management | major | always | 2009-02-27 10:51 | 2009-05-22 12:46 | |||
| Reporter | networkb | View Status | public | |||||
| Assigned To | dalsasua | |||||||
| Priority | immediate | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | pi | Fixed in SCM revision | 93f1dca72f92 | |||
| Projection | none | ETA | none | Target Version | 2.35MP5 | |||
| OS | Any | Database | Oracle | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | 2.35MP5 | SCM revision | ||||||
| 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 | 0007924: Select clause in Bank Statement's description doesn't get the correct line value for General Ledger Report | |||||||
| Description | Select clause defined for Bank Statement's descriptions is not taking the correct value in @Line@ variable, so the description is not working properly and , as a consequence of that, some records in General Ledger Report are being grouped (because they appear as they have same account value, same accounting date and same description) | |||||||
| Steps To Reproduce | 1. Financial Management || Accounting || Setup || Accounting Schema || Account Schema Tables --> go to C_BankStatement table and add "SELECT 'Extracto: ' || C_BANKSTATEMENT.NAME || ' - ' || C_BANKSTATEMENTLINE.LINE || ' - ' || NVL(C_DEBT_PAYMENT.DESCRIPTION,C_BPARTNER.NAME) FROM C_BANKSTATEMENT,C_BANKSTATEMENTLINE, C_DEBT_PAYMENT, C_BPARTNER WHERE C_BANKSTATEMENT.C_BANKSTATEMENT_ID = C_BANKSTATEMENTLINE.C_BANKSTATEMENT_ID AND C_BANKSTATEMENTLINE.C_DEBT_PAYMENT_ID = C_DEBT_PAYMENT.C_DEBT_PAYMENT_ID AND C_DEBT_PAYMENT.C_BPARTNER_ID = C_BPARTNER.C_BPARTNER_ID AND C_BANKSTATEMENT.C_BANKSTATEMENT_ID = @RecordId@ AND C_BANKSTATEMENTLINE.C_BANKSTATEMENTLINE_ID = @Line@"in SQL Description box. 2. Go to Financial Management || Receivables & Payables || Transactions || Bank Statement --> create 2 bank statements with same bank account and same accounting date. Process and Post. 3. Financial Management || Accounting || Analysis Tools || General Ledger Report --> execute the report and check that both bank statements are being grouped because description is the same (@Line@ variable is not being taken properly) | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0014663) hgbot (developer) 2009-03-16 11:16 |
Repository: erp/stable/2.40 Changeset: 93f1dca72f924c0d2e135d53c8f22ee513e8c176 Author: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com> Date: Tue Mar 03 19:04:17 2009 +0100 URL: http://code.openbravo.com/erp/stable/2.40/rev/93f1dca72f924c0d2e135d53c8f22ee513e8c176 [^] Fixes bug 0007924: Select clause in Bank Statement's description doesn't get the correct line value for General Ledger Report --- M src/org/openbravo/erpCommon/ad_forms/DocBank.java --- |
|
(0014933) sureshbabu (viewer) 2009-03-25 10:45 |
Re tested working fine (oracle) |
|
(0016572) pmagnin (viewer) 2009-05-22 12:02 |
The Invoice number is lost in the GL Report. The Settlement has this information, the GL Report should have it as well. This is also a Blatem requirement with High priorities. This issue exists in 2.50 and 2.40 Backport needed. |
|
(0016578) pmagnin (viewer) 2009-05-22 12:37 |
A new bug will be open, there is no direct relation between the missing invoice number and the initial defect. |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2009-03-03 18:55 | eduardo_Argal | Type | defect => backport |
| 2009-03-03 18:55 | eduardo_Argal | fix_in_branch | => 2.40 |
| 2009-03-16 11:16 | hgbot | Checkin | |
| 2009-03-16 11:16 | hgbot | Note Added: 0014663 | |
| 2009-03-16 11:16 | hgbot | Status | scheduled => resolved |
| 2009-03-16 11:16 | hgbot | Resolution | open => fixed |
| 2009-03-16 11:16 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/stable/2.40/rev/93f1dca72f924c0d2e135d53c8f22ee513e8c176 [^] |
| 2009-03-24 11:01 | psarobe | Fixed in Version | => 2.40MP4 |
| 2009-03-25 10:45 | sureshbabu | Status | resolved => closed |
| 2009-03-25 10:45 | sureshbabu | Note Added: 0014933 | |
| 2009-05-22 12:02 | pmagnin | Status | closed => new |
| 2009-05-22 12:02 | pmagnin | Resolution | fixed => open |
| 2009-05-22 12:02 | pmagnin | Note Added: 0016572 | |
| 2009-05-22 12:02 | pmagnin | Fixed in Version | 2.40MP4 => |
| 2009-05-22 12:37 | pmagnin | Note Added: 0016578 | |
| 2009-05-22 12:46 | psarobe | Status | new => scheduled |
| 2009-05-22 12:46 | psarobe | fix_in_branch | 2.40 => pi |
| 2009-05-22 12:46 | psarobe | Status | scheduled => resolved |
| 2009-05-22 12:46 | psarobe | Resolution | open => fixed |
| 2009-05-22 12:46 | psarobe | Status | resolved => closed |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |