Home            Links 



 


Microsoft Great Plains is main accounting / ERP application from Microsoft Business Solutions, targeted to the US market.  It serves the whole of vertical and horizontal market: most of the industries and company sizes.  Crystal Reports on the other hand is the leader in the reporting software industry and Microsoft is willing to use Crystal as main reporting tool for Great Plains, Solomon, Microsoft CRM, .Net platform, etc.

If you are developer who is asked: how do we extend Great Plains ReportWriter with somewhat more sophisticated ? read this and you will have the clues on where to look further.

  • Great Plains Tables Structure ? first of all you need to know the tables to link.  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.
  • Consider SQL Views ? if you don't want complex links in Crystal Report itself or if you need unionization from several companies ? SQL view is the answer.
  • Consider SQL Stored Procedures.  Sometimes you can not pull the data in one view ? you need temporary tables to be created and the final query should be based on these temp tables ? this is when you need stored procedure.
  • Call Crystal Report from GP Screens via VBA/Modifier ? if the user wants to call Crystal report for example - printing Invoices in GP and do it from SOP Entry window ? you can use Modifier and VBA to call Crystal Reports engine.
  • 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.
  • Happy customizing, querying and 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, Los Angeles, San Francisco, San Diego, Boston, New York, Houston, Dallas, Miami, Atlanta, Minneapolis, Seattle and having locations in multiple states and internationally (www.albaspectrum.com), he is Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer.



    Advent Software to Host Analyst and Investor Day Event on Friday, May 11, 2012
    Reuters
    SAN FRANCISCO - February 6, 2012 - Advent Software, Inc. (NASDAQ: ADVS), will hold its Analyst and Investor Day in New York on Friday, May 11, 2012, beginning at 9:00 am (EST). The meeting will feature presentations by Advent's executive team covering ...
    Advent Software Achieves Record Quarterly Revenue of $86 Million and Record ...MarketWatch (press release)
    Advent Software's CEO Discusses Q4 2011 Results - Earnings Call TranscriptTheStreet.com
    Advent Software Q4 Profit Drops; Issues Q1, FY12 Revenue Outlook - Quick FactsNASDAQ

    all 13 news articles »


    Scorpion Software Announces AuthAnvil Single Sign On Support for Level ...
    San Francisco Chronicle (press release)
    Scorpion Software, an industry leader in strong authentication and password management solutions for IT Service Providers and IT departments is pleased to announce integrated support for AuthAnvil Password Solutions with Level Platforms, ...
    Scorpion Software Offers Support for Level Platforms Managed WorkplaceThe Complete Managed Services Resource

    all 2 news articles »


    Caduceus Software Plans to Integrate a Cloud Platform with its Software ...
    SmallCap Network
    By Ed Liston Caduceus Software Systems Corp. (OTC: CSOC), a software company specializing in the development of an all-in-one solution for private practitioners and doctors, today, said that it plans to integrate a cloud platform with software systems.
    Caduceus Software Systems Corp. Plans to Integrate a Cloud Platform with its ...MarketWatch (press release)
    QualityStocks News - Caduceus Software Systems Provides Update on Current ...PR Web (press release)

    all 14 news articles »


    Proposal Software Continues Strong SaaS Revenue Growth in 2011
    MarketWatch (press release)
    WESTPORT, Conn., Feb 06, 2012 (BUSINESS WIRE) -- Proposal Software, Inc. (PSI), The Leader In Proposal Productivity(TM), and makers of PMAPS(R) WebPro (Proposal Management and Production System) announced 2011 results that continue its systemic growth ...

    and more »


    Manhattan Software Announces Strategic Partnership With Indiabulls for ...
    MarketWatch (press release)
    6, 2012 /PRNewswire via COMTEX/ -- Manhattan Software, the global leader in enterprise real estate software and a leader in the 2011 Gartner Magic Quadrant for Integrated Workplace Management Systems, announced today a strategic partnership with ...

    and more »


    Mezeo Software Announces National Master Distributor for Japan
    MarketWatch (press release)
    HOUSTON, TX, Feb 06, 2012 (MARKETWIRE via COMTEX) -- Mezeo Software(R), a leading provider of cloud storage management solutions, today announced the appointment of a master distributor for Japan, AIR Company Limited, a Japanese company focused on ...

    and more »


    The Cloud Software Companies You Need to Know About
    Motley Fool
    But software as a service is easy enough to define. Whenever you have to access your application through a central location, and pay ongoing license fees to the developer, that's generally software as a service. Microsoft's Office suite is plain old ...

    and more »


    Is BMC Software Growing or Slowing?
    DailyFinance
    By Seth Jayson, The Motley Fool Posted 4:11PM 02/06/12 Investing There's no foolproof way to know the future for BMC Software (NAS: BMC) or any other company. However, certain clues may help you see potential stumbles before they happen -- and before ...

    and more »


    Oakland police get free forensic software to analyze Occupy videos
    San Francisco Chronicle (blog)
    A Pasadena forensic video enhancement software company has donated its technology to Oakland police to help in capturing the goings-on at Occupy Oakland demonstrations, the company announced in a statement. At the request of Oakland law enforcement, ...

    and more »


    Longwood Software Establishes Strategic Reseller Agreement with Canada's Interlinc
    MarketWatch (press release)
    MAYNARD, Mass., Feb 06, 2012 (BUSINESS WIRE) -- Longwood Software, Inc., the developers and marketers of the RevBase(R) software-as-a-service (SaaS) marketing asset management system ( www.revbase.com ), announced today a strategic reseller agreement ...

    and more »

    Google News

    Related Articles
    Tripwire for Linux File Integrity
    What is Tripwire?
    OEComplete ? A Personal Information Manager
    OEComplete is a utility for managing the personal information of the user. It is designed to be flexible and affordable even for the home user. OEComplete allows setting up appointments and tasks, and creates notes for easy reference. Recurrence, reminders and attachment enhance the competence in addition to import and export facility.
    Reporting Tools for Microsoft Great Plains ? Overview For Developers
    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.
    Should I Use Windows Update?
    Should one use Windows Update?
    IT Strategy for Midsize Business: Microsoft vs. Java, Great Plains & CRM
    Midsize business or non-profit organization should decide if one-vendor solution would be appropriate and the associated risk acceptable. In our opinion, balancing the risk of one-vendor-approach is not economically feasible and should be avoided. This means that you need to decide if you plan to be Microsoft-oriented or Java/Unix/Linux/Oracle oriented. In the case of Java direction ? you again have to further consider your options and if possible do not deploy too many systems from different vendors. Even if you host your systems with somebody else ? we think that in the future you might have a risk of complex data conversion from one system to another. In this small article we'll show you typical way if you follow Microsoft direction: Microsoft Business Solutions Great Plains and Microsoft CRM
    Microsoft Great Plains Distribution, Barcoding, Consignment ? overview for consultant
    Microsoft Great Plains ? ERM from Microsoft Business Solutions and formerly Great Plains Software is pretty generic with its standard set of modules: GL, BR, AR, AP, IV, SOP, POP and US Payroll. However, having about twelve years of implementation and customization history ? Great Plains Dynamics, Dynamics C/S+, eEnterprise being Great Plains Dexterity written application has been and still is attractive core platform for third party software development companies to write vertical and horizontal modules, written as well in Great Plains Dexterity. If you have Microsoft Great Plains implemented or under the implementation should have your options in making in-house or outsourced customizations to fit your vertical industry needs. Let's consider consignment, barcoding and distribution/warehouse management
    Seven Reasons Why a Hosted Inventory Management Solution Might Be Right For Your Organization
    Upgrading. Downtime. Maintenance. Hardware obsolescence. Implementation issues. The litany of headaches related to the implementation and on-going care-and-feeding of enterprise based applications is enough make the savviest of companies want to engage in anything but another software implementation. Like a full-blown IRS audit. Anything?
    Microsoft CRM for Large Corporation ? Security
    Microsoft Business Solutions CRM proved to be reliable solution in the whole spectrum of industries and market niches: transportation & logistics, education, recruiting & placement, supply chain management, pharmaceutical, oil & gas, aerospace & defense, manufacturing, wholesale & retail. When corporation is looking into CRM application to choose from ? one of the fist questions is security. In this small article we'll try to give you the highlights on the most typical questions we are receiving in the security area.
    Partitioning, Formatting and Reinstalling in Windows 98
    Formatting and reinstalling windows 98 is very easy if you have the right know-how.
    Change Your Word Docs in Record Time!
    Anyone who has ever used Microsoft Word knows that it is a powerful word processing package. It's loaded with dozens of features designed to make creating documents a breeze. And anyone who has used Word's Find and Replace feature knows that this is one handy feature. It makes changing words or phrases throughout your documents fast and painless.
    Adware and Spyware
    What is 'adware'?
    The Opera Alternative
    Security flaws have long plagued Internet Explorer (IE), the market-dominating web browser from Microsoft. IE won the early browser wars, not only because it was free and bundled with Windows, but because it had some features and capabilities that its only real competitor, Netscape, didn't have. But the behind-the-scenes programming that makes those features possible is the very coding that also leaves wide gaps in IE's defenses against viruses and malicious scripting. Among several browser alternatives for Windows users, the Opera browser stands out in functionality and integration, and is gaining a wider following as a safer surfing alternative to Internet Explorer.
    Increase Office Efficiency With One Simple Tool
    When you need a phone number, you do a quick search on the Internet and in a few seconds, you've got the information you need. And you probably receive a lot of contact information right inside the emails you receive every day. Both methods are by far more convenient than using those white or yellow-colored telephone directories.
    Microsoft Navision Customization and Reporting ? Tips For Programmer/IT Specialist
    C/SIDE (Client/Server Integrated Development Environment) - The core of Navision is the C/SIDE. C/SIDE is the foundation for all the business management functionality of Navision. It is made up of five building blocks, called object types, which are used to create the application. These five object types are shared throughout Navision to create every application area, and give it a unified, consistent interface. This powerful language allows for the internal construction of new business logic and sophisticated reporting. Because of the internal nature of modifications it's highly recommended that you develop all your code in "processing only" report objects and called from the native code base. By grouping all your code in logical units, upgrades and additional modifications are easier to manage.
    Five Steps to Rapid Development with TierDeveloper 4.0
    Follow the steps below to quickly design, generate, and deploy a great portion of your real-life N-Tier application.
    Screenplay and Script Writing Software
    When it comes to screenplay software each screenwriter needs to determine what they need from the program they purchase and pick one that fits their specific needs. Screenwriting software doesn't write the screenplay for you. Why do I say this? I don't want you to be under the impression one software application is "better" or the "best" script writing software. No script writing software should be chosen based on it helping you complete your screenplay "better" or "faster" than another.
    How to Tell You Have Spyware, Ad-ware or Viruses
    Usually, the easiest way to tell you have spyware is because your PC is running at a reduced speed. The other way to check is to hit CTRL+ALT+DELETE and hit task manager (if you have windows service pack 2. If you have before SP2, then this should automatically bring up the task manager).
    Intro to UNIX Shells
    A UNIX Shell is in simplest terms, a command line interpreter, that takes the users input and gives it to the Kernel. If you are familiar with DOS, you will remember the 'command.com' that file takes the users information and passes it to the operating system in a way it can be understood by the system. With DOS you only had one type of shell, but with UNIX you have a variety, each with their own abilities, pluses and minuses.
    Microsoft CRM Programming Secrets ? Tips For Developers
    This article is for advanced Microsoft CRM SDK C# developers. It describes the technique of direct SQL programming, when SDK doesn't have the functionality to do the job.
    A Simple Computer Software Definition
    What is Software?



    Common misspellings for words used in this page include adavanced addtion addtional adecuate adn againnst agains agaisnt aganist agian agianst agin agina aginst ahev ahve alse alsot alternitives alwasy alwyas amke amking anbd anohter anytying aplication applicaiton applicaitons appropiate appropraite appropropiate apropriate artical artice articel aslo asociated assoicated automaticly availaible availble availiable availible avalable avaliable avilable baceause baout beacuse becasue beccause becouse becuase bedore befoer beng buisness busineses busness bussiness choosen comany comapany competance concider conection consdider consistant consttruction constuction contruction conveinent convertion convienient creaeted decribes definately definatly definetly definitly delevopment descriibes desgined deside dessigned develope developement develpment devolopement diferent diferrent differnt diffrent discribes doccuments eahc eearly ened esle ethose eveyr exemple exmaple eyars eyasr familliar feasable follwoing folowing fomr formelly frome furuther futher gerat graet grat haev hstory hten htey htikn htink htis hvae hvaing hvea hwihc hwole implimented infomation informtion inot inudstry iwll iwth jstu jsut knwo knwos konw konws kwno laguage liek liuke makse managment mkae mkaes mkaing mkea moreso mroe nkow nkwo nto omre onyl organiztion otehr owudl pary peronal possable possibile poverful poweful powerfull probablly probaly proccessing prooved propper quicklyu reccomend reccomended reccommend reccommended receving recieve recieving recomend recomended recuiting rela remeber runing runnung rwite scirpt screenwrighter seach severeal sevice shoudl shoudln smae smoe soem sofware sohw sophicated specfic specif spectum suphisticated suppy sytem tahn taht targetted tath technnology technolgy teh tehy temprary tghe thast theese theri thgat thge thier thikn thiunk thn thna thne thoughout thrid througout thsi thsoe thta thyat tihkn tihs tje tjhe tkaes transporation tyhat tyhe typcial uise understoon unsed useing vell veyr vrey vyer vyre waht wass watn weas wehn whant whants whcih whic whihc whith whlch whn whta wich wiew wih wiht wille wirting witht witn wiull wnat wnats wohle workststion woudl wriet writen ws wtih yeasr yeras yersa ytou yuo.