Option to schedule a GL Custom program where period parameter needs to be dynamically change on firs
Hi All,
We are building a custom report which extracts the GL Balances of all Balance Sheet accounts along with some other columns and the output will be automatically emailed to concerned stake holders.
This report has Period Parameter which is a Mandatory parameter
We want to schedule this report once, but we want the period parameter to change dynamically on first of every month.
Ex:- If we schedule this report say today (i..e. on 08-Aug-2018) with Period parameter as "AUG-18". We want the report parameter to be dynamically changed to "Sep-18" on 01-Sep-2018 and again this needs to be changed to "Oct-18" on 01-Oct-2018 and so on...