Skip to main content

Notifications

Microsoft Dynamics RMS (Archived)

How to resend all customers from Headquarters to Store Operations

Posted on by Microsoft Employee

I have an RMS 2.0 FP2 environment running Headquarters with several stores. All of our customers are setup as Global Customers.

We just opened a new store last week. Prior to the store opening, we had run the usual worksheets, including the 401 worksheet. At first glance, it looked Ok, and we thought that all of the customers from HQ downloaded to the store.

Well, nearly all, it seems.

The manager at this store used to be the manager at another store. She noticed that some of the customers which were in the old store are not showing up in Store Operations at this new store.

We checked and verified that the customers from her old store are in Headquarters.

For some of the customers she identified as missing in the new store, we edited the customer in HQ, adding a space to their name or billing address, just enough of a change so HQ would recognize that the customer information has been "touched". The next time a 401 worksheet is run for the new store, it downloads that customer to the new store's Store Operations system.

This old store had several thousand customers, and we don't want to manually "touch" each customer.

Also, even if we change the customer's name or billing address, the shipping address may not get reloaded in the store.

Is there some way that we could force all customers and their shipping addresses to be redownloaded to the store? I didn't see a worksheet in HQ to force customers from HQ down to the store; that usually happens automatically when the customer in HQ is added or updated (as we saw when we "touched" the customer in HQ).

If we need to run a SQL script against the HQ database, updating the LastUpdated field on the Customer and ShipTo tables, then run a 401 worksheet, that's fine.

However, I don't have the slightest idea how or even if I should update the DBTimeStamp field on those records in HQ. That looks like a hexadecimal value, and I'm assuming it's some sort of offset from a fixed datetime (maybe the number of milliseconds since a baseline datetime), but that's one field that I have never altered.

Any suggestions?

Bill Yater

Blue Horseshoe Solutions, Inc

*This post is locked for comments

  • RMS Goddess Profile Picture
    RMS Goddess 170 on at
    RE: How to resend all customers from Headquarters to Store Operations

    Worked perfectly when I had a similar issue.  Thank you for posting your resolution!

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to resend all customers from Headquarters to Store Operations

    I was able to resend all of the customers I wanted by doing a SQL update of the Customers table in Headquarters, setting the LastUpdated field on the Customer record to the current date/time.

    update customer

    set lastupdated = getdate()

     FROM  [RMSHQ].[dbo].[Customer] HQCustomers

    Fortunately, I did NOT need to manually change the DBTimeStamp. When the Customer record was updated, the DBTimeStamp automatically was updated.

    I also had a script that went along with this to update the ShipTo records for these customers as well:

    update shipto

    set lastupdated = getdate()

     FROM  [RMSHQ].[dbo].[Customer] HQCustomers

     join  [RMSHQ].[dbo].[ShipTo]   HQShipTo

    on HQShipTo.CustomerID = HQCustomers.HQID

    and HQShipTo.HQID = HQCustomers.PrimaryShipToID

    When the 401 worksheet for my store connected to HQ, it resent all of my updated customers and shipping addresses down to the store (since I have multiple stores, each one got the updated customer record). Any customers which were missing from Store Ops were created.

    Bill Yater

    Blue Horseshoe Solutions, Inc

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,902 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,297 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans