Page 1 of 1

GL Effective date

Posted: Tue Jan 05, 2010 9:18 am
by kommineni7
Hi All,


my doubt is how the effective gl date is populaitng in case of subledger transactions.

in case of any doucument in this regard pelase send/share here.

Thanks in Advance,
Venkatesh

Posted: Wed Jan 06, 2010 7:05 am
by oteixeira
Hello Venkatesh.

Depending on the subledger, the effective date on the GL journal entries can be, for example:

-AR Transactions -> GL Date (not the Transaction Date)
-AP Payments -> Payment Date
-AP Invoice Distributions -> GL Date

Octavio

Posted: Wed Jan 06, 2010 6:34 pm
by tgs100
It also depends on the journal summarization value. In case of summarize by GL period, the GL date will the last date of the period.

Cheers,
Saravanan

Posted: Thu Jan 07, 2010 12:00 pm
by kommineni7
Thanks guys..

need some more information ..

for some of ap/ar/fa transacitons gl effective date is defalting to first day or last day of period, so can you tell me for what type of transacitons the date will be default like that?

my second question is - Please confirm the below

if we are transfering the subledger data in detail mode - gl effective date will pick up from invoice/payment/receipt gl date.

if we are transfering the subledger data in summary mode - how the effective date functionality will work?

Posted: Thu Jan 07, 2010 4:11 pm
by tgs100
In the case of detail transfer, the transaction GL date (distribution line GL date, if applicable) will be considered as GL effective date.

In the case of summary by GL period, it will be the last date of the period.

In the case of summary by GL date, the transactions will be grouped based on the transaction GL date.

The above is not applicable to average balancing concept.

Cheers,
Saravanan

Posted: Mon Jan 11, 2010 1:25 pm
by kommineni7
Thanks Sarvanan..

sorry to ask you some more doubts..

the above 3 rules hold good for any modules or it will change by module wise..

For some trx. the efffective date will be the first day of period in our instance & for some trx. last day of the period..

Please clarify

Thanks,
Venkaetsh

Posted: Mon Jan 11, 2010 5:26 pm
by tgs100
1. What is the version?
2. In which application you are getting the GL date as first date?
3. What is the transfer level? Summary or detail?

Cheers,
Saravanan

Posted: Tue Jan 12, 2010 1:18 pm
by kommineni7
Hi Sarvanan,

we are in 11.5.10.2.

We are getting the first day of the period for the following type of categories.

Eg: Receipt writeoff, Payment void trx. etc

we are transfering the transaction in detail mode from ap/ar module.

Thanks in advance,
Venkatesh

Posted: Thu Jan 14, 2010 1:28 pm
by nrao1981
[quote]Thanks guys..

need some more information ..

for some of ap/ar/fa transacitons gl effective date is defalting to first day or last day of period, so can you tell me for what type of transacitons the date will be default like that?

my second question is - Please confirm the below

if we are transfering the subledger data in detail mode - gl effective date will pick up from invoice/payment/receipt gl date.

if we are transfering the subledger data in summary mode - how the effective date functionality will work?


<i><div align="right">Originally posted by kommineni7