Skip to main content

Notifications

Microsoft Dynamics RMS forum
Answered

RMS 2.0 HQ - multiple stores, sometimes new global account doesn't go to all stores

Posted on by 2

Sometimes when accounting creates a new global account through RMS 2.0.2023 HQ it will show up in two stores, but not in the third. Then it randomly shows up several hours to several days later. In this case, we have one that was created last Friday, 5/7 and has yet to appear in the third store. I tried a back dated worksheet 401 for that store, but it didn't bring it over. Anyone have any suggestions or fixes for getting these random accounts to show up where needed?

Thanks!

  • Rick Kirkman Profile Picture
    Rick Kirkman 2 on at
    RE: RMS 2.0 HQ - multiple stores, sometimes new global account doesn't go to all stores

    Hi Todd, and thanks for your response!

    401 worksheets run every 12-15 minutes for all stores.

    The "missing" global account from the one store finally showed up last night, approximately right after the next automatic run of the 401 update after my back-dated worksheet.

    Yes, new local (cash) accounts are created daily at this store. The account numbers are a different format (dashed phone numbers) for local accounts, so they are not duplicated. Global accounts have 4 to 6 digit numbers.

    I will check out some of your SQL queries the next time this issue happens. It's been random, but frustrating when trying to bill out on a new account and trying to ship it out the same day.

    Thank you again!

  • Verified answer
    ToddB Profile Picture
    ToddB on at
    RE: RMS 2.0 HQ - multiple stores, sometimes new global account doesn't go to all stores

    Hi Rick,

    Depending on how often a 401 worksheet is run at the store(s) determines when new records should be sent to the stores.

    Are 401s scheduled once an hour, once a day, etc. for the stores?

    Are there any duplicate account numbers? IDs? HQIDs at the store or HQ?

    select accountnumber, count(accountnumber) from customer group by accountnumber having count(*) > 1

    select ID, count(ID) from customer group by ID having count(*) > 1

    select HQID, count(HQID) from customer where HQID <> 0 group by HQID having count(*) > 1

    Were any customers created locally at the 3rd store?

    select * from customer where globalcustomer = 0

    Does the HQID, of this new customer, already exist at the 3rd store?

    Run at HQ:

    Select id from customer where accountnumber = 'XXXX'

    Run at the Store:

    Select * from customer where HQID = 'IDfromHQ"

    ____________________________________________________

    Just a note that Mainstream support for Microsoft Dynamics RMS 2.0 ended on July 10, 2016; and extended support ends on 7/13/2021:

    https://community.dynamics.com/rms/b/rmssupport/archive/2015/10/22/microsoft-dynamics-rms-2-0-mainstream-support-discontinuation-july-10-2016

    Dynamics Retail Management System 2.0 - Microsoft Lifecycle | Microsoft Docs

    pastedimage1620830611005v1.png

    This is around 2 months from now; and you can continue using RMS after this date, but technical support will not be available.

    I would recommend checking with your partner regarding what they may recommend as a replacement system after the extended support end date.

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

Give Back to the Community this Month

Quick Links

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

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

#2
Martin Dráb Profile Picture

Martin Dráb 229,135 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans