Dynamics Community Forum Thread Details

Using Sharepoint with GP 2010/Inventory SOP and Dashboards

We are a GP 2010 user who currently is not using SOP, Inventory and POP, although we have all of these modules.

I work for a 35 store retail grocery chain. Our inventory and margin demands are high. We have approximately 30,000 items. I have an idea we could use the inventory module to put us on a perpetual inventory basis.

This is a tall order, given the number of items and volume of purchases. Item costs change frequently and we need to get a daily view of sales, margin, inventory levels. I want to use either sharepoint or SRSS to pull together dashboards for internal users and management. The standard reporting out of GP won't cut it. With that many items and locations, all of the reports will be hundreds of pages long. No one has the time to wade through that. That is why I think sharepoint with it's dashboarding capability would be ideal for this application.

I was wondering if anyone has tried this on a large scale before. I don't know if there is a middleware data warehouse component that would be required. My VAR has provided me with a scalability document and GP2010 does have users with larger inventory and transactional requirements than ours. Based on this, I believe that it has the capability. I don't necessarily want to go on a fishing expedition if I can avoid it.

Thanks very much.

Pete Olesen

Sunflower Farmers Market

Quick Links

Leaderboard