0011157: callout SL_Journal_Period takes C_Calendar_ID from AD_ClientInfo instead of from

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0011157

Openbravo ERP

09. Financial management

public

2009-10-28 11:55

2009-11-19 00:00

Reporter

networkb

Assigned To

vinothbabu

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

OBPS

Web browser

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

0011157: callout SL_Journal_Period takes C_Calendar_ID from AD_ClientInfo instead of from

Description

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

Steps To Reproduce

1. Create new organization "Legal with accounting"
2. Financial Management || Accounting || Setup || Fiscal Calendar || Calendar : create new calendar for your organization.
3. Financial Management || Accounting || Setup || Fiscal Calendar || Calendar >> Year : create year 2009 for your organization's calendar
4. Financial Management || Accounting || Setup || Fiscal Calendar || Calendar >> Year >> Period : create period for your organization's calendar with
name=mes1 ; starting date=01-01-2009 ; end date=31-01-2009 ; type=standard calendar
5. General Setup || Enterprise || Organization || Organization : check allow period control and set your calendar to your organization
6. General Setup || Enterprise || Organization || Organization >> Org Schema : create new record
7. Come back to General Setup || Enterprise || Organization || Organization and press "set as ready"
8. Financial Management || Accounting || Transactions || G/L Journal || Batch : create new record for your organization and set accounting date=15-01-2009
(Realize that Period set is "Jan-09" instead of "mes1")
9. Financial Management || Accounting || Transactions || G/L Journal || Batch >> Header : create nwe record for your batch setting accounting date=15-01-2009.
Realize that SL_Journal_Period callout set "Jan-09" as period (which belongs to the calendar defined for * organization) instead of "mes1" (the period defined for your organization).
You can check it by clicking in "Period" link

Proposed Solution

In this select change table ad_clientinfo by ad_org:

SELECT C_Period_ID
FROM C_Period
WHERE C_Year_ID IN
(SELECT C_Year_ID FROM C_Year WHERE C_Calendar_ID =
(SELECT C_Calendar_ID FROM AD_ClientInfo WHERE AD_Client_ID=?))
AND to_date(?) BETWEEN StartDate AND EndDate
AND PeriodType='S'
AND exists (select 1 from c_periodcontrol where c_periodcontrol.c_period_id =
c_period.c_period_id
AND periodstatus = 'O')

Additional Information