Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics RMS (Archived) / HQ Store Inventory Dis...
Microsoft Dynamics RMS (Archived)

HQ Store Inventory Discrepancies

(0) ShareShare
ReportReport
Posted on by Patrick T. 135

Hello Folks!

So I am having an issue.
We recently setup a new store, with a limited selection of products, and ergo, not the entire Headquarter's worth of items in the database.
However, somehow, this new store managed to get assigned quantities of items if doesn't have in it's database, but HQ asserts it has. I tried to run a Inventory Wizard 190, but it doesn't populate a full list of items. Also, adjusting the store quantities via a worksheet does not work, either. The only thing that's worked so far is to manually visit each item in maintenance mode and clear them one by one. However, with over 20,000 items in inventory, it'd be a MASSIVE time sink to do.

I was curious as to what table HQ might store it's Store Quantities values at, so I could maybe just use a SQL command to eliminate all inventory from that store (It's not open yet, and not inventory has been transferred to it), or if another method exists for clearing all these phantom items out of HQ, since they are not present at the store level database

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: HQ Store Inventory Discrepancies

    Hi Scott,

    I am having a similar problem. I initiated a 307 - Adjust Inventory Quantities worksheet and added the same item twice with quantities. However when the worksheet was received in SOP the quantity was not adjusted. It happened for quite a few of items. HQ reflects the correct quantities.

    Can you say what cause this and give a possible fix?

    Thanks alot.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: HQ Store Inventory Discrepancies

    Hi Scott,

    I am having a similar problem. I initiated a 307 - Adjust Inventory Quantities worksheet and added the same item twice with quanities. However when the worksheet was received in SOP the quantity was not adjusted. It happened for quite a few of items.

    Can you say what cause this and give a possible fix?

    Thanks alot.

  • Suggested answer
    raelhefn Profile Picture
    raelhefn on at
    RE: HQ Store Inventory Discrepancies

    ItemDynamic table contains quantity for each store

    I think you have some missing records for items in this table which cause this problem

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: HQ Store Inventory Discrepancies

    Hello Patrick,

    The best practice to adjust store quantities is to complete a physical inventory count at the store, run a Style 501 worksheet for the store and then run a Task 190 in Headquarters Manager.

    Please note that if you have deleted items in the store database, then the above may not work as not all items will pull in..

    If the store has not yet opened, re-exporting out the database from Headquarters, using a blank database as the template, or a copy of a current store database with all item quantities zeroed out as the template, should allow you to then populate only the items that will be carried at the store.

    Thank you,

    Scott Wardzinski

    Microsoft Dynamics RMS & POS Support Engineer

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans