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