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) / Worksheet 250 created ...
Microsoft Dynamics RMS (Archived)

Worksheet 250 created duplicate items at Stores

(0) ShareShare
ReportReport
Posted on by OWNE 40

User changed a number of item lookup codes on HQ, ran worksheet 250 and the result was duplicate items/inventory at the stores.  The original items are still there, and there are new items with the same inventory amounts for the new lookup codes. 

Any idea why this would have happened or what to do to resolve it?

 

 

*This post is locked for comments

I have the same question (0)
  • OWNE Profile Picture
    OWNE 40 on at
    Re: Worksheet 250 created duplicate items at Stores

    Thank you for the responses.  I opened a support case with Microsoft.  They have not been able to determine why it happened.  Some more details about the circumstances:  

    The user created a new Dept at HQ (did nothing to create it at the stores!), and changed all the items in question to this new dept and changed their ILC by prefixing it with a D.  They then used Worksheet 250, selecting the new Dept, and transferred the changes to the stores.  

    Looking at the items at the Stores, the original item now has a HQID of 0, and the newly created item has the proper HQID.   This happened a few days ago, so there is no way I could do database restores.

    Support did give me a SQL script that I can use at each Store to merge the original item into the new item, along with all the supporting/linked tables.  However its for one item, so I will need to modify it to go through all of the items (a few hundred items were affected).

  • Jeff @ Check Point Software Profile Picture
    Jeff @ Check Point ... 13,382 on at
    Re: Worksheet 250 created duplicate items at Stores

    OWNE,

    Most likely cause is that the ILC's were created at the store instead of HQ.

    Run this query at the store and compare the HQID #s.  If one of them is 0, then its was created at the store.

    SELECT * FROM Item WHERE ItemLookUpCode = '<enter an ILC number>'

    As Ryan mentions, it can be fixed, it could be time consuming, it could be expensive!

    Jeff

  • Ryan Sakry Profile Picture
    Ryan Sakry 3,425 on at
    Re: Worksheet 250 created duplicate items at Stores

    Not too sure what caused it, but we have certainly been able to help people fix much worse issues.  If you are interested in a had, please drop me an email or give me a call and we can discuss.

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