| |
| |
|
softwarecatch.com
|
|
|
|
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
MORE RESOURCES:
Google News |
|
|
|
RELATED ARTICLES
Microsoft CRM Integration with Lotus Notes Domino: Messaging Connector - Future Directions IBM Lotus Notes Domino and Microsoft CRM (Client Relation Management) from now on can work in tandem. Microsoft CRM Lotus Notes Domino connector from Alba Spectrum Technologies provides seamless messaging in MS CRM through Domino. Microsoft Great Plains FA: Fixed Assets - Overview For Consultant Great Plains Fixed Assets Management module is a robust tool that can help you manage your assets effectively. It integrates perfectly with other Great Plains modules like General Ledger, Purchase Order Processing, and Payables Management ensuring accuracy while reducing redundant data entry. Change Your Word Docs in Record Time! Anyone who has ever used Microsoft Word knows that it is a powerful word processing package. It's loaded with dozens of features designed to make creating documents a breeze. Running a Program on a Remote Server Using SSH How do you run a program on a remote server using ssh?For this example we'll have two servers, one named Johnny and another named Cash. Both are running openssh. Software Engineering: An Introduction Software Engineering is the Systematic Approach for analysis design implementation and maintenance of Software .It involve the use of Case tools. Anti-Virus Software Anti-virus software is used to find, remove or fix files that are infected with computer viruses. Most anti-virus companies release weekly updates of their databases to help keep you safe. What is Software Piracy? There are several kinds of software piracy. The bottom line is when software is pirated, the developer does not receive compensation for their work. Groove Network. Are you in it? If you are in a business that passes documents around to be reviewed and edited over and over before they are ready to be posted for advertising or for a client, then you have probably already heard of a software solution to help keep your "floating" documents organized from Groove Network. You may not be aware that there is another option out there. Microsoft Great Plains Implementation: Collection Management - Overview For Consultant Microsoft Business Solutions Great Plains is very good fit for mid-size company and probably good budget solutions for large corporation. Being matured product - Great Plains provides such horizontal solutions as Collection department automation. C++ Tutorials: 3, Program Flow (If, Else, While, For) Program Flow is what you think it is. How the program will flow. The End of Spyware? The US House of Representatives has recently passed the "Spy Act" - or to give it its full title - the Securely Protect Yourself Against Cyber Trespass Act. This aims to prevent software companies from installing spyware on users PCs without their knowledge, and anyone found guilty of breaching the act faces a fine of up to $3 million. The Death of Windows I have always regretted how Microsoft price gouges and rips off computer users. I really regret Windows XP activation. Understanding Document Management The term "document management" and "paperless office" is the subject of countless articles and books. Everyone wants to achieve this lofty goal but not everyone understands what the terms really mean. The Bluebird Project The objective for Zandi Digital is to make available clever programs to end-users that want and need something more diverse. Bluebird is the current application being developed by Zandi Digital. Performance Tuning of a Daffodil DB / One$DB -JDBC Application This article illustrates the best practices to improve the performance of Daffodil DB / One$DB JDBC Driver. This article focuses on how to improve the performance of a Daffodil DB / One$DB JDBC application using Statement, PreparedStatemnt, CallableStatement and ResultSet interfaces. Software Upgrades Arent Always the Best Move When my daughter was getting into AOL instant messaging (AIM) and using all the cool add-ons, I looked for more as it's a great way to learn about extending applications. While doing research, I learned that if you wanted to use AIM themes, you don't want to upgrade to AIM 5. Troubleshoot Windows with Task Manager Task Manager is a Windows system utility that displays thetasks or processes currently running on your computer. Toopen Task Manager, press Ctrl+Alt+Del. Microsoft CRM Customization: Integration with Third Party SQL Application/Database Microsoft CRM - Client Relationship Management package from Microsoft Business Solutions was initially designed to be customizable with Microsoft Visual Studio.Net and one of its programming languages - C#. 5 Easy File Management Tips in Microsoft Word How many steps does it take you to locate and open your Word documents? Try these tricks to streamline how you find and open the files you use most often:Opening DocumentsWith a variety of choices, how do you open a file? Here are the standards plus several keyboard shortcuts:? File > Open? Open toolbar button (usually 2nd from the left on the Standard toolbar)? [Ctrl] + O? [Ctrl] + F12? [Ctrl] + [Alt] + F2Selecting More Than One FileOnce you are in the Open dialog box, select more than one file to open:? To select nonadjacent files in the Open dialog box, click one file, and then hold down [Ctrl] and click each additional file.? To select adjacent files in the Open dialog box, click the first file in the sequence, and then hold down [Shift] and click the last file. 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 the settlement value of claims. The insurance industry maintains it is a useful tool because it considers a great many factors, and the settlement values are just a range for use in any way the insurer wishes.
|
|
Powered By: Free Work At Home Business Opportunity! |
| © 2006 |
