Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/a26f9f83/public_html/articles/includes/config.php on line 159
Microsoft Great Plains Reporting ? Overview for Developer > NetSparsh - Viral Content you Love & Share

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!

    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


    It's time to regulate: The US must make software companies liable for breaches
    The software industry has failed to sufficiently protect the public from data theft and misuse. It's time for the U.S. government to get serious about regulation. Last year, multiple U.S. government agencies established guidelines for improved ...


    Pivotal Software files for IPO | TechCrunch
    The enterprise cloud computing company is majority-owned by Dell, which came about after its merger with EMC in 2016. It was spun off from Dell, EMC and VMware in April 2013. Since then, it raised $1.7 billion in funding from Microsoft, Ford and ...
    3 Takeaways From the New Pivotal Software Upcoming IPOFortune
    Dell-Backed Software Firm Pivotal Files For IPOForbes
    Pivotal Software IPO S-1 prospectus filing - CNBC.comCNBC
    Wall Street Journal -MarketWatch
    all 24 news articles »


    Cloud Software Stocks Rise on M&A Hopes - Barron's
    What emerged from the market swoon of February was a surprising surge in the shares of young software companies. These cloud-oriented companies are heading skyward on renewed mergers-and-acquisitions fervor. Since the Nasdaq's bottom on Feb. 8, at 6 ...

    and more »

    24/7 Wall St.

    Pivotal Software Gears Up for IPO
    24/7 Wall St.
    Pivotal Software has filed an S-1 form with the U.S. Securities and Exchange Commission (SEC) regarding its initial public offering. No pricing details were given in the filing, although the offering is valued up to $100 million, but this is normally ...


    Popular tax software may expose users to phishing attacks
    A new report by security research firm Global Cyber Alliance finds that some of the most popular tax software providers may leave consumers at risk for identity theft.

    and more »

    The Register

    UK Court of Appeal settles reseller's question: Is software a good ...
    The Register
    Software is not a good, the Court of Appeal in London, England, has ruled. More specifically, software is not a "good" as defined in the Commercial Agents EU Regulations, said the civil court in a ruling that overturns an earlier decision granting ...

    and more »

    Electronic Design

    What's All This Software Stuff, Anyhow?
    Electronic Design
    More bad software comes out of the USA than anywhere else. Think of those old HPGL plotter drivers. Indeed, a recent article in the Atlantic Monthly was titled “The Coming Software Apocalypse.” The URL base-name is equally amusing, “saving-the-world ...

    Software helps NY college students track progress toward degree
    Nassau Community College is boosting its efforts to increase student retention and on-time graduation through a new software program called DegreeWorks. The web-based auditing software allows students to see what courses they need, what order to take ...

    The Register

    UK Court of Appeal settles reseller's question: Is software a good?
    The Register
    Lady Justice Gloster of the Court of Appeal agreed with CA that "on a proper construction of the language in the regulations, the software did not constitute 'goods' within the meaning of Regulation 2(1)". The software itself was only ever supplied as ...


    Refreshed iPad and software to be focus of education event, cheaper MacBook reportedly not ready
    There's also a chance Apple will unveil a new version of its iBooks Author software to allow teachers to make their own teaching materials, as well as a renewed push to bring textbooks into the digital era. We may also see Apple announce the release ...
    Apple to launch low-cost iPad and educational software next week: BloombergBGR India
    What to expect at Apple's education eventQuartz
    Apple is working on a 'foldable' iPhone for release in 2020, says Bank of AmericaCNBC
    Bloomberg -Emojipedia Blog
    all 453 news articles »
    Google News

    The Death of Windows

    I have always regretted how Microsoft price gouges and rips... Read More

    Protect Your Computer...and Your Business!

    We all take the computer for granted. I mean, all... Read More

    Five Steps to Rapid Development with TierDeveloper 4.0

    Follow the steps below to quickly design, generate, and deploy... Read More

    Most Dangerous Types of Spyware are on the Rise: How to Choose the Weapon

    Bad News - the Threat is Bigger than it SeemedHow... Read More

    Microsoft Great Plains Implementation & Customization: Computer Parts Retailer Example

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

    Professional XP Style Icons in Software and Website Development

    Using professional icons in your application or website can bring... Read More

    Introduction To ISDN, Part II

    In the previous ISDN article, we looked at how and... Read More

    Microsoft Office Selecting Secrets

    Stop the Runaway MouseWhat's the "runaway mouse?" You've seen Read More

    Dreamweaver vs FrontPage

    There are two major WYSIWYG(What You See Is What You... Read More

    Groupware: Answers the 5 Questions of Document Collaboration

    Every organization which creates collaborative documents, whether they are budgets,... Read More

    6 Easy Steps for a Smoother CD/DVD Order

    It's all about turn times in the eMedia industry! The... Read More

    Need of Document Management System (DMS)

    Document Management or Enterprise Information Management is perhaps one of... Read More

    Tripwire for Linux File Integrity

    What is Tripwire?Tripwire is a form intrusion detection system (IDS)... Read More

    About Microsoft Sysprep (System Preparation) Utility (Windows 2000)

    The Microsoft system preparation utility for Windows 2000 is a... Read More

    Microsoft CRM and No-Frills Cadillacs

    In today's business world it's all but impossible to escape... Read More

    Downloading Spyware Removers: Think Before, not After

    Just imagine: you are walking, say, towards your car, and... Read More

    3 Reasons Why Medical Billing Software is Leading the Way

    Since technology changes so quickly, it is hard to begin... Read More

    SQL: Querying Microsoft Great Plains ? Overview for Database Administrator/Developer

    Looks like Microsoft Great Plains becomes more... Read More

    10 Ways to Learn a Software

    Following tips help you to learn a software in lesser... Read More

    ERP for Large Corporation ? New Selling Strategy

    Our opinion is based on our Microsoft Business Solutions Great... Read More

    Dont Choose Adobe When Working With PDF

    While Adobe is the most known maker of PDF tools,... Read More

    Do You Know These Facts About Spyware ?

    Imagine something that follows you home and sets itself up... Read More

    Bridging the Gap between Paper and Data

    The cornerstone of successful automated office systems is the ability... Read More

    Microsoft CRM Integration with Microsoft Retail Management System (RMS) ? Overview

    Microsoft Client Relation Management system (Microsoft CRM) and Microsoft RMS... Read More

    Run Your Own Search Engine

    Our hosted solution allow you to run your own search... Read More