Anyone experienced at using 9700sql utility? I'm trying to get a the tracking group totals by cashier from the system via the cashier totals file and am having some issues.
I'm using the following in my script:
OUTPUT_TO d:\csh.out
MAX_FIELDS_PER_LINE 4
MAX_LINE_LENGTH 64
PAD_NUMBERS OFF...
UPDATE:
Ok. So I've found the major item sales and tender types by rvc and can tie that to the system financial report. I still can't find a way to put together the employee/cashier sales reports. Any ideas?
Hi,
I'm trying to recreate the system financial summary report using SQL on a Micros 9700 v3.x system. The back-end is on MSSQL 2005. The specific data fields I'm looking for are the major group totals. Within the location_activity_db schema I've found the employee daily totals for netsales...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.