Effectively reporting information from multiple companies is a challenge for any organization that has multiple companies. Providing ad-hoc reporting functionality is very difficult. It generally takes a fair amount of training to get a user to the point where they can effectively navigate the ERP system to get the data they want.
SmartLists in Dynamics GP has proven to be a very popular reporting tool. Users take to it naturally and instantly. Dynamics GP comes with several SmartLists out-of-the-box.
But if you want to get to data that isn’t in the out-of-the-box SmartLists, or you want to get data from other non-GP databases, you need to use SmartList Builder. Our clients love this tool. It also has the additional value of being able to pull information from multiple Dynamics GP companies.
This quick video shows how to use SmartList Builder to create a SmartList that will report data from multiple company databases: http://youtu.be/72cRzWKOpNw