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.

    premium house cleaning Highland Park ..
    In The News:

    A New Jersey teenager filed a major lawsuit against AI/Robotics Venture Strategy 3 Ltd. over ClothOff, an AI tool that created fake nude images from her social media photos.
    Microsoft reports Storm-2657 cybercriminals sent phishing emails to 6,000 addresses at 25 universities to steal payroll credentials and redirect funds.
    Astronomers have discovered asteroid 2025 SC79, a skyscraper-sized space rock orbiting the sun in just 128 days. the second-fastest known.
    The Fox News AI Newsletter delivers the latest developments form the world of artificial intelligence, including the technology's challenges and opportunities.
    A cyberattack on SimonMed Imaging exposed personal information of 1.2 million patients, including medical records, financial details and identity papers.
    Spotify's managed accounts for kids under 13 now available in at least seven countries, allowing parents to filter and block explicit content and songs.
    Friendly text conversations about BBQs and social events can lead to WEEX gold trading scams that target older adults with fake investment opportunities.
    California company Skyeports creates self-healing glass spheres from Moon regolith that generate solar power and support plant growth for sustainable lunar living.
    Cleafy researchers discover fake VPN streaming app Mobdro Pro that installs Klopatra banking Trojan, giving attackers full control over Android devices.
    Police departments across the U.S. and Canada are adopting virtual reality training to better prepare officers for high-pressure, real-world situations.
    House Bill 469 would prevent AI systems from owning property, serving as executives, or gaining legal personhood in Ohio under Representative Thaddeus Claggett's proposal.
    Public voter records expose retirees' personal details to election scammers who create targeted cons using names, addresses, and voting history data.
    Instead of fearing what comes next with artificial intelligence, think outside the box. Here are high-earning AI jobs that don't require a computer science degree.
    OpenAI CEO Sam Altman says polite words like "please" and "thank you" cost millions annually, while direct prompts may improve ChatGPT accuracy by several points.
    Chattee Chat and GiMe Chat exposed intimate conversations and photos, revealing users spent up to $18,000 on AI companions before the breach.
    New Instagram parental controls allow families to manage teen screen time and content limits through the Family Center with stricter safety settings.
    Third-party security breach at Discord exposes sensitive user information including government IDs, highlighting cybersecurity risks from external service providers.
    Survey of 1,000 students shows teens using AI for personal relationships while two-thirds of parents remain unaware of their children's AI usage.
    Cybersecurity experts warn about a ShadowLeak vulnerability that weaponized ChatGPT's Deep Research agent to steal personal data from Gmail accounts through hidden commands.
    Tesla's Full Self-Driving system faces federal investigation following 58 reports of crashes, with six vehicles running red lights before colliding with other cars.
    The Fox News AI Newsletter brings you the latest developments on artificial intelligence, with news on OpenAI moving to soon allow erotica for adult users.
    Eric Schmidt alerts that hackers can reverse-engineer AI models to bypass safety measures, citing examples like the jailbroken ChatGPT variant called DAN.
    Cybercriminals exploit Microsoft Teams through impersonation, malicious links and fake profiles to gather intel and deliver ransomware to personal and work devices.
    Google, Dior, Allianz and dozens of other companies lost sensitive customer data in Salesforce-related breaches affecting millions of records across multiple sectors.
    Apple launches iOS 26 with new Preview app that combines document editing, PDF annotation and scanning features into one streamlined iPhone experience.

    OS 101: Suggestions for Choosing an Operating System

    An operating system (abbreviated OS) is essentially the path through... Read More

    New Web-Based HR Tool is Max From NAS, Hannibal, and InfoLink

    Three highly respected names in Human Resources have joined forces... Read More

    Microsoft Great Plains: exchange & brokerage ? implementation notes

    If you company is small or mid-size special products or... Read More

    Benefits of Shareware

    Shareware has been fighting the stigma of being misunderstood for... Read More

    Popular Fleet Maintenance Programs

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

    Accessing XML Using Java Technologies

    The most important benefit of XML is its simplicity. Though... Read More

    Microsoft Great Plains on Ctree or Pervasive SQL ? What to Do ? Tips for IT Manager

    As you probably know, when Microsoft purchased Great Plains Software... Read More

    What is Software Piracy?

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

    Microsoft CRM USA Nationwide Remote Support

    Remember old good days when your company probably had Great... 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

    Assertion in Java

    Assertion facility is added in J2SE 1.4. In order to... Read More

    Not All Project Management Software is Created Equal

    The purpose of Project Management Software is to provide an... Read More

    Make or Break Factors - When Considering Estimating Software

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

    Two Reasons to Use Timesheet Software

    This short paper will expand on two key reasons to... Read More

    Internet Security Threats: Who Can Read Your Email?

    Before being able to choose a secure Internet communication system,... Read More

    Understanding Document Management

    The term "document management" and "paperless office" is the subject... Read More

    Microsoft Great Plains Implementation for Midsize & Large Corporation: Lockbox Processing

    Microsoft Great Plains is now targeting large and midsize businesses... Read More

    Groupware as a Document Manager: Collaboration Series #3

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

    IT Department Skills to Support Microsoft Great Plains and Microsoft CRM

    Microsoft Great Plains as ERP and Microsoft CRM as... Read More

    Importance of Coding Standards

    Programming Help for BeginnersWe write programs to instruct computers. When... Read More

    Selecting Microsoft Great Plains Partner/VAR/Reseller: ERP Implementation & Customization ? Overview

    In the case when you represent mid-size or mid-size-to-large business,... Read More

    How the Firefox: How to... Manual Helped Me

    A few months back I really got sick of my... Read More

    Microsoft Great Plains Integrations - Tips for Developer

    In this short FAQ style article we would like to... Read More

    Software Process Improvement -A Successful Journey

    Background: For many organizations like ours, the interim target of... Read More

    Call Alert Notifications - Free Answering Machine Software for PCs

    If you're online using a dialup Internet connection, you'll probably... Read More

    bedroom cleaning professionals Mundelein ..