Offline batch lost

Hi Paul

There used to be a command that you could run to remedy this in older version of RMS, but I didn't think it applied to V2 as I haven't come across the issue yet, but here it is if it helps:

You need to know the number of your current batch before you start as you will be appending all your offline transactions to that one. You will also need to know your last transactionnumber in the offline db and current ZZ batchnumber. You should be able to retrieve these through sql

Select * from register Update [transaction] set batchnumber = ??? where transactionnumber = ???

Update [register] set zzbatchnumber = ??? where zzbatchnumber = ???

Jenny,

Well I am in the exact same situation that after offline processing the batch did not upload when the register came online. Most concerned about the credit cards as I could not settle those at the end of the day. I could not understand the SQL as I am not an SQL expert. Is there a paper or How to info to get the batch out from the offline database?

As an option I thought of tryin to settle the batch in offline mode but was not able to force the register to "offline mode". I use the same network to process the credit cards so waiting for an opportunity to stop the server to force the reigster in offline mode. Is there a soluiton to this problem?

Offline mode operation is a common usage so there should be some write up. Please help.

thanks Raj

"jennydat" wrote:

Hi Raj

If you disconnect your network cable you can go into offline mode

Thanks Jenny,

I got it in the offline mode but facing another problem as it is not recognizing any of the cashiers. During normal operation after I close the batch, it is not able to synchronize the offline database and I get error #

Is there no other way to get the transactions out from this terminal? Where are the transactions stored ? Is there a way to copy a file and upload it to the main as a separate batch? Any help is appreciated.

Called the credit card company and they said you may have to rekey the transactions again!!! Does not sound right to me. There has to be a way to get the offline batch?? Please help.

Thanks Raj

"jennydat" wrote:

Hi Raj

It sounds like you have an issue with your offline database. Going forward I would recommend that you set up a new offline database. If it's not syncing properly after you close a batch then this indicates that it's unable to push the figures from the offline into the online db. You may need someone with SQL knowledge to retrieve the information from the offline if possible. If you go into your configuration tab and test the connection to the local offline db, does it work?

With regards re-keying the CC transactions. This is true (I used to work in CC Auth). If you are unable to retrieve the information from your offline database you would have to do it this way as none of the information has gone through to the CC authorising bank (the downside here is that some transactions may not authorised as there has been quite some time between the actual transaction and the autorisation). If you are able to get the information from the offline to sync with the online - maybe with an SQL person to hand then it should process them automatically without re-keying. Bear in mind that if you manually re-key and THEN manage to get the sales through, your customers will be charge twice.

I hope all this makes sense and I'm sorry I can't help more with the SQL end of things.

Jenny

Hello Jenny,

Thanks a lot for the info. Here is the current situation. Register 2 is still not synching with offline database and POS closes everytime we Z it out. Since the offline is not updated I can not even log in in offline mode as it can not find the cashier. This is where I lost an offline batch with lots of credit card sales.

Register 1 was also not snchronizing the offline database but since last few days started synchronising perfectly fine, just like that without any changes in it.

As for the credit card sales it was easier to get the full details of the transactions from the credit card company and then manually entering each sales with the approval number and then I settled the batch and it went fine. I was told by the cc guys that the authorization can stay in system upto 6 months or even more and can be settled anytime using the the same authorization number. Using the same authorization number avoids the duplicate charge.

If you have some more info, please let me know about the synchronization of the databse.

Thanks again for your help. Raj

"jennydat" wrote:

was restored.

Hi Raj

I'm not sure that there is any more I can suggest I'm afraid. We recently had an issue with sync on a Vista machine, but it was down to user rights as Vista is so heavily locked down. Outside of that I'm afraid I don't know. Sorry.