Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0016595Openbravo ERP09. Financial managementpublic2011-03-31 14:032011-04-13 00:00
Reporteradrianromero 
Assigned Toadrianromero 
PriorityhighSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionCommunity Appliance
Product Versionpi 
Target VersionFixed in Version3.0RC7 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0016595: the system allows create two periods with a same date
DescriptionYou can create two periods that they are overlap.
One date, could be included in two periods distinct.
If you try post a document in this date, error is returned
Steps To Reproduce. modify the period Jan 11
end date: 15/02/2011

From 01/02/2011 to 15/02/2011, this dates are included in two periods:
Jan 11 and Feb 11
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 00195253.0MP8 closed jonalegriaesarte in oracle, a period can not be updated 
blocks backport 00161922.50MP28 closed adrianromero the system allows create two periods with a same date 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-03-31 14:03adrianromeroNew Issue
2011-03-31 14:03adrianromeroAssigned To => adrianromero
2011-03-31 14:03adrianromeroModules => Core
2011-03-31 14:03adrianromeroIssue generated from0016192
2011-03-31 14:03adrianromeroRelationship addedblocks 0016192
2011-03-31 14:09hgbotCheckin
2011-03-31 14:09hgbotNote Added: 0035423
2011-03-31 14:09hgbotStatusnew => resolved
2011-03-31 14:09hgbotResolutionopen => fixed
2011-03-31 14:09hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/805bb411d41fbbc14f2051b85ccafb39d38b6189 [^]
2011-03-31 14:13adrianromeroNote Added: 0035424
2011-04-12 16:07malsasuaNote Added: 0035857
2011-04-12 16:07malsasuaStatusresolved => closed
2011-04-12 16:07malsasuaFixed in Version => 3.0RC7
2011-04-13 00:00anonymoussf_bug_id0 => 3285540
2012-01-19 15:35malsasuaRelationship addedrelated to 0019525

Notes
(0035423)
hgbot   
2011-03-31 14:09   
Repository: erp/devel/pi
Changeset: 805bb411d41fbbc14f2051b85ccafb39d38b6189
Author: Adrián Romero <adrianromero <at> openbravo.com>
Date: Thu Mar 31 14:07:44 2011 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/805bb411d41fbbc14f2051b85ccafb39d38b6189 [^]

Fixes issue 0016595: the system allows create two periods with a same date
It has been added in the trigger of the C_PERIOD table the verification of overlapping periods. It has been modified also the process that creates periods to not to collide with the new trigger conditino

---
M src-db/database/model/functions/C_YEARPERIODS.xml
M src-db/database/model/triggers/C_PERIOD_TRG2.xml
M src-db/database/sourcedata/AD_MESSAGE.xml
---
(0035424)
adrianromero   
2011-03-31 14:13   
* Testing the issue

Verify that now following the steps to reproduce an exception is raised explaining that the dates period overlaps another period. Verify also that if the new period does not overlaps any other period it works properly.

Verify also that if the startdate is greater than the end date also an exception is raised.

Verify also that is possible to delete and insert new periods.

Verify also that the process that creates periods for a year works successfully.

* Other areas affected

No other areas affected appart from the edition actions of the C_PERIOD table and the process that creates periods for a year.
(0035857)
malsasua   
2011-04-12 16:07   
tested: the period cannot be created with days in other period in the same year. it works fine