Finds service tickets marked complete but never invoiced — jobs where work was done but no revenue was captured.
Using my Knowify data, query ServiceJobsSummaryReport for all tickets within [date range]. Filter for tickets where BusinessStateLabel is Completed AND InvoiceTotalAmount equals 0. Return ServiceTicketName, ClientName, DateCompleted, LaborCommitted, and MaterialsCommitted. What is the total cost of uninvoiced completed work?
