Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/a26f9f83/public_html/articles/includes/config.php on line 159
Microsoft Great Plains Integration Manager ? Advanced Techniques > NetSparsh - Viral Content you Love & Share

Microsoft Great Plains Integration Manager ? Advanced Techniques

Great Plains Integration Manager scripting and translation - overview for programmer, software developer, database administrator, IT specialist

Microsoft Business Solutions main middle market ERP application - Microsoft Great Plains has multiple integration options: MS SQL Scripting (stored procedures and views), ADO.Net programming, Microsoft SQL Server DTS packages. You certainly can deploy such SDK tools as eConnect. However here we would like to show you how to program the simplest user friendly tool: Microsoft Great Plains Integration Manager.

We assume that you are familiar with Microsoft scripting technologies: Visual Basic for Application (VBA). You should be aware, however, about poor performance of Integration Manager. We recommend it for low volume of complex transactions. It is good tool, if you are importing about 100 transactions per day from text file (when you need to come through empty lines or something not matching the template to filter integration lines). If you have thousand transactions and performance is critical - switch to SQL Stored procs or Dexterity custom process server.

1. VBA Scripting ? Launch Great Plains Integration Manager, open your integration, right click->Properties, switch tab to scripts, open Before Document script. Now place this code in it:

If Left(SourceFields("F4"), 4)="THRU" Then

SetVariable "DocDate", Right(SourceFields("F4"), 8)

End If

If IsNull(SourceFields("F1")) Or IsNull(SourceFields("F7")) Then


End If

It should mean that you can create DocDate variable and assign it the value from your query field. The second statement cancels document integration if certain condition met (when line is empty or is not actually integration line - something like comment record, etc.)

Now open Before Document Commit script and place this code there:

Dim MyTime, MyHour

MyTime = Now

MyHour = Hour(MyTime)

If Not IsNull(GetVariable("DocDate")) then

SetVariable "DocNumber", GetVariable("DocNumber")+1

DestinationFields("Document Number")="THRU"+GetVariable("DocDate") &"A" & GetVariable("DocNumber")

DestinationFields("Posting Date")=GetVariable("DocDate")

DestinationFields("Description")="Client Check "+ SourceFields("F1")

If Not IsNull(SourceFields("F8")) Then

DestinationFields("Check.Check Number")=SourceFields("F8")


SetVariable "DocNumber", GetVariable("DocNumber")+1

DestinationFields("Check.Check Number")=GetVariable("DocDate")& MyHour&GetVariable("DocNumber")

End If


If Month(DestinationFields("Check.Date")+1)= Month(DestinationFields("Check.Date")) Then


End If

End If

Here you do two things. First you construct check number, using Date and time plus Document number. And the second is even more interesting - you alter check date.

In After Integration script place this code:


It is good idea to nullify your variables.

2. Translation. Imagine that your are something like collection agency and you need to translate your vendors (from whom you purchase AR) into real vendors (banks). In AP integration open Destination Mapping, select Vendor ID, in the Rule Properties, click on the button next to Translation field, answer No, click on Translation tab and paste from Excel your translation list, something like this:




Now your vendors from integration file will be replaced with real vendors from Great Plains.

