Hi guys, I hope that you can help me. I've searched through the forum to find an answer but it seems like no-one's really asked this before.
I'm writing a 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.
- posted 8 years ago