I need to consider how to handle Gift Cards that Expire or Credit applied that will Expire. I have referenced the following links:
Other links exist but they came from me so no need to post. It seems this has not been resolved in V4 or V5 so I would like to get some ideas on how to solve this please.
In some Clubs I deal with they issue a Voucher for prize winning with an expiry date from 30 days, 90 days and sometimes a Year (Financial Year as determined by Accounting Year of Club). Therefore at some process point the Unused Value of the Voucher needs to be wiped when the Expiry Date passes.
I have implemented a Prize Ledger before and the difficult parts are Allocation of Value, Running Balance, Credit Redemption (wipes).
My initial thoughts was to create a new Entity Type - Prize Ledger but this infers individual records with various expiry dates and running balances. Using a Gift Card encapsulates expiry date, value and running balance in one Entity but the Clubs will issue 250+ Vouchers each week creating over time a very large Card Table!
The concepts can be expanded to Loyalty Points just as airlines will vanish your points if you do not travel with them enough.
Can I have other ideas and some techniques on solving this problem, thanks.
Ok so your saying a customer may win 1.00 on the 9th and then on the 11th win 2.00 if not used points expire after 30 days… so 30 days from the 9th 1.oo drops off but the 2.00 still there. Then 30 days from the 11th the 2.00 drop off ending with zero balance?
No problems @kendash - I am working through lots of other stuff so we have time. If we are successful this may resolve 1 (or all) of the multiple accounts for a customer.
My initial thoughts are that the Automation and SQL required to implement this will teach me heaps about SambaPOS. Also I think GiftCards are just another Entity Type (I think) so if we can work out some automation to attach a Gift Card Account to a Customer automatically - this can be applied to my other account requirements….
The use of Member No. will be a “custom field” applied across all Entity Types i.e. Gift Cards, House Levy…
Idea is to pick an Entity and through automation any Entity Types with the same Member No. are retrieved to the “Payments Screen” - (I guess you guys call this attached to a ticket?). An original thought by our Mr @QMcKay back in November '14.
Just not sure about how the accounting (Accounts) will turn out
PS: Gift Cards can be recharged right?
Well we have a couple new things we can work with. Task types are awesome and may be useful. Of course the API and scripting is an option as well. Or perhaps even a combination of it all.
Emre asked us to really start focusing on task types he saw tremendous potential and I can say after messing with them I’m on board. We can pretty much create our own database table structure with them to store and retrieve anything we want.
How about this? Ive just been asked if there is a way to have a membership Expiry… so, customer pays for 1 years membership which gives them VIP discounts, and after 12 months it expires? maybe gives a pop up telling of the expiry?
None from me as yet but you requirements are much more simple than mine.
You need to dig up as much DATE handling techniques as possible and then apply these to a Custom Field on Entity. One you can Test Expiry of a date the rest is sitting back and designing the process.
Trigger each day to test Expiry.
Report on Entity to test Expiry and Filter by.
A Screen Widget filtering Customer by Expiry with Actions to remove VIP Status.
A Script to select all Customers that have Expired VIP Status to an ARRAY and process each line to remove VIP Status.
A Trigger to run a Script would be the easiest and most compact: 1 script and 1 trigger. The hard bit is the JSON stuff with the Expiry Date as a Custom Field.
My needs are a bit complicated: I need an Expiry on Credits paid on Customer Account so each Credit Payment may have a difference Expiry Date I guess it would be Many Gift Cards attached to a Customer
Not really, I wish. You have 1 Entity with 1 Custom Field.
I have 1 Entity, no custom field BUT lots of Account Payments with some sort of Note containing a Expiry Date OR as above many Gift Cards attached to 1 Entity.
I guess if I could work out how to attached many Gift Cards and that would be practical I could look into it. Unfortunately looking at 1 Entity they would have 1,000 Gift Card Entries alone. AND we cannot remove entities or accounts histories…