Customer Messages

Not out of the box. Maybe someone will reply with a custom add-on.

Are you tracking the expiration date using one of the custom date fields in the customer record? If you are not using the custom number fields, if one is available, you could use it to track the number of days remaining until the expiration date. A SQL query can be run as a batch file to populate this value; then, you can use the HTML screen on the top part of the POS to display this information when a customer is assigned.

H> I know that you can link a pop-up message to an item that will display on the

You can perform ShowMessage function from html bar once date is passed. I cant remember correct way of doing it but there was something like that in customization guide.

Hi Scott - here's a query that can show days remaining.

SELECT firstname, lastname, getdate() as today, customdate2 as DateExpire, datediff(dd,getdate(),customdate2) as daysremaining FROM customer WHERE datepart(yy,customdate2) > 1899

The query assumes that you are tracking your member expire date in the custom date 2 field - change it as needed. The where clause only pulls records that have an actual date entry there (the default is as you may know a greyed out date referencing 1899).

The batch file can be set to run the following query to do a nightly update of a custom number field (which you would then show on your HTML file) something like....

UPDATE customer SET customnumber1 = datediff(dd,getdate(),customdate2) WHERE datepart(yy,customdate2) > 1899

Remember to doublecheck your fields and to backup your db if you do run the update as a test - h> Yes we have the date in a custom field on the customer table. The html is a