Sage 100

I have a customer using Sage 100 2018.x Premium - they want to generate an alert when an order is taken at a trade show (off-site). I'm being asked about Alerts but wonder if Visual Cut can do as good a job for 1/10th the licensing price? The main question that I believe will be asked is if Visual Cut can monitor in near real-time (ever 1-2 hours) for database changes and then send an email with new order information? Has anyone setup Visual Cut for that type of use case and if so has the customer been happy? TIA

@KevinMoyes ?

There is no snapshot feature but watch the VC webinar near the end where I quickly showed a batch file for how we use VI to update flags to do something like this. (Requires a free Sage 100 license for the VI jobs to work). VC - create a list of new orders (with your filter for offsite orders). VI - import a UDF flag (to being printed) based on the order list created above VC - run your report / alert (looking for the UDF flag set in step 2). VI - import the UDF flag (to already printed) based on the same order list created in step 1 With Premium you can use SQL in stead of VI to update the flags, but beware that if you try to update an SO which is open in SO Entry that the script will wait until the locked SO is available. Do all three steps in the same batch file to avoid problems with a paused script from being triggered multiple times by Task Scheduler. SQL - script to update the UDF based on your logic (using something like SQLCMD). VC - run the alert based on the flag. SQL - script to update the UDF (to prevent duplicate alerts for those orders) You can also try a time based report (new orders in the past XX time) but the flag method is more reliable for us.

The links in SC Helpful Links too https://www.dropbox.com/s/rurv82aoz8tnc3e/90%20Minds%20Visual%20CUT%20Webinar.mp4?dl=0

The batch file I mention is explained at around the 42 minute mark in the video.