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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by davidstanley01

  1. davidstanley01

    9700sql

    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...
  2. davidstanley01

    Micros 9700 Reporting

    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?
  3. davidstanley01

    Micros 9700 Reporting

    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...

Part and Inventory Search

Back
Top