Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0016595 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 09. Financial management | minor | always | 2011-03-31 14:03 | 2011-04-13 00:00 | |||
| Reporter | adrianromero | View Status | public | |||||
| Assigned To | adrianromero | |||||||
| Priority | high | Resolution | fixed | Fixed in Version | 3.0RC7 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | 805bb411d41f | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Linux 32 bit | Database | PostgreSQL | Java version | 1.6.0_18 | |||
| OS Version | Community Appliance | Database version | 8.3.9 | Ant version | 1.7.1 | |||
| Product Version | pi | SCM revision | ||||||
| Merge Request Status | ||||||||
| Review Assigned To | ||||||||
| OBNetwork customer | OBPS | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0016595: the system allows create two periods with a same date | |||||||
| Description | 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 | |||||||
| 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 | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|||||||||||||||
|
|||||||||||||||
 Relationships |
|
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 (viewer) 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 (viewer) 2011-04-12 16:07 |
tested: the period cannot be created with days in other period in the same year. it works fine |
|
Notes |
|
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 | OBNetwork customer | => Yes |
| 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 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |