in RMS, automated e-mail at the closing with closing amounts

You can come up with a creative solution using some third party software, the DOS command line (batch file) and the Windows Task Scheduler.

First, create a .bat file somewhere on your computer (I recommend C:\) with the following line in it (replace "servername", "databasename" and the "username" and "password" as required):

osql -S servername -d databasename -U username -P password -Q "SELECT year(ClosingTime) AS 'Year', month(ClosingTime) AS 'Month', day(ClosingTime) AS 'Day', Sales FROM Batch WHERE (year(ClosingTime)=year(getdate())) AND (month(ClosingTime)=month(getdate())) AND (day(ClosingTime)Úy(getdate())-1) ORDER BY day(ClosingTime)" -o "C:\sales.txt"

Then, use the Windows Task Scheduler to run the .bat file shortly after closing each day. It will create a file called C:\sales.txt with the sales from the day's closed batches.

Now you have to find a way to email it to yourself. There are a host of automated email programs out there. My favorite is to use the command line emailer called Blat. It lets you send an email using the contents of a file as the message body. You should install the program in C:\ and add the following lines to your .bat file (changing the variables as required):

blat -install smtpservername emailaddress blat C:\sales.txt -to to_email_addr -f from_email_addr -subject "Daily Sales Store 104" -u SMTP_username -pw SMTP_password

Username and password are only required if your SMTP server requires authentication.

It's great. Every day at 5:30 I get an email that looks something like this on my blackberry for each location:

Year Month Day Sales

----------- ----------- ----------- ---------------------

(1 rows affected)

Of course, this can be adapted to get any SQL retrievable information from the database. If you have multiple registers, I am sure you will need to add a SUM function the the SQL query, otherwise you will get a seperate batch sales total from each register. Maybe some SQL experts out there can give us the statements for daily, monthly, and yearly store totals in a simple and easy format...

Good luck!