While there is no existing report, you can easily create a custom report to see how many punches are being left unused after your expiration date.
- In the Data Entry main window click Reporting and then select General Reports to open the Reporting window.
- Click the Custom Reports tab.
- Click the Add SQL button.
- Enter a title and the following SQL query:
SELECT
postdate AS EXPIRED_ON,
concat(lastname, ', ', firstname) AS CUSTOMER,
delta AS PUNCHES
FROM
punches
JOIN customers ON punches.customer_id = customers.customer_id
WHERE
notes LIKE 'Exp. punches on%' and
POSTDATE between '{STARTDATE}' and '{ENDDATE}'
ORDER BY
postdate;
5. Note that the date range you select will be the dates that the punches were sold.
6. Click OK to save.
Comments
Please sign in to leave a comment.