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

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

In The News:

This RSS feed URL is deprecated, please update. New URLs can be found in the footers at https://news.google.com/news

GlobeSt.com

New Software Revolutionizes Site Planning
GlobeSt.com
... Areas to create, store and share work orders for properties and facilities. We sat down with Casey Rue, the founder and CEO of Common Areas, to talk about the new software, what users can expect and how it will impact the commercial real estate ...


Xconomy

Xconomy: Quest Analytics Buys Healthcare Compliance Software ...
Xconomy
BetterDoctor, a San Francisco-based startup that has built a national database with information on physicians, dentists, and other practitioners, has been ...

and more »

Forbes

What It Will Take For The Software Services Industry To Navigate A Digital Future
Forbes
No device exists without software, and the end-to-end software services and solutions for businesses across industries are being developed by the information technology (IT) sector. This underlines the need for the sector to be alert to opportunities.


Investor's Business Daily

Software Stocks Flying High, IPOs Drive Up Valuations, M&A May Suffer
Investor's Business Daily
Both Salesforce.com and Workday acquired firms at historically high prices, says Morgan Stanley. The investment bank notes 52 software acquisitions in 2018 thus far. That includes purchases of private firms. Companies bought 36 and 37 software firms, ...


eWeek

Lakeside Software: Product Overview and Insight
eWeek
eWEEK is building a new IT products and services section that encompasses most of the categories that we cover on our site. In it, we will spotlight the leaders in each sector, which include enterprise software, hardware, security, on-premises-based ...


Clarkson professor gets grant to compare DNA software
WatertownDailyTimes.com
Ms. Matthews, an associate computer science professor at Clarkson University, is leading a team that has been awarded a $75,000 Brown Institute Magic grant for her project, Decoding Difference in DNA Forensic Software. ‚ÄúSimply put, when computers are ...


WPRI 12 Eyewitness News

'Significant' UHIP software upgrade planned for this weekend
WPRI 12 Eyewitness News
PROVIDENCE, R.I. (WPRI) - A major software upgrade for Rhode Island's UHIP computer system is scheduled for this weekend. UHIP - short for Unified Health Infrastructure Project - is Rhode Island's problem-plagued computer system, which launched in ...


The Register

From here on, Red Hat's new GPLv2 software projects will have ...
The Register
Red Hat on Monday said all of its newly initiated open-source projects that adopt GPLv2 or LGPLv2.1 licenses will be expected to include the GPLv3 "cure" ...

and more »

512tech.com

Austin's Malauzai Software acquired by UK-based financial tech company Finastra
512tech.com
Austin-based Malauzai Software has been acquired by London-based financial technology firm Finastra, the companies said Monday. Financial terms of the deal were not released. Founded in 2009 by financial software industry veterans Tom Shen and Robb ...

and more »

TechCrunch

Kaspersky pulls plug on Europol joint venture after EU parliament ...
TechCrunch
Fresh political woes for Russian security firm Kaspersky, which has reacted angrily to a vote in the European Union Parliament last week to ban its software ...

and more »
Google News

A Case Study on Selecting Contract Management Software

Professional services firm cuts costs and improves productivity with integrated... Read More

Imagine if Everyone Working In Your Office Was In Synch?

Microsoft-Outlook is a pretty amazing program. So much more than... Read More

Microsoft Retail Management System (RMS) SQL Customization ? Overview for Programmer

Microsoft Retail Management System serves retail single store as well... Read More

Dashboard Widgets for Windows

For a windows user like me, just can watch with... Read More

Microsoft Great Plains: Service Business Customization & Integration Example

Microsoft Business Solutions Great Plains might be considered as ERP... Read More

RSS: Get Notified When Your Favorite Websites Are Updated

RSS (Really Simple Syndication) is a way for a site... Read More

Examining the Substance of Studio MX

To all web designers out there, this article is for... Read More

Microsoft Great Plains Remote Support - Overview

Microsoft Great Plains is now standard mid-market ERP application, serving... Read More

Introduction To ISDN, Part II

In the previous ISDN article, we looked at how and... 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... Read More

MySQL for Beginners ? How to Create a MySQL Database

Whether you are an experienced web programmer or a complete... Read More

Microsoft Navision Customization and Reporting ? Tips For Programmer/IT Specialist

C/SIDE (Client/Server Integrated Development Environment) - The core of... Read More

Screenplay and Script Writing Software

When it comes to screenplay software each screenwriter needs to... Read More

Free PDF Publishing Software

In a previous article, I wrote about OpenOffice... Read More

Microsoft Great Plains Inventory Control ? Overview For Consultant

Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More

Database Guru James F. Koopmann Reviews DBxtra Reporting and Query Tool

DBxtra is a powerful query and reporting tool that hides... Read More

Anti-Virus Software

Anti-virus software is used to find, remove or fix files... Read More

Corporate ERP: Standard vs. Rich functionality ? Microsoft Great Plains

Traditionally we were considering functionally rich systems, such as SAP,... Read More

Did You Ever Want to Completely Erase Everything on Your Computer?

Did you ever want to erase everything on your computer?... Read More

Microsoft CRM Customization

Microsoft CRM customization techniques are very diversified and based on... Read More

Crystal Reports for Microsoft Great Plains ? Overview for Developer

Microsoft Great Plains is main accounting / ERP application... Read More

Upgrading Great Plains Dexterity Customization ? switching to new technologies: SQL, Crystal, eConne

1. Replace Dexterity cursor with SQL Stored Procedure Dexterity... Read More

MultiNational Corporation ERP Implementation ? Microsoft Business Solutions Great Plains

If you look back to the history, you will see... Read More

Groupware: Avoid the Ad Hoc Shuffle

GroupwareEfforts are continually made to manage the unavoidable ad hoc... Read More

Microsoft Great Plains Customization: Project Organization ? International Business Example

Microsoft Business Solutions Great Plains fits to majority of horizontal... Read More