Using Excel Report Builder with Microsoft Dynamics GP
Imagine making an ERP report such as “Inventory Stock Status” available to be viewed and formatted in Excel… All a user needs to do is open Excel and there is the data refreshed in real time. All of this done from the comfort of Excel. Microsoft Dynamics GP Excel Report Builder is one of a variety of reporting tools that can make this happen today. No programming. No configuration. Just send the report to Excel and format the report to look the way you want to see it. No fuss. No mess.
The Excel Report Builder generates an Excel report with live data connections automatically. These connections link back to Microsoft Dynamics GP without the user having to configure servers or authentication. If the user has rights to view the report, they have rights to format it in Excel. So, think of the possibilities you can use today like a list of purchase orders needed from the Vicinity MRP or truck routings for delivery by day. Raw material usage with costs and production schedule data are all within Excel and easy for the user to consume. So, start using Excel as a reporting tool rather than a database. You will wish you had found this a long time ago.
If you are currently using Microsoft Dynamics GP, contact your reseller or give us a call. We are always here to help. If you are new to the Microsoft Dynamics community, take a look at what you are missing. In no time at all, you will be up and operational wondering how you ever lived without Microsoft Dynamics.