Reset Batch Number

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hello Everyone,

I would like to reset the EDC starting batch number (e.g. 300). How would I do it in Dynamics RMS. I am running RMS 2.0 with CU5 on Windows 10 Pro. Please response at your earliest convenience.

Thanks in advance.

*This post is locked for comments

All responses (2)

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

RE: Reset Batch Number

Hello Everyone,

I searched the forum little bit more and found some queries related to the issue.

Jeff@checkpointsoftware suggested following from one of his thread:

Batch numbers will repeat as its only a 3 digit number.

You need to call the processor and work out what the next number can be and then change the VisaNetAuthorization.VisaNetBatchID and VisaNetBatch.RequestBatchNumber on an open transaction(s).

But how can I write a query to perform the task right way?

Which Table need to be updated First? I pressume VisaNetAuthorization Does the following syntax work?

Update VisaNetAuthorization set VisaNetBatchID = # where Status = OPEN {1??} [where # is set the next batch number]

and then,

Update VisaNetBatch set RequestBatchNumber = # where Status = OPEN {1??} [where # is set the next batch number]

Still struggling.

Thanks for any help
Community Member Microsoft Employee on at

Like (0)

Report

RE: Reset Batch Number

I think I need to provide little more detail. I am receiving the above error when try to settle ECD batches. I talked to my processor but he says they can't edit the their batch number so I have to edit the batch numbers. Is there any way to settle this transactions by changing the batch numbers in RMS? These transactions worth ~$2000.

Also, in order to avoid any future conflict, I would like to reset the EDC starting batch number.

Please help.