Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics RMS (Archived) / Items in HQ missing
Microsoft Dynamics RMS (Archived)

Items in HQ missing

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

I have a situation that Items are in SOPOS but not in HQ.  I am quite sure that it is from a SQL command that identified items that haven't been sold in 2 years and zero  qty on-hand.  Now inventories have identified that we actually have them and request to adjust inventories have us missing the Item in HQ.  So my only idea to clean this up is to create a look up file that is based from HQ that will validate items.  Any items scanned on the handheld not in the HQ list would be invalid.  Therefore we can create the Items at HQ and send to SOPOS.  After all stores are inventoried I am thinking it will be fixed.  Any suggestions or problems with this logic?

HQ and SOPOS v 2.0155

*This post is locked for comments

  • Suggested answer
    archelle16 Profile Picture
    archelle16 1,735 on at
    RE: Items in HQ missing

    If you wish to recreating the items in the HQ, you can use linked server to compare the items which do not exists in HQ, query-to-insert that item with the same details in HQ.

    But if you do not want to recreate what was deleted, you can tagged that item as inactive in the store.

  • Suggested answer
    archelle16 Profile Picture
    archelle16 1,735 on at
    RE: Items in HQ missing

    Recreating item in hq with the same lookupcode will make two items but different HQIDs in stores. I suggest to recreate the item using the HQIDs shown in storedb in HQ, then issue update item to all stores.

  • Rick Kirkman Profile Picture
    Rick Kirkman 2 on at
    RE: Items in HQ missing

    [quote user="DW"]

    I have a situation that Items are in SOPOS but not in HQ.  I am quite sure that it is from a SQL command that identified items that haven't been sold in 2 years and zero  qty on-hand.  Now inventories have identified that we actually have them and request to adjust inventories have us missing the Item in HQ.  So my only idea to clean this up is to create a look up file that is based from HQ that will validate items.  Any items scanned on the handheld not in the HQ list would be invalid.  Therefore we can create the Items at HQ and send to SOPOS.  After all stores are inventoried I am thinking it will be fixed.  Any suggestions or problems with this logic?

    HQ and SOPOS v 2.0155

    [/quote]

    I have a similar situation, where I have an item that shows up in both stores, but is not in HQ. Is there a way to retrieve it or bring it back into HQ? If I attempt to recreate the Item Lookup in HQ, it will have a new base ID and won't sync with the existing item in the stores, correct? Any suggestions? RMS 2.0200. Thank you.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Items in HQ missing

    On the store database, run the following query that will display a list of items existing in the store database and not existing in the HQ database: -

    ***********************

    select StoreItem.*

    from item StoreItem

    left join

    OPENDATASOURCE('SQLNCLI',

       'Data Source=HQServerNameOrIP;User ID=sa;Password=xxxx')

    .[HQDBName].dbo.[Item] HQItem

    on StoreItem.Itemlookupcode=HQItem.ItemLookupCode

    where HQItem.ItemLookupCode is null

    *****************************

    Don't forget to replace "HQServerNameOrIP","HQDBName", and "xxxxx" with real information

    A Hassan

    RMS Leaders

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Items in HQ missing

    Hi DW,

    You can do it in this way as well without scanning, i m assuming you have SQL knowledge and your item master not exceeding 100000 .

    Take a complete list of items from Store database with inventory.

    Take a complete list of items from HQ database

    Get the items which exist in Store database but not in HQ. This can be done from SQL but vlookup in excel also will do.,

    Create the items in HQ database

    Inactive items, remove alias in store database for non existing list. (Again if non existing items are more, you can do it trough SQL)

    Issue the newly created items in HQ to stores through download items and add inventory which you have taken from above snapshot.

    Make sure not to create any item in Store database and block the access to create new items in stores.

    I hope this will help

    Regards

  • Jeff @ Check Point Software Profile Picture
    Jeff @ Check Point ... 13,380 on at
    RE: Items in HQ missing

    If you delete something at HQ, it does not delete it at the Store Level, One should make the item Inactive instead.

    Maybe someone here can create a ILC comparison between the HQ db and the store db

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,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans