SBX - Search With Button

SBX - Forum Post Title

Reset Batch Number

Microsoft Dynamics RMS Forum

Pappu asked a question on 8 May 2018 11:46 AM
My Badges

Question Status


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.

Pappu responded on 9 May 2018 8:25 AM
My Badges

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.

Pappu responded on 10 May 2018 4:27 PM
My Badges

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


SBX - Two Col Forum

SBX - Migrated JS