Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics RMS (Archived)

Shall i delete Duplicate records in the Item Class Componenet table?

Posted on by 415

Hi All,

Actually we dont have any assembly items. We importe the new items throguh Store_Operations_Import_Utility . I dont know how the duplicate records created in the Item class componenet table. Because of this duplicates the Master Quantity list report is not matching with Stores Qty .

Shall i delete those duplicate record in the Item Class component table.

Please advise me from this problem.

*This post is locked for comments

  • Ashish Sharma Profile Picture
    Ashish Sharma 415 on at
    Re: Shall i delete Duplicate records in the Item Class Componenet table?

    Thanks Jeff,

    Let me try and come back to you.

  • Jeff @ Check Point Software Profile Picture
    Jeff @ Check Point ... 13,380 on at
    Re: Shall i delete Duplicate records in the Item Class Componenet table?

    Backup your databease and try it!

  • Ashish Sharma Profile Picture
    Ashish Sharma 415 on at
    Re: Shall i delete Duplicate records in the Item Class Componenet table?

    Hi Experts ,

    Please throw some light about this issue .

    Thanks in advance.

  • Ashish Sharma Profile Picture
    Ashish Sharma 415 on at
    Re: Shall i delete Duplicate records in the Item Class Componenet table?

    Hi Experts ,

    Please share your experience about this problem.

  • Ashish Sharma Profile Picture
    Ashish Sharma 415 on at
    Re: Shall i delete Duplicate records in the Item Class Componenet table?

    Hi All,

    Please throw some light to resolve the problem.

  • Ashish Sharma Profile Picture
    Ashish Sharma 415 on at
    Re: Shall i delete Duplicate records in the Item Class Componenet table?

    HI All,

    Client is not using  matrix, lot matrix, or assembly items. In the process of importing items , we imported through Import utiluty tool . when we run that report as mentioned standard items are created duplicated in that item .  because of this ducplicates Store Item qty is not matching with HQ item Qty .Please guide me how to delete those records ?

    Thanks in advance

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