We have similar reports for other items that aren’t AR invoices. I would create a BAQ report that pulls the list of invoices you would want to display according to your criteria. If you turn that into an SSRS BAQ Report, you can then schedule it to run and email to a predetermined set of users.
We went directly from Epicor 9 to 10.1.600, so I’m not sure if the functionality is the same in 10.0.700, but when you run a BAQ report, you can choose “Email Report” after setting the report Schedule and Epicor will automatically email out the report each time the schedule triggers. If you build the BAQ so it uses the current date whenever it runs, you wouldn’t have to add date options to the BAQ report and it would automatically use the date the report is run as its filter.
