I run a billing report on the last day of month to prep for next month invoicing. Is there a way to automate running this report on the last night of each month?

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered

I run a summary report from my invoice table at the end of each month to help prepare the next month's invoices.  I accumulates all the client session hours up to the night of the day before the next month.  I would like to be able to automate this process...just in case I forget to run it.  The whole report resets on the first of the month.  

Photo of William


  • 0 Points

Posted 4 years ago

  • 0
  • 1
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,224 Points 20k badge 2x thumb
I assume you have a [Date] field  in your table which you compare to the first and last days of the current month to generate the report on the last day of the month. What you could do is create a second report with criteria to ask the user for the start and end dates to compare [Date] to. This would give you an audit capability to go back and run the report for any previous time period and would include the case of not running your current report on the last day of the month.