Dynamics GP involves a good way for getting information through your ERP cloud system, AX hosting and utilize it instantly. Everyone who uses Dynamics GP is probably familiar with Smart Lists. However, there are few people who are familiar with “Excel Reports for Dynamics GP”, also referred as refreshable Excel reports.
 
According to Rose ASP, refreshable Excel Reports is different from Smart Lists in that when you run the reports, the data goes directly to Excel, and a refreshable data connection is created so that as new data is added or changed in Dynamics GP, the Excel reports using the connection will reflect the change.
 
It is a useful tool for making reviews along with particular formatting like graphs and pivot tables. This you would like to use repeatedly, and share with others.
 
Therefore, this is the trick: many people do not know they have this functionality because they have not deployed it yet.
 
This is a great tool since it is, however, you could also easily publish your records to SharePoint and Outlook. This video shows you how to do it - http://www.youtube.com/watch?v=dgssNqKJ4w4&feature=youtu.be
 
To find out more about the Microsoft SPLA see - http://roseasp.com/about/microsoft-spla-licensing
 
Source For This Article - http://roseasp.com/publishing-refreshable-excel-reports-with-dynamics-gp




Leave a Reply.