We are currently integrated with Procore, so all our subcontractor invoices are created in and synced from Procore to Sage, so we do not enter invoices manually.  When our subcontractors bill their retainage, it creates a $0.00 invoice in Sage.  Does anyone have a specific report they are using from either Procore or Sage that shows them which subcontractors have actually billed for their retainage?  Because the invoices come across as $0.00, they don't show up on my AP report, so management doesn't know who has billed and who hasn't as not all subs bill retainage at the end.  

I'm trying to find a report that would tell me who has billed retainage and who hasn't or does everyone just work it manually?

Appreciate any feedback.

Thanks,

Susan