GL Calendar

This forum is to discuss different features/issues of Oracle Financials modules ( GL - General Ledger, AP - Accounts Payable, AR - Accounts Receivable, FA - Fixed Assets & CM - Cash Management ).
Post Reply
lokeshoracle123
Posts: 10
Joined: Sun Mar 20, 2011 8:25 am
Location: India

GL Calendar

Post by lokeshoracle123 »

Hi ,

We have defined GL Acctg calendar with period type 4-4-5 where 12 periods and one adjustment period ,Our calendar starts from 26DEc 2010 and ends on 25th Dec 2011 and the adjustment period is for one day i.e 25th Dec .

As our calendar is ending on Dec 25th now we would like to capture data for the remaining week in dec 2011 how can we add this?

How can we capture data for the last week of december for our calendar setup...

Please advice.

Thanks
karthikeyanp1981
Posts: 463
Joined: Thu Nov 09, 2006 4:50 pm
Location: India
Contact:

Post by karthikeyanp1981 »

Dear Lokesh,

i am unable to understand it clearly.

I have defined the below Calendar in my instance and tested with the Calendar Validation report also, no validations found ....

Period Number 1 Quarter1 26-Dec-09 25-Jan-10
Period Number 2 Quarter1 26-Jan-10 25-Feb-10
Period Number 3 Quarter1 26-Feb-10 25-Mar-10
Period Number 4 Quarter2 26-Mar-10 25-Apr-10
Period Number 5 Quarter2 26-Apr-10 25-May-10
Period Number 6 Quarter2 26-May-10 25-Jun-10
Period Number 7 Quarter3 26-Jun-10 25-Jul-10
Period Number 8 Quarter3 26-Jul-10 25-Aug-10
Period Number 9 Quarter3 26-Aug-10 25-Sep-10
Period Number 10 Quarter4 26-Sep-10 25-Oct-10
Period Number 11 Quarter4 26-Oct-10 25-Nov-10
Period Number 12 Quarter4 26-Nov-10 25-Dec-10
Period Number 13 Quarter4 25-Dec-10 25-Dec-10 (Adjusting Period)

as per my understanding the last week of December should be your very first period of the financial / calending year....

What is your first period Date and every period contains how many days, please let me know in details... so i spend some more thought on this...

Regards,
Karthikeyan
lokeshoracle123
Posts: 10
Joined: Sun Mar 20, 2011 8:25 am
Location: India

Post by lokeshoracle123 »

Hi,

Thanks for your reply.

Please find below my current calendar setup:

Period Number 1 Quarter1 26-Dec-09 22-Jan-10
Period Number 2 Quarter1 23-Jan-10 19Feb-10
Period Number 3 Quarter1 20-Feb-10 26-Mar-10
Period Number 4 Quarter2 27-Mar-10 23-Apr-10
Period Number 5 Quarter2 24-Apr-10 21-May-10
Period Number 6 Quarter2 22-May-10 25-Jun-10
Period Number 7 Quarter3 26-Jun-10 23-Jul-10
Period Number 8 Quarter3 24-Jul-10 20-Aug-10
Period Number 9 Quarter3 21-Aug-10 24-Sep-10
Period Number 10 Quarter4 25-Sep-10 22-Oct-10
Period Number 11 Quarter4 23-Oct-10 19-Nov-10
Period Number 12 Quarter4 20-Nov-10 24-Dec-10
Period Number 13 Quarter4 24-Dec-10 24-Dec-10 (Adjusting Period)


This is our current calendar setup, With period type 4-4-5 where 12 periods and one adjustment period.

Now our requirement is that we need to close our financial year completelely in this calendar it self, i.e till dec 31 2010.

As our calendar is ending on 24th dec how can we capture the data for the last week of dec i.e from dec 25 to Dec 31 in this calendar.Is it possible by adding up a week if yes how can we add.

What are the possible solutions available for this???

Please provide me your available findings on this.

Thanks
Post Reply

Who is online

Users browsing this forum: No registered users and 17 guests