Great Plains Custom Development: Dexterity, VBA, SQL, Crystal, eConnect ? Overview For Programmer

Microsoft Great Plains is main Microsoft Business Solutions accounting package for the US market. It has multiple customization/modification/reporting tools. Currently there is upgrade campaign to version 8.0 and due to the discontinuation of the technical support for Microsoft Great Plains Standard on Ctree and Pervasive SQL - we see substantial increase in migration needs: migration from ctree/Pervasive to MSDE/MS SQL Server. This in turn increases interest to customization and customization upgrade.

If you are developer who is asked: how do we customize Great Plains ? read this and you will have the clues on where to look further.

1. Great Plains Dexterity ? this is proprietary programming language and technology, designed back to earlier 1990th with the goal to build platform independent graphical accounting package ? Great Plains Dynamics. Dexterity itself is written in C (following popular those days hope ? that C will provide platform independence). You can install Dexterity from Great Plains 7.5 CD #2. Obviously it requires a lot of learning / training, but it allows your custom piece be seamlessly integrated with Great Plains interface. Nowadays, however ? and this is a good thing ? most of Great Plains installations are moved to SQL Server ? so you can use Dexterity for custom forms drawing only and make the buttons run SQL stored procedures.

2. Modifier with VBA. Unfortunately you have to purchase this tool and get new registration keys. If you are familiar with VBA customization for Access or Excel ? you have all the skills needed ? then you just attach your scripts to the buttons and fields on GP forms (you can modify these forms with Modifier ? or just tough them with it).

3. Continuum for VB/Delphi ? we don't recommend this tool, because it is using Great Plains as OLE server ? and you probably don't want to be trapped by old technology.

4. Crystal Reports. Great Plains has its own ReportWriter, but its functionality is limited ? you can't do cross modules reports (you can't link Sales and Purchasing tables in one report, for example). So ? you use Crystal. The GP tables structure is in Tools->Resource Description->Tables ? and you are in control. Feel free to create views and stored procs directly in the companies databases ? it doesn't hurt the Dexterity engine

