Home            Links 



 


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 (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 TranscriptSeeking Alpha
    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 »


    Longwood Software Establishes Strategic Reseller Agreement with Canada's Interlinc
    EON: Enhanced Online News (press release)
    (EON: Enhanced Online News)--Longwood Software, Inc., the developers and marketers of the RevBase® software-as-a-service (SaaS) marketing asset management system (www.revbase.com), announced today a strategic reseller agreement with Interlinc, ...

    and more »


    Law Offices of Howard G. Smith Announces Investigation of JDA Software Group, Inc.
    Business Wire (press release)
    (BUSINESS WIRE)--Law Offices of Howard G. Smith announces that it is investigating potential claims on behalf of purchasers of the securities of JDA Software Group, Inc. (“JDA†or the “Companyâ€) (NASDAQ:JDAS) concerning possible violations of federal ...
    JDA SOFTWARE GROUP INC: Law Offices of Howard G. Smith Announces Investiga..4-traders (press release)

    all 18 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 ...EON: Enhanced Online News (press release)
    QualityStocks News - Caduceus Software Systems Provides Update on Current ...PR Web (press release)

    all 14 news articles »


    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 »


    Pilot Flying J Selects Predixion Software for Predictive Analytics
    EON: Enhanced Online News (press release)
    (EON: Enhanced Online News)--Predixion Software announced today that Pilot Flying J, which operates 550 interstate travel centers and travel plazas in North America and is one of the top 10 privately held companies in the United States, has purchased ...

    and more »


    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 »


    The Mobile Pivot: Pyxis becomes Verivo Software
    Forbes
    Every company I speak with is building mobile software for its customers (B2C) or its employees (B2E). In effect, the entire software market is morphng before our eyes as the world deals with enabling business on the go. This transition has created an ...
    Verivo Software CMO Speaks on Mobility at NICSAEON: Enhanced Online News (press release)
    Business Profile: Waltham's Verivo has an aptitude for appsWicked Local

    all 9 news articles »

    Google News

    Related Articles
    A Case Study on Selecting Contract Management Software
    Professional services firm cuts costs and improves productivity with integrated software system.
    Online PowerPoint Presentation ? Convert PowerPoint to Flash
    Although we don't know whether Microsoft ever envisioned such a big market about PowerPoint on its first release. Today this software is impacting profoundly on education and corporation's activities in the way that nobody could ignore. With a wealth of visual and audio effects people rely on it to express their ideas, plans more intuitively with more effective communication outcomes.
    Two Reasons to Use Timesheet Software
    This short paper will expand on two key reasons to move to a computerized timesheet system at your company. There are more than two reasons of course, but these will be expanded on at a later date. The two key reasons to be discussed here are Timesheet Efficiency, and Timesheet Automation.
    C++ Tutorials: 3, Program Flow (If, Else, While, For)
    Program Flow is what you think it is. How the program will flow. As you know the compiler will just go down the code. Program flow is what you use to make it run a certain thing a few times, do something based on a variable, etc... There are some basic comands to program flow. The first two are loops: While and For. When you want something to loop for an amount of times based on a variable, use while. If you know how many times you want something to run, use for. If and else statements are pretty self explanable. Dont be afraid, I will go over all the syntaxes and how to do everything!
    Fleet Maintenance Software Reviews
    Innovative Maintenance Systems (IMS) is one company that offers solutions for companies in need of fleet maintenance software. One of their most popular products is Fleet Maintenance Pro®. According to the website and fleet maintenance software reviews, this product offers automatic calculations of maintenance, assists in tracking PM and repair maintenance, helps you analyze fleet costs over time and much more. This product is recommended for maintaining vehicles that are tracked by date, mileage, hours and etc. Prices range from $189.00 - $750.00 for single users, but networking capabilities are also available.
    Causes of ERP Failures
    ERP is the acronym of Enterprise Resource Planning. Multi-module ERP software integrates business activities across various functional departments, from product planning, parts purchasing, inventory control, product distribution, to order tracking. ERP has transformed the way multi-billion dollar corporations conduct their businesses. Successful implementation of ERP systems could save tens of millions of dollars and increase employee satisfactions, customer satisfactions and sustain competitive advantages in every-changing marketplace. Corporate executives are often perplexed by the stories that how reputable corporations (Hershey Foods, etc.) have failed miserably and lost ten of millions of dollars in their ERP endures.
    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.
    These Items Are A Must Before Making The Decision To Purchase Any Off-The-Shelf Software
    1. What determines the software price? Is it Per Seat or Per User or Per Processor?
    Spyware, What is it?
    Spyware, what it is and what it does. Basically, spyware is a program put on your computer usually after you have downloaded some kind of program or went to a certain site. Once this program is on your computer, depending on what kind was put on, has the potential to monitor what you're doing without you knowing it.
    The XP Firewall Isnt Enough
    Every computer that connects to the internet has an IP address. This is like a sort of phone number, and is issued either to an individual computer or to a "gateway" that connects a private network to the 'net.
    SpyBot - Search and Destroy versus Microsoft AntiSpyware (Beta).... My personal experiences...
    Ok... Where to start?
    Linux Secrets
    The first thing that you will notice about Linux Red Hat (using the Gnome Interface) is that it looks a lot like Windows 95/98/NT. But that's where the similarity ends. Linux requires a whole new set of commands as well as a new way of thinking about things.
    Your Computer May Be Infected, Heres How To Check (NOT about virus)
    NOTE: Please take time to read on - it may be vital for your PC's security. If you are not in the mood, just save it or print it out for later reference.
    Destination: Desktop for Google
    First we had the original Google search that evolved into the leader in its class. In fact, it became so popular that the word "google" worked its way into our everyday language as a verb, as in "to google" something. Google later introduced a toolbar that was plug-in for some browsers like Internet Explorer. The Google toolbar features a direct Google search box with quick access to image and group searches, a pop-up blocker, and for Internet marketers mostly, a PageRank (PR) indicator.
    Microsoft CRM Implementation ? Fundamental CRM Principles Revision
    Microsoft CRM is relatively new player on the now becoming traditional CRM software applications market. We would like just to mention shift in the technical conception ? Microsoft CRM is committed to Windows and Microsoft components: Exchange, Active Directory, SQL Server, etc (while traditional CRM applications, such as Siebel were biased toward multiplatform compatibility: Unix, Oracle, Windows, SQL Server) and move up to business logic paradigm shift.
    Defining OLAP Solutions and Data Warehouse design
    This tutorial covers OLAP solutions used by Data warehouses and understanding Data Warehouse design. The enterprise needs to ask itself certain fundamental questions before actually launching on the process of designing the data warehouse. It must begin with a conviction that a data warehouse would really help its business and the return on investment will make it worth it.
    Microsoft Great Plains: Interest Calculation Example ? Stored Procedure for Crystal Report
    This is intermediate level SQL scripting article for DB Administrator, Programmer, IT Specialist
    Spyware - The Internet Devil Of Our Times!
    Spyware and Adware infest over 90 percent of computers in use today. Internet linked computers has made it easy for spybots, adware, and trojans to infiltrate and compromise online privacy. Installed toolbars can also contribute to browser hijacking and spyware related problems.
    Microsoft Great Plains as ERP and Microsoft CRM as CRM
    If you have Microsoft Great Plains and support it for your company then you need to know some technical details about Great Plains version upgrade and what is going on behind the scenes, which options do you have in case of Dexterity, VBA, SQL customization, additional complexity comes with migration from ctree/Pervasive to MS SQL/MSDE.
    Microsoft Great Plains Furniture & Fixtures ? Implementation & Customization Highlights
    Microsoft Great Plains, former Great Plains Software Dynamics / eEnterprise was introduced in 1993 as first Microsoft Windows and Macintosh based graphical accounting/ERP application for Mid-Size businesses. Considering the history of furniture retailer and custom assembly lines ? they showed up on the market about five decades ago and they have automated their business operations with Unix-based businesses in the late 1960th and earlier 1970th. You can find such furniture resale systems as Storis, which is Unidata based application, automating furniture retail outlets. Let's consider the options.



    Common misspellings for words used in this page include accross activites actualy addtional adecuate adn againnst agains agaisnt aganist agianst aginst ahev ahve alse alsot alternitives alwasy alwyas amke ammount anbd aplication applicaiton applicaitons artical artice articel aslo availaible availble availiable availible avalable avaliable avilable baceause backgorund baout beacuse becamae becasue beccause becomeing becomming becouse becuase bedore befoer beggin buisness busineses busness bussiness ceratin certian cmoputer comany comapany comited comitted comminication commited communciation communiation competative competive complier comprimise computarized concider conection consdider consolodated coorperations coputer corperations coudl criterias dael definately definatly definetly definitly desigining dicussed diea diferent diferrent differnt diffrent doccuments doign donig ealier ect eearly eiter ened esle ethose excelent excellant exelent exellent fidn finacial follwoing folowing fomr frome fundametal gerat gogin goign gonig graet grat gropu haev halp housr howver hstory hten htey htikn hting htink htis hvae hvaing hvea hwihc hwole idaeidae inctroduced infilitrate inot intergrated intergration intrduced introdued intruduced intutively itnroduced iwll iwth jstu jsut knwo konw kwno laguage levle liek liuke maintainance maintainence maintance maintenence maintinaing makse mkae mkaes mkea moreso mroe nkow nkwo nowe nto oftenly oging omre onyl orginal origional owudl palce peopel peronal populare possable possibile privte proccess proces propper propperly puchasing raelly realitvely realy realyl reccomend reccomended reccommend reccommended recomend recomended rela relaly relativly relitavely seach severeal shoudl shoudln similiarity smae smoe soem sofware sohw sould spectum statememts storeis storise sytem tahn taht targetted tath technnology technolgy teh tehy tghe thast theese theri thgat thge thier thign thikn thikning thiunk thn thna thne thnig thsi thsoe thta thyat tiem tihkn tihs timne tiome tje tjhe tkae towrad traditionnal tranformed twpo tyhat tyhe uise unsed usally usefull usualy ususally vell verison veyr vrey vyer vyre waht wass watn weas wehn whant whcih whic whihc whith whlch whn whta whther wich wih wiht wille witht witn wiull wnat wohle workststion woudl writen ws wtih wupport ytou yuo.