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

I am trying to run a search that will show items that have Available below a given threshold but are On Order, the PO# and estimated delivery date of that order, and the Inbound Shipment # &amp; estimated delivery of the Inbound (ideally, the 2 dates would be the same, but we don't always get the PO date updated).

I currently have the search set as a Transaction search, with Transaction type PO. Is there a different search I should use to get the Inbound information added to the results as well?

do an inbound shipment search, you can join to the PO from there

I'm able to see the PO and Inbound dates, but for new POs we haven't created the Inbound yet, so those won't show, will they?

if you want both, then your first approach was correct

check out suite analytics...a lot more join options there.