Hello!
I'm attempting to build a report (or saved search) that will allow me to view all Sales Orders (with specific statuses: pending billing, pending fulfillment, partially fulfilled/partially billed, etc). Basically I need to show all "open" sales orders for Q4 2022. But with this report, I'd like to be able to click on each sales order and see the child transactions or Related Records that would show on the Sales Order record.
I've tried customizing the Open Sales Order report but the Sales Order status is set to "open" which displays orders that have a "Billed" status, which I do not want. I'm not seeing a way to set the status to the specific types as I'm able to in Saved Search criteria.
I've tried creating a Saved Search but I don't know how to make the results simply display the Sales Orders (along with the accompanying columns) that will allow me to click and drill down to see the child transactions or related records. I put the "Billing Transaction" column in this search but that only seems to show invoices and we need to show any type of related records.
Our accounting team would like to see all of this one one screen and not have to click into each Sales Order record and go to related records to investigate.
Is this possible?