Home
>
Software
>
Microsoft Great Plains Customization Tools ? Overview

Microsoft Great Plains Customization Tools ? Overview

Former Great Plains Software Dynamics/eEnterprise, and currently Microsoft Business Solutions Great Plains was initially designed in the earlier 1990th as the extendable and modular application with its proprietary tool: Great Plains Dexterity, written in C programming language as a shell. This was popular tendency those days ?compare with SAP ABAP or Navision C/Side. Great Plains has additional ideas ? database platform independence and graphical platform independent interface (initially targeted to both Apple Macintosh and Microsoft Windows with good chance that one of them will take market over ? and it did happen, including the acquisition of Great Plains Software by Microsoft). In this small article we'll give you revised overview ? you can find previous publication in the last year posts.

? Great Plains Dexterity. Dexterity is the architecture of Great Plains and it is very difficult to take it out of the picture. So we'll say that if you plan on creation GP module or custom piece for reselling it on the market ? you should first consider Dexterity as a tool. Dexterity requires deep training and some experience ? you can not begin programming in Dexterity over night. So-called fat client of Great Plains is pure dexterity application, however database itself since version 8.0 is MS SQL Server with some Dexterity specifics (DEW_ROW_ID column, for example).

? Old Tools. These tools were popular in 1990th and relate to such now legacy technologies as OLE, VBA scripting, etc. Please note that even if C was considered as universal language ? custom scripts were targeted for light customizations and both C and VBA were targeted to modify fat client ? thin client and web interface were not known those good old days.

1. VBA/Modifier. Microsoft introduced VBA as scripting for light customization of Microsoft Office products ? Excel, Word, etc. Great Plains adopted it for its own needs. It tried to produce Dexterity/VBA hybrid and allowed Dexterity forms to be modified via Modifier (Dexterity application) and enabled modified screens to adopt VBA for its fields.

2. Continuum for VB/Dephi. Borland was strong on the customization market ? this is why it also includes Delphi. In Continuum you can program Great Plains workstation as OLE server. For example ? you can have Great Plains Integration Manager integrate several companies data one-by-one with automatic logging in and off without operator intervention ? over night for example. Also ? you can deploy Continuum to switch Dexterity modules (such as Intellisol APOP or Project Accounting) and include Dexterity Sanscript code into VBA scripts.

3. ReportWriter. We placed RW in this section because it is Dexterity application and is now actively replaced with new tools, such as Crystal Reports, SQL Reporting, XML & HTML web publishing

? New Tools. In XXI century development world begins to bias toward thin and web clients and SQL scripting. eCommerce is a must for retail and wholesale nationwide businesses and Microsoft Business Solutions come with these tools:

1. eConnect. As good instrument for eCommerce developer ? it allows to create, modify and delete Great Plains objects ? customers, invoices, purchase orders, payments, inventory items. It has certain restrictions ? it can address core Great Plains objects (not something in former third party modules ? Collection Management, Customer/Vendor Consolidation, etc.). Also eConnect can not post SOP, AR, AP, POP documents ? posting should be done by operator in Great Plains. However you can deploy posting stored procedures, available on the market (through Alba Spectrum for example)

2. Extender. Let's see it in action in the following year. The idea is really nice and it allows non-developer to modify Great Plains screens and place custom logic

You can always appeal to our expertise. Give us a call: 1-630-961-5918, 1-866-528-0577, help@albaspectrum.com

Andrew Karasev is Chief Technology Officer at Alba Spectrum Technologies ( http://www.albaspectrum.com ) - Microsoft Business Solutions Great Plains, Navision, Axapta MS CRM, Oracle Financials and IBM Lotus Domino Partner, serving corporate customers in the following industries: Aerospace & Defense, Medical & Healthcare, Distribution & Logistics, Hospitality, Banking & Finance, Wholesale & Retail, Chemicals, Oil & Gas, Placement & Recruiting, Advertising & Publishing, Textile, Pharmaceutical, Non-Profit, Beverages, Conglomerates, Apparels, Durables, Manufacturing and having locations in multiple states and internationally.

maide service in Wilmette ...

In The News:

Bedrock Robotics says its autonomous excavators are doing paid earthwork on active job sites in Texas and Nevada with no operator in the cab.

A dedicated banking computer isolates your financial accounts from malware and phishing, but passwords, SIM swapping and outdated software remain risks.

The OlloNi SS1 AI robot pet uses a 4K camera and facial recognition to learn your family, but its removable Red Heart memory module raises questions.

Nine identity theft warning signs range from unfamiliar credit inquiries to SIM swap attacks that can quietly drain your bank account funds.

Robot.com's R-dog uses articulated legs and wheels to climb stairs and deliver packages, while its built-in screens display paid ads along the route.

MyChart phishing emails mimic real patient portal alerts with fake lab results and malware tricks that target Windows users across the country.

The Fox News AI Newsletter covers the latest artificial intelligence technology advancements, including the challenges and opportunities AI presents now and for the future.

Google's Motion Assist places animated dots on Pixel screens to combat motion sickness in vehicles, but the Android 17 rollout remains limited.

Moving to a 55+ community can quickly expose your data to scammers and data brokers before you even unpack, putting your whole family at risk.

Amazon Prime Air drone delivery plans to reach nearly 500 U.S. cities by the end of 2026, but your yard and ZIP code may determine eligibility.

The FBI reports nearly $21 billion in cybercrime losses for 2025, up 26%, as AI scams make fake voices and identities more convincing than ever.

Uber teen accounts now feature live video streaming from the driver's camera, but encrypted recordings stay on Uber's servers for up to 14 days.

Router firewalls and software firewalls serve different roles in protecting your home Wi-Fi from unwanted traffic and suspicious connections.

A Chrome extension with 70,000 users and a 4.7-star rating began injecting fake update warnings after a threat actor acquired and weaponized it.

Amazon's Alexa+ rolls out free to Fire TV devices across the U.S., but hands-free microphones and stored voice data raise key privacy questions.

Meta's new teen accounts settlement sets a default two-hour daily limit on Instagram and Facebook, plus night mode and school mode restrictions.

The CareCloud data breach exposed Social Security numbers, banking information and medical records belonging to more than 3.75 million people.

Waymo reveals its custom 5-nanometer chip and dual computing systems designed to take over instantly if the robotaxi's primary computer fails.

Identity theft now includes account takeover, phone hijacking and payment card exposure. Here's what to look for in identity theft protection services.

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 and Justice Department seized domains tied to QScan and QTRouter, tools allegedly used by China-linked hackers to breach NASA and other agencies.

Uber Eats drone delivery launches later this year through a Zipline partnership, starting in Dallas and Houston with a goal of one million daily flights.

Medicare Open Enrollment scams start with data broker targeting months before October. Learn why August is the time to remove your personal info.

The World Humanoid Robot Games' crashes show how far the technology still needs to go to be useful, "Survivor" reality TV star and robotics scientist Christian Hubicki says.

X-Humanoid's TianGong Ultra ran 100 meters in 9.32 seconds at Beijing's World Humanoid Robot Games, beating last year's winner by more than half.