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

(0) Share

Report

Posted on by Rick Kirkman

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!

All responses (2)

Answers (1)

Rick Kirkman 2 on at

Like (0)

Report

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 on at

Like (1)

Report

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

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.