Page 1 of 1

Account Analysis report with Date Parameter instea

Posted: Sun Jan 30, 2011 3:11 am
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

Posted: Sat Mar 05, 2011 8:55 am
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