0007924: Select clause in Bank Statement's description doesn't get the correct line value for General Ledger Report

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0007924

Openbravo ERP

09. Financial management

public

2009-02-27 10:51

2009-05-22 12:46

Reporter

networkb

Assigned To

dalsasua

Priority

immediate

Severity

major

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS Version

Product Version

2.35MP5

Target Version

2.35MP5

Fixed in Version

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

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)

Proposed Solution

Additional Information