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!

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

Aloha Fiscal Settings, export & upload automatically?

Status
Not open for further replies.

mmartinezcec

IS-IT--Management
Apr 5, 2013
2
MX
Hello,

I am new to Aloha Software and I noticed that right now we have to export the fiscal ticket report manually every morning and then upload it to a server. Is there any way to do this process automatically?
 
in the text below I have outlined how to create reports automaticlly. to send them I use a program called Blat along with Stunnel
Check out this website to setup stunnel and blat



In this command, X is for export and C is for sales report. P is product mix and PW for product mix weekly and Y for the payment detail report. Try this.

Sales Report %IBERDIR%\BIN\RPT.EXE /DATE %1 /XC /LOAD "dsr.sls.set”

%IBERDIR%\BIN\RPT.EXE /DATE %1 /XP /LOAD "default.pmx.set"
%IBERDIR%\BIN\RPT.EXE /DATE %1 /XP /LOAD "default.wpm.set"

%IBERDIR%\BIN\RPT.EXE /DATE %1 /XPW /LOAD "bar.wpm.set" Not sure how to format the date for a weekly report.

%IBERDIR%\BIN\RPT.EXE /DATE %1 /XY /LOAD "Default.pay.set"
Void Report %IBERDIR%\BIN\RPT.EXE /DATE %1 /Xv /LOAD Default.voi.csv

AD=Daily Cashout Summary

B=Employee Break Report

C=Sales Report

CW=Weekly Sales Report

D=ADP Payroll Export File

DD=Delivery Driver Report

DP=Delivery Production Report

E=Entertainer Income Report

F=ReMacs Menu Item Sales Export File

G=Gift Certificate Tracking Report

H=Hourly Sales and Labor Report

HW=Weekly Hourly Sales and Labor Report

I=Menu Item Forecast Report

J=Tip Income Report

K=Comparative Server Sales Report

L=Scheduled Vs Actual Labor Report. You cannot fully automate this report from a command line.

M=Edited Punches Report

N=Surcharge Report

O=Overtime Warning Report

OD=Open Drawer Report

P=Product Mix Report

PQ=Weekly Quick Count Report

PW=Weekly Product Mix Report

Q=Employee Performance Measures Report

R=RealWorld Payroll Export File

S=Landry's Sales Report

T=Top Item Movement Report

TS=Team Service Tip Split Report

U=Edit Deposits Report

V=Void Report

W=Server Sales Report (There is not a way to select the employees to list in this report from a command line, so printing this report from a command line produces a blank report.)

Y=Payment Detail Report

Z=Sales By Revenue Center Report

1=Coconut Code Payroll Export File

11=Overtime Forecast Report

2=Coconut Code Sales Mix Export File

3=Coconut Code Daily Sales Export File

4=Back-of-House User Security

5=Back-of-House Security Levels

6=Detailed Access Levels

7=Front-of-House Cash Owed Report

8=Speed of Service Report

9=Tiered Tax Report

An example

The following command line exports a Sales (Cash) Report for 1/7/2000 in versions 5.2x and higher using the 'default' settings:

%IBERDIR%\BIN\RPT.EXE /DATE 20000107 /XC /LOAD "DEFAULT.SLS.SET"
%IBERDIR%\BIN\RPT.EXE /DATE today /XV /LOAD "Default.voi.csv"
sorry for the late reply, but it was not working on the export side but has been fixed.
 
Hello AlohaRoss,

Thank you for the information! One question, I need to create a batch file in order to run the command line automatically right?

Thanks and regards.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top