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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0011157
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementmajoralways2009-10-28 11:552009-11-19 00:00
ReporternetworkbView Statuspublic 
Assigned Tovinothbabu 
PriorityurgentResolutionfixedFixed in Version2.50MP9
StatusclosedFix in branchFixed in SCM revisionc39ccd238ce0
ProjectionnoneETAnoneTarget Version2.50MP9
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version2.50MP7SCM revision 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0011157: callout SL_Journal_Period takes C_Calendar_ID from AD_ClientInfo instead of from

DescriptionIn 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 Reproduce1. 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 SolutionIn 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')
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 00111582.50MP9 closedvmromanos Method selectLinesPeriodClosed from DocLineBank_data.xsql takes C_Calendar_ID from AD_ClientInfo instead of from AD_Org 

-  Notes
(0021446)
rafaroda (viewer)
2009-10-28 14:35

 Please provide proper steps to reproduce this issue.
(0021461)
networkb (viewer)
2009-10-29 10:14

 we have provided steps to reproduce
(0021605)
vmromanos (viewer)
2009-11-05 12:33

 Instead of getting the calendar directly from the organization, use the ad_org_getcalendarowner(p_organization character varying) database function
(0021899)
hgbot (developer)
2009-11-17 09:17

 Repository: erp/devel/pi
Changeset: c39ccd238ce0098ad24377b3f430971e6bb6eb69
Author: Vinoth Babu <vinoth.babu <at> openbravo.com>
Date: Tue Nov 17 13:46:09 2009 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/c39ccd238ce0098ad24377b3f430971e6bb6eb69 [^]

Fixes bug 11157 Callout changes SL_Journal_Period

---
M src/org/openbravo/erpCommon/ad_callouts/SL_Journal_Period.java
M src/org/openbravo/erpCommon/ad_callouts/SL_Journal_Period_data.xsql
---
(0021938)
sureshbabu (viewer)
2009-11-18 07:23

 Tested working fine

- Issue History
Date Modified Username Field Change
2009-10-28 11:55 networkb New Issue
2009-10-28 11:55 networkb Assigned To => rafaroda
2009-10-28 11:55 networkb OBNetwork customer => Yes
2009-10-28 14:35 rafaroda Note Added: 0021446
2009-10-28 14:35 rafaroda Assigned To rafaroda => dalsasua
2009-10-28 14:35 rafaroda Priority immediate => urgent
2009-10-28 14:35 rafaroda Status new => scheduled
2009-10-28 14:37 rafaroda Relationship added related to 0011158
2009-10-29 10:14 networkb Note Added: 0021461
2009-10-29 10:14 networkb Proposed Solution updated
2009-11-05 12:33 vmromanos Note Added: 0021605
2009-11-12 06:47 rajagopal Assigned To dalsasua => vinothbabu
2009-11-17 09:17 hgbot Checkin
2009-11-17 09:17 hgbot Note Added: 0021899
2009-11-17 09:17 hgbot Status scheduled => resolved
2009-11-17 09:17 hgbot Resolution open => fixed
2009-11-17 09:17 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/c39ccd238ce0098ad24377b3f430971e6bb6eb69 [^]
2009-11-18 07:23 sureshbabu Note Added: 0021938
2009-11-18 07:23 sureshbabu Status resolved => closed
2009-11-18 07:23 sureshbabu Fixed in Version => 2.50MP9
2009-11-19 00:00 anonymous sf_bug_id 0 => 2900154

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker