Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0005872Openbravo ERP01. General setuppublic2008-11-07 08:352008-12-03 19:55
vmromanos 
vmromanos 
highmajoralways
closedfixed 
20Ubuntu 8.04
pi 
2.50 
No
Core
No
0005872: Check calendar restrinctions after changing the organization's calendar
When you change the organization's calendar, the application currently does not check if the new one fulfills the mandatory requirements
Create a statement level trigger into the AD_Org table which uses the AD_CHK_CALENDAR function
multi-org
Issue History
2008-11-07 08:35vmromanosNew Issue
2008-11-07 08:35vmromanosAssigned To => vmromanos
2008-11-07 08:35vmromanossf_bug_id0 => 2233111
2008-11-07 08:35vmromanosOBNetwork customer => No
2008-11-07 08:35vmromanosRegression testing => No
2008-11-07 08:37vmromanosStatusnew => scheduled
2008-11-07 08:37vmromanosfix_in_branch => trunk
2008-11-07 08:37vmromanosTag Attached: multi-org
2008-11-07 08:42vmromanosPrioritynormal => high
2008-11-07 08:42vmromanosfix_in_branchtrunk =>
2008-11-07 09:18svnbotCheckin
2008-11-07 09:18svnbotNote Added: 0010065
2008-11-07 09:18svnbotStatusscheduled => resolved
2008-11-07 09:18svnbotResolutionopen => fixed
2008-11-07 09:18svnbotsvn_revision => 9772
2008-11-25 13:35psarobeNote Added: 0010642
2008-11-25 13:35psarobeIssue Monitored: psarobe
2008-11-25 15:33vmromanosNote Added: 0010649
2008-12-03 19:55psarobeStatusresolved => closed
2008-12-03 19:55psarobeNote Added: 0010953

Notes
(0010065)
svnbot   
2008-11-07 09:18   
Repository: openbravo
Revision: 9772
Author: vmromanos
Date: 2008-11-07 09:18:49 +0100 (Fri, 07 Nov 2008)

Fixed bug 0005872: Check calendar restrinctions after changing the organization's calendar

---
A branches/modularity/src-db/database/model/triggers/AD_ORG_STLE_TRG.xml
---

https://dev.openbravo.com/websvn/openbravo/?rev=9772&sc=1 [^]
(0010642)
psarobe   
2008-11-25 13:35   
Victor, please specify what exactly QA has to review
(0010649)
vmromanos   
2008-11-25 15:33   
When you are changing the calendar of a ready organization and this organization is marked as "Legal Entity", the new calendar must fulfill some rules:
- Every legal entity must have itself or an ancestor at least a calendar attached to it
- All the organizations that belong to the same legal entity must have a unique calendar

To test it you can, for example, create a new legal entity organization, assign to it a calendar (and an accounting schema) and set it as ready. Then remove the organization's calendar and try to save it; the application should not allow it.

Another test you can do is:
1- Create two calendars
2- Create one legal entity (summary level), assign to it the first calendar and set it as ready
3- Create another legal entity, assign to it the same calendar, make it a child of the previous one and set it as ready.
4- Then try to change the assigned calendar for these organizations to other calendar. The application should not allow it.
(0010953)
psarobe   
2008-12-03 19:55   
QA has tested this case:

To test it you can, for example, create a new legal entity organization, assign to it a calendar (and an accounting schema) and set it as ready. Then remove the organization's calendar and try to save it; the application should not allow it