vinyl siding installation siding installation rolling meadows james hardie siding cary install vinyl siding long grove best siding .. Chicago Drug testing

Microsoft Great Plains Reporting ? Overview for Developer

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.

  • 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.
  • 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).
  • 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.
  • 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.
  • 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 direct web publishing is good taste.
  • 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 1-866-528-0577! help@albaspectrum.com

    Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies ? USA nationwide Great Plains, Microsoft CRM customization company, based in Chicago, California, Texas, New York, Florida, Georgia, Minnesota, Oregon, Arizona, Canada, UK, Australia and having locations in multiple states and internationally (www.albaspectrum.com), he is Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer.

    In The News:

    Information Products: A Business Owners Best Friend

    We live in a post-industrial age where information is the... Read More

    Editing Your Photos Using Microsoft Picture It Publishing Platinum 2002 - A Great Dinosaur

    I started using PIP (Picture It Publishing) Platinum 2002 right... Read More

    Software Upgrades Arent Always the Best Move

    When my daughter was getting into AOL instant messaging (AIM)... Read More

    Four Easy Ways To Prevent Spyware

    How would you like to prevent spyware and adware from... Read More

    10 Things You Could be Using Photoshop For, But Probably Arent

    Most people don't use Photoshop to its fullest capabilities. Here... Read More

    Brief Notes About Mainframe Software Pricing

    We don't think about mainframe software pricing anymore, we just... Read More

    Microsoft Great Plains Chemicals & Paint Industry Implementation & Customization Notes

    Microsoft Great Plains fits to majority of industries, in the... Read More

    Blind CC (Bcc): Master Its Use When E-Mailing

    If you use Microsoft Outlook (or similar applications) for e-mailing,... Read More

    Spyware Definitions List

    The adware and spyware definitions list is very long. But... Read More

    Microsoft Small Business Manager Customization Options - Overview

    Microsoft Business Solutions Small Business Manager is Great Plains Dexterity... Read More

    Simple Solution for Php Includes - IFrames

    I have recently created my first Php program. I wanted... Read More

    Scrap Booking Online: Word Perfect or Corel Graphics Suite?

    Scrapbooks are very popular these days. I think that almost... Read More

    Is Software Tester a Most Infamous Person in a Software Project Team?

    The fact that a software tester is a most infamous... Read More

    Antivirus Software ? Get The Bugs Before They Get You!

    You turn on your computer, and it doesn't look quite... Read More

    Upgrading Great Plains Dexterity Customization ? switching to new technologies: SQL, Crystal, eConne

    1. Replace Dexterity cursor with SQL Stored Procedure Dexterity... Read More

    Microsoft Great Plains: Interest Calculation Example ? Stored Procedure for Crystal Report

    This is intermediate level SQL scripting article for DB Administrator,... Read More

    A Simple Computer Software Definition

    What is Software?Software is a set of instruction written to... Read More

    Getting Patched with Windows Service Pack

    Are you one of those people that keeps track of... Read More

    The Religion And Philosophy Of Small Internet Business

    I have always had a tendency to focus on the... Read More

    OSI Layers Model

    IntroductionDuring the early years of our modern computer era, very... Read More

    Microsoft Great Plains Implementation & Customization: Computer Parts Retailer Example

    Microsoft Great Plains fits to majority of horizontals and retail... Read More

    Microsoft Great Plains eCommerce: overview for developer

    Microsoft Business Solutions Great Plains was designed back in the... Read More

    Microsoft Blues

    With the advent of 'Service Pack 2' for Windows XP... Read More

    Is Your Family Protected?

    When you think... Read More

    Defining OLAP Solutions and Data Warehouse design

    This tutorial covers OLAP solutions used by Data warehouses and... Read More

    led flood lighting fixtures led recessed lighting fixtures Pete's produce ..
    led flood lighting fixtures led recessed lighting fixtures Pete's produce ..