Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0007925Openbravo ERP09. Financial managementpublic2009-02-27 10:512009-03-10 16:43
Reporternetworkb 
Assigned Todalsasua 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.35MP5 
Target Version2.35MP5Fixed in Version2.35MP13 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0007925: Select clause in Bank Statement's description doesn't get the correct line value for General Ledger Report
DescriptionSelect 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 Reproduce1. 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
TagsNo tags attached.
Relationships
blocks defect 00078612.35MP5 closed dalsasua Select clause in Bank Statement's description doesn't get the correct line value for General Ledger Report 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-03-03 18:55eduardo_ArgalTypedefect => backport
2009-03-03 18:55eduardo_Argalfix_in_branch => 2.3x
2009-03-03 19:02hgbotCheckin
2009-03-03 19:02hgbotNote Added: 0014330
2009-03-03 19:02hgbotStatusscheduled => resolved
2009-03-03 19:02hgbotResolutionopen => fixed
2009-03-03 19:02hgbotFixed in SCM revision => http://code.openbravo.com/erp/stable/2.3x/rev/4c8fbf5686f1bdcc17a8b17c0ae83343a4a83c73 [^]
2009-03-06 16:09psarobeFixed in Version => 2.35MP12
2009-03-10 16:43psarobeStatusresolved => closed

Notes
(0014330)
hgbot   
2009-03-03 19:02   
Repository: erp/stable/2.3x
Changeset: 4c8fbf5686f1bdcc17a8b17c0ae83343a4a83c73
Author: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com>
Date: Tue Mar 03 18:59:08 2009 +0100
URL: http://code.openbravo.com/erp/stable/2.3x/rev/4c8fbf5686f1bdcc17a8b17c0ae83343a4a83c73 [^]

Fixes bug 0007925: 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
---