Software Information |
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: Unable to open RSS Feed $XMLfilename with error HTTP ERROR: 404, exiting |
RELATED ARTICLES
Microsoft Great Plains Nationwide Remote Support ERP Consulting industry is on the way to serve clients nationwide and even worldwide, when the client is multinational corporation. There are several reasons to specialize in remote support. 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, has announced the launch of its new version of MailScan Ver. The Software 2005 Conference - A Review The Software 2005 conference is now a wrap. This conference, presented by M. Start Developing Your Own Software Learning how to program software seems like a daunting task fit only for the geeks and nerds who lock themselves away in dark rooms staring at their monitors for days on end as they pour over thick manuals written largely in zeros and ones. Fortunately the reality is that it's not as complicated to make basic applications as people may think. Microsoft Great Plains in Construction & Building - Implementation & Customization Highlights Microsoft Great Plains could be tuned and setup to fit most of horizontal markets. You can deploy third party modules or build your own custom logic in Great Plains Dexterity. Microsoft eCommerce Web-development: Great Plains eConnect .Net - Highlights for Programmer In our small article we'll consider Microsoft Business Solutions Great Plains Sales Order Processing module as eCommerce backend. Plus we'll cover what is possible and impossible in eConnect and why. Downloading Spyware Removers: Think Before, not After Just imagine: you are walking, say, towards your car, and all of a sudden somebody comes up to you and begins? polishing your shoes. Or even better example--a guy you've never met before opens the hood of your car, says the engine is broken and tries to persuade you to add some gadget your car desperately needs--and now! What you'd do if such a crazy thing happened? Wouldn't you readily accept the help, paid for it and thank this unknown altruist for his generosity? Why not? Lots of people are doing exactly the same on their PCs. An Introduction to .NET Framework .Net Framework is a platform or development environment to seamlessly create web-applications that are accessible through client machines from across the globe. Microsoft CRM Implementation for Large Corporation - overview Microsoft Business Solutions CRM is now approaching the phase of being mature product and the CRM solution you may consider for large publicly traded company. Our view point considers the fact of multiple platforms and systems coexistence and balancing: UNIX, Linux, Microsoft Windows, Java, . Microsoft Great Plains SOP: Sales Order Processing Microsoft Business Solutions Great Plains is marketed for mid-size companies as well as Navision (which has very good positions in Europe and emerging markets where it can be easily localized).Great Plains Sales Order Processing (SOP) module forms a third of the core Inventory and Order Processing part of Great Plains. A Guide To Purchasing Professional XP Icons Online And Enhancing Your Applications Icons are used everywhere; right from software applications, to internet browsers, to operating systems to websites and even in print media. But businesses have to waste a good deal of money and time in manufacturing icons on their own. Passwords Used In Microsoft Word Documents You would like to protect your documents, wouldn't you? Reasons may vary but the problem is the same - you need to protect your Microsoft Word documents from unauthorized editing or viewing. What document protection features does Microsoft® Office Word 2003, a part of Microsoft Office Professional Edition 2003 provide?Microsoft Word features for document protection. Great Plains Sales Order Processing and Invoicing Modules - Tips For Consultants We'll give you non formal view, based on our consulting practice.Common Features. Great Plains Dexterity Programming - Overview For Developer Looks like Microsoft Great Plains becomes more and more popular, partly because of Microsoft muscles behind it. Now it is targeted to the whole spectrum of horizontal and vertical market clientele. Cisco CCNA Certification: Becoming A Truly Valuable CCNA. I've been active in the Cisco Certification track for four years, working my way from the CCNA to the coveted Cisco Certified Internetwork Expert title, and during that time I've conducted job interviews and casual conversations with hundreds of CCNAs and CCNA candidates. The CCNA is an exciting beginning to your Cisco career, but just having the certification simply isn't enough. Microsoft Business Solutions Customization Options - Overview for Programmer Several years ago Microsoft purchased Great Plains Software, then Navision (Denmark based software development company). At this time Great Plains Software already was active ERP applications consolidation player - it already acquired Solomon Software couple of years prior. Bill of Lading - Custom Reporting for Microsoft Great Plains - Overview for Consultant Bill of Lading is required report for Logistics and Freight Forwarding companies. If you are looking at Freight Forwarding software, targeted to automate transportation business - Bill of Lading with multiple custom forms should be present there. 10 Ways to Learn a Software Following tips help you to learn a software in lesser time and in an efficient manner:1. After installing a software package, look for any README file in the installed folder. Fundraising Software - How Can That Help Me? Fundraising software lets you connect with donors in a way that is unlike any communication you've ever had before. You can diversify your fund raising efforts with software and manage all of your day-to-day activities. OLAP, An Alternative Technology Over Spreadsheets Are Spreadsheets Robbing your Enterprise of Competitive Advantage?'90% of "average" companies are not confident that their forecasts and reports are accurate and reliable'In a recent study, 81% of FD's cited that their highest priority is the accuracy of revenue and earnings forecasts while 63% complained of inadequate budgeting and forecasting systems .The modern FD is coming under increasing pressure from all sides to produce more robust, meaningful and accurate financial information. |
home | site map | contact us |