Reporting for Microsoft Dynamics GP, SL, NAV, CRM notes

Apr 17
07:27

2009

Andrew Karasev

Andrew Karasev

  • Share this article on Facebook
  • Share this article on Twitter
  • Share this article on Linkedin

Reporting tool selection may seem to be very important, and in fact you have to distinguish between so-called Financial Reporting: Consolidated or Single company Balance Sheet, Profit and Loss, Statement of Cash Flow – these are typically done in FRx Financial Reporting, please see our additional publications on FRx.

mediaimage

If your Microsoft Dynamics reporting requirements go beyond Financial Statements and you cannot find out-of-the-box report,Reporting for Microsoft Dynamics GP, SL, NAV, CRM notes  Articles then you should think about typical managerial reporting tool: Crystal Reports, Microsoft SQL Server Reporting Services, Microsoft Access Reporting, MS Excel or even MS SQL Server Query, saved to the text file and opened in Excel.  Let’s come through highlights:

1.       Microsoft CRM.  Especially for version 4.0, which is current, you should consider creating reports in Report Wizard in SSRS or Microsoft SQL Server Reporting Services.  Wizard gives you pretty good start and then if you need additional logic to be introduced, and if you are Visual Studio .Net developer – feel free to import newly created reporting into MS VS reporting project and work on its perfection.  If you do not have programming expertise in-house, you can consider creating SQL Stored Procedure or SQL View in specially created custom SQL Server DB (please do not create custom objects in your MS CRM company database) and base Crystal Reports on these procedures and views.  Here, again you need to know that SSRS is more flexible to be deployed on WWW versus CR (SSRS license is virtually free for existing MS SQL Server purchase)

 

2.       Great Plains Dynamics GP.  Here, you should review set of available ReportWriter reports (in Dynamics GP Reports section), then look at SSRS reports (here you will need to install them from GP CD #2 and we recommend them if you are on Dynamics GP version 10.0).  Then, if your goals are not achieved, please consider CR.  Good tactic is to create Microsoft SQL Server stored procedure or view and use them as the base for your Crystal Reports

 

3.       Dynamics SL or Solomon.  Here you are in very similar to Great Plains situation.  If you are not happy with existing reports, feel free to create new custom reports in Crystal

 

4.       Navision Dynamics NAV.  Navision is a bit different, as its design is coming from C/Side shell.  If you are still on native Navision C/Side database, you are likely working with C/ODBC module, if you moved to NAV on Microsoft SQL Server 2000 or 2005, then you should know that Navision companies are hosted in single MS SQL Server Database and each Navision table in this database has company ID prefix.  We recommend you to resolve Navision reporting in MS SQL Server View or Stored Procedure and then pull the results in Crystal or SSRS