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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics RMS (Archived) / SQL command to resend ...
Microsoft Dynamics RMS (Archived)

SQL command to resend all worksheet for a specific Date and Time Range

(0) ShareShare
ReportReport
Posted on by Community Member

Is there a sql command to resend all worksheets to a store from a specific date range? I have a situation a store has 2 db's one admin is pointing to for sales and the other HQ is updating. This was due to a huge blunder and too many hours at the keyboard. It took me 13 days to realize if forgot to change the HQ client DB to match Admin. Now I need to resend all worksheets from 13 days ago. Is this recommended as a good fix for my current situation?

*This post is locked for comments

I have the same question (0)
  • Trent Bourgois Profile Picture
    Trent Bourgois Microsoft Employee on at

    Hello DW,

    Thank you for your questions.

    Unfortunately, there is no SQL command that can send all worksheets that a store had missed.

    First I would create a back-dated 401 worksheet for that store. Set the effective date / time to the day before this happened.

     

    You would then have to manually re-create all other worksheets that the store had missed.

    Let us know if you have any other questions.

  • Community Member Profile Picture
    Community Member on at

    Thanks for your reply. I fixed HQ client then let it connect to did a manual 401. Then copied all ws outgoing from HQ to SO. Now I noticed duplication in some of the items ws in HQ not in SO.  Having to manually fix items in admin. Would back dating the 410 sheet have saved me this issue? Would I have had to send ws again or did I make it worse?

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February 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