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

    Rolling Meadows Cadillac Escalade rental .. Lockport Chicago limo O’Hare
    In The News:

    Hertz, the rental car giant, recently confirmed that customer information was exposed through a cyberattack on one of its software vendors.
    There are a number of features with AirPods you may or may not know about to take your listening experience to the next level. Kurt the CyberGuy explains.
    These 35 Chrome extensions have privacy and security concerns. Tech expert Kurt “CyberGuy" Knutsson says to delete them now.
    Tech expert Kurt “CyberGuy" Knutsson says 329,000 mph fusion rocket promises to be fast, disruptive and enable deep-space missions.
    Stay up to date on the latest AI technology advancements and learn about the challenges and opportunities AI presents now and for the future.
    Tech expert Kurt “CyberGuy" Knutsson says a new autonomous AI is a game changer that also raises privacy risks. Is your data safe?
    Tech expert Kurt “CyberGuy" Knutsson says robots and drones are revolutionizing fruit farming with faster picking and smarter handling.
    Landmark Admin revises May 2024 cyberattack scope to show twice as many people were affected. Kurt “CyberGuy" Knutsson gives tips to help stay safe from an insurance data breach.
    Tech expert Kurt “CyberGuy" Knutsson talks about how Yamaha’s hydrogen outboard motor could revolutionize boating with zero emissions.
    Tech expert Kurt “CyberGuy" Knutsson reveals how to memorialize or remove a deceased loved one’s Facebook account and protect their digital legacy from misuse or scams.
    Tech expert Kurt “CyberGuy" Knutsson says an Apple Watch saved psychiatrist Amanda Faulkner by detecting deadly leukemia early.
    Scammers and fraudsters are increasingly targeting the most vulnerable, especially nursing homes and the personal data of their residents. Kurt the CyberGuy has safety tips.
    Infected USB flash drives can spread malware among multiple organizations in ways that can easily bypass traditional security systems.
    With a fully automated warehouse system and AI-powered robots, Ocado's Hive picks, packs and delivers grocery store orders in just a few minutes.
    Stay up to date on the latest AI technology advancements and learn about the challenges and opportunities AI presents now and for the future.
    Recycling robots are using artificial intelligence to learn how to sort recyclables by recognizing patterns in colors, textures, shapes and logos.
    The Reachy 2 robot is designed to be friendly and approachable, inviting natural interaction and is perfect for research, education and experimenting with embodied AI.
    Kurt "CyberGuy" Knutsson shares several easy ways to keep your credit cards safe from digital thieves while you're traveling this summer.
    Arcturus sets up cameras around the edges of baseball stadiums to capture real-time action and generate a 3D digital clone of the game.
    Stay up to date on the latest AI technology advancements and learn about the challenges and opportunities AI presents now and for the future.
    The CyberGuy explains why healthcare organizations are vulnerable to hackers after there have been a half dozen data breaches this year.
    Developed at two California universities, the innovative technology combines brain-computer interfaces with advanced AI to decode neural activity into audible speech.
    Microsoft patches 12 critical flaws, but six have already been exploited by criminals. Kurt “CyberGuy" Knutsson says updating your system is only a short-term fix.
    Tech expert Kurt “CyberGuy" Knutsson discusses how robots can milk, feed and clean cows on dairy farms, boosting efficiency and comfort.
    Tech expert Kurt “CyberGuy" Knutsson says quantum internet ensures unhackable security and redefines online privacy and speed.

    Microsoft Great Plains GL: General Ledger ? Overview For Consultant

    Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More

    Ukraine: a Prospective Player on the World Software Outsourcing Market

    The destruction of the Soviet Union about 15 years ago,... Read More

    When is a Software Engineer Not a Software Engineer?

    The title of "software engineer" has got to be among... Read More

    Microsoft Great Plains IV: Inventory Management

    Great Plains Inventory Management (IV) module gives your business a... Read More

    Tools for Customizing Great Plains

    Microsoft Business Solutions ? Great Plains has captured the US... Read More

    Microsoft Great Plains Data Conversion ? Overview For Developer

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

    Microsoft Great Plains: Dexterity vs. eConnect ? FAQ

    Microsoft Business Solutions Great Plains, former Great Plains Software Dynamics/eEnterprise... Read More

    Microsoft Business Solutions Customization Options - Overview for Programmer

    Several years ago Microsoft purchased Great Plains Software, then Navision... Read More

    Cisco Certification: Five Things To Do DURING Your CCNA Exam

    There are plenty of articles out there about how to... Read More

    C++ Tutorials: 3, Program Flow (If, Else, While, For)

    Program Flow is what you think it is. How the... Read More

    How a Bug Challenges to a Software Professional

    It is really interesting that a bug can create problem... Read More

    SyncUp ? A File/Folder Synchronizer For Windows

    SyncUp, a file synchronizer is designed to assist the home... Read More

    DB Integration - Software for Combine MS Access Databases

    Our company, Novaprof Inc., developed unique software - DB Integration.... Read More

    Corporate ERP: Microsoft Great Plains For The Plant In Brazil ? Overview For CIO

    Microsoft Business Solutions Great Plains as new ERP for multinational... Read More

    Dreamweaver vs FrontPage

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

    History of Java

    The java programming language is becoming more and more popular... Read More

    What is Shareware?

    Shareware is software that you can try before you buy;... Read More

    Microsoft Great Plains Dynamics on Pervasive SQL.2000 Data Repair ? Overview For DBAs

    Some introduction into Great Plains Software products, now Microsoft Business... Read More

    Review of TikiWiki Content Management System

    TikiWiki is open source software - it is written in... Read More

    Microsoft Great Plains implementation: Restaurants Supply Chain Management Example

    Microsoft Great Plains serves majority of US based horizontal and... 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

    Linux Secrets

    The first thing that you will notice about Linux Red... Read More

    Increase Office Efficiency With One Simple Tool

    When you need a phone number, you do a quick... Read More

    Keep Your Software Simple! A Review of EditPlus

    I like my software simple. If it's too complex or... Read More

    Adware and Spyware Blockers

    The most important things you can do for your computer... Read More

    Des Moines rental limo ..