Batch problem

Here is my story I changed my merchant for try and I setted the batch before I change the setting and I tried as test dollar transation and One dollar debit card and Debit card did'nt go through because my pin pad was not eccript(4 mercury) then I settled the batch again and I put back my old merchant setting and I restarted my Pos. I took all day credit card and debit card and end of the night I think I forgot to restart my Manger and I setteled the batch and It was successful some how My all the credit crad batch was settled through my new merchant(mercury) and My all the debit card transactions are still in the air. I called my old merchant and They told me they can see all transaction but They cant settle the batch manuely. I have to settle the batch through my software. When I called MS support they told me I can not reset the batch again on rms 2.0 and I have all the approvel code.Is there way to get money back from air ? I need help

Gill, I do not think there is an easy way to do this but this is how I would try to do it. Backup your database! Run a SQL trace on the Store Ops Backoffice DB while you run debit transaction under your old merchant account. See what RMS does with those transaction and where it places the data. I would then copy the unprocessed Debit (The Debit transaction that didnt get settled) information from your VisaNetAuthorization into new a new table. Then take the old data minus the Keyed field and VisaNetBatchID fields and insert them back into the VisaNetAuthorization table. You may need to add the current open batch number to the new insterted records. IF this is even possible you should see the transactions in the Settle EDC batch in the Store Ops Manager.

Again, I would higly recommend you backup your database before you try any of the above steps. I am sure someone has had to do something crazy liek this before but if they will talk about it is the question.

Good luck Dane