Happy integrating! if you want us to do the job - give us a call 1-866-528-0577!

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, Colorado, Arizona, New York, Texas, Florida, Georgia, Canada, UK, Australia and having locations in multiple states and internationally (, he is Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer;

In The News:

This RSS feed URL is deprecated, please update. New URLs can be found in the footers at


This Call May Be Monitored for Tone and Emotion
We all know how it feels to be low on energy at the end of a long work day. Some call-center agents at insurer MetLife are watched over by software that knows how it sounds. A program called Cogito presents a cheery notification when the toll of hours ...


How Software Maker Tableau Helps Doctors Tame Data
Aaron Black calls it “hand-to-hand combat”: the time-consuming, painful battle to convert a Tower of Babel of information into life-saving guidance for doctors and researchers. Black is chief data officer at the Inova Translational Medical Institute, a ...

570 News

BlackBerry gains after announcing software expansion, Microsoft partnership
BlackBerry Ltd. BB, -1.78% shares gained in late trading Monday after the company announced an expansion of its security-software gambit that includes a new partnership with Microsoft Corp. MSFT, -1.81% BlackBerry detailed plans for BlackBerry Secure ...
BlackBerry says new software bridge to Microsoft products will increase security570 News

all 17 news articles »

Oracle stock falls as earnings, outlook fuel doubts about cloud software growth
Oracle Corp. shares declined in the extended session Monday after the enterprise software company's quarterly earnings report and forecast did not show the cloud-software growth Wall Street expected. Oracle ORCL, -0.61% shares fell 3.7% in immediate ...

and more »


AI is becoming ubiquitous across enterprise software
This week at IBM Think, it will be difficult if not impossible to avoid the glare of artificial intelligence. With Watson, IBM has bet its reboot on AI. And with attention has come market pressure to make AI more accessible. We posted several months ...

Drone DJ

Software update for the Skydio R1 drone
Drone DJ
Skydio just came out with their fully autonomous R1 drone a few weeks ago and here is the first software update. Some of the improvements include short processing time of the video footage after flights, automatically attempt to reconnect in case of a ...


UK software firm Micro Focus suffers share price collapse
The company added it was grappling with the impact of its recent $8.8 billion (7.2 billion euro) purchase of software assets of Hewlett Packard Enterprise (HPE). The deal was completed last September. Micro Focus added that boss Chris Hsu, a former HPE ...
A firm bought assets from Hewlett Packard Enterprise. Its CEO has now quit and shares are tankingCNBC
Micro Focus value halves after warning on revenueThe Times
Shares of software giant Micro Focus plummet 46 percent as CEO Chris Hsu quitsSiliconANGLE News (blog)
The Guardian
all 83 news articles »

Pirelli using new software to spice up F1 strategies in 2018
Pirelli has developed new software to help it choose race-by-race Formula 1 tyre compounds in order to encourage two pit stops per event, and give teams more strategy options. The Italian company is using simulations to find the best combination of ...
Pirelli using new software to spice up F1, Edition: Global

all 2 news articles »


Xilinx debuts software programmable chip design in data center push
This enables a fundamentally different software centric design flow since all of the connectivity infrastructure is natively software programmable." Xilinx CEO Victor Peng explained that the company's past products have all had some level of ...
FPGA maker Xilinx aims range of software-programmable chips at data centersNetwork World

all 19 news articles »

Baltimore Business Journal

Baltimore software firm Sema Labs raises $500000
Baltimore Business Journal
CEO Matt Van Itallie described Sema Labs as a "software company that writes software to fix other software." He started the company in July last year, after doing extensive research on software maintenance. He previously had jobs in the public and ...

Google News

Microsoft Great Plains Implementation in Russia ? Overview for Consultant

Microsoft Business Solutions Great Plains is very popular ERP platform... Read More

Enterprise Resource Planning Overview

ERP (Enterprise Resource Planning) Overview covers What is ERP, Brief... Read More

How To Avoid Getting Hooked By Pfishing

"Pfishing", sometimes spelled "Phishing", is a word that's used to... Read More

Professional XP Style Icons in Software and Website Development

Using professional icons in your application or website can bring... Read More

Internet Faxing Service Review

The Internet is reshaping every form of communications medium, and... Read More

Microsoft Business Solutions Customization Options - Overview for Programmer

Several years ago Microsoft purchased Great Plains Software, then Navision... Read More

How to Backup Windows XP Home Edition

Your computer cost you from hundreds to thousands of dollars,... Read More

Lotus Domino: Application Integration ? A Programmer View

There are two approaches for application integration:? Programmer's approach ?... Read More

Microsoft CRM Integration with Lotus Notes Domino: Messaging Connector ? Future Directions

IBM Lotus Notes Domino and Microsoft CRM (Client Relation Management)... Read More

Free Program Removes Spyware not Detected by Premium Security Scan

What is Spyware?Spyware monitors your surfing habits and sends the... Read More

Adware and Spyware Blockers

The most important things you can do for your computer... Read More

Groupware: What Works the Way Businesses Do?

GroupwareThe internet is full of 1.5 million to 7 million... Read More

MSN Messenger Is A Sweet Way To Communicate

MSN messenger is a pretty cool invention. I mean I'm... Read More

What Stands Behind The Software Description?

With thousands of web pages added to the Net every... Read More

Microsoft Navision Customization Upgrade ? Tips For Programmer/IT Specialist

Currently Microsoft Business Solutions is on the way of creating... Read More

Integrating Microsoft Great Plains Accounting/ERP: RMS, CRM, eCommerce, Lotus Domino ? overview

Microsoft Business Solutions Great Plains has substantial market share among... Read More

Software: What Suits Me?

Almost all new and major brand of PCs come with... Read More

Daffodil DB: Web Database

What is a Web Database?A web database is a database... Read More

Microsoft Navision Integration with Microsoft RMS - Overview for IT Specialist

Microsoft Business Solutions Navision serves both European and American megamarkets.... Read More

OLAP, An Alternative Technology Over Spreadsheets

Are Spreadsheets Robbing your Enterprise of Competitive Advantage?'90% of "average"... Read More

Best Practices In Choosing Network Monitoring Software

Blue Cross and Blue Shield of Hawaii (HMSA) found itself... Read More

Microsoft Great Plains - Microsoft RMS Integration ? overview

Microsoft Great Plains and Microsoft Retail Management System (Microsoft RMS)... Read More

Do You Want Your Own Fully Programmable ERP? - Part 1

We are in a transition phase in the Managerial Administration... Read More

SpyBot - Search and Destroy versus Microsoft AntiSpyware (Beta).... My personal experiences...

Ok... Where to start?Well, I guess I will start at... Read More

Software Companies: Generate New Revenue Streams and Decrease Costs with Custom e-Learning Content

It's no secret that software companies operate in a very... Read More