Hi all, Any advice? I'm looking to create a dataset that shows the sales order and it's related invoice, only for sales orders that contain a dropship item. Thanks!

did you get this done? what issue are you stuck on?

Nope, I'm trying to create a report to compare shipping costs for drop ship orders with the shipping cost on the bill for the associated vendor. I'm doing this by linking 2 datasets. The piece where I'm stuck on is the data set that pulls the sales order, related invoice, and shipping cost on the invoice. I'm looking to filter the results returned by only sales orders that have a drop ship item on them.

Probably obvious to you already, but have you checked Answer Id: 83688 that shows a way to search for dropship vs non-dropship items on SOs?

No, I actually didn't know that, that is very helpful, thank you!!