When deleting an inventory item, message 58 appears: "Record cannot be deleted. It is in use elsewhere in the system."
How do we find where it is being used? Everything we check shows no usage, no history etc.
*This post is locked for comments
If you have access to SQL, try this against your App database:
declare @Item char(15)
set @item = '******' --'Replace ***** with your Inventory code'
SELECT * FROM INTran WHERE InvtID = @item
exec SCM_smServCall_OpenInvoice @item
exec WOHeader_InvtID_WONbr @item, '%'
exec Kit_All @item
exec PurOrdDet_InvtId_OpenLine @item
exec Component_CmpnentId @item -- component of a kit?
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,432
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
