Sage 300 ERP - A/R Invoice Summary

Hi All

How can i run something (and download to excel) that shows all invoiced A/R customers and the amount billed to them for a specific period of time (lets say 2016).

something that looks like:

Thanks!

Vendor A                   $50,000

Vendor B                 $100,000

Vendor C                     $5,000