2 | Multi-Venue - Limiting a Prize Setup 1 per Account

Learn how to provides a workaround for Multi-Venue organisations where the client wants to only be able to issue 1 x Prize setup per account. An example is a Birthday Reward once a year.

This article provides a workaround for Multi-Venue organisations where the client wants to only be able to issue 1 x Prize setup per account.

An example is a Birthday Reward once a year.

Problem

• Prize promos within a multi-venue setup do not limit 1 x prize promo per account for all Venues
• The current design is that the Prize will trigger once per Venue per Account

Solution

• Set up a custom or Bepoz report with the Account activity or AccPromo activity
• Create a Custom Account Flag to be enabled and disabled
• Setup a scheduled job called: Acc Flag from Report
• Account Profile to exclude or include with said Custom Account Flag

• Example of a Custom Report for Birthday Month to prevent multiple rewards if the customer attends multiple venues within the same month
• The below select script creates a report from AccPromo Table and only selects the PrizePromoID linked to the Birthday Reward, it then finds the month from a column called DateLastDate (Last Used Date) and then Get the current Month from the System
• This then generates a list of all Birthday Prizes awarded within the current month
  

SELECT * FROM AccPromo WHERE PrizepromoID= 1 and MONTH(DateLastday) = MONTH(GetDate())

• The second step: Create a Custom Account Flag. (Boolean) which the Schedule Job will flag on and off

• The third step: Create a Schedule job called: Acc Flag From Report

• Specify the Bepoz or Custom report
• Specify the Custom Account Flag that needs to be triggered
• Specify the interval time you want the Scheduled Job to be executed

• The Last Step: Specify the Custom Flag within the Account Profile, in the above example we want to exclude any Members from being rewarded more than once in their Birthday Month
• Set the Custom Flag to Is False
• Any Account that has the Bday Prize Given set to true, will not populate in the Account Profile and will be unable to be rewarded a second time

• NOTE: Once the calendar month changes for example from February to March all accounts that are flagged will be unflagged and next year will be able to be rewarded again