You’re offline. This is a read only version of the page.
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
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
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,
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?
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,
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?
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.
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?
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,113
Super User 2024 Season 2
#2
Martin Dráb
229,918
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (