We are Dynamics GP users and have just started using Sharepoint (Office 365 hosted). I want to pull product sales data from Dynamics and put it into Sharepoint online, so I can cllok at products (list items in Sharepoint) and see things like:
- YTD Sales
- Lifetime Sales
- Rate of movement (units sold in last 3 months)
- Inventory
- Etc.
Has anyone integrated these two. What is the best practice - is it opening up a direct data connection between the on-premises Dynamics GP and hosted Sharepoint or is it generating an Excel file of data and running the report and somehow importing it into the list.
Please advise.
Thanks!
*This post is locked for comments