0011158: Method selectLinesPeriodClosed from DocLineBank_data.xsql takes C_Calendar_ID from AD_ClientInfo instead of from AD_Org

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0011158

Openbravo ERP

09. Financial management

public

2009-10-28 12:17

2009-11-19 00:00

Reporter

networkb

Assigned To

vmromanos

Priority

urgent

Severity

major

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS Version

Product Version

2.50MP7

Target Version

2.50MP9

Fixed in Version

2.50MP9

Merge Request Status

Review Assigned To

OBNetwork customer

Web browser

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

0011158: Method selectLinesPeriodClosed from DocLineBank_data.xsql takes C_Calendar_ID from AD_ClientInfo instead of from AD_Org

Description

In 2.50 you can now define the calendar for organization's level (instead of entity level as before) but this select continue taking calendar information from entity instead of from organization.

Steps To Reproduce

Proposed Solution

In this select change table ad_clientinfo by ad_org:

SELECT COUNT(*) AS COUNT
FROM C_BANKSTATEMENTLINE BL left join C_DEBT_PAYMENT DP on BL.C_DEBT_PAYMENT_ID
= DP.C_DEBT_PAYMENT_ID
WHERE C_BANKSTATEMENT_ID = ?
AND EXISTS (SELECT 1
FROM C_YEAR, C_PERIOD, C_PERIODCONTROL, AD_CLIENTINFO
WHERE C_YEAR.C_YEAR_ID = C_PERIOD.C_YEAR_ID
AND C_PERIOD.C_PERIOD_ID = C_PERIODCONTROL.C_PERIOD_ID
AND C_YEAR.C_CALENDAR_ID = AD_CLIENTINFO.C_CALENDAR_ID
AND AD_CLIENTINFO.AD_CLIENT_ID = BL.AD_CLIENT_ID
AND C_PERIODCONTROL.DOCBASETYPE = 'CMB'
AND C_PERIODCONTROL.PERIODSTATUS <> 'O'
AND BL.DATEACCT >= C_PERIOD.STARTDATE
AND BL.DATEACCT < C_PERIOD.ENDDATE + 1)
GROUP BY bl.line
ORDER BY LINE

Additional Information