Recent content by Andy16H

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

How do I know if I'm locally hosted? I think I'm Oracle.

What Delete Master Items, will it rebuild them?

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

Thank you so much for correcting my problem but most importantly giving me a very quick crash course.

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

Hopefully that is not the only way as we do not use the scheduler built in Micros. Any other suggestions?

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