|
Great Plains Reports: how to create and typical design tools Alba Spectrum
Microsoft Dynamics GP reporting is essential part of GP implementation and post production ERP support. As for typical mid-size MRP application, you should expect multiple reporting tools, especially if you think about reports genre: financial reporting, business processes specific reports, etc. Also, when Microsoft incorporated MS SQL Server Reporting Services or SRS and kind of recommended it over former tool of the choice Crystal Reports, you should do your homework on selecting reporting tool which will do proposed and expected job. In this article we would like to review major reporting tools for Microsoft Great Plains and give you orientation session:
1. Great Plains ReportWriter or RW. This tool is incorporated into GP Dexterity environment, meaning that it works from the GP user interface and within Great Plains security realm. RW is the tools you should look at first when you are customizing something which you call from GP interface: Sales Order Processing invoice form, for example. Do not expect too much from Report Writer, as it has numerous restrictions: it can work from existing GP screens only where parameter sets are predefined by GP existing standard logic. If you would like to create custom reports in RW and call it from GP interface with custom parameter selection form, you will have to create GP Dexterity customization and call your report from there
2. Crystal Reports and SRS. These two report design tools are competing on the market and in some features similar. When you base you GP reporting logic in SQL Stored Procedures, the final report printing could be done with the same success from CR and SRS, so it probably the question which tool is the most comfortable for you from your skills and experience. The advantage of SRS and CR is the following you can create really cross-modules and all-nightly report. You should also consider comparing stored proc over SQL view, stored procedure allows you to submit parameters and create temporary tables in your SQL script code these are what you can not do in the SQL views. However if you are looking in the creation of pure financial reports: Profit & Loss Statement, Balance Sheet and Cash Flow you need to keep reading
3. FRx. FRX Report Designer advantage over Crystal and SRS is the connection to General Ledger GP interface. In FRx you can also cross company boundaries and create consolidated report. FRx allows you to create so called reporting trees, where you can create report by specific GP segments in multiple companies. Plus, FRx give you the link to Excel worksheet, where you have something like small branch accounting data, which you would like to see consolidated with corporate income statement
4. Microsoft Excel reporting options. Imagine that you recognize the fact that most of your people in Accounting department trust to MS Excel only and do not follow corporate procedures to use complex tools, such as MS Outlook or even Microsoft CRM. In GP you can easily export data to Excel from Smart List or more advanced tool Smart List Builder, where you can create views based you custom SQL expressions
5. SQL Select statement. If your reporting and data mining and discovery needs are changing every day, and creation of permanent Crystal Reports is not feasible, and if you have decent SQL programmer and developer in staff, you should consider ad-hoc SQL scripting with export to Excel to produce required reports. You should be aware, that if your managers require you to build data warehouses on the daily basis, then you should implement SQL Analytical Services with Excel Pivoting tables or Cognos
6. Microsoft Access Reporting option. If your IT people expertise covers MS Access, consider using ODBC connection to GP database and use Access Reports
7. MS Visual Studio.Net custom programming reports. If you have strong C# and VB developers, you should consider training them in eConnect and then they should be capable to build web reporting applications. In the case if you would like to extend eConnect logic with direct access to GP tables, please review GP tables structure Microsoft Dynamics GP->Tools->Resource Description->Tables
8. Archaic DB platforms. If you are still on GP 7.5 and earlier, you may be using Pervasive SQL Server 2000 or Ctree/Faircom. If this is your case, you have to use one of the following tools: MS Access, Crystal Reports (where you are restricted to ODBC driver limitations to cross GP modules restrictions), or GP Dexterity customization. Also if you are on old version you should consider upgrade if you business is in active mode current version of GP is 10.0 and you have to use GP migration tool to MS SQL Server version
9. Cross-Platform Reporting. Here we recommend you to review first MS SQL Server linked server concept, also you can consider similar tools from Oracle EDI.
10. Generic ERP reporting. If you are on PeopleSoft, Oracle EBusiness Suite, Peachtree, MYOB. Then reporting tool requires homework
Andrew Karasev, Alba Spectrum Group, http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918. Serving GP customers in Illinois, Texas, California, Florida, Wisconsin, New York, Michigan and USA and Canada nation wide via remote support. Our service is popular in USA country side, where you do not expect local consultants to be available and we cover the whole country with travel onside with initial user training then we typically save your budget by convenient remote support, as we already are familiar with your key IT and accounting personnel. Local service is available in Chicago, Houston, Naperville, Oakbrook, Wheaton, Joliet, Plainfield, Aurora, Elgin, Springfield, Morris, Ottawa, LaSalle, Channahon, Brookfield, Villa Park, Downers Grove, Lisle, Hinsdale, Lincolnwood, Zion, Kankakee, Braidwood, Niles.
|
Company: Alba Spectrum Group
| Related press releases |
Great Plains Reports Design: Crystal, SRS, MS Access, Excel, ReportWriter, Dexte... [2008-06-22 16:19:02]
Microsoft Dynamics GP is successor of former Great Plains Dynamics and eEnterprise, current GP version is 10.0. Since the time when GP became exclusively available on MS SQL Server DB platform only (...
|
|
Microsoft Great Plains Boca Raton, FL Alba Spectrum Group [2007-12-23 04:52:45]
Microsoft Business Solutions Great Plains is gaining market share as we write these lines. Alba Spectrum Group is announcing its Florida GP consultants headcount increase. If you have concerns about...
|
|
eConnect Posting Extension: Alba Spectrum Autoposting Server [2008-05-21 22:54:55]
If you are ecommerce developer, who are programming in C# or VB.Net with some SQL stored procedures, then more likely you are deploying Microsoft Dynamics GP eConnect SDK to integrate eCommerce websit...
|
|
Ecommerce design for Microsoft Dynamics GP Great Plains Alba Spectrum [2007-08-18 03:29:33]
Alba Spectrum Group http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918
Microsoft Great Plains backed ecommerce websites are very popular and considering Alba Spectrum ...
|
|
Microsoft Dynamics GP 10.0 Visual Studio Development notes Alba Spectrum [2007-08-26 04:23:08]
Alba Spectrum Group, http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918
If you are eCommerce programmer and plan to dive into Microsoft Great Plains e-commerce web des...
|
|
Microsoft Great Plains Software development: typical scenarios in Sales Order Pr... [2008-01-14 08:29:55]
Microsoft Dynamics GP has a set of SDK and programming tools to enable business logic customization for software developers. You can utilize Extender, VBA with Modifier, direct SQL scripting as well ...
|
|
Microsoft Dynamics GP 10.0 Project Green Advances or future ERP trends Alba Sp... [2007-08-23 04:21:37]
Alba Spectrum Group, http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918
In around 2003 Microsoft stated about Project Green that it will be merging several Microsoft j...
|
|
Microsoft Dynamics GP 10.0 Reporting: traditional and new tools Alba Spectrum [2007-07-28 03:48:40]
Alba Spectrum Group http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918
Microsoft Great Plains version 10.0 was released in Summer 2007. If you support GP ERP in your ...
|
|
Upgrading to Microsoft Great Plains 10.0 Alba Spectrum Chicago [2007-08-07 07:15:48]
Alba Spectrum Group, http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918
Microsoft Dynamics GP upgrade service in Chicagoland: downtown Chicago, Chicago Southwest subur...
|
|
Microsoft Dynamics GP Great Plains Integration and Upgrade Service in Chicago ... [2007-11-02 07:45:12]
Former Great Plains Software, later on Microsoft Business Solutions Great Plains and currently finally Microsoft Dynamics GP ERP application serves to midsize and large US businesses, also it has Cana...
|
|
|
|
| Time Boss |
 Transcendent award-winning parental control software. Time Boss gives You an ability to manage exactly what, when and how long other user can do on the computer and offers adjusted powerful tools combining with user-friendly multilingual interface. |
|
| CD and DVD Jewel Case and Label Creator |
 Now you can create your own beautiful and professional CD and DVD Jewel Cases and Labels in just minutes! Perfect for business, home, or hobby. Works with any type of paper or CD label, DVD Label, or Jewel Case! |
|
| Pure SEO CMS |
 Fast, powerful, SEO website builder, optimized CMS, CSS compliant. Fast, client side XML to html engine. Beginners enter content and select design. Experts use their own templates and save time building high quality sites . No online server required. |
|
| Hex Workshop |
 Hex Workshop is a set of hexadecimal development tools for Windows that combines advanced binary editing with the ease and flexibility of a word processor. |
|
| QIOS Pelican |
 Use QIOS Pelican to send personalized, bulk or mass e-mail to contacts in data sources, such as Microsoft SQL Server, Exchange, Access, Outlook, Excel, Oracle or MySQL. Define fields in your message and apply the datasource to create the e-mail. |
|
| PixFiler |
 An easy way to catalogue and share your digital photos. Annotate and categorize your photos. Locate any photo in seconds. Create CDs, web-pages, and prints of selected photos. View EXIF metadata. Supports RAW formats for more than 100 cameras. |
|
| SnapaShot |
 Smallest free screen capture tool, SnapaShot is great for taking screenshots of different size. Just open Snapa, resize its window to fit the area you want to save, and press "save it" button. |
|
|
Latest press releases
