|
Dynamics GP or Great Plains with Crystal Report
Besides the great and versatile built-in Microsoft Dynamics GP or Great Plains Report Writer, Crystal Report also offers another great tool to create financial reports that base on Dynamics GP data. The data can come from GP modules like Accounts Receivables, Accounts Payables, General Ledger, Inventory, Sales, Purchasing, Manufacturing, Project Accounting and many other modules.
Just like building Crystal reports for any other accounting software, a right data connection is the first thing that needs to be done correctly. The most convenient connection is to use the Sql Server Odbc connection to connect to GP database. Once the Odbc entry is correctly created, you can select it in a Crystal report to connect to GP modules for their data.
Either regular or formula data fields are readily placed on the reports. You can create a data source either based on a single GP table or linked multiple tables in GP. For the linked table data source, you could link the table in a Sql Server stored procedure, a view, or simple link them in a Crystal report. Once that is ready, just select the fields or create formula fields and place them on the reports. All the formatting like font and color for labels and data fields are just like the regular reports.
Because of the ability of accessing various modules in GP, a Crystal report can show data simultaneously come from Sales, Purchasing and Inventory for example. Also, because of the ability of using formula fields, the resulting Crystal reports can show GP data in many different ways.
All Great Plains or Dynamics GP windows and reports are ready to customize, you can use modifiers to change the appearances or values. If more advanced modification or customization is needed then VBA, Dexterity, Visual Studio Sdk are there to help. Great Plains has been in the accounting software marketing for many years, and it is one of the first software to convert to Windows environment from DOS. It is also one of the first accounting software to include the .Net in its tools, so the software has always been trying to be on top what are new with computers and operating systems.
Company: Viccomp, Inc.
|
| Related press releases |
Dynamics GP or Great Plains with Crystal Report [2008-09-04 16:35:52]
Besides the great and versatile built-in Microsoft Dynamics GP or Great Plains Report Writer, Crystal Report also offers another great tool to create financial reports that base on Dynamics GP data. ...
|
|
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 (...
|
|
Great Plains Dynamics upgrade notes Alba Spectrum [2007-09-22 04:08:07]
If your organization deploys GP Dynamics or eEnterprise ERP versions 7.5, 7.0, 6.0, 5.5, 5.0 or 4.0 you should consider upgrade scenarios, plus you should also consider reenrollment into Microsoft Bus...
|
|
Microsoft Dynamics SL or Solomon with Crystal Report [2008-09-04 16:40:14]
Crystal Report offers a great tool to create financial reports that base on Dynamics SL data. The data can come from SL modules like Accounts Receivables, Accounts Payables, General Ledger, Inventory...
|
|
Great Plains Version Upgrade Microsoft Dynamics GP installation notes Alba Spe... [2007-10-07 03:20:00]
Alba Spectrum Group: http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918
Microsoft Business Solutions Great Plains Dynamics GP version update technology seems to be str...
|
|
Crystal Reports for Microsoft Dynamics GP Great Plains Alba Spectrum [2007-10-22 04:56:11]
Crystal Reports Design for GP overview and typical FAQ
Microsoft Dynamics GP is successor of Great Plains Software Dynamics and eEnterprise ERP application, and Crystal Reports was always the repor...
|
|
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...
|
|
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...
|
|
Microsoft Dynamics GP Great Plains and MS CRM tandem as corporate ERP Alba Spe... [2007-09-08 06:16:58]
Alba Spectrum Group, http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918
Microsoft Dynamics ERP products family includes both Great Plains and Microsoft CRM, so it is i...
|
|
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 ...
|
|
|
|
| NET Reports Server PRO |
 NET Reports 2.0 Server - a Internet ready application; Fast Query & Report solution for Ms.Sql Server, Oracle, PostGreSql, MySql, Interbase, Firebird, MS. VFP. Sybase, MS. Access; Free client software from http://www.net-reports.net/downloads.html |
|
| Screen Paver |
 Screen Paver is an easy to use make-your-own slide show screen saver. The program will display an unlimited number of your own jpeg, png, or bitmap images from local and/or network directories. Plays music too. Great for digital camera users. |
|
| Amazon Price Watch |
 Amazon Price Watch help you to keep track of the price, get notice when hot item is available or price drops for your wishlist, and find great deals or filler items when you need a bit more for free shipping. |
|
| 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
