Search results for query: *

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

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 :)

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

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

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

Here's the situation: Micros client machine was setup and functioning properly. No Micros settings were changed on the server or the client in question. An end user unwittingly infected the client with a series of trojans, unbeknownst to the installed AV software. Several icons vanished mid...

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

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

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

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

The solution to this problem is likely related to my other question about RVC/printers, but here goes: The establishment has two RVC's. The system was originally setup with one RVC, but another has been added. There are two workstations on the original, and one UWS on the new RVC. The RVC...

Depending on your understanding of relational databases, and what you need for your 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...

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)

The establishment presently has three UWS terminals, each with their own local printer. There is also a server unit in the building and a remote printer on an IDN line from one of the UWSs. Two of the UWSs are setup to be part of one RVC. They both print guest cheques/receipts to their local...

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

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

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

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

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

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