Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0007925
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] 09. Financial managementmajoralways2009-02-27 10:512009-03-10 16:43
ReporternetworkbView Statuspublic 
Assigned Todalsasua 
PriorityimmediateResolutionfixedFixed in Version2.35MP13
StatusclosedFix in branch2.3xFixed in SCM revision4c8fbf5686f1
ProjectionnoneETAnoneTarget Version2.35MP5
OSAnyDatabaseOracleJava version
OS VersionDatabase versionAnt version
Product Version2.35MP5SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0007925: 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)
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
blocks defect 00078612.35MP5 closeddalsasua Select clause in Bank Statement's description doesn't get the correct line value for General Ledger Report 

-  Notes
(0014330)
hgbot (developer)
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
---

- 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.3x
2009-03-03 19:02 hgbot Checkin
2009-03-03 19:02 hgbot Note Added: 0014330
2009-03-03 19:02 hgbot Status scheduled => resolved
2009-03-03 19:02 hgbot Resolution open => fixed
2009-03-03 19:02 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/stable/2.3x/rev/4c8fbf5686f1bdcc17a8b17c0ae83343a4a83c73 [^]
2009-03-06 16:09 psarobe Fixed in Version => 2.35MP12
2009-03-10 16:43 psarobe Status resolved => closed

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker