I'm writing a VB.NET application that will be run on each till running RMS. What I'm trying to do is to be able to run an SQL query that returns the last total to be rung through the till that it's run on. I don't mind manually putting the till number into the SQL query and so far I've been able to return results from the RMS database, just not the ones I need.
My problem is that I'm struggling to understand how RMS works. We obviously have the tills in the shop and they are connected to our server across the network which is running RMS HQ. If I look at the TransactionEntry table, or Journal table on the server, I can see a good history of transactions and that would be perfect to get my data from, but it doesnt seem to be live, there's a lag. So I thought maybe it was just stored on a local database on the till and then polled up to ther server occasionally.
I looked on the tills local sql database, can find all the tables, but they're all empty with no data; so at that point I have a transaction that's been completed that looks like it's disappeared into thin air until later when it appears on the server...But it can be seen by using the RMS Store Ops Manager software, so it must be stored somewhere! Any help anyone can offer would be greatly appreciated! Apologies for the length. Matt