Schedule calculations

User permission: Rebates

You can schedule non-parent rebates within a project to calculate whenever the project's source database is updated. This allows you to gain visibility of rebate estimates as soon as a month has ended, as databases are typically updated (or rebuilt) at the end of each month. You’ll see the results in your Rebates Analysis database and any other databases that have a Rebates measure.

Set a schedule

1. Open the project and click Schedule to schedule the calculation for the whole project. Alternatively, to schedule a calculation for a specific rule, select the rule and click Schedule.

   
2. In the Schedule window, select Frequency > On source database update.

3. Configure the schedule settings:

   • Calculation Date: This defaults to Yesterday and you can’t change it. You can change the timezone (see below) to suit the timezone of the consumer of the calculation information. For example, to account for them behind or ahead of your local timezone.

   • Transaction Range: By default, the Month of calculation date is selected, which refers to the full calendar month in which yesterday falls. For example, if today is November 1, the calculation date is October 31st and the transaction range is the month of October. You can select a Custom range if required. See below for instructions.

   • Selection: By default, any Active, valid, non-parent rebates in the project are included in the calculation. You can’t change this.

   • After calculation: Select Update Phocas Database(s) to trigger a database build after the scheduled calculation runs, then select the database(s) you want to update. These settings keep your Rebates analysis database(s) up to date. This option can only be applied to databases other than the project source databases and databases without a build schedule.

     
   • Timezone: The timezone defaults to your timezone but you can change it to the timezone of colleagues or other end users who need the calculation information. Changing the timezone here only affects the calculation schedule for this particular project. It does not affect your default timezone or anything else in Rebates or Phocas.

4. Click Save.

   

Select a custom transaction range

Rather than base the schedule on the default month of calculation date, specify a custom timeframe for the calculations.

in the Schedule window, select Transaction Range > Custom. Two custom transaction range options are available:

• Fixed date range - Select the Start month and End month in the range. For example, Start: January 2023 and End: March 2023.

• Dynamic date range - Define a dynamic date range such as year-to-date or last month based on today's date, so the data continues to update. You can set both the start and end dates as offsets or just one of them. Select the Offset checkbox and enter the offset date as a number.

  • An offset of 0 months for the start date will start in the current month of the calculation date (which is always yesterday). For example, if today is 7 February 2024, and the calculation runs today, the start would be the start of February 2024.

  • Negative offset numbers go into the past and positive numbers into the future.

  • The message underneath the date range can be very helpful, as it tells you when the schedule will end. For example, in the following image, the schedule will end in April 2024 because in May the start date would be March (two months prior) but as the end date is set to February, it would not be valid.

    

Edit or remove a schedule

You can edit the schedule configuration later via the Schedule button on the project homepage.

To remove a schedule, in the Schedule window, select Frequency > Never.