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! [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


    Study shows software used to predict repeat offenders is no better at it than untrained humans
    COMPAS, a piece of software commonly used in the justice system to predict which offenders will find themselves behind bars again, is no better than soliciting random people on Mechanical Turk to determine the same thing, a new study has found. Oh, and ...
    Software 'no more accurate than untrained humans' at judging reoffending riskThe Guardian
    Software Used to Make “Life-Altering” Decisions Is No Better Than Random People at Predicting RecidivismMother Jones
    Court software may be no more accurate than web survey takers in predicting criminal riskPhys.Org
    IEEE Spectrum -EurekAlert (press release) -ABA Journal
    all 17 news articles »

    GE's Strategy To Attack The Massive Software White Space Problem
    Throughout tech history, one of the main challenges for software has been that in order for a product to succeed, it has to solve a problem that is common to a wide variety of companies. The more common the problem, the bigger the total addressable ...

    Tom Siebel's billion-dollar software firm raises $100 million
    SAN FRANCISCO (Reuters) - C3 IoT, a software company founded and run by longtime Silicon Valley executive Thomas Siebel that helps companies collect and analyze data, has raised another $100 million in a new funding backed by TPG Growth, the company ...

    and more »

    Seattle Times

    More than half of Seattle's software developers were born outside US
    Seattle Times
    ... about 143,000 people in the Seattle-area civilian labor force are in IT occupations — software developers, computer programmers, systems analysts and so on. And nearly 57,000 of them, or 40 percent, were born in another country, according to my ...

    TOP500 News

    AI Software Outperforms Humans on Reading Comprehension Test
    TOP500 News
    Although that's a slim margin to claim superior performance, it represents the first time any natural language processing (NLP) software has been able to eclipse humans on this particular benchmark. Google, IBM, Facebook, TenCent, Samsung, Salesforce ...

    and more »


    Diversis Capital acquires Marketron, maker of monetization software ...
    Marketron, a company whose software helps radio and TV broadcasters manage their advertising, has a new owner and a new CEO. The company announced this morning that it has been acquired by private equity firm Diversis Capital. (The previous owner ...

    and more »

    Sun Sentinel

    Weston-based Ultimate Software named No. 1 tech workplace for third year
    Sun Sentinel
    Weston-based Ultimate Software was named top tech workplace for third consecutive year by Fortune magazine. Marcia Heroux PoundsContact ReporterSun Sentinel. Privacy Policy. Ultimate Software has been ranked No. 1 on Fortune magazine's “Best Workplaces ...
    Ultimate Software Named to Canada's 25 Best Workplaces for Inclusion ListBusiness Wire (press release)
    Ultimate Software Ranked #1 on Fortune's Best Workplaces in Technology List for Third Consecutive YearMarkets Insider

    all 11 news articles »

    Lake County expects to recoup campaign finance software costs
    Chicago Tribune
    After an eight-year wait for new campaign finance software never provided to the Lake County Board of Elections and Voter Registration officials may soon get their money back. The Lake County Board of Elections and Voter Registration on Tuesday ...

    Digital Journal

    Barcelona Council abandons Microsoft for open-source software
    Digital Journal
    The Spanish city of Barcelona has announced it will phase out its use of Microsoft software in favour of open-source alternatives. Over the next few years, the city will transition away from Microsoft's services to guarantee its "technical sovereignty ...


    BlackBerry launches cybersecurity software for self-driving cars
    Once initiated, automakers will have online access to Jarvis and can scan files at every stage of software development, the company said. Last year, the global “ransomware” attack, dubbed WannaCry, helped raise awareness of BlackBerry's security ...
    BlackBerry Doubles Down on Car Software With Hack ProtectionBloomberg
    BlackBerry debuts Jarvis software scanning platform at NAIASZDNet
    BlackBerry launches Jarvis code-scanning security tool for automotive softwareTechRepublic
    The Detroit News -CNET -The Sydney Morning Herald -QNX operating systems, development tools, and professional - QNX Software Systems
    all 107 news articles »
    Google News

    25 Things Mapping Software Can Do For You

    1. With mapping software you can create a report that... Read More

    Think Of This

    Think of this, first we had the HAM Radio, then... Read More

    Microsoft Great Plains implementation: Restaurants Supply Chain Management Example

    Microsoft Great Plains serves majority of US based horizontal and... Read More

    Best Spyware Removers

    Finding the best spyware removers to detect and remove spyware... Read More

    Recent Studies Show that 9 out of 10 PCs Are Infected with Spyware

    Spyware and malware are large problems for Internet users today... Read More

    Should I Use Windows Update?

    Should one use Windows Update?This topic has good and valid... Read More

    Professional XP Style Icons in Software and Website Development

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

    HSphere Control Panel Tips and Tricks - Power At Your Fingertips: Part 1

    The first topic we are going to discuss... Read More

    Downloading Spyware Removers: Think Before, not After

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

    The Opera Alternative

    Security flaws have long plagued Internet Explorer (IE), the market-dominating... Read More

    S is for Spying, Surveillance -- and for Software as Well

    Words we choose to describe things and phenomena often show... Read More

    Microsoft CRM Integration & Customization: SharePoint Document Gateway

    MS CRM is very close to document workflow automation, including... Read More

    What is Software Piracy?

    There are several kinds of software piracy. The bottom line... Read More

    Beware of The Pirated Software E-Mail Scams!

    You have gotten those E_Mails buy software at deep discounts.... Read More

    Theres Gold in Your Websites Server Log

    Many Webmasters have never bothered to view their website's server... Read More

    How to Evaluate Staffing Software

    If you are in the market for new staffing software,... 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

    The Secret of the Layer Styles Dialogue

    When you double-click a layer in the Layer Palette, you... Read More

    Managing Stress in the Computer Industry - Five Steps to a Stress-free Life

    It would be easy to think, like most people apparently... Read More

    10 Steps To Secure And Manage Your Passwords

    Passwords protect your most sensitive personal, financial and business information.... Read More

    Microsoft Great Plains Payroll Module Customization Scenarios

    It is now common thing when large corporation selects mid-market... Read More

    Algebra Help Software

    Need help making sense of algebra? Have algebra lectures in... Read More

    Intro to UNIX Shells

    A UNIX Shell is in simplest terms, a command line... Read More

    Artificial Intelligence And Intuition

    The intuitive algorithm.Roger Penrose considered it impossible. Thinking could never... Read More

    Anti-Spyware Protection ? Holes in the Shining Armor

    Looking at all the ads which promise to get rid... Read More