I just started a programming job for a franchise company that owns several different concepts. One store uses old Micros 2700 as their POS and they have no backend reporting software as of now...that is where I come in. I was asked to write a program like Menu-Link (on a much smaller scale, this is a small location) but I have never touched a Micros POS terminal before. So my question is if anyone has attempted this before and if so how they did it. My biggest concern is exporting the data held in the POS to a computer in the office running my program, and how that is to be done...if it can be done. If anyone has any suggestions or can point me in a direction with answers I would be grateful.
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!
Interfacing with Mircos 2700 HMS in C#
- Thread starter mtgoebel
- Start date
colttaylor
Programmer
Micros 2700's use a serial port based interface for talking to the outside world. Normally this is done so that the POS can bill sales to an account receivables system or a property/hotel management system. They call this interface the PMS interface and documentation for it can be gotten from Micros or maybe found on the web.
This interface is not very useful for reporting because it summarizes the entire sellable inventory into four sales categories. That means that even though I bought three beers and a sandwich and you had some scotch and a salad, the reportng software only gets told about our buying drinks and lunch. Not enough detail for any usable reporting.
There may be another way to get data out of a 2700, but if so, I don't know about it.
Good Luck!
Peace,
Colt
If it's stupid but it works, it isn't stupid
This interface is not very useful for reporting because it summarizes the entire sellable inventory into four sales categories. That means that even though I bought three beers and a sandwich and you had some scotch and a salad, the reportng software only gets told about our buying drinks and lunch. Not enough detail for any usable reporting.
There may be another way to get data out of a 2700, but if so, I don't know about it.
Good Luck!
Peace,
Colt
If it's stupid but it works, it isn't stupid
microsdude
Programmer
2700 doesn't offer much when it comes to extacting data. There is a back office modules RM2700 and PM2700 that requires a PCISN ISA board that polls the terminal for data.
The good news is that the data is ultimately stored on that back office server. The bad news is to my knowledge these is not a utility to extract data.
The client should consider upgrading to 2800. In simplisitc terms it is 2700 terminals tied into 3700 back office sytsem. The 3700 back office is ODBC compliant SQL Anywhere.
The back office includes many reports and you can customize reports using crystal.
Good luck
The good news is that the data is ultimately stored on that back office server. The bad news is to my knowledge these is not a utility to extract data.
The client should consider upgrading to 2800. In simplisitc terms it is 2700 terminals tied into 3700 back office sytsem. The 3700 back office is ODBC compliant SQL Anywhere.
The back office includes many reports and you can customize reports using crystal.
Good luck
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question