Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0016192Openbravo ERP09. Financial managementpublic2011-03-10 09:102011-04-06 17:00
Reportermalsasua 
Assigned Toadrianromero 
PriorityhighSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionCommunity Appliance
Product Version2.50MP27 
Target Version2.50MP28Fixed in Version2.50MP29 
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
Summary0016192: 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
depends on defect 0016595 closed adrianromero the system allows create two periods with a same date 
related to defect 00203363.0MP12 closed jecharri Should not be possible to create several periods for same date range in different years 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-03-10 09:10malsasuaNew Issue
2011-03-10 09:10malsasuaAssigned To => dalsasua
2011-03-10 09:10malsasuaModules => Core
2011-03-10 09:10malsasuaOBNetwork customer => Yes
2011-03-10 10:58malsasuaIssue Monitored: malsasua
2011-03-10 10:58malsasuaIssue Monitored: networkb
2011-03-10 10:58malsasuaIssue End Monitor: malsasua
2011-03-10 17:43malsasuaTarget Version2.50MP29 => 2.50MP28
2011-03-31 14:02adrianromeroStatusnew => scheduled
2011-03-31 14:02adrianromeroTypedefect => backport
2011-03-31 14:03adrianromeroIssue cloned0016595
2011-03-31 14:03adrianromeroRelationship addeddepends on 0016595
2011-03-31 14:03adrianromeroAssigned Todalsasua => adrianromero
2011-03-31 14:14adrianromeroNote Added: 0035425
2011-04-01 12:33hgbotCheckin
2011-04-01 12:33hgbotNote Added: 0035455
2011-04-01 12:33hgbotStatusscheduled => resolved
2011-04-01 12:33hgbotResolutionopen => fixed
2011-04-01 12:33hgbotFixed in SCM revision => http://code.openbravo.com/erp/stable/2.50/rev/7f853bd7be356e9c8497c7d423faec1ea570801c [^]
2011-04-06 17:00malsasuaNote Added: 0035665
2011-04-06 17:00malsasuaStatusresolved => closed
2011-04-06 17:00malsasuaFixed in Version => 2.50MP29
2012-04-24 16:18maiteRelationship addedrelated to 0020336

Notes
(0035425)
adrianromero   
2011-03-31 14:14   
Fix done and tested. Pending for the repository to be unfrozen.
(0035455)
hgbot   
2011-04-01 12:33   
Repository: erp/stable/2.50
Changeset: 7f853bd7be356e9c8497c7d423faec1ea570801c
Author: Adrián Romero <adrianromero <at> openbravo.com>
Date: Thu Mar 31 14:05:03 2011 +0200
URL: http://code.openbravo.com/erp/stable/2.50/rev/7f853bd7be356e9c8497c7d423faec1ea570801c [^]

Fixes issue 0016192: 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
---
(0035665)
malsasua   
2011-04-06 17:00   
tested: the period cannot be created with days in other period in the same year. it works fine