This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Can you left outer join from a transaction search that giving line level results to the item table so get null values for items customers arent buying?

Are you just wanting to get a list of items that don’t appear on a transaction?

if your left table is the transaction, that won’t work