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

Forbes

Digital Transformation Reveals Limitations Of Software Packages And SaaS
Forbes
Most large enterprises were on a journey for the past 30 years where a higher and higher proportion of the core systems driving the enterprises was software packages or software as a service. Traditional wisdom for companies was “don't build – buy ...

and more »

The Verge

Microsoft alters Surface Hub 2 hardware, delays new software features to 2020
The Verge
Microsoft is unveiling hardware changes to its Surface Hub 2 today. The software giant first unveiled its 50-inch display earlier this year, with a promise of a 2019 release. While the hardware will now be released in Q2 of 2019, many of the cool new ...
Ignite 2018: Microsoft shows off Surface Hub 2 running latest WCOS softwareOnMSFT (blog)
What's next for Surface Hub 2 - Microsoft Devices BlogMicrosoft Devices Blog - Windows BlogWindows Blog

all 59 news articles »

American Software: The SaaS Narrative Collapses
Seeking Alpha
American Software has tried to frame itself as an SaaS company - but 'cloud' sales still represent less than 12% of revenue. A disappointing Q1 undercuts much of the optimism that revenue growth is set to accelerate. After a nearly 40% plunge, AMSWA ...

and more »

TOP500 News

IBM Introduces Software to Alleviate AI Bias
TOP500 News
A cancer treatment recommendation powered by machine learning may be right 98 percent of the time, but what are the liabilities of the software-maker when a misdiagnosis results in death? A less fatal, but still undesirable type of bias comes into play ...
IBM's new bias detection software, democratizing AIIT World Canada

all 6 news articles »

Threatpost

Adwind RAT Scurries By AV Software With New DDE Variant
Threatpost
The spam campaign features two types of droppers that leverage a new variant to the already-known DDE code-injection attack on Microsoft Excel – enabling them to bypass AV software. DDE is a legitimate method for transferring data between applications ...

and more »

CMSWire

Choosing a SaaS Product: 7 Non-Software Related Considerations
CMSWire
When it comes to choosing software, you need to consider more than just the code itself. As more and more companies incorporate software-as-a-service (SaaS) tools into their marketing technology stacks, we felt it was important to address seven vital ...


GeekWire

Pixvana's new virtual reality production software lets you edit VR content while wearing a headset
GeekWire
Seattle startup Pixvana today released the full version of its software platform SPIN Studio that helps virtual reality filmmakers edit, process, and deliver video at 8K resolution. Perhaps the most notable update to SPIN is the ability to edit VR ...

and more »

ZDNet

Adwind Trojan circumvents antivirus software to infect your PC
ZDNet
"Although both the generic method and the payload are known, this campaign show[s] how some variance into well-known artifacts can trick antivirus [software]," Cisco Talos says. "Their behavior, however, is clearly classical, which means that ...


Bloomberg

India's Sliding Rupee Has an Upshot: Rising Software Exports
Bloomberg
The currency's double-digit drop against the dollar this year is helping the nation's services exports, according to HSBC Holdings Plc's chief India economist Pranjul Bhandari. So much so that the share of services exports, which mainly comprise ...

and more »

Mashable

Snag this illustrating software on sale for 50% off
Mashable
Clip Studio Paint Pro is an all-inclusive software meant to make it easier to draw and paint on your computer or tablet. Once you download the software, you'll have access to over 10,000 downloadable brushes as well as a handful of 3D models and figurines.

and more »
Google News

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

Many reasons made GBM a unanimous choice for experts, one... Read More

Create A Flash Presentation For Free With Open Office

The intentions of this short tutorial are not to teach... Read More

Great Plains Customization Upgrade? Overview For CIO/IT Director

Around the same time Microsoft made its move with .Net... Read More

What is Software Piracy?

There are several kinds of software piracy. The bottom line... Read More

Protect Your Most Vital Business Asset with Security Software

Homeland security, airport security, Internet security â?" these days weâ??re... Read More

Microsoft Great Plains Integration with Microsoft Access ? Overview for Developer

... Read More

A Time-Saving Programming Tactic that Doesn?t Work

Let's say that you have a software project that's under... Read More

Windows x: Basic Windows ?Security? Issues

Language development computer: Computer-based method for aiding language development seems... Read More

Razzle Dazzle Them

Once upon a time not so long ago, there was... Read More

Microsoft Great Plains - Typical Problems And Fixes ? Overview For IT Administrators

How to delete the user? This is the first problem... Read More

Secure File Transfer Using SSH Plus Additional Audit & Automation - FSA Reporting

In order to meet regulatory and corporate compliance requirements reporting... Read More

Run Your Own Search Engine

Our hosted solution allow you to run your own search... Read More

Microsoft CRM ? Typical Customizations

Microsoft CRM was designed to be easily customizable. Microsoft CRM... Read More

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

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

Microsoft Great Plains Jewelry ? Implementation & Customization Overview

Each Industry and market niche has business specific and unique... Read More

Seven Reasons Why a Hosted Inventory Management Solution Might Be Right For Your Organization

Upgrading. Downtime. Maintenance. Hardware obsolescence. Implementation issues. The litany of... Read More

Microsoft Small Business Manager Customization Options - Overview

Microsoft Business Solutions Small Business Manager is Great Plains Dexterity... Read More

10 Ways to Learn a Software

Following tips help you to learn a software in lesser... Read More

Microsoft Great Plains Remote Support - Overview

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

An Introduction to .NET Framework

.Net Framework is a platform or development environment to seamlessly... Read More

Separate Anti-Keylogging Protection: Who Needs it Most?

If there still are few unprotected computers left, I haven't... Read More

Microsoft Great Plains Integrations ? Retail Management Sample

Microsoft Business Solutions is emerging as very attractive vendor for... Read More

Microsoft Great Plains in Construction & Building ? Implementation & Customization Highlights

Microsoft Great Plains could be tuned and setup to fit... Read More

Microsoft CRM Implementation - US Market Lessons

Microsoft CRM is CRM answer from Microsoft Business Solutions. If... Read More

Importance of Coding Standards

Programming Help for BeginnersWe write programs to instruct computers. When... Read More