|
|
Corporate ERP Reporting for Dynamics GP, SL, NAV, CRM notes - Alba Spectrum
Andrew Karasev
Corporate ERP and MRP II are coined standards in search engines keywords. And yet, you have to be sort of conservative when buying on what corporate MRP or corporate ERP really is. We would like to offer you small ERP publication, where reporting standards are considered for Microsoft Dynamics ERP applications: Great Plains, Axapta, Solomon, CRM, Navision
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. If your Microsoft Dynamics reporting requirements go beyond Financial Statements and you cannot find out-of-the-box report, 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
Andrew Karasev, Alba Spectrum LLC. http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577. Web portal: http://www.pegasplanet.com We are Microsoft Dynamics GP technology partner, ERP and software integrator, who serves you USA, Canada, Mexico and Latin America nationwide. Local service is available in Chicago, San Diego, Los Angeles, Houston: SAP BO and Dynamics GP. We have customer in the following business metros: Phoenix, New York, Boston, Milwaukee, Buffalo, Rhino, San Jose, Miami, Atlanta, Minneapolis, San Francisco, Detroit, Montreal, Las Vegas, Oceania, Colombia, Caribbean, Poland, UK, New Zealand, Australia
Author Site
4/16/2009
|
|
