Multi-Company Reports in Microsoft Dynamics GP
Posted on: March 3, 2012 | By: SuperUser Account | Microsoft Dynamics GP
No matter how many great solutions Microsoft develops, Excel is still a key tool the accounting and finance teams use to analyze data. Microsoft Dynamics GP has great tools like Management Reporter and standard Dynamics GP reports, but Excel always is an important tool.
As a Microsoft Dynamics GP partner our consultants at Logan Consulting are constantly asked for ways to use Excel to analyze data. One of the best tools is Excel Report Builder that is available with Microsoft Dynamics GP 2010 R2. Excel Report Builder allows you to use the familiar Excel interface to query data in Dynamics GP. A common need for our clients is to look at data for multiple companies in Excel.
Thankfully our friends at Microsoft recently posted some good information on how to do this. Click here to see how you can create multi-company reports using the Excel Report Builder.