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

    Micros Res 3700 SIM to start tab with name from a credit card

    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?
  2. Andy16H

    Micros Res 3700 SIM to start tab with name from a credit card

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

    Micros Res 3700 Operations on PC, Printer Help

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

    MyMicros.net incorrect Item Names

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

    MyMicros.net incorrect Item Names

    What Delete Master Items, will it rebuild them?
  6. Andy16H

    MyMicros.net incorrect Item Names

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

    Micros Res 3700 SQL Statement

    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) +...
  8. Andy16H

    Micros Res 3700 SQL Statement

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

    Micros Res 3700 SQL Statement

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

    Micros Res 3700 SQL Statement

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

    Micros Res 3700 SQL Statement

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

    Micros 3700 Multiple Job Choices

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

    Micros 3700 Multiple Job Choices

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

    Happy Hour Pricing Auto Levels Micros 3700

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

    Happy Hour Pricing Auto Levels Micros 3700

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

    Happy Hour Pricing Auto Levels Micros 3700

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

    Connect to a Micros DB file

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

    Micros 3700 Open/Closing Totals Over/Short Report

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

    Micros 3700 Open/Closing Totals Over/Short Report

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

    Print to pdf and .csv

    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.

Part and Inventory Search

Back
Top