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)

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

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

Notes
(0014334) hgbot (developer) 2009-03-03 19:06	Repository: erp/devel/pi Changeset: 5b3b48eec9c87f8be8056d8d57dd394f42b428c2 Author: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com> Date: Tue Mar 03 19:05:19 2009 +0100 URL: http://code.openbravo.com/erp/devel/pi/rev/5b3b48eec9c87f8be8056d8d57dd394f42b428c2 [^] Fixes bug 0007861: 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 M src/org/openbravo/erpCommon/ad_forms/FactLine.java ---

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