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.

express cleaning service Arlington Heights ..

In The News:

Researchers from Osaka Metropolitan University designed a 21-foot dome that combines aquaculture and hydroponics to create a self-sustaining urban food system.

The Fox News AI Newsletter gives readers the latest AI technology advancements, covering the challenges and opportunities AI presents.

ChatGPT data breach exposes personal info of users through partner Mixpanel. OpenAI confirms names, emails compromised in security incident.

Android rolls out Emergency Live Video for 911 calls, letting dispatchers see real-time scenes during emergencies. Great for holiday travel safety.

Malicious Chrome and Edge extensions collected browsing history, keystrokes and personal data from millions of users before Google and Microsoft removed them.

Google's new Call Reason feature lets Android users mark calls as urgent before dialing, displaying an urgent label to recipients using Phone by Google app.

Medical history made as surgeons successfully restore sight to legally blind patient using world's first 3D printed corneal implant grown from human cells.

Data brokers aggressively collect your holiday shopping data to fuel scams and targeted ads. Learn how to delete your digital profile before 2025 starts.

Scammers are sending fake MetaMask wallet verification emails using official branding to steal crypto information through phishing links and fraudulent domains.

Learn what background permissions, push notifications, security updates, auto-join networks and app refresh mean to better manage your phone's privacy settings.

Criminals test stolen data by applying for deposit accounts in victims' names to prepare bigger attacks. Learn why banks won't share fraud details.

New study of 10,500+ kids reveals early smartphone ownership linked to depression, obesity, and poor sleep by age 12. Earlier phones mean higher risks.

A phone phishing attack compromised Harvard's alumni and donor database, marking the second security incident at the university in recent months.

AutoFlight's zero-carbon floating vertiport uses solar power to charge eVTOL aircraft while supporting emergency response, tourism, and marine energy maintenance.

A new phone return scam targets recent buyers with fake carrier calls. Learn how criminals steal devices and steps to protect yourself from this fraud.

New Anthropic research reveals how AI reward hacking leads to dangerous behaviors, including models giving harmful advice like drinking bleach to users seeking help.

The Fox News AI Newsletter gives readers the latest AI technology advancements, covering the challenges and opportunities AI presents.

Holiday email scams, including non-delivery fraud and gift card schemes, spike in November and December, costing victims hundreds of millions, the FBI says.

Holiday visits offer the perfect opportunity to help older parents with technology updates, scam protection and basic troubleshooting skills for safer digital experiences.

Swiss scientists create grain-sized robot that surgeons control with magnets to deliver medicine precisely through blood vessels in medical breakthrough.

Researchers exploited WhatsApp's API vulnerability to scrape 3.5 billion phone numbers. Learn how this massive data breach happened and protect yourself.

Travel companies share passenger data with third parties during holidays, but travelers can protect themselves by removing data from broker sites and using aliases.

Xpeng's humanoid robot moves so realistically that crowds believed it was fake, marking a major advancement in robotics technology ahead of 2026 commercial launch.

Researchers discover phishing scam using invisible characters to evade email security, with protection tips including password managers and two-factor authentication.

iPhone and Android users can reduce battery drain and data usage by restricting Background App Refresh to Wi-Fi connections instead of mobile networks.