The author is a very experienced software developer for customizing or integrating Dynamics GP or Great Plains, please visit our website www.Viccompinc.com for more information.
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.
- Related Videos
- Related Articles
- Ask / Related Q&A
- Microsoft Dynamics Gp Implementation Faq
- Workflow in Microsoft Dynamics Gp 10.0
- Microsoft Dynamics Gp 10.0 – Improved and Enhanced
- Improve Cash Management Capabilities With Microsoft Dynamics Gp 10.0
- Microsoft Dynamics Gp – Typical Customizations
- Great Plains Integration Tools: Microsoft Dynamics Gp Integration Manager
- Microsoft Dynamics Gp 10.0 Customization Scenarios
- Microsoft Dynamics Gp 10.0 Technical Notes or Under the Hood
How to Convert DRM Protected WMA WMV to Plain MP3 MP4?
By: Kindour | 03/01/2010The following article is going to show you how to remove DRM protection from purchased WMA WMV files and convert DRM protected WMA WMV to plain MP3 MP4 so that you can play them on iPod, iPhone, Zune, PSP, BlackBerry, Creative Zen, burn them to DVD discs, etc.
DSi Download Center website – Is DSi Download Center Legitimate?
By: Peter Jackson | 03/01/2010Have you heard of a dsi download website called DSi Download Center ?DSi Download Center is a collection of games, movies, music and software database designed specially to be used on Nintendo DSi console. The services are created and run by programmers with the software download service for their member. Here comes the question “Is DSi Download Center legitimate?” many would feel skeptical after visiting the website. In this article, I will show you the actual information.
Download Games,Movies and Software for your Dsi for life please read more about the Best Dsi Download Site!
By: Peter Jackson | 03/01/2010Nintendo Dsi is one of the most popular handheld devices today with features such as a webcam and the ability to download Dsi games. However, most people don’t know how to download Dsi games. Well there are many ways to download your Games to your Dsi and there are many sites that will rip you off and give you hardly any downloads for what you paid for.
unlimited downloads for dsi
By: Peter Jackson | 03/01/2010The Dsi is one of the greatest Nintendohandheld gaming devices that has had the pleasure of reaching the shores of the USA. The Dsi holds great features such as internet connectivity and the ability to download games directly on it. The main place people normally go that have the Dsi go to for their Dsi downloads needs is the Dsi shop which you will have to earn points in order to download a single game. Well if you have the time to wait to build up points to download one single game you truly
Where To Download Nintendo DS And DSi Games For Free ?
By: Peter Jackson | 03/01/2010If you are looking for free Nintendo DS and DSi game downloads I would say forget about it there is no such thing as free lunch. Nobody offer anything for free there is always a price to pay. But in reality, you can really get to download Nintendo Ds and DSi games for free at any download site and torrent, but they offer you nothing than malicious software and virus with the purpose to attack your computer and hijack your personal information. If you want to download clean Dsi games safely you w
Download for DSI: Using Supercard for Ultimate Gaming
By: Peter Jackson | 03/01/2010Gamers lie you who have experienced the difference of Nintendo DSI will surely look for ways to download the games for free. Although there are so many websites now offering free download for DSI, you have one remaining problem and this is the kind of card that you will use. Many people have managed to come up with hacking software that allowed them to make copies of the games and even distribute them. However, the gamers do not have the right tools to store the games. This means that you have a
Learn how to download Dsi Games and get unlimited DSi Games for your console
By: Peter Jackson | 03/01/2010I bought a Nintendo Dsi and am loving it just now, However I wanted to be able to Download DSi Games like I do on my Nintendo Wii. I have found the solution for all of you looking for Nintendo DSi Downloads. These days with the internet there is a wealth of information out there on all sorts of products, information websites. I was looking for nintendo dis downloads. I was surprised how little information there was out there. You can now download games for the wii, xbox and playstation 2 but i
DSi Download Center - Honest Review
By: Peter Jackson | 03/01/2010DSi Download Center is the world largest downloadable DSi games database. Normally, you need to purchase a game cartridge in order to play Nintendo DSi game. But with the power of internet you can access to a collection of DSi download database with your finger tip. The website is legitimate and granted the rights to distribute DSi software.
Dynamics Sl or Solomon With Crystal Report
By: Tenny | 04/09/2008 | SoftwareCrystal 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, Cash Manager, Purchasing, Requisitions, Project Controller, and many other modules.
Dynamics Sl or Solomon Voucher and Adjustment Entry
By: Tenny | 04/09/2008 | SoftwareMicrosoft Dynamics SL or Solomon has a Voucher and Adjustment Entry in the Accounts Payable module that is very useful for businesses that purchase and sell products or items from the vendors and to the customers. You can enter documents like vouchers, debit adjustments, and credit adjustments with the entry, and then release the documents for further processes like selection for payment and other tasks.
Dynamics Sl or Solomon Customization Manager
By: Tenny | 04/09/2008 | SoftwareDynamics SL or Solomon enables software developers and users to modify standard Solomon screens easily and efficiently. It can be a simple changes that the manager or user can make, or complex customizations that the software developer or consultant with Visual Basic programming and Sql statement experience will do.
Gp Web Services a Tool for External Applications to Work With Dynamics Gp
By: Tenny | 04/09/2008 | SoftwareMicrosoft Dynamics GP provides the Web Services for Microsoft Dynamics GP for external applications to integrate with the data contained in the Microsoft Dynamics GP. eConnect acts as the middle engine internally to do the integration and business rules enforcement, therefore it provides an additional reliability to the Web Services tool.
Dynamics Gp or Great Plains With Crystal Report
By: Tenny | 04/09/2008 | SoftwareBesides 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.
Dynamics Gp or Great Plains Purchasing Receivings Entry
By: Tenny | 04/09/2008 | SoftwareMicrosoft Dynamics GP or Great Plains has a Receivings Transaction Entry in the Purchasing module that is very useful for businesses that purchase and receive items from the suppliers or vendors. You can enter receiving entries for types like shipment, shipment/invoice and in-transit inventory with the Receivings Transaction Entry.
Dynamics Gp or Great Plains Purchase Order Entry
By: Tenny | 04/09/2008 | SoftwareMicrosoft Dynamics GP or Great Plains has a Purchase Order Entry in the Purchasing module that is very useful for businesses that purchase products or items to the suppliers or vendors. You can enter purchase orders for types like drop ship and standard orders with the Purchase Order Entry.