The program is a database for warranties, so what it does is a “Dealer” registers a warranty under their account at – [url removed, login to view]
User – mail@[url removed, login to view]
Pass – user101
When a warranty is registered it has the status of “Lifetime”, every year the warranty is due for a service, so 30 days prior to the 12 month anniversary date it shows that warranty on the “Service Alerts” page when you login…
The customer then has up to 30 days after the 12 month anniversary date.. If we haven’t added a Service Entry on that warranty within the 30 days after the anniversary it needs to change the Status to “5 Years”. If a service entry has been added it keeps the Status as “Lifetime”…
If it changes to “5 Years” it no longer needs to show up in the service alerts every year…. If it stays as “Lifetime” it needs to show up every 12 months still..
The problem is the database is working by making the warranty show up in service alerts 30 days prior, and if a service entry is added it does keep the warranty as lifetime and it stops showing up in the Service Alerts page..
But if nothing is added after 30 days it just says “Service Missed’ and doesn’t change it to “5 Years” and removes itself from the service alerts..
I hope this isn’t confusing, if you want me to explain it again please let me know.