EDC Batches Self Resetting

RMS V 1.3.1006

We have a location whose EDC Settlement Batches are resetting themselves back to 1.

I ran this query: SELECT * FROM VisaNetBatch

to see what information I could get about this. The response came back with all of the VisaNetBatches, from 1-174. However, in the middle of the response, we have a day with completely blank fields, after this day (where it is completely blank), the EDC batch numbers set back to 1, 2, 3, then suddenly, back to the correct sequence.

This has happened twice on this location, each time it has happened, the EDC numbers go back to 1, 2, 3, (one case 4) then back in line.

When I run a query to ask what the next batch number is in sequence, it is stuck on 174. I have placed CCs in this batch and settled. It should move on to batch 175, and it is not.

Should I run a CC and force the trx into EDC batch # 175 then settle and see if it rights itself out?

Any help is greatly appreciated. Thank you, -- Jocelyn snipped-for-privacy@hotmail.com

Jeff1 (right?) thank you for your reply. I do not know how to do a database check and re-index. Is this something easily explained?

Jocelyn,

I guess I'm Jeff1, who is/are the other(s)? ;-)

SO Admin | File | Connect | put in your password | Database | Backup | Database | Check | Database | Re-index

Check the system times on the registers. FYI: it's ok for EDC batch numbers to be reset (though what happens on your client is really wierd), EDC batch numbers can be repeated and would settle successfully after 7 days.

You are the best!!! I think once I had an answer to a question 'you' had, but you said that was actually Jeff2.

I was waiting for your response to this one. Thanks for the help, I'll let you know what unfolds.