5. Direct web publishing from Great Plains SQL databases, using Visual Studio.net and your language of choice (VB.Net, C#, J#, etc). Plus you probably want to have several SQL stored procs.

6. eConnect ? this tool is type of SDK with VB.net samples. It allows you to feed data into Great Plains and was primarily created for eCommerce developers.

7. Integration Manager ? it is end-user tool for importing to GP, however if end-user meets some challenges in the integration ? you as a developer can help with VBA scripts. IM validates 100% of business logic and uses hidden GP forms ? so it maybe slow for big on-going integrations, when you have thousands records per day ? in this case you rescue to eConnect or directly to SQL store procedures.

8. SQL queries - as a developer you have unlimited potential in using SQL queries, because the database in MS SQL Server. Be careful, it is kind of surgery - you can easily delete all your customers, by executing: DELETE RM00101

Happy customizing! if you want us to do the job - give us a call.

About The Author

Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies ? USA nationwide Great Plains, Microsoft CRM customization company, based in Chicago, California, Arizona, Texas, Florida, Georgia, New York and having locations in multiple states and internationally (www.albaspectrum.com), he is Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer.

[email protected]

1-866-528-0577! [email protected]

In The News:

Software: Start Early, Use Often  Manufacturing.netReaching corporate-grade production with additive manufacturing in a production environment.
OpenAI refuses to release software because it's too dangerous  Fast CompanyAI researchers fed their piece of software the first sentence to George Orwell's 1984, and it produced the following text: advertisement. I was in my car on my way ...
Study: The 4 software development trends that will dominate 2019  TechRepublicThe software development landscape is changing, but developers are using four key methods to handle it, according to an Atlassian survey.
NIOSH releases new EXAMiner training software  Mining TechnologyNIOSH has released a beta version of its new EXAMiner training software, which is designed to help miners improve their ability to identify hazards.
How to make PDFs in macOS Mojave without any extra software  AppleInsiderYou've been able to make a PDF out of any document on Macs for years. We take it so much for granted, though, that we don't know what extra options we've ...
Tera Software jumps 15% on orders worth Rs 289 cr  Moneycontrol.comThe company has received three orders including big operation and maintenance order in Andhra Pradesh.
Why IBM Is Untethering Watson AI Software from Its Cloud  Data Center KnowledgeAI models are best trained right where the data is, and most customer data isn't in IBM's cloud.
'Couldn't do it without technology': Embracing clinical software for trial recruitment  OutSourcing-Pharma.comGetting patients into possibly life-saving trials has long been a complex process, however, with the age of electronic health records and cloud-based data, there ...
Private equity is on a spending blitz in cloud software  CNBCVista's agreement on Tuesday to buy Ellie Mae is the latest example of private equity jumping into cloud software.
Novel Software May Help Detect Heart Diseases: Study  Doctor NDTVResearchers have developed a new software that could spot potentially lethal heart diseases and may lead to improvements in prevention and treatment, says a ...
Ottawa security firm Interset bought by U.K. software giant  Ottawa CitizenAn Ottawa security and data analytics firm has been bought by a massive U.K. software company for an undisclosed amount.
HR Software Technology: Which Problems Recruitment Software Can Solve?  BOSS MagazineThe recruitment process can be streamlined by adopting the right HR software.
Best Brightness Control Software for Windows 10  TWCN Tech NewsHere is a list of some of the best free desktop screen broghtness control software for Windows 10/8/7. Researchers have proven that looking at the screens for a ...
Software development isn't a manufacturing process  BetaNewsThe following is an exclusive excerpt from Project to Product: How to Survive and Thrive in the Age of Digital Disruption with the Flow Framework by Dr. Mik ...
Israeli software firm DriveNets raises $110 million in first round of financing  HaaretzDriveNets said its software allows communication *service* providers to handle growing demand without sacrificing profitability.
Tera Software Standalone December 2018 Net Sales at Rs 19.97 crore, down 43.12% Y-o-Y  Moneycontrol.comNet Sales at Rs 19.97 crore in December 2018 down 43.12% from Rs. 35.10 crore in December 2017. Quarterly Net Profit at Rs. 0.38 crore in December 2018 ...
Police leaders recognized for innovative use of cloud-based crucial information software  Police NewsBy P1 Staff ORLANDO – Several law enforcement leaders from around the country were recognized for their innovative use of a cloud-based records ...
Ultimate Software Ranked #8 on Fortune's 100 Best Companies to Work For 2019 List  Business WireUltimate Software announced today that Fortune and Great Place to Work have ranked Ultimate #8 on their 2019 list of 100 Best Companies to Work For.
Top 4 auto SMS sender software for PC to use in 2019  Windows ReportAn auto sms sender software for PC with auto responding facility helps users send messages in bulk for marketing purpose.
New Astaroth Trojan exploits anti-malware software to steal credentials  Software Testing NewsA new Astaroth Trojan campaign targeting Brazillian and European countries is exploiting software made by GAS Tecnologia to steal online credentials.
Crossover: A software sweatshop  Forbes IndiaTwo decades ago, Joe Liemandt became the youngest member of the Forbes 400 by building an enterprise software juggernaut. He's quietly returned, bigger ...
Webex Review: Best Cloud-Based Video Conferencing Collaboration Software  Business News DailyAfter conducting extensive research and analysis of video conference services, we recommend Webex as the best video conference *service* for cloud ...
DriveNets Pockets $110M to Pave Software Disaggregation Path  SDxCentralIsraeli software startup DriveNets landed $110 million in first round financing to boost its focus on helping *service* providers disaggregate proprietary routers from ...
ULTIMATE SOFTWARE INVESTOR ALERT BY THE FORMER ATTORNEY GENERAL OF LOUISIANA: Kahn Swick & Foti, LLC Investigates Adequacy of Price and Process in Proposed Sale of The Ultimate Software Group, Inc. - ULTI  PRNewswireNEW ORLEANS, Feb. 15, 2019 /PRNewswire/ -- Former Attorney General of Louisiana Charles C. Foti, Jr., Esq. and the law firm of Kahn Swick & Foti, LLC ...
Anti-violence measures including phone checks for hidden software  The AdvertiserPeople who fear they are being cyber-stalked by a controlling partner would be able to scan their mobile devices for hidden software under a trial to ensure the ...
The Internet Was Built on the Free Labor of Open Source Developers. Is That Sustainable?  MotherboardA look at the complicated business of funding open source software development.
Today's Pickup: Beyond Software In The AV Space; SmartWay Slashes Emissions, Fuel Costs  BenzingaGood day,. As the self-driving vehicle space matures, industry experts are calling attention to technology challenges that aren't quite as sexy as AV software but ...
Software Pirates Hack iPhone Apps To Bypass App Store By Utilizing Apple Digital Certificates  Lowyat.NETApple is clearly not having a good start to the new year. Not only has the fruit company had to address the recent breaches conducted by both Google and.
Top 5 software to recover Microsoft Excel passwords  Windows ReportForgoten password for your MS Excel spreadsheet and WorkBook? Here are the best software to recover MS Excel password on Windows 7-8-10 PCs.
Iowa software company seeks more than $2.5M in state help  News8000.com - WKBTA software company wants more than $2.5 million in state aid to expand in Ames.
“A goldmine of tech talent:” Two reports highlight growing software export capacities in four Eastern European countries  Tech.euThe growth of the IT *service* market is driven by a long-term upward trend which involved the world's increasing economic interdependence, the transfer of jobs ...
How to update the software on your Honor 8X  Android CentralUpdates bring new features, tighten up security, and generally make us feel good. Make sure you never miss one on your Honor 8X by learning how to update it.
Move Over Actors And Artists, Software Developers Are True Creative Heroes  ForbesSoftware engineers are not workhorses, they are inherently creative people who, given the right environment, can transform the fortunes of a company. Business ...
Global $78.62 Bn Automotive Software Market, 2018-2026 - Key Players are NXP, Renesas, BlackBerry, Elektrobit, Microsoft, NVIDIA, Airbiquity, Green Hills Software, Wind River and Aricent  GlobeNewswireDublin, Feb. 15, 2019 (GLOBE NEWSWIRE) -- The "Global Automotive Software Market Size, Market Share, Application Analysis, Regional Outlook, Growth ...
Providers Use Therap's Disability Software to Generate Comprehensive Reports for Audits, Compliance and Quality Assurance  Markets InsiderWATERBURY, Conn., Feb. 15, 2019 /PRNewswire/ -- Therap's electronic health record and documentation system is the leading software globally and within the ...
Should You Invest in the Invesco Dynamic Software ETF (PSJ)?  NasdaqIf you're interested in broad exposure to the Technology - Software segment of the equity market, look no further than the Invesco Dynamic Software ETF (PSJ), ...
Harris Beach creates software company  Rochester Business JournalThe Harris Beach law firm has created a new company, separate from the law practice, offering a cloud-based subscription software tool to help companies with ...
Atlassian rewrites the SaaS playbook with beloved products like Jira  Business InsiderAtlassian is so vital to how businesses work, it's practically recession-proof, says BTIG's Joel Fishbein.
What Will Software Look Like Once Anyone Can Create It?  HBR.org DailyA former YouTube executive on building apps without knowing how to code.
Xiaomi’s MIUI 10 Global software is getting a built-in dark theme  XDA DevelopersXiaomi's MIUI 10 will receive a system-wide dark theme soon on the lines of Android Q's dark mode, starting today with the MIUI 10 Global Beta v9.2.14.
This software program could help prevent future school shootings  CNNIn the wake of increasingly frequent school shootings, school districts across the country are using a combination of tools to try to prevent another tragedy. One of ...
Software for assigning family members same polling booth  Times of IndiaPune: The Election Commission of India (ECI) has instructed the electoral registration officers of all the assembly constituencies to complete “family.
Israeli software firm DriveNets raises $110 million in first funding round  Reuters UKTEL AVIV (Reuters) - Israeli networking software company DriveNets said on Thursday it raised $110 million in its first round of financing led by Bessemer ...
Samsung One UI (Android 9 Pie) review: Samsung's best software yet  Android CentralSamsung's Android 9 Pie release, with the new One UI interface and features, is something every Samsung phone owner should look forward to.
The Lethality of Software | SIGNAL Magazine  Signal MagazineArtificial intelligence, machine learning, advanced manufacturing, blockchain, 5G, the Internet of Things, quantum computing, data science, cloud computing and ...
Police Hope Software Can Help Avoid \'Losing\' Sex Offenders  Government TechnologyContinually improving information sharing, mapping and *content* management systems have allowed law enforcement agencies across the country to keep ...
InfluxData raises $60 million for time-series database software  VentureBeatInfluxData has raised $60 million for InfluxDB, its time-series data management software that's freely available on GitHub.
Video Management Software market 2022  Wise AwarenessMarket Research Report on Video Management Software 2022 by Research for Markets.
AMD Releases Radeon Pro Software for Enterprise 19.Q1: Adds Limited Support for Consumer Radeon Cards  AnandTechHeadlining this release, on the heels of the launch of the prosumer-oriented Radeon VII, AMD is introducing Radeon Pro Software compatibility for many of their ...
UK software firm Micro Focus 'back on track' as revenue tops expectations  City A.M.London-listed software firm Micro Focus said sales had fallen less than expected last year, causing its share price to jump as much as 15 per cent.
Global Dental Practice Software Market 2018:2025, Top Players – Solutionreach, Bestosys Solutions  Industry News NetworkMRS Research Group recently Published Global Dental Practice Software Market research study with more than 100 industry informative desk and Figures ...
Brokerages Set Software AG (SOW) Target Price at $41.24  Fairfield CurrentSoftware AG (ETR:SOW) has been assigned a consensus rating of “Hold” from the nineteen research firms that are covering the company, MarketBeat reports.
One Investment Firm Found a Silver Lining in the Mortgage Industry: Software  The New York TimesA mortgage-processing software company called Ellie Mae will sell itself to Thoma Bravo for $3.7 billion — an impressive feat in a strained industry.
TIAA CREF Investment Management LLC Decreases Holdings in American Software, Inc. (AMSWA)  Fairfield CurrentTIAA CREF Investment Management LLC cut its stake in American Software, Inc. (NASDAQ:AMSWA) by 10.1% in the 3rd quarter, according to its most recent ...
Global Customer Communication Management Software Market 2018:2025 – Adobe Systems, Cincom Systems, Doxee SPA, Dell  Industry News NetworkThe Customer Communication Management Software Global market 2019-2025 from QY research gives basic data to advertisers, managers, analysts, business ...
Global Student Information System Software Market 2018:2025, Top Players – Skyward, Ellucian, Blackbaud, Jenzabar  Industry News NetworkMRS Research Group recently Published Global Student Information System Software Market research study with more than 100 industry informative desk and ...
Firm Offers Software To Clean Rented Email Lists 02/14/2019  MediaPost CommunicationsMost comments about email lists now focus on customer files, it seems. But Mr. Marketing, a digital marketing specialist, is offering software for brands using ...
Slic3r vs Cura – 3D Printer Slicer Software Shootout  All 3DPIf you've been trying to find the latest features on the best slicers, look no further. We compare the top two open source slicers, Slic3r and Cura, focusing on their ...
D.C. restaurant software company sets sights on international markets  Washington Business JournalHostme recently closed on $1.3 million in new funding.
Global Diagram Software Market 2018:2025, Top Players – Microsoft, JGraph, Cinergix, Slickplan, SmartDraw, Gliffy  Industry News NetworkMRS Research Group recently Published Global Diagram Software Market research study with more than 100 industry informative desk and Figures spread ...
Software developers need more confidence on Stack Overflow  QuartzEvery software developer is familiar with the site Stack Overflow, the 11-year-strong compendium of questions and answers. Part knowledge base, part social ...
IonSense Introduces PIMISA Search Software for Rapid Identification of Drugs of Abuse by DART-MS  GlobeNewswireTogether with the DART®-equipped Waters ACQUITY® QDa detector, drug samples are identified with yes/no answers in seconds instead of hours. The system ...
Why Software Companies Should Care About Global Warming  ForbesGlobal warming could affect every industry and area of the planet. Many tech giants are working toward greater energy efficiency and sustainability -- and your ...
Apple Releases Software Fix for FaceTime Eavesdropping Flaw  BloombergApple Inc. on Thursday released a software update for iPhones and its other devices to fix a bug that let users of its FaceTime video-chat *service* listen in on ...
Former Sage CEO joins software firm  BusinessCloudStephen Kelly and ex-Salesforce chairman Steve Garnett invest in fast-growing company which helps keep millions of people engaged with online *content*.
Job Role: Software Engineer  TechopediaSoftware engineers are behind the software and apps that we use. But what exactly does the role entail? Here we examine the duties of a software engineer.
Best file recovery software  TechRadarAccidentally deleted a file, or had it nuked by a virus? All is not lost.
In Quadriga saga, 30-year-old software engineer makes a $560K mistake  BNNBloomberg.caTong Zou wasn't a stereotypical crypto bro bent on accumulating flashy trophies such as Lamborghinis when he deposited his life savings into Quadriga CX's ...
Bill and Melinda Gates said software is making school textbooks obsolete, and it could save college students thousands of dollars  Business InsiderNot only is technology making physical textbooks "a thing of the past," Bill and Melinda Gates wrote, but it's making education cheaper, too.
Enjoy a '93 video tour of id Software while Doom was being made  GamasutraThe clip appears to have been online for ages, but if you haven't yet seen it it's well worth a watch to get a sense of what id Software (and game dev.
Global Yard Management Software Market 2018:2025, Top Players – HighJump, c3 Yard, DEPOT Core, Omni-ID  Industry News NetworkMRS Research Group recently Published Global Yard Management Software Market research study with more than 100 industry informative desk and Figures ...
The Best Online Tax Filing Software for 2019  TheStreetThe 2019 online tax preparation packages are out, and there is no shortage of great tax management deals to choose from....HRB.
Why free software evangelist Richard Stallman is haunted by Stalin's dream  FactorDailyMore than 30 years ago, Richard Stallman quit a doctorate program at the MIT to start the GNU Project, a free software operating system. Not only has he been ...
Music Composing Software Market by Instrument Simulation - Global Market Size, Share, Development, Growth and Demand Forecast (2013-2023) - ResearchAndMarkets.com  Business WireDUBLIN--(BUSINESS WIRE)--The "Music Composing Software Market by Instrument Simulation - Global Market Size, Share, Development, Growth, and ...
Stupid Patent of the Month: IBM's Software Patent on Texting and Driving  EFFIn the smartphone era, “distracted driving” is a serious, and well-known, problem. Official warnings about poor driving habits are as old as the automobile itself.
11 Best Free Floor Plan Software Tools in 2019  G2 CrowdFloor plan software has myriad uses, including office space planning, facility plant floor planning, and venue management planning. Even parking lots benefit ...
WeWork Continues Its Software Company Acquisition Bender, Aims To Be Tech Company  BisnowWeWork snaps up yet another software company, the better to become a tech giant.
Racami Releases Enhanced Version of Alchem-e Software Platform  Printing ImpressionsATLANTA - February 15, 2019 - On Wednesday Feb. 6, Racami, the IT services and software company released an enhanced version of its Alchem-e software ...
Amazon Still Pushing Biased Facial-Recognition Software To Law Enforcement, MIT Researcher Contends  ForbesAmazon CEO Jeff Bezos was made aware of biases in its facial-recognition software last June when Joy Buolamwini, an activist at MIT Media Lab and founder of ...
Marin Software shares slide on disappointing 4Q results  Proactive Investors USA & CanadaShares of Marin Software Inc (NASDAQ:MRIN) tumbled in pre-market trade Friday, after the cloud-centered digital marketing software group disappointed ...
Apple Planning to Modify iPhone 7, iPhone 8 Software and Hardware to Circumvent Ban in Germany: Report  Gadgets 360After being forced to pull the iPhone 7 and iPhone 8 from sale in Germany, Apple has reportedly found a way to bypass Qualcomm's patent infringement claims.
Looking to give wings to your software development and deployment?  The RegisterEvents Whether you're just piloting your first DevOps projects, want to scale things up, or are ready to leap into Kubernetes or Serverless, you should be joining ...
Software Engineer (Desktop) Internship - iManage  Built In ChicagoiManage is hiring for a Software Engineer (Desktop) Internship in Chicago. Find more details about the job and how to apply at Built In Chicago.
More On The Return Of Tesla’s Software-Limited Battery Pack Scheme  InsideEVsWe really can't say we're surprised to see the return of Tesla's software-limited battery scheme. It just makes more sense to handle "trims" this way.
Stanford spurs AI navigation for space rendezvous software | Stanford News  Stanford University NewsAn AI-powered navigation system would direct spaceborne 'tow trucks' designed to restart or remove derelict satellites circling aimlessly in orbit.
Cisco’s AppDynamics software ties in SDN, serverless for greater app management  Network WorldThe wide-ranging Cisco AppDynamics announcement targets enterprise customers looking to monitor performance and automate the response to problems in ...
Ciena Spins Off Blue Planet Software Into an Independent Division  SDxCentralCiena anticipates that Blue Planet will reach $50 to $60 million in annual revenue during fiscal 2019, and to $100 to $120 million in 2021.
New Software Tool Helps Urban Planners Increase Bike Lanes  Interesting EngineeringUrban Planners have a new data-driven software tool to assist them to place bike lanes in areas where they will be most beneficial. The tool was developed out ...
How Lloyds' software dept. is engineering the bank of the future  TecheratiFor banks to truly benefit society, they need to harness the combined power of all the great minds sitting in their engineering ranks, says James McLeod.
SolarWinds CEO On MSP Software, Private Equity And DRaaS  ChannelE2ESolarWinds CEO Kevin Thompson's favorite acronym appears to be MSP (managed services provider). The evidence: Thompson, his executive team, and Wall ...

Windows x: Basic Windows ?Security? Issues

Language development computer: Computer-based method for aiding language development seems... Read More

Fleet Maintenance Software Reviews

Innovative Maintenance Systems (IMS) is one company that offers solutions... Read More

Free Software: How Not To Get More Than You Bargained For!

I completed an experiment recently. I wanted to find out... Read More

Corporate ERP: Standard vs. Rich functionality ? Microsoft Great Plains

Traditionally we were considering functionally rich systems, such as SAP,... Read More

Microsoft Axapta, Navision or Great Plains: ERP Selection for Large Corporation

If you would like to pick something from Microsoft, or... Read More

How to Build a Basic CSS Layout

Designing without tables by using CSS layouts is fast becoming... Read More

Microsoft Great Plains as ERP and Microsoft CRM as CRM

If you have Microsoft Great Plains and support it for... Read More

Five Steps to Rapid Development with TierDeveloper 4.0

Follow the steps below to quickly design, generate, and deploy... Read More

Unofficial Windows 98 SE Service Pack 2.0 RC2

Microsoft has never released a service pack for Windows98 SE,... Read More

The Dirt on Screensavers

Remember back in the days where screensavers were the coolest... Read More

Beware of Spyware

One day, you suddenly realize that your computer started to... Read More

Why do Manufacturers Invest in Business Management Software?

With many manufacturing shops heading over seas in favor of... Read More

Crystal Reports - Microsoft SQL Server

Microsoft SQL Server is the leader for inexpensive and middle... Read More

Four Easy Ways To Prevent Spyware

How would you like to prevent spyware and adware from... Read More

Collaboration Software: Index of Collaboration Software Technologies

Collaboration SoftwareCollaboration Software, also known as group collaboration software or... Read More

Microsoft CRM Customization: Integration with Third Party SQL Application/Database

Microsoft CRM ? Client Relationship Management package from Microsoft Business... Read More

How To Identify, Cure and Prevent Spyware/Adware Infections

Just when you thought you were Web savvy, one more... Read More

OSI Layers Model

IntroductionDuring the early years of our modern computer era, very... Read More

Microsoft CRM Customization Secrets ? Second Edition

This article is for advanced Microsoft CRM SDK C# developers.... Read More

Microsoft Great Plains Implementation: Collection Management ? Overview For Consultant

Microsoft Business Solutions Great Plains is very good fit for... Read More

Configure Windows Indexing Service for Performance

The Windows Indexing Service provides you with the ability to... Read More

Introducing GRML

Creating a new markup language.Introduction.General Reuse Markup Langauge, or GRML,... Read More

Mapping Software: Putting Data Visualization on the Map

Mapping Software Improves Data VisualizationFrom the outset, it is important... Read More

Microsoft CRM Customization

Microsoft CRM customization techniques are very diversified and based on... Read More

Microsoft CRM in Latin America: Implementation, Customization, Support ? Overview for Consultant

Microsoft Business Solutions CRM is present several years on the... Read More