Is there a way to schedule a Quick Report (or a Database Task running one) to run a fixed number of days after each accounting period's end date, rather than on a fixed calendar date that needs manual adjustment every period?

All FAQ questions / Finance

Answer

Yes — compute the period's actual end date dynamically using ACCOUNTING_PERIOD_API functions (for example, combining GET_CURR_ACC_YEAR_PERIOD() to get the current year/period and GET_UNTIL_DATE_FOR_YEAR_PERIOD() to get that period's end date) and add the number of days you need as an offset, using that expression in a custom schedule for the Scheduled Database Task. This keeps the schedule correctly aligned to each period's actual end date automatically, rather than needing a hardcoded date that has to be updated every period.

Documentation-based answer. Confirm the product and release before applying it. This answer has not been verified in an IFS environment.

← Browse Finance questions