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.
Back Ground
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.
So the basic need is to allow the points to be wiped after specific time period has passed? The card itself may not expire but the points would? Is that correct?
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?
Yes to both. I have a database with $100K value stored. I would need to convert this over but I can do using SQL the main issue id adding and controlling new prize allocations.
Some Clubs do all of the above and also will wipe at the end off the Accounting Year everything not used including a prize allocated 2 days prior will be wiped.
EDIT: Its 11.49pm so off to get some sleep, excuse me if I do not answer straight away
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.
Hey @gsreddyno I have not gone further with Expiry Dates as back then was waiting for some ideas from kendash. Know much more about Samba now and probably not use Samba Accounting Documents for this.
May need to revisit in the future when I have more time…
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?
Yes not a lot has been done with Dates & Expiry from what I can gather. I have asked about before and I think kendash was heading done the Task Widget path but never started.
is there any advances in this? Id like the VIP Level to be removed 12 months from when an account is opened.
Customers pay for 12 month membership, which uses my VIP tutorial and gives them a VIP Level in custom fields. Id like that field wiped after 12 months.
I cant even begin to think what actions would be needed for this
I can make it so that a membership start date is entered, so can it add an expiry automatically? then maybe a task action that looks for that day and clears custom data?
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.
First Thoughts:
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.
EDIT:
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…