Home
>
Software
>
Microsoft Great Plains Customization Tools Evolution ? Overview for Consultant

Microsoft Great Plains Customization Tools Evolution ? Overview for Consultant

When Great Plains Software introduced the first graphical accounting application for Mac and Windows in the beginning of 1990th it had Great Plains Dexterity customization tool, IDE and programming language. Dexterity design was based on several longevity principles: Graphical platform independence and database platform independence and easy switch from one DB to the other among the most important ones. Dexterity was written as a shell in C programming language, which was "platform independent" and at the same time very efficient in compilation (close to assembler). Since then we saw new tools and options:

? Modifier with VBA. This tool allows you place custom buttons and editable fields on the forms and attach VBA scripts to these buttons and fields. Theoretically you can deploy ADO and make a call to the database, but typically this would be given to Dexterity programmer. Also Modifier can deal with ReportWriter report ? which is rarely used option, but you should be aware of it. Another usufull feature - calling Crystal Reports engine from VBA, so you can print custom Crystal Report - Invoice from SOP Entry screen, instead of regular Report Writer SOP Invoice Form.

? Continuum for VB and Delphi. We do not touch obvious features of Continuum, but would like to mention its advanced use. First ? in Dexterity you can not easily target multiple modules (coming from different software vendors ? those days Intellisol Advanced Purchase Order Processing, Project Accounting and ForeStar Fixed Assets). This feature could be addressed through Continuum generated VBA code with inclusion of Dexterity Scripts (Sanscript). The second nice feature of Continuum could be Great Plains Integration Manager custom apps, which allows you to switch Great Plains companies automatically and integrate the whole corporation during the night

? Dexterity SQL Support. When Great Plains C/S+ was introduced on MS SQL Server 6.5 platform ? instead of using Dexterity cursors ? you could use the way more efficient stored procedures and simply call them from Dexterity code. The negative side of this was ? you can not have your custom piece running on Btrieve or Ctree platforms, where Dexterity cursors were the only way to work with the database

? Dexterity COM object support. This was new feature of Microsoft Great Plains Dexterity version 7.0. This feature allows you to call something nice, like web service from your COM object and in this case replace, say Great Plains tax engine with the one working from your web server, located in one place and serving numerous subscribers.

? eConnect. This tool was initially designed for eCommerce developer, who deploys Microsoft Great Plains as the back end/ERP. eConnect is SDK with SQL Stored Procedures and parameters descriptions.

? Extender. We'll wait the next version ? but even now it is very promising and it doesn't require you to be programmer to customize Great Plains.

We encourage you to analyze your alternatives. You can always appeal to our help, give us a call: 1-866-528-0577 or 1-630-961-5918, help@albaspectrum.com

Andrew Karasev is Chief Technology Officer at Alba Spectrum Technologies ( http://www.albaspectrum.com ), serving Microsoft Great Plains, CRM, Navision to mid-size and large clients in California, Illinois, New York, Georgia, Florida, Texas, Arizona, Washington, Minnesota, Ohio, Michigan

shuttle to Midway Beardstown .. Lockport Chicago limo O’Hare

In The News:

The FBI has issued a warning that scammers are impersonating doctors, police and banks using spoofed numbers as "smishing" texts surge nationwide.

Communities with unreliable internet service stand to gain after Amazon's Project Kuiper launched its first full batch of satellites into orbit April 28.

Tech expert Kurt “CyberGuy" Knutsson says unsubscribing from spam might actually backfire. Learn when to avoid it and stop junk effectively.

Tech expert Kurt “CyberGuy" Knutsson talks about how the first nonstop beating heart transplant, called zero ischemic time, at Taiwan hospital changes surgery.

Kurt “CyberGuy" Knutsson: FBI warns of "time-traveling" hackers.

Kurt “CyberGuy" Knutsson talks about a soft, vine-like robot called SPROUT that aids safe survivor rescues in collapsed buildings.

Health insurance giant Blue Shield of California confirmed it had been sharing private health data of 4.7 million users with Google for three years without even realizing it.

Delta and JetZero’s blended wing body aircraft marks a meaningful step toward a cleaner, quieter and more efficient future for air travel.

Recent reports show many common passwords can be cracked in literally seconds. Kurt the CyberGuy explains how to strengthen your passwords.

Stay up to date on the latest AI technology advancements and learn about the challenges and opportunities AI presents now and for the future.

Iron, a robot that stands 5 feet, 8 inches tall and weighs 154 pounds, combines advanced artificial intelligence with human-like movement and exceptional vision.

Hertz, the rental car giant, recently confirmed that customer information was exposed through a cyberattack on one of its software vendors.

There are a number of features with AirPods you may or may not know about to take your listening experience to the next level. Kurt the CyberGuy explains.

These 35 Chrome extensions have privacy and security concerns. Tech expert Kurt “CyberGuy" Knutsson says to delete them now.

Tech expert Kurt “CyberGuy" Knutsson says 329,000 mph fusion rocket promises to be fast, disruptive and enable deep-space missions.

Stay up to date on the latest AI technology advancements and learn about the challenges and opportunities AI presents now and for the future.

Tech expert Kurt “CyberGuy" Knutsson says a new autonomous AI is a game changer that also raises privacy risks. Is your data safe?

Tech expert Kurt “CyberGuy" Knutsson says robots and drones are revolutionizing fruit farming with faster picking and smarter handling.

Landmark Admin revises May 2024 cyberattack scope to show twice as many people were affected. Kurt “CyberGuy" Knutsson gives tips to help stay safe from an insurance data breach.

Tech expert Kurt “CyberGuy" Knutsson talks about how Yamaha’s hydrogen outboard motor could revolutionize boating with zero emissions.

Tech expert Kurt “CyberGuy" Knutsson reveals how to memorialize or remove a deceased loved one’s Facebook account and protect their digital legacy from misuse or scams.

Tech expert Kurt “CyberGuy" Knutsson says an Apple Watch saved psychiatrist Amanda Faulkner by detecting deadly leukemia early.

Scammers and fraudsters are increasingly targeting the most vulnerable, especially nursing homes and the personal data of their residents. Kurt the CyberGuy has safety tips.

Infected USB flash drives can spread malware among multiple organizations in ways that can easily bypass traditional security systems.

With a fully automated warehouse system and AI-powered robots, Ocado's Hive picks, packs and delivers grocery store orders in just a few minutes.