Account Analysis report with Date Parameter instea

There are many available reports in Oracle Apps so you can discuss the requirements related to these reports here.
Post Reply
EMANUEL
Posts: 94
Joined: Sun Feb 22, 2009 9:59 am
Location: India

Account Analysis report with Date Parameter instea

Post by EMANUEL »

Hi,

We have already customized the Account Analysis Report in GL Module, but the user requirement is to insert the date instead of period in the report parameter

Please let me kow if this is possible

Rgds

Emanuel
mohsinsm
Posts: 1
Joined: Sat Mar 05, 2011 7:37 am
Location: Saudi Arabia

Post by mohsinsm »

Hi Emanuel

If u r using gl_je_lines table in ur query
u can use gl_periods table also
and link in ur where clause gl_periods.period_name=gl_je_lines.period_name
and use gl_periods.start_date and gl_periods.end_date
as ur date parameters instead of periods.
hope this help u.


Thank You


Regards

Mohsin
Post Reply

Who is online

Users browsing this forum: No registered users and 0 guests