Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0011258Openbravo ERP09. Financial managementpublic2009-11-05 11:332009-11-20 00:00
networkb 
vmromanos 
highminoralways
closedfixed 
5
2.50MP6 
2.50MP92.50MP9 
Core
No
0011258: It is not possible to create a new calendar for an Organization
If a new Organization (with accounting), is created. It is not possible to create a new Fiscal calendar for it.

The reason is c_period_unique_period constraint (ad_client_id, startdate, enddate). It should be updated.
Go to General Setup > Enterprise > Initial Organization Setup.
Create a new one, selecting as Organization type, "Legal with accounting".
Enter a name, an organziation user, select as currency "EUR", and Business Partner, Product and Project checkboxes.
Go to Financial Management > Accounting > Setup > Fiscal Calendar.
Create a new one for your Organization (select it in Organization combo box).
Go to Year tab.
Create a new one (IE 2009).
Press "Create periods". An error is shown.
No tags attached.
related to defect 00114182.50MP9 closed vmromanos api checkbuild 210 fails 
Issue History
2009-11-05 11:33networkbNew Issue
2009-11-05 11:33networkbAssigned To => rafaroda
2009-11-05 11:35rafarodaAssigned Torafaroda => vmromanos
2009-11-05 11:35rafarodaPriorityimmediate => high
2009-11-05 11:35rafarodaStatusnew => scheduled
2009-11-13 09:33networkbTarget Version2.50MP10 => 2.50MP9
2009-11-18 14:07vmromanosNote Added: 0021966
2009-11-18 17:02vmromanosNote Added: 0021978
2009-11-18 17:51hgbotCheckin
2009-11-18 17:51hgbotNote Added: 0021981
2009-11-18 17:51hgbotStatusscheduled => resolved
2009-11-18 17:51hgbotResolutionopen => fixed
2009-11-18 17:51hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/d4efa4cd14bd789fcfb5bb54cfcee1fd12d85f5a [^]
2009-11-19 05:41sureshbabuNote Added: 0021998
2009-11-19 05:41sureshbabuStatusresolved => closed
2009-11-19 05:41sureshbabuFixed in Version => 2.50MP9
2009-11-19 14:47shuehnerRelationship addedrelated to 0011418
2009-11-20 00:00anonymoussf_bug_id0 => 2900816

Notes
(0021966)
vmromanos   
2009-11-18 14:07   
Breaking the API is needed for fixing this bug
(0021978)
vmromanos   
2009-11-18 17:02   
Just a clarification for networkb (and users in general):

The c_period_unique_period unique constraint is wrong and it's going to be fixed, but I want to inform you that two or more organizations can share the same calendar; so it's not necessary to create a new calendar for each legal entity if the calendars have exactly the same years and periods.

Remember that in 2.50, the calendar is defined at Organization's level (after checking "allow period control" flag, you can associate a calendar) and not at Calendar's level. The organization in the calendar's window is not related with the organization that owns this calendar (it's just kept for backward compatibility for the migration process).

Best regards,
Víctor.
(0021981)
hgbot   
2009-11-18 17:51   
Repository: erp/devel/pi
Changeset: d4efa4cd14bd789fcfb5bb54cfcee1fd12d85f5a
Author: Víctor Martínez Romanos <victor.martinez <at> openbravo.com>
Date: Wed Nov 18 17:52:19 2009 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/d4efa4cd14bd789fcfb5bb54cfcee1fd12d85f5a [^]

Fixed bug 11258: impossible to create two identical calendars for the same client

---
M src-db/database/model/tables/C_PERIOD.xml
---
(0021998)
sureshbabu   
2009-11-19 05:41   
Tested working fine