Search results for query: *

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

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

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

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

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

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

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

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

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

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

Request sent as well. Thanks

Anyone knows the answer? Thanks

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

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

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

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

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

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

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

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