Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0029827Openbravo ERP09. Financial managementpublic2015-05-08 12:312015-05-11 17:13
Reporterpsanjuan 
Assigned Tovmromanos 
PriorityimmediateSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionUbuntu 8.04.1
Product Version 
Target Version3.0PR15Q2.1Fixed in Version3.0PR15Q2.1 
Merge Request Status
Review Assigned ToSandrahuguet
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0029827: Open/Close Period Control window should only shown the calendars associated to an Organization
DescriptionOpen/Close Period Control window should only shown the calendars associated to an Organization
Steps To ReproduceGo to Fiscal Calendar window
Create a new one called "Calendario España Test" for F&B España org (this organization already has a calendar assined in the "Organization" window).
Go to Year and create 2014 year.
Go to periods tab and create them (Periods) by using the process button "Create Periods".
Process completes successfully.

Go to Open/Close Period Control window and realize that the new calendar created is shown there. Select it and select all those periods. Try to open them.

Realize that those periods cannot be opened, realize that those periods do not have any document assigned and its status will always remains as "Mixed".

Above scenario is confusing.

Proposed SolutionOpen/Close period control window should only show calendars assigned to Organizations set as ready, because once an organization is set as ready, calendar option turns to read-only, it can not be changed.
Additional Information
TagsApproved
Relationships
blocks defect 0029823 closed vmromanos Open/Close Period Control window should only shown the calendars associated to an Organization 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2015-05-08 12:49vmromanosTypedefect => backport
2015-05-08 12:49vmromanosTarget Version => 3.0PR15Q2.1
2015-05-08 14:21dmitry_mezentsevTag Attached: Approved
2015-05-11 16:56hgbotCheckin
2015-05-11 16:56hgbotNote Added: 0077292
2015-05-11 16:56hgbotStatusscheduled => resolved
2015-05-11 16:56hgbotResolutionopen => fixed
2015-05-11 16:56hgbotFixed in SCM revision => http://code.openbravo.com/erp/backports/3.0PR15Q2.1/rev/5c24b3086d3276bb5b3c2ec3a0a2caa6632efae2 [^]
2015-05-11 17:13SandrahuguetReview Assigned To => Sandrahuguet
2015-05-11 17:13SandrahuguetNote Added: 0077298
2015-05-11 17:13SandrahuguetStatusresolved => closed
2015-05-11 17:13SandrahuguetFixed in Version => 3.0PR15Q2.1

Notes
(0077292)
hgbot   
2015-05-11 16:56   
Repository: erp/backports/3.0PR15Q2.1
Changeset: 5c24b3086d3276bb5b3c2ec3a0a2caa6632efae2
Author: Víctor Martínez Romanos <victor.martinez <at> openbravo.com>
Date: Fri May 08 14:02:09 2015 +0200
URL: http://code.openbravo.com/erp/backports/3.0PR15Q2.1/rev/5c24b3086d3276bb5b3c2ec3a0a2caa6632efae2 [^]

Fixed bug 29827: Open/Close Period Control shows calendars associated to organizations

The Open/Close Period Control window was showing all the periods available at the C_Period table.
The target of this window is to open/close periods in fiscal calendars, so it should only show periods belonging to a fiscal calendar linked to an organization set as ready.

The fix has 2 parts:
1. Added a hql where clause to include only periods belonging to a fiscal calendar linked to an organization set as ready.
2. The hql filter clause was wrong because it was filtering by the c_period.ad_org_id. Instead it should be filtering by the organization linked to the calendar's periods

---
M src-db/database/sourcedata/AD_TAB.xml
---
(0077298)
Sandrahuguet   
2015-05-11 17:13   
Code review + testing OK