Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0031860Openbravo ERP09. Financial managementpublic2016-01-11 14:142016-03-17 10:54
Reporterngarcia 
Assigned ToAtulOpenbravo 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned Todmiguelez
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression levelProduction - Confirmed Stable
Regression date2015-03-23
Regression introduced in release3.0PR15Q3
Regression introduced by commithttps://code.openbravo.com/erp/devel/pi/rev/908de92996757265cce434502b36adf8860d6450 [^]
Triggers an Emergency PackNo
Summary0031860: Cannot save a G/L Journal header with the date of the adjustment period if both periods are opened
DescriptionCannot save a G/L Journal header with the date of the adjustment period if both periods are opened
Steps To ReproduceAs group admin role:
   Create a new year in the Fiscal Calendar window
   Create periods and select the option to create the adjustment period
   Open all periods
   Go to G/L Journal window and create a record with the date of the adjustment period (31/12)
   Create a Header with the same date. Check you cannot save the record neither if you select the common period nor the adjustment period. The following error message is shown:
      Saving failed. No valid period for this accounting date.
   
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
depends on backport 00318963.0PR16Q1 closed AtulOpenbravo Cannot save a G/L Journal header with the date of the adjustment period if both periods are opened 
depends on backport 00318973.0PR15Q4.2 closed AtulOpenbravo Cannot save a G/L Journal header with the date of the adjustment period if both periods are opened 
depends on backport 00318983.0PR15Q3.5 closed AtulOpenbravo Cannot save a G/L Journal header with the date of the adjustment period if both periods are opened 
caused by defect 00289523.0PR15Q3 closed fsoto82 Period Not Updated in G/L Journal if the Accounting Date belongs to a closed period. It is not possible to unpost it 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2016-01-11 14:14ngarciaNew Issue
2016-01-11 14:14ngarciaAssigned To => Triage Finance
2016-01-11 14:14ngarciaModules => Core
2016-01-11 14:14ngarciaResolution time => 1455490800
2016-01-11 14:14ngarciaTriggers an Emergency Pack => No
2016-01-11 14:15ngarciaRelationship addedcaused by 0028952
2016-01-11 14:17ngarciaIssue Monitored: networkb
2016-01-13 07:37AtulOpenbravoAssigned ToTriage Finance => AtulOpenbravo
2016-01-13 07:38AtulOpenbravoStatusnew => scheduled
2016-01-14 04:26AtulOpenbravoNote Added: 0083275
2016-01-14 04:31AtulOpenbravoNote Edited: 0083275bug_revision_view_page.php?bugnote_id=0083275#r10613
2016-01-14 17:09dmiguelezRegression level => Production - Confirmed Stable
2016-01-14 17:09dmiguelezRegression date => 2015-03-23
2016-01-14 17:09dmiguelezRegression introduced in release => 3.0PR15Q3.3
2016-01-14 17:09dmiguelezRegression introduced by commit => https://code.openbravo.com/erp/devel/pi/rev/908de92996757265cce434502b36adf8860d6450 [^]
2016-01-14 17:09dmiguelezRegression introduced in release3.0PR15Q3.3 => 3.0PR15Q3
2016-01-14 17:17dmiguelezStatusscheduled => feedback
2016-01-14 17:17dmiguelezStatusfeedback => new
2016-01-14 17:53dmiguelezStatusnew => scheduled
2016-01-14 18:06hgbotCheckin
2016-01-14 18:06hgbotNote Added: 0083318
2016-01-14 18:06hgbotStatusscheduled => resolved
2016-01-14 18:06hgbotResolutionopen => fixed
2016-01-14 18:06hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/c2ba9553dc85c07b2461e34c9a5b4d81c70a43d2 [^]
2016-01-14 18:06dmiguelezReview Assigned To => dmiguelez
2016-01-14 18:06dmiguelezNote Added: 0083319
2016-01-14 18:06dmiguelezStatusresolved => closed
2016-03-17 10:54hudsonbotCheckin
2016-03-17 10:54hudsonbotNote Added: 0085047

Notes
(0083275)
AtulOpenbravo   
2016-01-14 04:26   
(edited on: 2016-01-14 04:31)
Test Plan
- Login as Group admin role:
- Create a new year in the Fiscal Calendar window
- Create periods and select the option to create the adjustment period
- Open all periods.
- Go to G/L Journal window and create a record with the date of the adjustment period (31/12)
- Create a Header with the same date. Check you can save the record.

Test Plan for 28952 is also tested.
(0083318)
hgbot   
2016-01-14 18:06   
Repository: erp/devel/pi
Changeset: c2ba9553dc85c07b2461e34c9a5b4d81c70a43d2
Author: Atul Gaware <atul.gaware <at> openbravo.com>
Date: Wed Jan 13 21:13:18 2016 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/c2ba9553dc85c07b2461e34c9a5b4d81c70a43d2 [^]

Fixes Issue 31860:Cannot save a G/L Journal header with the date of the
adjustment period if both periods are opened

c_chk_open_period returns value more than 1 in case standard period and
adjustment period is open in which the date of GL journal is included.
<> 1 check is failed in this case so check is changed to < 1 to show
error message in case period id not available

---
M src-db/database/model/triggers/GL_JOURNAL_CHK_RESTRICT_TRG.xml
---
(0083319)
dmiguelez   
2016-01-14 18:06   
Code Review + Testing Ok
(0085047)
hudsonbot   
2016-03-17 10:54   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/b22fb0500156 [^]
Maturity status: Test