I have a query written to show all work orders still in work order status (7). This is used to help us see what still needs to be billed.  What I am wondering is if there is a way to get the cost incurred to pull into the query/report.  If we go to each individual work order you can click view and then select service order costs.  I feel like there should be a way to pull that into a query or a report.

Thank you for your help