Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / Inventory KIT
Microsoft Dynamics SL (Archived)

Inventory KIT

(0) ShareShare
ReportReport
Posted on by Steve Yako 120

Someone turned one of our stock item sku's into a Kit accidentally and of course PO and SO transactions have occured after the change so the system will not allow us to delete via the "Kit" screen.

In database research it appears the inventory table has a kit flag field that is set as a 0 or a 1 to determine if an item is a KIT or not adtionally a record is created in the kit table that has a kitid matching the invtid value in the inventory table.

Consequently if components are added to a KIT then additional related records get created in the components table. For this partiular item no components have ever been assigned nor has it been used in an assembly plan.

Is anyone aware of issues if I delete the kit table record for this particular item and then set the KIT flag back to 0 in the inventory table turing this sku back into a normal stocked item.

Let me know.

Steve

*This post is locked for comments

  • Toni Savage Profile Picture
    Toni Savage 260 on at
    Re: Inventory KIT

    Another workaround would be to create a new item and make it the only item in the "kit".  The new item would have all the details that the real non-kitted item would have had.

  • Darin Madsen Profile Picture
    Darin Madsen on at
    Re: Inventory KIT

    Hi Steve,

     

    Thanks you posting to the OTC.

     

    Scope

    ======I understand that you are wondering if there are any issues with changing the kit flag in SQL back to 0 and deleting the kit table record. 

    Assessment

    ===========

    In general, I cannot see that there would be any issues if this item is truly not a kit item, however, we

    do not know what changing the  item in this manner would actually do to all of the tables. If you make

    this change using SQL and you do not see the desired results, you will likely need to change this item to

    inactive and create a new inventory item.

     

    Plan: NEXT STEPS

    ==============

    1) Make change with SQL

    or

    2) Change item to inactive and create a new inventory item.

     

    Let me know if you have any questions.

     

    Darin

     

    Darin Madsen

    Support Escalation Engineer

    Microsoft Dynamics SL

     

     

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