Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics RMS (Archived) / Store don't replic...
Microsoft Dynamics RMS (Archived)

Store don't replicate to HQ

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hi Guys

 

I've recently taken over a customer who's using RMS integrated with NAV (It's quite a while ago I've worked with RMS - so I need a bit of help).

 

I'm having a problem with one store (they are having 10+ stores) where they had a problem for 8 days where the sales of the store for some reason was not replicated into HQ and therefore not posted in NAV? It's working again and there haven't been any changes so that's my "worry" that things was working fine and then stopped working for 8 days and now it's ok again.

How do I solve this problem??

All help really appreciated.


THANKS in advance.

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Store don't replicate to HQ

    Hi ALL

    I've just investigated the problem even deeper from a SQL perspective. It's seems to be quite strange since the 401 is completed and the transactions are in the Transaction table but they are not distributed further to the sales table etc.

    Any clue about this? As well I can't tell why it's not happening every day but only some days?

    Carsten

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Store don't replicate to HQ

    SDDXB are you based in Dubai?? Can I have your no. to give you a call and discuss this issue please? Please write me a PM or email at carstenolholm@hotmail.com

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Store don't replicate to HQ

    This seems to be the way it's been done as well.

    Is there anyway a chance to do things differently? Since it seems like the problem happen during the day the 12 as it have posted some entries (10% of the total) and then for the next 8 days no entries have been taken into HQ Manager and then again it's working.

    They have multiple store and the issue is only for one of them which is what I believe is strange.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Store don't replicate to HQ

    Hi Carsten,

    It should not be effective date. Ask them to change the From date in 401 worksheet. This will pickup the missing data. Here i am attaching a screenshots for you.

    Effective date to define when store should process the worksheet

    From date  will pick up all missing data during the define date to current.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Store don't replicate to HQ

    The client have tried to do above but still not able to get the data in to HQ Manager for some reason?? Any other suggestions??

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Store don't replicate to HQ

    Thanks a lot - I'll ask them to try this on Sunday when they are back to work.!

  • archelle16 Profile Picture
    archelle16 1,735 on at
    RE: Store don't replicate to HQ

    To create a worksheet 401 in HQ, Use RMS HQ Manager.

    Login to HQ Manager, go to Worksheet menu then select worksheet 401. Follow instructions of worksheet wizard.

    Note: Effective Date should be specified on when was the worksheet will be effective.

    Please let me know if this helps. Thanks.

  • archelle16 Profile Picture
    archelle16 1,735 on at
    RE: Store don't replicate to HQ

    Hi Mhir Shah,

    The effective date in Woksheet wizard does not mean that it will upload data starting from June 12. Effective date means, that worksheet will be effective on the said date. For example, today is July 4 and I specify July 5 instead. When the store starts to sync, there will be no worksheet  available to process. But, when store starts to sync tomorrow, the worksheet created will be processed.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Store don't replicate to HQ

    Thanks MIhir - I've tried to ask the client to do so but they said they are not aware of how to do. Any documents on how to create a manual 401?

  • Mihir Shah Profile Picture
    Mihir Shah 985 on at
    RE: Store don't replicate to HQ

    Create a new 401 with effective date of June 12th and process it.

    This should upload the store sales data from June 12 onwards to HQ.

    Mihir

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,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans