I can remote into each of the terminals and they all have the correct pms2.isl file on them. I've even reconfigured the CAL. What else could I look at to solve this problem?
I've had a SIM installed on our Micros system for 10+ years. This SIM quit working on 3 of the 4 terminals.
1. Login to terminal
2. Click Begin By CC, this brings up another screen that is created by the SIM.
3. Swipe Card and it Starts a Tab with the Name on the Credit Card.
This works on...
I have 4 terminals for Micros Res 3700 version 5.2. I've been doing some work remotely and using the Run Operations on PC feature. When I'm using the Run Operations on PC, how can I get reports to print to a .pdf printer installed on the server? I went to add a printer in Micros and I didn't...
We have reused some item numbers over the years and the old item names show up in MyMicros.net. I could go through and manually correct them, but I really don't want to. How can I update all of the item names in MyMicros.net?
I think i figured it out with a left join. I also summed some columns. Is this correct? Is the summed information already summed in another column?
Select
(ISNull(SD.sls_itmzr_01,0) +
ISNull(SD.sls_itmzr_02,0) +
ISNull(SD.sls_itmzr_03,0) +
ISNull(SD.sls_itmzr_04,0) +...
The only column in the dsvc_dtl table that looked like it would help me was the percentage column, which i'm assuming is the percentage discount. Below is the query where i added the new table you told me about. My current problem with this query does not return transactions that were not...
One more question, I can't find item level discounts. Any idea where that hides?
I've found item_dsc_ttl which is all zeros same for sttl_dsc_ttl
I've also found a column for pending_discount_ttl which is also all zeros. I ran the query and omitted the Where statment and I only found 1 item...
I'm learning SQL as a because it is almost impossible to get service from Oracle. I've written the following query which runs but it creates duplicates. The 4th Inner Join seems to be the one that makes the duplicates show up. I'm pretty sure there is a much better way to write this query...
We promoted a employee from Bar Back to Bartender. I added the new job choice and marked as Primary. Micros will not let me delete the old job. I even went in and gave the old job an effective date of 12/31/2099 and selected the box to Omit from SRG.
I do not want the employee to have the...
Thank you.
I've got it setup and working.
1 Regular
2 Monday Special
3 Tuesday Special
4 Wednesday Special
5 Thursday Special
6 Friday Special
On the changing Menu Levels, I think I kind of understand this but to clarify.
1. You could activate Main Menu Level 2 and use a price from Sub Level...
Thank you for your response.
I went and copied the sub level 1 price down to sub level 2-10 on every menu item. I then went back and adjusted the sub pricing to fit my specials.
Daquiri's have $4 on Price level 2 and $6 on Price levels 1,3-10. There are 2 Daquiris that also have different...
We have a different Happy Hour every day. I've created a period for each day, my menu items are in the following Classes:
Beer
Cocktails
Daiquiris
Food
The default menu level and sub level are both 1.
Example of happy hour
Monday $2 Domestic Beer and $4 Daiquiris
Tuesday $4 Wells and 2 for 1...
I have several backups of my Micros 3700 DB file. I'm trying to access the backup file from my laptop. I'm not having any luck. On the Micros PC at the restaurant I use interactive SQL. I've looked and the Micros PC had SQLLite of course driver installed on it. I've installed SQLLite and...
I appreciate your response, but since my Micros Dealer was taken over by Corporate. It is next to impossible to get anything done. I was hoping to find some detailed instructions or someone that is interested in Freelance work.
I have contacted Micros about this and they tell me 4 to 6 weeks and would like me to use Cash Management. We are a small bar and in past have kept our Business Cash Deposits and Over/Short calculations on separate report in Excel. I would like to consolidate all of this into Micros and I've...
Is there any way to change
SELECT * FROM micros.dly_sys_trk_ttl;
So the column headings come over as well?? I've googled this and tried several different scenarios but can't get one to work.
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.