Q:
Your company has multiple departments that require customized Excel reports generated from Dynamics 365 finance and operations apps, but they want to minimize repetitive manual work.

You need to automate the generation of department-specific Excel reports from Dynamics 365.

What should you do?

A Implement Excel add-in for Dynamics 365 and design templates for each department.
B Schedule a recurring batch job to export data to a shared folder in Excel format.
C Train department heads to manually export data to Excel and apply filters as needed.
D Create a single Excel template and instruct users to manually enter their departmental data.

Write your comment