Reporting Tools For Microsoft Great Plains ? Overview For Developers
|
Looks like Microsoft Great Plains becomes more and more popular, partly because of Microsoft muscles behind it. Now it is targeted to the whole spectrum of horizontal and vertical market clientele. Small companies use Small Business Manager (which is based on the same technology ? Great Plains Dexterity dictionary and runtime), Great Plains Standard on MSDE is for small to midsize clients, and then Great Plains serves the rest of the market up to big corporations. There are several reporting tools available and you definitely need to know which one to use for different types of reports.
If you are developer who is asked: how do we create report for Microsoft Great Plains ? read this and you will have the clues on where to look further.
1. Great Plains Report Writer (ReportWriter) ? this is built-in reporting tool. All the original report in Great Plains are written in ReportWriter. ReportWriter itself is Dexterity module. You should use this tool if you would like to modify existing Great Plains reports, such as Blank Invoice Form - here you can place your company logo, change the positioning, fonts, colors, etc. ReportWriter will allow you also do new reports - simple option if you want to export all the records from one Great Plains table - use it. New report, however doesn't have interface where you would enter parameters - so it is not useful for real custom reports. Another limitation of ReportWriter - you can not do cross-modules report - when you need sales and purchasing info on the same report for example.
2. FRx. This is excellent tool when deal with financial reporting - it works on the General Ledger level (Balance sheet, P&L, Cash Flow Statement, etc.). It also allows you to do multiple companies consolidation - when you do consolidated Balance Sheet (with inter-companies transactions elimination).
3. Smart List - Export to Excel ? this is nice feature in Great Plains - you could create a list with simple criteria and then export it to Excel.
4. Crystal Reports. It gives you unlimited functionality. Obviously flexibility requires you to know Great Plains table structure: Launch Great Plains and go to Tools->Resource Description->Tables. Find the table in the proper series. If you are looking for the customers ? it should be RM00101 ? customer master file. If you need historical Sales Order Processing documents ? they are in SOP30200 ? Sales History Header file, etc. Create ODBC connection to GP Company database. Use the same technique as when you create standard ODBC connection for GP workstation ? but change default database to targeted company database. Create SQL Query to probe the data ? we always recommend tuning your query and see that you are getting adequate results ? in any case ? Crystal Report is just a nice tool to show the results of your query.
5. Direct Web Publishing off Great Plains databases ? yes - it is easy now with Visual Studio.Net and you can hire good programmers. This is good - Microsoft Business Solutions products: Great Plains, Solomon, Navision and Axapta will be integrated into so called Microsoft Business Portal - which will have web interface - you can get the idea if you look at Microsoft CRM web client - so derecti web publishing is good taste.
6. SQL Queries. If you have SQL background - this is great field for you. You know - with properly formatted SQL query you can realize simple EDI export/import for the integration with legacy systems.
Happy designing! if you want us to do the job - give us a call!
About The Author
Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies ? USA nationwide Microsoft CRM, Microsoft Great Plains customization company, based in Chicago, Boston, San Francisco, Los Angeles, Houston, Atlanta, and Miami and having locations in multiple states and internationally www.albaspectrum.com, he is Dexterity, SQL, VB/C#.Net, Crystal Reports and Microsoft CRM SDK developer.
1-866-528-0577 help@albaspectrum.com
|
|
|
How To Identify, Cure And Prevent Spyware/adware Infections
Just when you thought you were Web savvy, one more privacy, security, and functionality issue crops up - spyware. Installed on your computer without your consent, spyware software monitors or controls your computer use. It may be used to send you pop-up ads, redirect your computer to websites, monitor your Internet surfing, or record your keystrokes, which, in turn, could lead to identity theft.Many experienced Web users have learned how to recognize spyware, avoid it, and delete it. According to officials at the Federal Trade Commission (FTC), the nation's consumer protection agency, all computer users should get wise to the signs that spyware has been installed on their machines, and then take the appropriate steps to delete it....(related: Software)
Demand More From Your Lead Tracking Software
An integral part of any quality CRM system is lead tracking software. This is the part of the system that helps you gather customer data from your sales force. The ideal lead tracking software package, however, won't just tell you where the sales are coming from, but will help generate revenue by pointin...(related: Software)
Begun, The Browser Wars Have
As Mozilla Firefox nears 10% market share, with well over 25 million downloads direct from the makers website, and goodness knows how many through other sources, Microsoft announces that it will be releasing IE 7 ahead of schedule. Originally scheduled for release with Microsoft's new Longhorn operating system in 2006, it seems that Microsoft are reacting to the run away success that Firefox has had over the last few months. But is Microsoft's announcement just a response to Firefox's success, or is it tr...(related: Software)
Cosmic: A Small Improvement On The Symons Method
The COSMIC FP (function point) software quality metric, is no longer 'proposed' but an actual system in use and internationally recognised, whereas MarkII, like other older systems, is not recognised anywhere, and, even in the UK is in decline if not actually dormant, so this debate is already over.Historically, from my limited understanding of the situation, it seems that originally there were upwards of 35 variants of function point style metrics until the ISO developed criteria for a acceptable solution, ISO 14143: Parts 1 to 5 (1995-2002):The COSMIC group reviewed existing functional size measurement methods, namely the work done in the late 80's by Charles Symons in the UK. The aim was to improve on Albrecht's size index (IFPUG FPA)As stated in many sources, the most important feature...(related: Software)
Spyware Definitions List
The adware and spyware definitions list is very long. But the definitions listed below are the most common ones. This is a glossary of spyware facts and terms so you'll know what these mal...(related: Software)
Guide To Software Marketing
IntroThis concise article will tell you in plain English how you can promote your software easily and effectively.Submit your softwareI recommend submitting your software to upload.com. It costs $79 dollars a year, but is well worth it. It will display your product on download.com and its partner network made up of 20 other major download sites. Download.com is so popular that if your product was only listed on download.com it would still be worth the yearly fee.Use Rudenko's (submit.rudenko.com) software submission service to submit your software to hundreds of software archives. Unlike auto-submit programs, Rudenko has employees manually submit your software to each archive so it is l...(related: Software)
Google Brings The Earth To Your Desktop
Google Inc. has launched a new software package that allows you to see satellite images on your desktop.Google Earth lets you search for locations anywhere on earth and display 3D aerial images ...(related: Software)
Microsoft Great Plains Fa: Fixed Assets ? Overview For Consultant
Great Plains Fixed Assets Management module is a robust tool that can help you manage your assets effectively. It integrates perfectly with other Great Plains modules like General Ledger, Purchase Order Processing, and Payables Management ensuring accuracy while reducing redundant data entry.As with other Great Plains modules, save time and money by utilizing classes or groups to make mass changes. This is useful for depreciating, retiring, or simply changing the information for a set of assets with a single click. Great Plains' intuitive graphical user interface makes it easy to access supporting data on assets, books, etc. The latest versions of Great Plains Fixed Asset also comes with a total of 16 ...(related: Software)
Microsoft Crm For Corporate Business ? Working Offline
If your company has regional and worldwide operations, you might already realized that it is very hard to get decent internet connection in your remote locations. In this small article we will try to give you highlights on how to implement Microsoft Business Solutions CRM for worldwide operations with restricted internet connection.? Outlook Client. This was very bright idea from Microsoft side to have outlook client as a presentation for Microsoft CRM data. Outlook has such nice features as synchronization and then working offline. If you have outlook client for CRM ? you can download your customers, leads, contacts, and event properly programmed custom features, then work with them and finally synchronize them back to MS CRM database? MS CRM Integration. As the task itself it is not difficult or challenging ...(related: Software)
site-map - Copyright © 2008 | Contact Webmaster | All Rights Reserved. | Software