RMS Transaction

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 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
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload

Hi Matt
I think you need to read up on how RMS fundamentally operates.
The best place to be retrieving your totals is from the Store Ops database and probably from the batch table or transaction table. There will always be a lag in data appearing in HQ as the information is transmitted via scheduled worksheets and not in real-time.
Rod
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
Thanks for your reply Rod. I'd happily do some reading on how RMS fundamentally operates, but I can't really find anything anywhere. Hence why I've resorted to posting on the forum.
So is the Store Ops database updated live then? And is that stored locally on the till or on the server? I can see a database on the local till and we've got what looks to be a Store Ops database on the server. But when I look in these, I still can't find my latest transactions immediately.
Thanks for your help, I really appreciate it. Any small pieces of information help me work it out and get a step closer to sorting it all out!
Matt
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
responding to http://www.beansmart.com/point-of-sale/RMS-Transaction-44216-.htm kursatozer wrote: Hey Matt,
first of all the if from the 'local' database you mean the 'offline' stored on each register (till?), then it will not help you at all. The 'offline' database is connected whenever the main database cannot be connected and transaction on it will be stored until the main database is back online.
Second, RMS keeps all values on POS (scanned line items, totals, discounts, tax etc) on certain pre-defined values until transaction is complete and sent to database server. search for "customization" on MJicrosoft dynamics customer portal. I guess you need to get familiar with "QSRules", "QSBridge" etc.
Please let me know if you are able to download it from MS web site or else I can download it and email it to you.
Good luck with your work.
------------------------------------- K.O.
Working with RMS since 2004, mostly loving it...
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload

BeanSmart.com is a site by and for consumers of financial services and advice. We are not affiliated with any of the banks, financial services or software manufacturers discussed here. All logos and trade names are the property of their respective owners.

Tax and financial advice you come across on this site is freely given by your peers and professionals on their own time and out of the kindness of their hearts. We can guarantee neither accuracy of such advice nor its applicability for your situation. Simply put, you are fully responsible for the results of using information from this site in real life situations.