@C_Billings & @TJ Cornelius my goal is to get a comprehensive report on all items that are on order with a column for inbound shipment details (such as container number, BOL, etc.) While Including all lines that aren't on a inbound shipment as well I might be wrong but i the only way to get that would be by structuring the search around a the purchase order Any suggestions how to go about it?