Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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 795

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

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

    Thanks! I appreciate you replying!

    Cheers,

    Craig

  • Suggested answer
    Craig Harris Profile Picture
    Craig Harris 795 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 Microsoft Employee 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,085 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 795 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 795 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,085 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,085 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

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans