1. Home
  2. Point-Of-Sale Software
  3. Possible to have RMS send automated emails?

Possible to have RMS send automated emails?

Question I have been unable to get answered on the POS system (running a single store with no HQ module). Is there an add-on or programming possibility in the SQL database to have POS send an automated email? For example to send the store owner a nightly copy of the Z-report? Or if inventory for specific items gets too low to send the owner an email with details so he/she might take re-order actions, etc? Any suggestions would be appreciated.

Reply to
Bob Thrasher
Loading thread data ...

email alerts are not a part of the RMS package, and I don't know of any add-ons that allow it. You might want to check out SQL Server notification services and reporting services - I believe they are available as part of the SQL 2005 Express Advanced download.

Glenn Adams Tiber Creek C> Question I have been unable to get answered on the POS system (running a

Reply to
Glenn Adams [MVP - Retail Mgmt]

Reply to
JAY (MANOJ) SHA

You can combine a few tools to achieve this functionality. I do this very thing to send myself text messages with total sales at the end of every day. Here is how I do it:

  1. Create a .bat file with the following commands (2 separate lines): osql -ddatabasename -Uusername -Ppassword -n -h-1 < daily_sales.sql >

daily_sales.txt clemail -quiet -to snipped-for-privacy@email.com -from snipped-for-privacy@email.com -smtpserver ispServerName -subjectfile daily_sales.txt -body "daily sales"

clemail is Comman Line Emailer and can be found at

formatting link
I recall seeing anothersimilar tool that is freeware but I don't remember the name and Ialready paid for clemail a long time ago. osql is a utility for running sql queries at the command line. Check out:
formatting link

  1. Create a sql command file (referenced as daily_sales.sql above). I use the following statement: SELECT CONVERT(CHAR(19),GETDATE()), DailySales.Total FROM yourdatabasename.dbo.DailySales DailySales WHERE DailySales.Type=6 AND DailySales.Date>=getdate()-1 ORDER BY DailySales.Date

  1. Set up a job to run > Question I have been unable to get answered on the POS system (running a

Reply to
lancemuz

We use SQL reporting services to produce scheduled reports. Its a fairly elegant solution, but requires full SQL 2000 license rather than MSDE on one of your servers. We also use SRS to report from our ecommerce platforms and marketing data so our clients only see one report format.

I believe the free version of SQL 2005 has this functionality FOC but we are not using 05 with RMS yet.

Reply to
Neil McQuillan

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.