Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics RMS (Archived)

restarting transactionnumber in store operations

Posted on by 145

hello,

i want to know if there's a way to restart the transactions in RMS, in this case the customer have 10 stores and need to restart the transaction counter because the store change the name, they want to go from transactionnumber='1245' to transactionnumber='1', im not sure if its posible so need help

Thanks

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: restarting transactionnumber in store operations

    First you have to delete previous transaction and them set the next transactionnumber on Store Operations Administrator. Make a backup of previous DataBase.

  • Suggested answer
    archelle16 Profile Picture
    archelle16 1,735 on at
    RE: restarting transactionnumber in store operations

    Hi, Transaction numbers in store database is auto incremented so it is impossible to set back at 1 or less. But you can still set transaction numbers (using above procedure) greater than the current maximum transaction number. In your case, you can choose numbers > 1245.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: restarting transactionnumber in store operations

    If you are synching to headquarters, this might cause information to be overwritten/updated in HQ unless store id is changed.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: restarting transactionnumber in store operations

    Start Store Operations Administrator. On the File menu, click Connect, type the SQL Server password in the Password box, select the Store Operations database that you want to set the next transaction number for in the Database list, and then click OK. Click Database, and then click Set Next Transaction Number.

    Click Yes. Type in the value and then click OK. Click Yes, and then click OK.

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

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans