Is there a way to have the system remind you that a certain layway is about to expire? Thanks.
Layaway expiration reminder
Jul 27, 2008
3 Replies
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.
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
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required