Is there a way to have the system remind you that a certain layway is about to expire? Thanks.
- posted
15 years ago
Layaway expiration reminder
Loading thread data ...
- Vote on answer
- posted
15 years ago
You can run a report in SO Manager, the layaway report that shows you the expiry date. You can run this by date to get the information you need regularly.
- Vote on answer
- posted
15 years ago
- Vote on answer
- posted
15 years ago
Hi, You can make some scheduled task script and check with osql/sqlcmd result of the following statement to see the current day expirations: select ID from dbo.[Order] where Type=5 and ExpirationOrDueDate between getdate()-1 and getdate()
Koit Lahesoo