Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0016192Openbravo ERP09. Financial managementpublic2011-03-10 09:102011-04-06 17:00
malsasua 
adrianromero 
highminoralways
closedfixed 
20Community Appliance
2.50MP27 
2.50MP282.50MP29 
Core
No
0016192: the system allows create two periods with a same date
You 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
. 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
No tags attached.
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 
Issue History
2011-03-10 09:10malsasuaNew Issue
2011-03-10 09:10malsasuaAssigned To => dalsasua
2011-03-10 09:10malsasuaModules => Core
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