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

    Micros 3700 RES 4.6 CAL 'Installer'

    I finally got a working Windows XP machine (no thanks to procrastination) and I've got it ready to go. I have been unable to find McrsCalClient on the server, or on the decommissioned workstation. There are other CAL related applications. These applications work on the existing machines, but...
  2. Bennett000

    Micros 3700 RES 4.6 CAL 'Installer'

    Thanks DrZogg, you're a wealth of information as always. The new PC is a quad core job, stacked with RAM, so I'm going to virtualize XP, I saw a thread on here about that very subject, and I think you may have answered a bunch of questions there too :)
  3. Bennett000

    Micros 3700 RES 4.6 CAL 'Installer'

    I'm working on a micros installation with four machines. Three workstations, and a server. Two of the workstations are proper WS4 machines. One of the workstations runs off of a PC. Back in June the disk drive in the PC went down, and I replaced the drive. Now the entire machine is just...
  4. Bennett000

    Micros 3700 / RES 4.x Printer Hangs, Windows Service Issue?

    Thanks DrZogg, I'll check it out! I've also recently found out that the printer was behaving strangely before the crash, so I'm going to test it on another terminal, see if it's still in working order...
  5. Bennett000

    Micros 3700 / RES 4.x Printer Hangs, Windows Service Issue?

    Oh and I should also mention that the system prints fine to remote printers, just not its local Epson.
  6. Bennett000

    Micros 3700 / RES 4.x Printer Hangs, Windows Service Issue?

    ...put in a new disk and started installing windows. After installing windows I installed CAL, and a MDSHosts file from the server, and everything *seems* to be fine. However when I try and print locally to COM1, Micros says: "Please Wait... Printing" and just sits there. OPs is still active...
  7. Bennett000

    Micros 3700 RES 4.x Autosequence/Reports

    Nice query! I just got my results. I'll be comparing them against reports once I can get back in the office. The total for the new RVC from the query I just ran was $834.52. I also looked at the tender options. They look okay, but I think you're probably onto something with the 'incorrect...
  8. Bennett000

    Micros 3700 RES 4.x Autosequence/Reports

    Alright, here's a bunch more information about the setup. The problem is that the Total Revenue at the top does not match the Cash Due at the bottom. The Original RVC had and still has credit/debit/cash which report their totals as expected. The new RVC is cash only at the moment. I don't...
  9. Bennett000

    Micros 3700 RES 4.7 Printer/RVC Question

    *SOLVED* POS Conigurator -> System -> Order Types -> Order Devices Then I selected the printers I needed for the order type. I noticed none of the other types had printers selected yet they work. I'm sure there's another setting buried somewhere that is responsible for this.
  10. Bennett000

    Micros 3700 ACcess Logs

    I don't know the official answer to your question, but I do know that many of the tables in the micros database have columns labeled 'last_updated_by' which may or may not be filled in. When they are filled in, their number may line up to an emp_seq, which is the primary key of the...
  11. Bennett000

    Micros 3700 RES 4.x Autosequence/Reports

    ...sold for the day, and what type of tender it was. The autosequence has three steps: 1. close any open bills the employee has 2. run the report *EMPLOYEE 3. clock out the employee The problem seems to be in these *EMPLOYEE reports. In the original RVC, the totals appear to be accurate...
  12. Bennett000

    Micros Res 3700 and Excel

    ...accounting, the micros DB, might not be what you're actually looking for. Azrobert's exactly right (IMO), the data in the micros database can be *difficult* to track down, and what's worse is that it can be *seemingly* contradictory, ie you'll find multiple sets of sales totals for a day...
  13. Bennett000

    Micros 3700 RES 4.7 Printer/RVC Question

    Great suggestions, but the remote device was already selected as an order device, and the local reports are already directed to the local printer (with the exception of the journals)
  14. Bennett000

    Micros 3700 RES 4.7 Printer/RVC Question

    ...UWS, won't print to the remote printer. The menu items are the same, just accessed from different SLUs. While all of the various printer settings *seem* correct, something is obviously misconfigured, I'm just not sure where. I can provide more settings details as needed. Whatever is...
  15. Bennett000

    Micros 3700 RES 4.x Unable To Close Table

    yeah, it totally was, DBISQL is great, it lets me export query results to a variety of file formats. Just being able to access data via SQL makes me happy because it makes things so much easier
  16. Bennett000

    Micros 3700 RES 4.x Unable To Close Table

    Thanks guys, custom/custom worked. The UPDATE statement would not execute, which makes sense since, I doubt the Micros designers want people updating their DB from an external source. The procedure micros.sp_forcechkclose(#####) worked well. The problem was that the first few times I tried...
  17. Bennett000

    Micros 3700 RES 4.x Unable To Close Table

    There is a DBA account setup in the Micros Database manager, however I don't have the password for it, I'm going to ask the owners, and people who set it up. The problem isn't crippling, so it's not that big a deal. If nobody knows the DBA password do you suppose Micros would give it to me...
  18. Bennett000

    Micros 3700 RES 4.x Unable To Close Table

    I think you misunderstood me MikeRose, I had the chk_seq almost immediately, when I said prepared statement, I was really referring to the function: 'sp_forcechkclosed'. The query didn't work because I wasn't permitted to execute an UPDATE command, the SQL was valid. I'll have access to the...
  19. Bennett000

    Micros 3700 RES 4.x Unable To Close Table

    Alright, the meeting isn't letting up anytime soon so I logged in remotely and gave it a go. The prepared statement didn't work, so I tried the SQL, I don't have write permission, rather I don't have UPDATE permission. I'll need to look at the computer later to figure out why. The account I...
  20. Bennett000

    Micros 3700 RES 4.x Unable To Close Table

    thanks!! I'll try that out once I can get access to the Micros server again (meeting going on in that room presently) I've never used DBISQL either which is exciting, since I'd rather deal with SQL than the micros interface. Side Question: I know the chk_dtl table tells me what bills I have...

Part and Inventory Search

Back
Top