Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0016595
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementminoralways2011-03-31 14:032011-04-13 00:00
ReporteradrianromeroView Statuspublic 
Assigned Toadrianromero 
PriorityhighResolutionfixedFixed in Version3.0RC7
StatusclosedFix in branchFixed in SCM revision805bb411d41f
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabasePostgreSQLJava version1.6.0_18
OS VersionCommunity ApplianceDatabase version8.3.9Ant version1.7.1
Product VersionpiSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0016595: 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
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to defect 00195253.0MP8 closedjonalegriaesarte in oracle, a period can not be updated 
blocks backport 00161922.50MP28 closedadrianromero the system allows create two periods with a same date 

-  Notes
(0035423)
hgbot (developer)
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 (manager)
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 (developer)
2011-04-12 16:07

tested: the period cannot be created with days in other period in the same year. it works fine

- Issue History
Date Modified Username Field Change
2011-03-31 14:03 adrianromero New Issue
2011-03-31 14:03 adrianromero Assigned To => adrianromero
2011-03-31 14:03 adrianromero Modules => Core
2011-03-31 14:03 adrianromero Issue generated from 0016192
2011-03-31 14:03 adrianromero Relationship added blocks 0016192
2011-03-31 14:09 hgbot Checkin
2011-03-31 14:09 hgbot Note Added: 0035423
2011-03-31 14:09 hgbot Status new => resolved
2011-03-31 14:09 hgbot Resolution open => fixed
2011-03-31 14:09 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/805bb411d41fbbc14f2051b85ccafb39d38b6189 [^]
2011-03-31 14:13 adrianromero Note Added: 0035424
2011-04-12 16:07 malsasua Note Added: 0035857
2011-04-12 16:07 malsasua Status resolved => closed
2011-04-12 16:07 malsasua Fixed in Version => 3.0RC7
2011-04-13 00:00 anonymous sf_bug_id 0 => 3285540
2012-01-19 15:35 malsasua Relationship added related to 0019525


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker