Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0007861 | Openbravo ERP | 09. Financial management | public | 2009-02-27 10:51 | 2009-04-22 00:01 |
|
| Reporter | networkb | |
| Assigned To | dalsasua | |
| Priority | immediate | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 5 | OS Version | |
| Product Version | 2.35MP5 | |
| Target Version | 2.35MP5 | Fixed in Version | 2.50 | |
| 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 | 0007861: 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) |
| Proposed Solution | |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | | depends on | backport | 0007924 | 2.35MP5 | closed | dalsasua | Select clause in Bank Statement's description doesn't get the correct line value for General Ledger Report | | depends on | backport | 0007925 | 2.35MP5 | closed | dalsasua | Select clause in Bank Statement's description doesn't get the correct line value for General Ledger Report | | related to | defect | 0009141 | 2.50 | closed | dalsasua | Invoice number lost in GL Report |
|
| Attached Files | |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2009-02-27 10:51 | networkb | New Issue | |
| 2009-02-27 10:51 | networkb | Assigned To | => rafaroda |
| 2009-02-27 10:51 | networkb | OBNetwork customer | => Yes |
| 2009-02-27 10:51 | networkb | Regression testing | => No |
| 2009-02-27 10:53 | rafaroda | Assigned To | rafaroda => dalsasua |
| 2009-03-03 18:55 | eduardo_Argal | Status | new => scheduled |
| 2009-03-03 18:55 | eduardo_Argal | fix_in_branch | => pi |
| 2009-03-03 19:06 | hgbot | Checkin | |
| 2009-03-03 19:06 | hgbot | Note Added: 0014334 | |
| 2009-03-03 19:06 | hgbot | Status | scheduled => resolved |
| 2009-03-03 19:06 | hgbot | Resolution | open => fixed |
| 2009-03-03 19:06 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/5b3b48eec9c87f8be8056d8d57dd394f42b428c2 [^] |
| 2009-04-21 10:33 | psarobe | Status | resolved => closed |
| 2009-04-22 00:01 | anonymous | sf_bug_id | 0 => 2778032 |
| 2009-08-03 16:24 | rafaroda | Relationship added | related to 0009141 |