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

Search results for query: *

  1. FreeSoldier

    Micros SQL Queries

    Hi All, I have an SQL queries that will list all the employees with their job(s) and pay rate. select e.obj_num as "Payroll ID", e.long_first_name as "First Name" , e.long_last_name as "Last Name" , j.name as "Job Name" , COALESCE(h.override_reg_pay_rate, j.deflt_reg_pay_rate) as 'Pay...
  2. FreeSoldier

    Server 2012 R2 VPN Encryption

    Hi, Our 2012 R2 Windows Server is setup to accept VPN connection via the "Routing and Remote Access" Tool. We currently only accept L2TP and IKEv2 VPN Connections with a Preshared Key Setting. Since our business accepted credit cards, we are required to run a PCI scan via trustwave.com...
  3. FreeSoldier

    Micros DB Access via Excel 365 / Windows 10 Pro

    Regis M., Apologies for the late answer but downloading the sql Anywhere 17 drivers and setting up the connection did the trick. Many Thanks. FreeSoldier
  4. FreeSoldier

    Micros DB Access via Excel 365 / Windows 10 Pro

    Thanks again Regis. It looks like Micros installation does not add any of the 64 bits drivers. When I tried to follow you suggestion I could not find the "SQL Anywhere 16" drivers under ODBC (64 bits) they are only listed under ODBC (32 bits). Any idea where I can download the "SQL Anywhere 16"...
  5. FreeSoldier

    Micros DB Access via Excel 365 / Windows 10 Pro

    Good Morning Folks, Any Excel 64-bits/Micros DB expert in house that could assist? Thanks in advance. FreeSoldier
  6. FreeSoldier

    Micros DB Access via Excel 365 / Windows 10 Pro

    Thanks for the suggestion Regis. Under Windows 10 Pro, when I go to the Control Panel -> Administrative Tools and i look under both "ODBC Data Sources (32-bit)" and "ODBC Data Sources (64-bit)", the Micros DB is listed under both modules under the "System DSN" tab with Name=Micros...
  7. FreeSoldier

    Micros DB Access via Excel 365 / Windows 10 Pro

    Update: So it turns out the Office 365 version I installed was the 64 bits one. My Office 2010 is the 32 bits one. So I installed Office 365 32 bits version and now I can see the Micros* DB in Excel from the Data Tab, Get Data -> From Other Sources -> From Microsoft Query. Does anyone...
  8. FreeSoldier

    Micros DB Access via Excel 365 / Windows 10 Pro

    Hi all, We are in the process of migrating our back office PCs to Windows 10 Pro/Office 365. We are currently running under Windows 7 Pro/Office 2010. We also recently upgraded our Micros 3700 to version 5.6 MR1. I ran WIN Cal on one of the new Windows 10 Pro PC and successfully installed...
  9. FreeSoldier

    Micros / Shift4 EMV Solution

    Hi All, We are currently looking at upgrading our current Micros 3700 installation to an EMV solution. Our current Micros Rep has recommended Shift4. Anyone is using them ? Any pros/cons ? Any other provider that we should consider for EMV? Any feedback will be much appreciated. Cheers...
  10. FreeSoldier

    micros 3700 5.5 error

    Hi maxp, Make sure your computer name and the name in the Pos Configurator/Network Node matches (same character capitalization). If they don't, the the license will not work. Best FreeSoldier
  11. FreeSoldier

    Decrypting micros ISL Files...

    Request sent as well. Thanks
  12. FreeSoldier

    Micros RES 3700 - Is the "Time Fire" Function accessible via SIM/ISL ?

    Hi all, Anyone knows if the "Time Fire" Function:Transaction in Micros RES 3700 can be accessed inside a SIM/ISL. If it is, would you happen to known what is the corresponding key_pair for the Key() Function that can be used inside a SIM/ISL to access it ? Many Thanks FreeSoldier
  13. FreeSoldier

    Micros 3700 - Item Sales SQL Query

    Bufftrek, The best solution is to create menu items called Rocks, Double etc that have required condiments. So when you click on Double it will prompt you for a spirit selection. Note that the required condiments have to be different for Rocks and Double unless your pouring size is the same...
  14. FreeSoldier

    Automatic Calculation of Banquet Fees

    Thanks Wildbar. Because of Labor Law and IRS Regulation regarding tips and service charges, Banquet Fees can not be posted as service charge since the same account is used to post all the tips. The banquet fee has to be a line item by itself on the check and can not be combine with anything...
  15. FreeSoldier

    Automatic Calculation of Banquet Fees

    Hi, POS system is Micros Res 3700. I was wondering if anyone has in their SIM library some code that will automatically calculated a "Banquet Fee" that is either 3% or 5% of Total Sales on a check. The banquet Fee is the commission paid to our private event department for private event...
  16. FreeSoldier

    Connect MYMicros through SQL or other database server.

    There is an Excel plug-in called iquery that you can download from mymicros.net. It allows you to do quite a few query via a GUI and acccess multiple data set. But it it is not a full fledge access to the raw data. Good luck
  17. FreeSoldier

    Held Menu Items that will be automatically be released after an elapsed time.

    Turns out there a function in Micros Res 3700 called "Timed Fire" that solves my request. Cheers FreeSoldier
  18. FreeSoldier

    Held Menu Items that will be automatically be released after an elapsed time.

    Hi all, The POS system is Micros 3700. The concept is a "tapaz" like concept with a lot of cold and hot small plates. Currently the server takes the complete order for the guest. Enters the complete order in Micros and put the hot small plates on hold. Once the cold small plates hit the table...
  19. FreeSoldier

    Voice mail for external line that rings on 2 sets

    Many Thanks curlycord. Your suggestion did the trick. Cheers FreeSoldier

Part and Inventory Search

Back
Top