web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Season of Giving Solutions is Here!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics RMS (Archived) / Reset Batch Number
Microsoft Dynamics RMS (Archived)

Reset Batch Number

(0) ShareShare
ReportReport
Posted on by Community Member

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

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    245_5F00_246_5F00_EDC_5F00_Batch_5F00_Settlement_5F00_Issue1.jpg

    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.

  • Community Member Profile Picture
    Community Member on at

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Season of Giving Solutions is Here!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics RMS (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans