I am creating a BAQ of all sales order lines and their ship date.
I know the ship date comes from the shiphead table. But I am stuck in two options that both do not return what I want.
I want lines that have not shipped to return blank or a specified text. However, when I add the shiphead table without a subquery or table criteria, I get multiple duplicates of same line. When I add as subquery also I only get lines that have shipped and lines that haven’t shipped do not show on the final table at all.
I need help on how to get all sales order lines showing and the ship date showing for those that have shipped and blank for those that have not shipped.