Inside Microsoft Dynamics GP

Get the latest inside scoop directly from the Product Marketing team!

Feature of the Day: Multicompany Excel Reports in a single worksheet

Feature of the Day: Multicompany Excel Reports in a single worksheet

  • Comments 1

Multicompany Excel Reports in a single worksheet using Excel Report Builder

Why this feature is cool!

 

In Microsoft Dynamics GP 2010 R2, you can now consolidate Excel reports data from multiple companies into a single Excel worksheet.  Additionally, you can add a calculated field to the report to display either the Company Name or Company ID field on each line to identify the source of the data.  This gives you the ability to centralize key information.

 

 

What does it look like?

 

 Navigation:  Dynamics GP menu > Tools > SmartList Builder > Excel Report  Builder > Excel Report Builder > Options button

 Navigation:  Dynamics GP menu > Tools > SmartList Builder > Excel Report  Builder > Excel Report Builder > Calculations button >> Add Calculated Field button

Leave a Comment
  • Please add 6 and 2 and type the answer here:
  • Post
Page 1 of 1 (1 items)