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

There is `@NONE@` in SuiteScript, I can't remember off hand if it's the same in SuiteTalk but check the docs

Yep, that also works in SuiteTalk. dont know why they dont provide that as a constant/enum :rage:

Any idea if there Is any way to search for ItemReceipts / ItemFulfillments that dont have an inventory detail (but the item is a lot numbered)?

the inventoryDetailJoin always seems to be `null`

Sorry I haven't dealt with inventory detail records before