NetSuite Admin Tip | Item-to-Transaction Analysis with SuiteQL

As an Administrator, you may sometimes need to identify which items are actively being used in transactions—and which ones are not. Doing this directly from the UI can be time-consuming, especially if you have a large item catalog. SuiteQL provides a faster way to analyze this data.

By using a RIGHT JOIN between the Item and TransactionLine tables, you can list all items in your account and check whether they have ever appeared in a transaction.

SuiteQL Query

SELECT 
    item.itemid AS item_name,
    item.displayname AS item_display,
    transactionLine.transaction AS transaction_number
FROM transactionLine
RIGHT JOIN item