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
formatting link
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
Reply to
Matt King
find an answer but it seems like no-one's really asked this before.
last total to be rung through the till that it's run on. I don't mind manua= lly 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.
ly have the tills in the shop and they are connected to our server across t= he 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 liv= e, 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.
ey'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 w= hen it appears on the server...But it can be seen by using the RMS Store Op= s Manager software, so it must be stored somewhere!
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
Reply to
Rod RSG
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
Reply to
Matt King
responding to 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...
Reply to
kursatozer

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.