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! [email protected]

    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 (, he is Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer.

    In The News:

    This RSS feed URL is deprecated, please update. New URLs can be found in the footers at

    Wall Street Journal

    Fiat Chrysler Recalls 5.3 Million Vehicles for Cruise Control Software Glitch
    Wall Street Journal
    The recall is the largest by Fiat Chrysler since an air bag-related announcement two years ago affecting 4.3 million of its vehicles and is the latest in the series of retroactive product fixes by the auto maker, some prompted by deficient software.
    FCA Recalls 4.8 Million Vehicles Over Software IssueMotor Trend
    Fiat Chrysler software fix prompts recall of 4.8 mn vehiclesPhys.Org
    Fiat Chrysler Automobiles (FCAU) to Recall 4.8M Vehicles for Software
    Bloomberg -The Verge -NHTSA -CNNMoney
    all 144 news articles »


    ZeppelinOS Software Launch Promises Easier Fix for Ethereum Contracts
    Unfixable ethereum smart contract errors might soon be a thing of the past. While such bugs can cause any number of issues for blockchain operators today, a startup called Smart Contract Solutions is launching ZeppelinOS, a release that marks the ...


    With Here OTA Connect, Over-the-Air Software Updates Finally Become Common For Cars
    As cars become more software dependent, the need for over-the-air (OTA) software updates has become more critical. Except for Tesla, automaker have delayed rolling out OTA updates that not only keep vehicle electronics current, but also save car owners ...

    and more »


    Facial recognition software could help endangered primates, slow illegal trafficking
    Science Daily
    Facial recognition software could help endangered primates, slow illegal trafficking. Date: May 24, 2018; Source: Michigan State University; Summary: New facial recognition software can help protect endangered primates -- more than 60 percent of which ...
    New Facial Recognition Software Tracks and Protects Endangered PrimatesFuturism

    all 3 news articles »

    Dayton Daily News

    Kessel Run hits hyperdrive to build combat software
    Dayton Daily News
    “We're all consumers of this software,” said Michael, a government civilian intelligence analyst at the 15th Intelligence Squadron at Langley Air Force Base, Virginia, on his first day at KREL. “Sometimes your job is just to make a system that is 15 ...

    and more »


    FDA Approves AI-Based Software for Wrist Fracture Detection
    The US Food and Drug Administration (FDA) approved computer-aided detection and diagnostic software called OsteoDetect to speed the diagnosis of wrist fractures in adults, the agency announced yesterday. OsteoDetect, from Imagen, in New York City, ...
    FDA authorizes marketing of OsteoDetect software for detecting wrist
    FDA Green Lights OsteoDetect, AI-Guided Software for Wrist Fracture IdentificationMD Magazine

    all 5 news articles »


    US bill would force tech companies to disclose foreign software probes
    U.S. tech companies would be forced to disclose if they allowed American adversaries, like Russia and China, to examine the inner workings of software sold to the U.S. military under proposed legislation, Senate staff told Reuters on Thursday. The bill ...
    House debates defense bill that authorizes smaller nukes, space force and a military parade.USA TODAY

    all 50 news articles »


    Best payroll software 2018
    The software also provides you with the tools to make tax calculations and automatically submits payment data to HMRC, ensuring your company is fully compliant with the latest tax laws. When it comes to managing employees, you're able to track working ...

    Bill: Tech Firms Must Disclose US Adversaries' Software Reviews
    A new bill would require U.S. tech companies to disclose if they allowed American adversaries to examine software sold to the U.S. military. The bill, approved by the Senate Armed Services Committee, comes after Reuters discovered that tech companies ...
    Tech companies to disclose foreign software probes under US Bill ...ZDNet

    all 3 news articles »


    Best video conferencing software of 2018
    Working on the move, working from home, and working from abroad are all commonplace in businesses both big and small, creating an ever-expanding market for video conferencing software. Not only do employees enjoy breaking free from the shackles of ...

    Google News

    What is Groupware?

    Vince Lombardi once said that, "The achievements of an organization... Read More

    Microsoft CRM Customization

    Microsoft CRM customization techniques are very diversified and based on... Read More

    Lotus Domino/Notes - Microsoft Great Plains Tandem as ERP with Documents Workflow - Overview for IT

    Lotus Domino/Notes ? Microsoft Great Plains tandem as ERP with... Read More

    Does your Company have Documentum?

    Are you lost in the mess of documents that get... Read More

    Brand Your Websites URL With a Favicon

    Have you ever noticed that when you look at your... Read More

    Microsoft Great Plains Data Conversion ? Overview For Developer

    Looks like Microsoft Great Plains becomes more and more popular,... Read More

    Brief Notes About Mainframe Software Pricing

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

    New SQL Delta Version 3.1

    COMMAND LINE FUNCTIONA powerful command line script processor has been... Read More

    Make or Break Factors - When Considering Estimating Software

    Make-or-Break Factors in Success and ProfitabilityFor quick printers, estimating can... Read More

    Lotus Domino: Reports and Connectors ? Crystal Reports, XML, ODBC/JDBC, OLE

    Lotus Notes Domino is very efficient in electronic document workflow... Read More

    Microsoft CRM Customization Secrets ? Second Edition

    This article is for advanced Microsoft CRM SDK C# developers.... Read More

    PHP On-The-Fly!

    IntroductionPHP can be used for a lot of different things,... Read More

    Groove Network. Are you in it?

    If you are in a business that passes documents around... Read More

    Lowering The Risks In Developing Do-It-Yourself Software Projects

    Mike Dunville* had a decision to make. As the new... Read More

    Great Plains Accounting Migration to Microsoft Great Plains - Overview for IT Specialist

    This is a short article, written in question/answer/FAQ style to... Read More

    Windows Screensavers Explained

    In this article you will find some background information about... Read More

    Microsoft Great Plains Security Setup - Overview For Consultant

    Microsoft Business Solutions Great Plains is very good fit for... Read More

    Groupware and Online Collaboration: Collaboration Series #4

    This article is the fourth of a series of articles... Read More

    Daffodil DB: Web Database

    What is a Web Database?A web database is a database... Read More

    Popular Fleet Maintenance Programs

    Some companies that are in need of fleet management may... Read More

    Great Plains Sales Order Processing and Invoicing Modules ? Tips For Consultants

    We'll give you non formal view, based on our consulting... Read More

    Why Stick With Email Clients Like Outlook?

    Trying to figure out a stream in banning one email... Read More

    MySQL for Beginners ? How to Create a MySQL Database

    Whether you are an experienced web programmer or a complete... Read More

    Navision Customization: C/SIDE, C/ODBC, C/FRONT, XBRL ? Development Options

    Microsoft bought Navision, Denmark based software development company, along with... Read More

    Best Practices In Choosing Network Monitoring Software

    Blue Cross and Blue Shield of Hawaii (HMSA) found itself... Read More