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

CancelDocument

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")

Else

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

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

End If

DestinationFields("Check.Date")=GetVariable("DocDate")

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

DestinationFields("Check.Date")=DestinationFields("Check.Date")+1

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:

ClearVariables

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:

JOHNB BANKOFAMERICA

PETERP BANKOFAMERICA

MARTHAM CITIBANK

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! help@albaspectrum.com

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 (www.albaspectrum.com), he is Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer; akarasev@albaspectrum.com

Groupware Finds Home in American Business: Collaboration Tool Analysis

What is Groupware?Have you ever had to manage document collaboration in a hurry? No need... Read More

Most Common Ways to Accumulate Spyware (where It is Downloaded to Your PC)

It is possible that if one avoided all sources of spyware, ad-ware and virus infection... Read More

Microsoft Great Plains 8.0 Brazilian Version ? Overview For International Consultant

Microsoft Great Plains has substantial mid-market share in the USA plus due to the ... Read More

HelpDesk & Asset Management Software - Choosing The Right One

If you are to buy a HelpDesk & Asset Management software, see the following checklist... Read More

Microsoft CRM Development

Microsoft CRM is CRM answer from Microsoft Business Solutions.The whole conception behind CRM seems to... Read More

Microsoft Great Plains: Service Business Customization & Integration Example

Microsoft Business Solutions Great Plains might be considered as ERP platform, ready for customization and... Read More

Microsoft Great Plains RW: Report Writer

Microsoft Business Solutions Great Plains is marketed for mid-size companies as well as Navision (which... Read More

Anti-Virus Software

Anti-virus software is used to find, remove or fix files that are infected with computer... Read More

Downloading Spyware Removers: Think Before, not After

Just imagine: you are walking, say, towards your car, and all of a sudden somebody... Read More

Microsoft Blues

With the advent of 'Service Pack 2' for Windows XP operating system, Microsoft have really... Read More

Cisco Certification: Five Things To Do DURING Your CCNA Exam

There are plenty of articles out there about how to prepare for the CCNA exam.... Read More

How to Tell You Have Spyware, Ad-ware or Viruses

Usually, the easiest way to tell you have spyware is because your PC is running... Read More

Microsoft Great Plains Installation ? Overview for IT Director/Controller

Microsoft Great Plains is main mid-market application from Microsoft Business Solutions. This is short article,... Read More

Dashboard Widgets for Windows

For a windows user like me, just can watch with envy the new eye candy... Read More

Microsoft Great Plains Subcontracting ? Overview for Microsoft Business Solutions Partner

Microsoft Business Solutions Great Plains is very popular ERP/MRP applications in the USA, Canada, UK,... Read More

Reduce TCO: The Java Database Way

TCO (Total Cost Ownership) is the buzzword in today's business world. This metric... Read More

Spyware, Adware, etc. -- Terms and Common Sense

When reading an article where some term is used often, it is useful to make... Read More

DB Integration - Software for Combine MS Access Databases

Our company, Novaprof Inc., developed unique software - DB Integration. This software makes it possible... Read More

Groupware and Online Collaboration: Collaboration Series #4

This article is the fourth of a series of articles exploring specific aspects of groupware.... Read More

Assertion in Java

Assertion facility is added in J2SE 1.4. In order to support this facility J2SE 1.4... Read More

Choose your Java Wisely

Java has come along a long way. Many would agree with this. I did not... Read More

Great Plains Dexterity ? Microsoft Great Plains Customization Overview

Microsoft Business Solutions Great Plains, former Great Plains Software Dynamics and eEnterprise are Dexterity-written applications.... Read More

Microsoft Great Plains e-Commerce ? additional considerations for programmer

Microsoft Great Plains, designed back in 1990th as database transferable and graphical platform... Read More

Enterprise Resource Planning Overview

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

Great Plains Dexterity History and Programming Overview

As of now - Great Plains Dynamics/eEnterprise is transformed/renamed into Microsoft Great Plains and Microsoft... Read More

Free Microsoft Word Online Training Tutorial Resources

Microsoft Word is one of the most popular office applications that provide many features such... Read More

The Truth about Colossus: Are You Just A Magnetic Image?

What is Colossus?Colossus is software licensed to about twenty-five insurance companies to aid in predicting... Read More

An Easy Way to Develop JAVA Enterprise Applications

Research bears that less than 70 percent of development projects are actually completed, and more... Read More

Spyware, What is it?

Spyware, what it is and what it does. Basically, spyware is a program put on... Read More

.Net Charts and Graphs Interact with Businesses and Customers

Bar charts, bar graphs, and any other chart or graph used in financial statements, inventory... Read More

Recovering Microsoft Great Plains Customization ? Tips for IT Director

Remember nice and prosperous Clinton era? When you implemented innovative those old days accounting application... Read More

Microsoft Business Solutions Products Selection: ERP, CRM, Retail Management

Let's first look at your ERP system selection (without Retail Solution). Your options are:Microsoft Great... Read More

FreeDOS

Before September 1995, Microsoft Windows was an MS-DOS program. DOS was an easy to use... Read More

Screenshots Vista Windows

Features Additionally, Vista will include many other new features.Aero Vista will include a completely re-designed... Read More

Microsoft Great Plains Nationwide Remote Support

ERP Consulting industry is on the way to serve clients nationwide and even worldwide, when... Read More

A Simple Guide To Wikis

A wiki is an editable text-based website. But you don't need to understand any complex... Read More

Reloading Windows XP

If you have been running Windows XP for a couple of years or more you... Read More

Accessing XML Using Java Technologies

The most important benefit of XML is its simplicity. Though it is simple it is... Read More

Microsoft Great Plains Integrations - Tips for Developer

In this short FAQ style article we would like to introduce you - software developer,... Read More

MultiNational Corporation ERP Implementation ? Microsoft Business Solutions Great Plains

If you look back to the history, you will see that ERP for large publicly... Read More

What is Spyware? Are You Being Watched?

Find out why Spyware Removal from computers is important and how adware infestations affect your... Read More

Microsoft Great Plains: Manufacturing or Bill of Materials - Overview for IT Specialist

Microsoft Great Plains is main Microsoft Business Solutions product, targeted to mid-size companies. Currently Microsoft... Read More

Rapid Application Development - Is it Really a Need of Today?

Rapid Application Development (RAD) is a software development methodology. In this competitive world, software product... Read More

COSMIC: A Small Improvement on the Symons Method

The COSMIC FP (function point) software quality metric, is no longer 'proposed' but an actual... Read More

What is Fleet Maintenance Management?

Fleet Maintenance Management is a critical position in any company that has a number of... Read More

MicroWorld Releases New Version of MailScan Ver. 4.5 - Antivirus and Content Security Software

MicroWorld Technologies, Inc. the leading solutions provider in the area of Anti-virus and Content security,... Read More

Explore the Internet in a Whole New Way

For a long time now Microsoft's Internet Explorer has ruled as 'King of Internet browsers'.... Read More

Microsoft Great Plains Upgrade ? Things to Consider and FAQ

If you have Microsoft Great Plains and support it for your company then you need... Read More

Industry Experts Answer the One Million-dollar Question - Why Genie Backup Manager?

Many reasons made GBM a unanimous choice for experts, one of them is the fact... Read More

Three Steps To Windows Safety Heaven

Now there are Three Steps To Heaven Just listen and you will plainly see How... Read More