Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Script Weekly Sales Report 1

Status
Not open for further replies.
ChadPOS

ChadPOS

Technical User
Apr 20, 2009
4
Anybody know how to script a weekly sales report in Alohoa version 6.0.9. I am successfully scripting my daily sales report with the following line:

%IBERDIR%\BIN\RPT.EXE /DATE DATA /XH /LOAD "Default.sls.set"

This works like a champ. When I try to run the weekly report it appears to run fine, but it only shows me one day on the report. I can't figure out how to modify the date string so that it takes a range.

My goal is to run a report on Sunday night that runs the weekly sales report for the current week. Any ideas?
 
Sort by date Sort by votes
Use %1 for the "DATE" and following the report switch add the "DAYS" switch with number of days you wish to report.
%IBERDIR%\BIN\RPT.EXE /DATE %1 /RC /DAYS 7
/LOAD "DEFAULT.SLS.SET"

As best as I remember you want to use a negetive number of days if running from a WINHOOK.

I would think the best report to generate would be the weekly sales report... "CW
 
Upvote 0 Downvote
There are many ways. You can use the Windows AT schedule to fire this off, or add it to winhook and use a command line tool from Radiant called DAYWEEK

A sample of using DAYWEEK in the winnhok.bat:

del /q %IBERDIR%\tmp\*.day
dayweek

if exist %IBERDIR%\tmp\SUN.DAY (
%IBERDIR%\BIN\RPT.EXE /DATE DATA /XH /LOAD "Default.sls.set"
)



Or, if you want to use the windows task scheduler:

at 2:30 /every:SU %IBERDIR%\BIN\RPT.EXE /DATE DATA /XH /LOAD "Default.sls.set"

---
MegabyteCoffee.com
 
Upvote 0 Downvote
Awesome guys. It is working perfectly now. Thanks a ton.
 
Upvote 0 Downvote
Ok, I know this issue is closed, but I thought if someone didn't have the DAYWEEK program, that they could still use something similar in the winhook.bat (Or any batch file) if you wanted to call something only on a specific day.

The example below uses Sunday as the trigger:

Code: 
date /t |find /i "Sun"
if not errorlevel 1 (
     %IBERDIR%\BIN\RPT.EXE /DATE DATA /XH /LOAD "Default.sls.set"
     )

---
MegabyteCoffee.com
 
Upvote 0 Downvote
Nice Mega.
I usually use scheduler(s) for anything Aloha.
I dislike the issues at end of day if the winhook fails for some reason. Would rather keep EOD / Grind issues separate to themselves...
 
Upvote 0 Downvote
Sorry if this is a silly question, but I am new to scipting things in Aloha. What is winhook? So far I have written Windows batch files and used the Windows scheduler to run them.

On a side note there are two other reports I would like to automate. I need an end of month sales report and a biweekly labor report. Do you guys have any ideas?

Thanks again for your help so far.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

RenanUrteaga
  • Locked
  • Question
sales by concepts in Aloha
Replies
0
Views
137
RenanUrteaga
RenanUrteaga
M
  • Locked
  • Question
Why the revenue sales from Simphony not transferred to RNA
Replies
2
Views
463
Mr.Pitt
M
GeminiBoy
  • Locked
  • Question
Simphony CAPS Not Posting Sales to R&A
Replies
10
Views
298
Niko S
Niko S
Joseph.H
  • Locked
  • Question
Simphony 86 List Sim/ISL Script?
Replies
3
Views
373
DatFatMan
DatFatMan
HDK
  • Locked
  • Question
Micros RES 3700- Consolidate Employee Sales Detail Report empty
Replies
0
Views
93
HDK
HDK

Part and Inventory Search

Sponsor

Back
Top