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.

    taxi from O'Hare Bismarck .. Lockport Chicago limo O’Hare
    In The News:

    Experts say hackers who used to focus on Windows operating systems are increasingly targeting Apple IDs as part of a new phishing campaign.
    Unitree, a Chinese robotics company that developed a backflipping robot, has now introduced a humanoid robot capable of doing a side flip.
    Stay up to date on the latest AI technology advancements and learn about the challenges and opportunities AI presents now and for the future.
    According to the FBI, cybercriminals are sending extortion letters, threatening to release victims' sensitive information unless a ransom is paid.
    FireSat is a satellite project designed to detect and track wildfires early, aiming to detect a fire that's the size of a classroom within 20 minutes.
    Tech expert Kurt “CyberGuy" Knutsson reports that researchers have uncovered a Chrome vulnerability used in a cyber espionage campaign.
    Preserving voicemails securely on Android: Tech expert Kurt “CyberGuy" Knutsson reveals easy methods to keep memories alive forever.
    This phishing kit bypasses 2FA via session hijacking and real-time credential theft. Kurt “CyberGuy" Knutsson offers four ways to stay safe from Astaroth phishing attacks.
    Tech expert Kurt “CyberGuy" Knutsson discusses Joby Aviation and Virgin Atlantic planning to launch 200-mph U.K. air taxis linking airports and cities.
    Fake Apple virus warnings, security alerts and messages are tactics used to prompt you to call a number or click on a malicious link. The CyberGuy explains how to protect your devices.
    The combination of artificial intelligence and neuroscience allows a paralyzed man to manipulate a robotic arm by using his brain to imagine movements.
    With the help of artificial intelligence, sophisticated fraud techniques emerging today are virtually undetectable to the untrained eye.
    Stay up to date on the latest AI technology advancements and learn about the challenges and opportunities AI presents
    If you need to free up space on your Mac, consider deleting duplicate photos in your image library. Apple makes it easy to do, and the CyberGuy explains the process.
    Microsoft is discontinuing Skype in May after 22 years of service. Kurt the CyberGuy addresses other options for internet-based phone and video service.
    Tron 1, a Chinese company's two-legged robot, is versatile and can walk, roll and pivot, even on rough terrain. Tron 1 stands 33 inches tall and weighs 44 pounds.
    Hackers are tricking people into installing password-stealing malware by making them press keyboard shortcuts under the pretense of proving they're not bots.
    Saving the voices of loved ones can be a comforting way to keep alive memories. Kurt "the CyberGuy" Knutsson explains how to preserve voicemail messages.
    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 FBI warns that some free online document converters load malware onto people's computers, making their private information vulnerable to attack.
    Toyota's compact electric FT-Me is designed to tackle challenges of city living while offering an accessible and eco-friendly transportation solution.
    Kurt “CyberGuy" Knutsson says 23andMe's bankruptcy raises data privacy fears: Opt out, download and delete data now.
    UBTech and Zeekr unite with AI robot swarms to make car manufacturing faster and smarter. Tech expert Kurt “CyberGuy" Knutsson explains how the process works.
    Tech expert Kurt “CyberGuy" Knutsson says Apple's Passwords app had a three-month phishing flaw from iOS 18 to 18.2 patch.
    Tech expert Kurt “CyberGuy" Knutsson discusses how this super-small electric mini-truck takes a big step toward production.

    What You Should Know About Installing Screensavers

    Do you remember that frustrating feeling when you find an... 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 Great Plains Customization Tools Evolution ? Overview for Consultant

    When Great Plains Software introduced the first graphical accounting application... Read More

    Marketing Your WinRunner Team

    It won't matter how effective your WinRunner Team is if... Read More

    Microsoft Navision Database Selection: C/SIDE or MS SQL Server - Overview For IT Specialist

    There are certain pluses and minuses in both cases and... Read More

    Crystal Reports for Microsoft Great Plains ? Overview for Developer

    Microsoft Great Plains is main accounting / ERP application... Read More

    5 Mac Security Tips You Can?t Live Without

    So, you've bought a new Macintosh, and now you may... Read More

    10 Things You Could be Using Photoshop For, But Probably Arent

    Most people don't use Photoshop to its fullest capabilities. Here... Read More

    Professional Software Icons For Your Standalone Application

    User interfaces and accessibility are some of the most important... Read More

    Does your Company have Documentum?

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

    SpyBot - Search and Destroy versus Microsoft AntiSpyware (Beta).... My personal experiences...

    Ok... Where to start?Well, I guess I will start at... Read More

    Database Guru James F. Koopmann Reviews DBxtra Reporting and Query Tool

    DBxtra is a powerful query and reporting tool that hides... Read More

    Resume Software ? Advantages Revealed

    The various resume software offered, particularly on the internet, can... Read More

    Tripwire for Linux File Integrity

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

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

    Program Flow is what you think it is. How the... 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

    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

    Selecting Corporate ERP: Microsoft Business Solutions Great Plains ? Estimation Parameters

    As we could imagine, if you are reading this article... Read More

    Microsoft Great Plains eCommerce ? Stored Procedures Approach

    Since Version 8.0 Microsoft Business Solutions Great Plains & Great... 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

    Alien Intruders!

    You probably didn't casually invite, or extend a formal attendance... Read More

    Are You Waiting for Microsoft Longhorn Operating System

    I love new technology. I am still ready to wait... Read More

    It?s Back!! WordPerfect?s Amazing Comeback

    Have you noticed WordPerfect is gearing up for a comeback... Read More

    Make or Break Factors - When Considering Estimating Software

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

    Spyware: What It Is and How to Combat It

    Spyware is software or hardware installed on a computer without... Read More

    Granger Lincoln Stretch limo rentals ..