Hey everyone, I'm working on a Sales Order report, but can't seem to figure out how to filter out lines with drop ship POs. Is this possible with a report?

I believe there's a field called "special order" or something like that and I think it picks up drop ships and special orders IIRC. Give that a shot and see if it works.

I was thinking of that but unfortunately the person needing the report wants special orders to remain. only needs to filter out drop ships

Does the LInked Fields "Purchase Order fields..." pull in just the drop ship details if you restrict the base transaction type to sales orders?

on a saved search this is super easy and possible, but I'm thinking this isn't possible on a basic report

oh yeah, probably not, I thought you were doing a saved search

was thinking filtering by ship to address but again don't think i can get to a PO table

you could try Suiteanalytics Workbook and maybe you get some of that reporting functionality you're looking for along with the data flexibility

yeah that's a good idea