List of Linked Transactions

[Former Member]

Hello,

How would one go about finding a list of transactions for 1 item?

Context: I created an item and its now in the Item Master Data. I need to delete the item but the well known error comes up:

"You cannot remove item; linked transactions exist Help 09/03/2017 08:03:00 10001290"

I created the item yesterday and I control most of the transactions for an item so there are no transactions I can find associated with the item. Finding a way to list any linked transactions would help.

Note: I have already looked at a Relationship Map and have found nothing linked. I have also tried to remove the item while "Active" as well as "Inactive".

The community's help is greatly appreciated.

[kothandaraman_nagarajan · Accepted solution]

Hi,

Enter item code in below query to find transaction,

SELECT T0.[TransNum], T0.[TransType] FROM OINM T0 WHERE T0.[ItemCode] = [%0]

Regards,

Nagarajan

[Former Member · Accepted solution]

Hi Nagarajan,

This is due to my own SQL ignorance but how would I layer in DocNum? This is what I came up with to no avail:

SELECT T0.[TransNum], T0.[TransType] FROM OINM T0 INNERJOIN T1.[DocNum] WHERE T0.[ItemCode] = [%0]

[kothandaraman_nagarajan · Accepted solution]

Please share item in issue with in-stock, Committed, Ordered and available qty column here to check..

[former_member312729]

Hi Dorian Liriano

Check inventory posting report for related transaction with the item. Even you can check the warehouse report to cross check the committed and ordered if value exist then you cannot remove the item from master table.

Regards:

Balaji.S

[Former Member]

Hi Balai,

Thank you very much for this suggestion. The item doesn't appear in transactions so it appears to have been committed to the database in another way not visible to me.

Your input has been greatly appreciated.