web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics RMS (Archived) / ItemDynamic Data Missing
Microsoft Dynamics RMS (Archived)

ItemDynamic Data Missing

(0) ShareShare
ReportReport
Posted on by Craig Harris 797

Good evening,

We have discovered that some of our items at HQ (Version 2.0.0166) are missing all ItemDynamic information (Store Quantity, Store Costs etc)

Wondering if anyone has seen this before and, if yes, is there is a solution to the problem.

Background: If we add an item individually in HQ and push the data we do NOT see the issue. If we import multiple items (via NWT Item Import) and push the data we are seeing the issue.

Any help or advice is greatly appreciated.

I have initiated a support incident with vendor and with Microsoft and will post findings when I hear back.

Cheers,

Craig

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Craig Harris Profile Picture
    Craig Harris 797 on at
    RE: ItemDynamic Data Missing

    Thanks! I appreciate you replying!

    Cheers,

    Craig

  • Suggested answer
    Craig Harris Profile Picture
    Craig Harris 797 on at
    RE: ItemDynamic Data Missing

    Thanks to everyone for their input. It is appreciated. Here are the 2 queries that we used to repair ItemDynamic Data.  After running the queries I ran manual WS 401, 402 and 501 and everything looks good now.

    --fixes itemdynamic for items

    insert into itemdynamic(itemid,StoreID,quantitycommitted,quantity,ReorderPoint,RestockLevel,SnapShotQuantity,SnapShotQuantityCommitted)

    select item.id as ItemID, store.id as StoreID,0 as quantitycommitted,0 as quantity,0 as ReorderPoint,0 as RestockLevel,0 as SnapShotQuantity,0 as SnapShotQuantityCommitted

    from item inner join store on item.id=item.id

    left join itemdynamic on item.id=itemid and store.id=storeid

    where storeid is null

    --fixes itemdynamic for matrix items

    insert into itemdynamic(itemid,StoreID,quantitycommitted,quantity,ReorderPoint,RestockLevel,SnapShotQuantity,SnapShotQuantityCommitted)

    select itemclass.id as ItemID, store.id as StoreID,0 as quantitycommitted,0 as quantity,0 as ReorderPoint,0 as RestockLevel,0 as SnapShotQuantity,0 as SnapShotQuantityCommitted

    from itemclass inner join store on itemclass.id=itemclass.id

    left join itemdynamic on itemclass.id=itemid and store.id=storeid

    where storeid is null

  • Verified answer
    Community Member Profile Picture
    Community Member on at
    RE: ItemDynamic Data Missing

    The below query would fix the problem, it inserts any missing records in the table with default values

    insert into itemdynamic(itemid,StoreID,quantitycommitted,quantity,ReorderPoint,RestockLevel,SnapShotQuantity,SnapShotQuantityCommitted)

    select item.id as ItemID, store.id as StoreID,0 as quantitycommitted,0 as quantity,0 as ReorderPoint,0 as RestockLevel,0 as SnapShotQuantity,0 as SnapShotQuantityCommitted

    from item inner join store on item.id=item.id

    left join itemdynamic on item.id=itemid and store.id=storeid

    where storeid is null

    A Hassan

    RMS Leaders

  • Sad Profile Picture
    Sad 650 on at
    RE: ItemDynamic Data Missing

    hi,

    it happened with me when creating a new item attached with a picture file.

    so when i create a new item always i check for store records in store quantity tab before press  OK to finish creating the new item.

  • Spencer McCandless Profile Picture
    Spencer McCandless 2,087 on at
    RE: ItemDynamic Data Missing

    It sounds like the issue is with the import utility. I would check with NWT. Off the top of my head, I think the solution for the existing problem would be to use a SQL insert statement within a while loop to create all of the entries in Itemdynamic, but, besides being pretty intense database manipulation, which should be discouraged,  I suspect it would not fix the problem for future product imports.

    Edit: I see you said pretty much this while I was typing this up.

  • Craig Harris Profile Picture
    Craig Harris 797 on at
    RE: ItemDynamic Data Missing

    Vendor (NWT) has acknowledged and taken ownership of the import/missing data issue. They are preparing a fix right now.  I will post more info as I get it.

  • Craig Harris Profile Picture
    Craig Harris 797 on at
    RE: ItemDynamic Data Missing

    Thanks for reply.

    1. Items do exist at Store Ops level (all 35 stores)

    2. ItemDynamic has NO entries (Store Tax, Store Cost etc). Used SMSS and queried by ItemID for specific examples.

    If I look at the Item Properties the tabs for the above are completely blank. No stores listed at all.

  • Spencer McCandless Profile Picture
    Spencer McCandless 2,087 on at
    RE: ItemDynamic Data Missing

    Also, do the items exist in the Store Operations databases, or were they just never sent down at all?

  • Spencer McCandless Profile Picture
    Spencer McCandless 2,087 on at
    RE: ItemDynamic Data Missing

    There's no entries at all in the itemdynamic table with values in the itemid column that match the products, or do the entries just contain all null or zero values?

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

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July 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