1) How to correctly define a Calendar with Adjusting Period?
2) Will the Quarter be 4 or 5?
3) Will the Month Number be 12 or 13?
4) A Calendar with a name like “Try Calendar” cause a problem when trying to save the Calendar definition? In this case, is “Calendar” a Oracle Reserved Word which we shouldn’t use?
5) What was I doing wrong for not being able to save the above calendar, with different combinations for the last row, such as the above separate two rows?


6) When calendar is defined compiled and validated, it can be attached to a Ledger. When the periods within the calendar a running out, do we have to append extra periods to this calendar in question, or do we have to create another fresh calendar and attach it to the Ledger.

7) In case we have to append perioad to the existing calendar, does it has to be a full 12 periods all the time?

Prefix Type Year Quarter Number From To Name Adjusting

JAN Month 2009 1 1 1-Jan-2009 31-Jan-2009 JAN-09
FEB Month 2009 1 2 1-Feb-2009 28-Feb-2009 FEB-09
MAR Month 2009 1 3 1-Mar-2009 31-Mar-2009 MAR-09
APR Month 2009 2 4 1-Apr-2009 30-Apr-2009 APR-09
MAY Month 2009 2 5 1-May-2009 31-May-2009 MAY-09
JUN Month 2009 2 6 1-Jun-2009 30-Jun-2009 JUN-09
JUL Month 2009 3 7 1-Jul-2009 31-Jul-2009 JUL-09
AUG Month 2009 3 8 1-Aug-2009 31-Aug-2009 AUG-09
SEP Month 2009 3 9 1-Sep-2009 30-Sep-2009 SEP-09
OCT Month 2009 4 10 1-Oct-2009 31-Oct-2009 OCT-09
NOV Month 2009 4 11 1-Nov-2009 30-Nov-2009 NOV-09
DEC Month 2009 4 12 1-Dec-2009 31-Dec-2009 DEC-09
DEC Month 2009 4 or 5 12 or 13 31-Dec-2009 31-DEC-2009 Dec-09 YES



DEC Month 2009 4 12 31-DEC-2009 31-DEC-2009 DEC-09 YES


DEC Month 2009 4 12 31-DEC-2009 31-DEC-2009 DEC-09 YES

Adjustment Period
-Assuming you have only 1 ADJ period.

Period = ADJ
Quarter = 4
Month = 13
31-Dec-2009 to 31-Dec-2009
Set the ADJ flag

1) How to correctly define a Calendar with Adjusting Period?

Usually 13th period is marked as adjusting. The period will consist of only 1 day: 31-DEC. Some companies keep 2 adjusting periods.

2) Will the Quarter be 4 or 5?

4th

3) Will the Month Number be 12 or 13?

13

4) A Calendar with a name like “Try Calendar” cause a problem when trying to save the Calendar definition? In this case, is “Calendar” a Oracle Reserved Word which we shouldn’t use?

Could be a bug ... Need more info like error message

5) What was I doing wrong for not being able to save the above calendar, with different combinations for the last row, such as the above separate two rows?

Dont know. Need more info.

6) When calendar is defined compiled and validated, it can be attached to a Ledger. When the periods within the calendar a running out, do we have to append extra periods to this calendar in question, or do we have to create another fresh calendar and attach it to the Ledger.

Append extra periods to this calendar.

7) In case we have to append perioad to the existing calendar, does it has to be a full 12 periods all the time?

One full year should be added. However you can add few months as well. (Budgeting will not work)

Thank you all for the help. The Calendar Definition process has categorically refused Month Number 13, with error message, forcing me to revert it back to 12, even though I have an Adjusting Period as 31-DEC-2009 to 31-DEC-2009. I will try defining another calendar with an Adjusting Period in it and post the error message on the forum, if there is a error.
Thanks

Fhorvath, thank you. I have just realised that I was wrongly using DEC as the "Period Prefix", instead of ADJ, even though I set the flag. I think this was what caused the whole problem. I will have a GO again, and let the Forum know the outcome. Cheers!

Thank you Hasan. Could a first accounting calendar with monthly period less than 12 periods be successfully compiled by the system engin and validly attached to the Ledger when creating it? Cheers!
Gavrobere

Question: Accounting Calendar and Adjusting Period

Answer: Setup > Financials > Calendar > Types. I had to first create a new Period Type as ADJ (adjusting), Periods per Year as 13 (1 or 12 wasn't working when trying to save the calendar definition). I then typed
ADJ as Period Prefix (DEC will not be saved),and selected
Period Type = ADJ,
Year is the same,
Quarter = 4,
Number = 13,
From: 31-DEC-2009
To: 31-DEC-2009
Name: ADJ-09 (with the flag set),

The word Calendar can be used within the calendar's name (this is not an Oracle Reserved Word, at least in this case).

Have I done the right thing by having first define the Period Type as ADJ (which was not among the system default period types such as, Year, Quarter, Month and Week?

Is it normal to set the Period Number to 13, instead of 1 (one Adjusting Period)?

Period Number set to 1 generated the following error: Please, enter a period number between 1 and 1.

A calendar must contain all periods of same "type".
You are trying to insert 13th period in a 12 period year.
This is what you should do:
1) Create a new type and call it "Month13". Enter 13 in "periods per year" field.
2) Create a new calendar based on this type.
3) Create adjusting period as ADJ

Hasan

Thank you very much, Hasan. I was adopting the wrong approach in implementing a Accounting Calendar with an Adjusting Period.

You have set me right, and this is how I can put it for other Forum Users:

Answer2: The correct approach to adopt when creating a calendar with adjusting Period.

A calendar must contain all periods of same "type".

Assuming only one adjusting period for Year 2009:

This is what you should do:
1) Create a new Type as:
Period Type: "Month13".
Period per Year: 13.
2) Create a new calendar based on this type.
3) Create adjusting period as ADJ (Prefix name) with Period Type of Month13
4) Year is the same
5) Quarter is 4
6) Number of Period is 13
From: 31-Dec-2009
To: 31-Dec-2009
Name: ADJ-09
Set Flag to Yes (Tick)

When the periods within the calendar is running out, we have to append extra periods to this calendar in question (one full year periods should be added). However, you can add few months as well (but Budgeting will not work, if you implement budgeting).

Nicely put. Thanks.

Hasan