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) / RMS HQ ItemDynamic not...
Microsoft Dynamics RMS (Archived)

RMS HQ ItemDynamic not updating

(0) ShareShare
ReportReport
Posted on by Community Member

Hi 

Hopefully I have simply missed something easy here, but I have just added a new store to the system but the information in the HQ ItemDynamic table is not updating with the new stores stock levels, committed stock etc when the Data Upload Worksheet runs to pull the data from the new store.

Any suggestions to point me in the right direction what I have missed would be great

Many Thanks

Martin

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    does the information exist in the new store database?

  • Community Member Profile Picture
    Community Member on at

    Hi

    Yea I have connected to the Local database and in Item table I can see all the quantities and the ItemType is set to 0 (standard inventory), and I have the 401 Worksheet polling every 20 mins, and I know the 401 is working as the sales data is populating in to the HQ Transaction/Batch tables.

    I was going to run a 501 and 190 tonight to request and reconcile the stock quantities between HQ and the stores however I don't know if this will kick the new store to update correctly when they start selling again tomorrow.

    Many thanks again and for your quick response.

    Martin

  • Community Member Profile Picture
    Community Member on at

    Did you export the the store from the HQ Admin?

    Did you perform the initial sync of the store with HQ?

    If you change prices at HQ and process a Worksheet 250 for that store, do prices update?

    Have you done any stock or inventory transactions at the store like a PO or Transfer?  Do you see that replicate from the store to HQ?

  • Community Member Profile Picture
    Community Member on at

    Hi

    Once again thanks for your time, response to your questions below:

    No I created a Store Template and copied this for each store (changed the multi store id as I went to each store) I used this in the initial setup for 12 stores and all worked fine, this is my first new store since the initial setup 6 months ago, and I must have missed something stupid.

    Yes the initial sync (101) was performed and looking in the Store Manager -> Config it says the database is synced.

    Yes if I send a 250 the prices at the store do update.

    Yes PO's have been accepted at the store however these have not been replicated in the HQ!!

    What have I missed!!! Haha!!

    Many Thanks

    Martin

  • Community Member Profile Picture
    Community Member on at

    Hi JSG_MB.

    I'm not sure which RMS version you're using. This might help. We're in version 2.0.1004

    This was not available in version 2.0.0XXX

    Try HQ Manager->Admin->Stores-> Open the store and edit any of fields.  Ex: You can add\update address field and press ok.  When you do that,

    There is a background process happening where it copies all missing HQ Items from item master table to Itemdynamic table.  Weird workarounds by MS team! seriously,

    For us it'is really irritating as this background process blocks all other process while searching the entire master. We have like 950K items in our HQ DB. Now we cant use front end screen to edit any store information.  

    Cheers

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Hello Martin,

    Thank you for your question.

    When you check the store table in the Headquarters database, does the store appear there?

    Please note that we recommend exporting out store database from Headquarters Administrator, rather than copying a template database at each location and manually changing store IDs.

    I would suggest that you export out this store database from Headquarters Administrator, restore it at the store level and see if the issue continues after this.

    Thank you,

    Scott Wardzinski

    Microsoft Dynamics RMS & POS Support Engineer

  • Community Member Profile Picture
    Community Member on at

    This is very interesting to read..  I am having similar issue in where a stores dynamic table does not have an item that the store says it has.  And if the above is true then it should be updated from said process.  But I can tell you that is not occurring all the time or working properly..  Because I have two stores who's dynamic tables are not updating from master.  2.0.2020 build.

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