Well, you could probably have your scheduled refresh procedure check to see if the period is closed - and then bring in that data.

Thanks Kevin, I was hoping there would be someway that an event would trigger it. Otherwise, we would have to setup multiple schedules to run to keep check

could have a schedule that does the check that runs daily - and then creates a record in a sql table - that then says "hey give me all the transactions for this period the first time it shows up" and have that one run daily as well - or build it all into one schedule.