Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Item Type Change
Microsoft Dynamics GP (Archived)

Item Type Change

(0) ShareShare
ReportReport
Posted on by prateekpulp 540

Hi All,

We have a wrong Item type Against one item in our Database. We reported this item to Bill of materials(BOM) earlier but now removed it. I also removed it from Item engineering data. But However, when we try to delete this item it says that it has been used in a Bill of materials (BOM) and cannot be deleted. Please advice me on how to fix this issue? We want to change the item type or reenter the item after deleting it. If deleting, Please guide me what precautions need to be taken.

Thank You,

Prateek

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Item Type Change

    Roger - you said you can remove the won/close as lost buttons from the toolbar.

    I would like to add a 'Close as Lost - Evaporated' option to the main toolbar, right next to those other two options.
    Is this possible? And where would I go to edit?

    Thanks!
    Bree

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Item Type Change

    I will have to try this soon. Although, the best thing to do for the mean time is to share a suggestion on MSConnect in order to have an official response from Microsoft.

    You may kindly close the case if it is fulfilled,

  • prateekpulp Profile Picture
    prateekpulp 540 on at
    RE: Item Type Change

    Thanks Mahmoud. That was really helpful. I have gone to the process. and successfully removed it from the back end.

    However I am looking forward to prevent this thing from happening  in future. I got that Copy BOM functionality won't throw any error while copying a BOM line item to a misc Item and database will be successfully updated. Is there any way to prevent that? Do we  have to write Codes for that?

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Item Type Change

    prateekpulp 

    Let's recap the whole approach to get this resolved. May I ask you to use the search all db stored procedure to look for the tables at which a record for this item exists.

    It can be found on  spSearchOnAllDB: SQL Stored Procedure to Search an Entire Database

    After creating the stored procedure, run the below:

    exec spSearchOnAllDB 'ItemNumber#%']

    Please share the results in order to proceed accordingly
    Your feedback is highly appreciated,

  • prateekpulp Profile Picture
    prateekpulp 540 on at
    RE: Item Type Change

    Hi, Now i got What's happening. When we created this item we kept the item type as Misc type.Gp dont allow us to add BOM for item type Misc type. But it actually allowed to Copy BOM from similar made item and it didnt throw error at that time. So, BOM has been made for this particular item. Nowwe are not able to delete this item from the front end. Is anyone know how to solve this one? If we have to go for a back end fix then anybody knows how to prevent this thing in the future?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Item Type Change

    If you item number is showing as PPN_I in the BM 115 table then the system is seeing your item as a BOM and not just a component of a BOM. Check to see if it is listed in the BM 415 BOM header table as it should be if it is actually a BOM.

  • soma Profile Picture
    soma 24,406 on at
    RE: Item Type Change

    I think, for this case you have to delete the item number from back end.

    Hope this helps!!!

  • prateekpulp Profile Picture
    prateekpulp 540 on at
    RE: Item Type Change

    The Item that we are dealing here is Misc Type. We cannot add BOM line for misc item types. I am not sure how it got added in the first place. But now I am unable to delete it from the front end as it says you cannot build the item of Misc TYPE. But at the back end it shows that there are some BOM lines added for this item. Is there any other way to delete the item from All the BOM'S or should I go for the back end solution?

  • Suggested answer
    Ian Grieve Profile Picture
    Ian Grieve 22,782 on at
    RE: Item Type Change
    Yes, you will need to remove the Item from all BOMs it is contained within.
  • prateekpulp Profile Picture
    prateekpulp 540 on at
    RE: Item Type Change

    Thank you for your response.

    I checked in the table BM010115 which consists of BOM lists and found that there are two columns PPN_I and CPN_I. CPN_I, I assume is the component item. when I ran the query for my particular item number I found 10 rows with the concerned item number in PPN_I column. So the item has to be deleted from all these BOM list in order to proceed with the deletion of item?

    I appreciate your help in this.

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