Combines unpaid subcontractor contract balances with outstanding vendor bills to produce total sub exposure. This cross-report calculation is not available natively in Knowify.
Using my Knowify data, first query SubcontractorsReport (include_paid_subs: false) to get all unpaid sub contract balances by project. Then query BillsSummaryReport for outstanding vendor bills. Combine these to give me total subcontractor financial exposure — sum of unpaid contract balances plus outstanding bills, by sub and by project.
