web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Check out the Community Spotlight Video Series
News and Announcements icon
Community site session details

Community site session details

Session Id :
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

I have the same question (0)
  • Suggested answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at

    Apparently the item has been used as a components in a bill of material. Do you have a manufacturing module ? If so, go to smart list and search for this item being a component in a bill of material. Once it is removed from the BOM, you can proceed by deleting the item from the card.  In case this is not a new item with no transactions, you will have to primarily make sure of the points below:

    • All item quantities are zero
    • No unposted transactions for this item


    Let us know if you need any further assistance,

  • prateekpulp Profile Picture
    prateekpulp 540 on at

    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.

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

    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?

  • soma Profile Picture
    soma 24,416 on at

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

    Hope this helps!!!

  • Community Member Profile Picture
    Community Member on at

    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.

  • prateekpulp Profile Picture
    prateekpulp 540 on at

    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?

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at

    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

    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

    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,

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

Check out the Community Spotlight Video Series

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans