| Home | Links |
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
Oakland police get free forensic software to analyze Occupy videos San Francisco Chronicle (blog) A Pasadena forensic video enhancement software company has donated its technology to Oakland police to help in capturing the goings-on at Occupy Oakland demonstrations, the company announced in a statement. At the request of Oakland law enforcement, ... |
Advent Software to Host Analyst and Investor Day Event on Friday, May 11, 2012 Reuters SAN FRANCISCO - February 6, 2012 - Advent Software, Inc. (NASDAQ: ADVS), will hold its Analyst and Investor Day in New York on Friday, May 11, 2012, beginning at 9:00 am (EST). The meeting will feature presentations by Advent's executive team covering ... Advent Software Achieves Record Quarterly Revenue of $86 Million and Record ... Advent Software's CEO Discusses Q4 2011 Results - Earnings Call Transcript Advent Software Q4 Profit Drops; Issues Q1, FY12 Revenue Outlook - Quick Facts |
Scorpion Software Announces AuthAnvil Single Sign On Support for Level ... San Francisco Chronicle (press release) Scorpion Software, an industry leader in strong authentication and password management solutions for IT Service Providers and IT departments is pleased to announce integrated support for AuthAnvil Password Solutions with Level Platforms, ... Scorpion Software Offers Support for Level Platforms Managed Workplace |
Caduceus Software Plans to Integrate a Cloud Platform with its Software ... SmallCap Network By Ed Liston Caduceus Software Systems Corp. (OTC: CSOC), a software company specializing in the development of an all-in-one solution for private practitioners and doctors, today, said that it plans to integrate a cloud platform with software systems. Caduceus Software Systems Corp. Plans to Integrate a Cloud Platform with its ... QualityStocks News - Caduceus Software Systems Provides Update on Current ... |
Law Offices of Howard G. Smith Announces Investigation of JDA Software Group, Inc. Business Wire (press release) (BUSINESS WIRE)--Law Offices of Howard G. Smith announces that it is investigating potential claims on behalf of purchasers of the securities of JDA Software Group, Inc. (“JDA” or the “Company”) (NASDAQ:JDAS) concerning possible violations of federal ... JDA SOFTWARE GROUP INC: Law Offices of Howard G. Smith Announces Investiga.. |
Proposal Software Continues Strong SaaS Revenue Growth in 2011 MarketWatch (press release) WESTPORT, Conn., Feb 06, 2012 (BUSINESS WIRE) -- Proposal Software, Inc. (PSI), The Leader In Proposal Productivity(TM), and makers of PMAPS(R) WebPro (Proposal Management and Production System) announced 2011 results that continue its systemic growth ... |
Manhattan Software Announces Strategic Partnership With Indiabulls for ... MarketWatch (press release) 6, 2012 /PRNewswire via COMTEX/ -- Manhattan Software, the global leader in enterprise real estate software and a leader in the 2011 Gartner Magic Quadrant for Integrated Workplace Management Systems, announced today a strategic partnership with ... |
Mezeo Software Announces National Master Distributor for Japan MarketWatch (press release) HOUSTON, TX, Feb 06, 2012 (MARKETWIRE via COMTEX) -- Mezeo Software(R), a leading provider of cloud storage management solutions, today announced the appointment of a master distributor for Japan, AIR Company Limited, a Japanese company focused on ... |
Is BMC Software Growing or Slowing? DailyFinance By Seth Jayson, The Motley Fool Posted 4:11PM 02/06/12 Investing There's no foolproof way to know the future for BMC Software (NAS: BMC) or any other company. However, certain clues may help you see potential stumbles before they happen -- and before ... |
The Cloud Software Companies You Need to Know About Motley Fool But software as a service is easy enough to define. Whenever you have to access your application through a central location, and pay ongoing license fees to the developer, that's generally software as a service. Microsoft's Office suite is plain old ... |
Google News
Related Articles
Computer Phones ? Facts and Fallacies
The stakes are high when considering security, privacy, and savings, and the old adage, "look before you leap" might be a more judicial approach when searching for a computer phone provider, aka VoIP (voice over internet protocol).
Understanding XML Server
XML Server can be a Web Server that stores the XML files in it and serves them on demand. The XML Server would have processing capabilities with an XML engine and to transform the XML document to other forms. Basically a server which hosts and serves the XML documents is called a XML Server.
Microsoft CRM Modification ? Overview for IT Specialist
Microsoft CRM is now on the scene and it is increasing its market share, due to the Microsoft Business Solutions muscles and marketing strategy. It is tightly integrated with other Microsoft Business Solutions products such as Microsoft Great Plains, Solomon, Navision.
Secure File Transfer Using SSH Plus Additional Audit & Automation - FSA Reporting
In order to meet regulatory and corporate compliance requirements reporting members will require a cost effective solution that may be installed at one side of the data transfer without being tied to any proprietary protocol.
10 Things You Can Do With Photoshop CS2 That You Couldnt Do Before Now
Is Photoshop CS2 worth the upgrade? You bet it is! Here are just 10 things you can do with this fantastic new version of Photoshop that were impossible (or difficult) to do with previous versions:
The Hidden Power of Online Manual
Writing software manuals is boring, isn't it? We often think: "My software is easy to use. The user interface is intuitive. Why should I waste so much time for writing the document which nobody reads anyway?" Sometimes it's true ? I've never read the WinZip or Internet Explorer manuals ? everything seems clear without explanations. Nevertheless, even if your manual doesn't help to your software users, it may help to you. Publish your manual online and turn its hidden power into the real benefits for your business. Online Manual Makes Your Web Site Visible User manual is a huge bunch of words, the highly targeted words, which are specific for your software market. For instance, if you develop a database management system, its user guide will certainly contain such words as "database", "query", "transaction", "table", "record", and etc. On the other hand, people use these words in their queries when they are looking for a database management solution on the Google, Yahoo, or other search engine. Let the interested people to find your web site and your product. Upload your manual on your web server and make it available for indexing by search engine spiders. This area specific content will make your web site and your software more visible to potential customers. Making the user guide available online will increase your web site rank in relevant search results and will bring highly targeted traffic to web your site. Let the manual to work not only for your users, but for you as well. Online Manual Saves Your Time A picture worth a hundred words. Those who are engaged in user support know this for sure. When replying to user concerns, very often we have to write sentences like this "Open the Document settings dialog. Choose the External modules tab. Select the 'ABC Spell Checker' in the module list. Enter your registration key and verification code in the corresponding text fields which will appear at the bottom of the window. Then, press Activate". If your application is simple the user will likely understand you right and will do everything as you have explained. However, if your application is a complex system with lots of setting windows which behave differently in various modes, the user may be puzzled which window and which fields do you mean. In this case you risk getting into a long conversation by repeatedly explaining the same things again and again. The screenshot could be a very helpful illustration of your explanations. You may run your application, go to the certain window, open that tab page, activate the corresponding item in the list. Then make the screenshot of the window by using Alt+PrtSc key combination or another screen capture tool, save the picture in a file, and finally attach it to your message. Sometimes it's also necessary to add callouts, annotations and other enlightenments to the screenshot picture. Thus, you have to launch your image editor and to manually draw all the elements required. As you see, it may takes up to a half hour to reply to a single message only. And how many messages are yet in the queue? Having the screenshots prepared is a good approach which may save your time. But having screenshots already prepared together with callouts, explanations, and annotations is a great approach which will save you much more time. Most likely, you have all that stuff prepared in your software manual but it's not very polite to reply to the user: "Read that fantastic manual". User may have no idea where the manual is on the PC and on what page is the looked-for solution located. On the other hand, you may also have no time to manually cut particular pages with screenshots and related instructions from the manual and to attach them to each support message. The solution is easy. Put your manual on your web site in the form of HTML pages. Make all the pictures, screenshots with callouts, descriptions, and instructions accessible for every user. When you are processing another support request, simply insert an URL link to the appropriate page of your online manual and add just a few clarification words ? more words and pictures are already on that page. You will save much time and nerves because you will be sure that the user is looking at the same thing which you are describing. At the same time, the user will get a fast solution which is supported by clear pictures and neat instructions. Online Manual Makes Your Products Trustworthy Besides the users get the faster and more helpful support, they also see that you did this tedious job ? writing the handy and well structured manual with great screenshots and clear explanations. They know that this job is boring and developers don't like to do it. Therefore, if you did it and if you did it perfectly, it means that you respect your customers, not only their money. Good manual means that you consider your business and product seriously yourself. This helps your business to look more credible and serious. So, make your manual available online and prove your respect to your existing and prospective users. Make them trusting in you and in your product before they even download a demo copy of it. Online Manual Brings Sales As we see, the software manual which is a part of your web site generates a targeted traffic. The people may easily find your product because online help makes your web site more visible in relevant search results on the search engines. Those new visitors get more loyal when they see a well done help system. Also, if a prospect experiences difficulties with your software and asks for technical support, you may easily resolve the issue by referring the user to a certain page of your online help. With just a one click the user will see screenshots and explanations which will help them to settle the case. So, you have a motivated and targeted visitor, who feels loyal to your company and products, and whom you can easily help in case of a technical problem. The probability of such visitor ordering a license is several times higher than of the average one.
How to Make Own CMS
Every day millions of new web documents emerge on the Internet, and the amount of web management tools is growing simultaneously. These tools are usually referred to as Content Management Systems, CMS for short. If you have a web site and still do not use any CMS, you will definitely face a choice to buy or to develop an enterprise content management solution in the near future. What would you do if you wanted to develop a CMS, your own software that has a WYSIWYG editor and perfectly meets all your requirements and security standards? Can this task be fulfilled? Which ROI should you expect? You will have to answer all those questions all by yourself. Your chance to success can be increased if you gain an understanding of basics of a web content management system.
Four Desktop Tools To Drastically Increase Your Productivity
Sticky Notes
Microsoft CRM Customization Secrets ? Second Edition
This article is for advanced Microsoft CRM SDK C# developers. It describes the technique of direct SQL programming, when SDK doesn't have the functionality to do the job.
Microsoft CRM or Siebel
Siebel is traditional CRM market leader, however and mostly due to recession 200-2003, Siebel lost sizable portion of CRM market to new tiger, such as Microsoft CRM. Microsoft CRM s recent (2001) CRM answer from Microsoft and attempt top get market share from traditional vendors: Siebel, Oracle, Onyx. Now it is targeted to the whole spectrum of horizontal and vertical market clientele. It is tightly integrated with other Microsoft Business Solutions products such as Microsoft Great Plains, Solomon, Navision (the last two in progress).
Will Adobe Manage to Replace Industry Work Horse Quark Express by Giving Adobe InDesign for Free?
And kill the best layout software in the process of gaining market share?
Microsoft RMS ? Great Plains Integration ? Overview For IT Specialist
Microsoft Great Plains and Microsoft Retail Management System (Microsoft RMS) are getting new market share due to the Microsoft strong marketing campaign. Both products: Microsoft Great Plains and Microsoft RMS are coming from the same Microsoft subdivision - Microsoft Business Solutions (MBS), however due to the fact that both products were bought by Microsoft from different vendors, the integration between the two is not an easy thing. At this time MBS has RMS integration on the General Ledger and Purchase Order level into Great Plains out of the box. This integration has some advancements in comparison to old product: QuickSell, but it is still GL and PO only. We do understand the need for midsize and large retail companies, structured as clubs and selling on account to their members to have more adequate integration when you can synchronize your Sales information and have robust Great Plains reporting. There is the product on the market, which is integration on the Receivables Management level from RMS to Great Plains, written by Daniel Sionov and Andrew Karasev and maintained by the alliance between LightEdge Solutions (www.lightedge.com) and Alba Spectrum Technologies (www.albaspectrum.com). In Alba Spectrum Technologies we actually do coding and product tuning for specific client needs.
6 Easy Steps for a Smoother CD/DVD Order
It's all about turn times in the eMedia industry! The speed with which your vendor can get your CD or DVD project completed is vital to many customers. However, responsibility for these projects meeting their completion dates starts with the customer and ends with the vendor. It's a partnership that shares the responsibility. Just follow the 6 easy steps below:
Keep Your Software Simple! A Review of EditPlus
I like my software simple. If it's too complex or difficult to figure out, I don't use it.
How a Bug Challenges to a Software Professional
It is really interesting that a bug can create problem for a learned person even the bug is not alive. One day my one friend was working and a bug created much problem. It was not easy to track the bug. evrytime bug was challenging any other different problem.
Dig Out That Worm
Internet worms. Is your PC infected?
Microsoft Great Plains Implementation: Verticals - Wholesale Order Entry center ? overview
Microsoft Business Solutions Great Plains has substantial market share and strong support by Microsoft on the US market. Currently we see the trend in the vertical markets when companies with custom-built accounting application, usually written on legacy platform are switching to standard and proven ERP solution and customize or tailor it to fit their vertical market requirements. We'll be publishing series of vertical articles: Logistics, Distribution Centers, Warehouse Management, Barcoding, Shipping/Receiving, eCommerce, EDI, Wholesale. Today we'll give you Wholesale tailoring scenario
Microsoft CRM Integration & Customization: SharePoint Document Gateway
MS CRM is very close to document workflow automation, including Microsoft Office documents: Words, Excel, etc. The document workflow was perfectly automated about 10 years ago in Lotus Notes Domino. In this small article we describe the solution based on MS CRM integration with MS SharePoint.
Where to Find Free Fleet Maintenance Software
Costs of fleet maintenance software can vary widely. It is generally expected that the fleet manager will look at the needs of the company to determine what software package is best suited for their particular needs. Depending upon the size of the company, number of vehicles to be maintained and services of the company, you may be able to locate free fleet management software for your needs.
Alien Intruders!
You probably didn't casually invite, or extend a formal attendance request to, these undesirables known as viruses.
Common misspellings for words used in this page include accessable actualy adavanced adecuate adn agian agin agina ahev ahve allready alreayd alsot amke ammount anbd anohter aplication apon applicaiton appropiate appropraite appropropiate apropriate aready artical artice articel asign aslo asume attemp attemt attendence availaible availble availiable availible avalable avaliable avilable baceause baout beacuse becasue beccause becouse becuase bedore befoer beng benifits betwen bewteen buisness busineses busness bussiness ceratin certian chalenging claer clera cmoputer collecton comany comapany comming comparision completetion concider concidering condidtion consdider coputer corparate correponding correposding corrisponding coudl creaeted crtical decribe decribes definately definatly definetly definitly descriibes develope diea diferent diferrent differnt diffrent dificulties discribe discribes doccument doccuments eahc ened enxt ethose everthing eveyr expeced explaning eyars eyasr familliar fianlly fidn fiels finaly fomr freind freindly frome generaly gerat graet grat haev halp heigher helpfull higer howver htey hting htis hvae hvaing hvea hwihc hwole idaeidae inbetween inclreased includng incuding infomation informtion inlcuding inot intergrated intergration iwll iwth jstu jsut judical juducial knwo konw kwno larg lastr launchs levle liek liscense lisence lisense liuke lsat maintainance maintainence maintance maintenence makse managment mantained marketting mkae mkaes mkea moreso motiviated mroe neccesary neccessary necesary nessecary nkow nkwo nowe nto oftenly omre onyl otehr owrk owudl palce parituclar particualr paticular peopel performence previvous probabilaty probablly probalibity probaly probelm proccess proccessing proces proove propietary proprietory pwoer raelly realy realyl reccomend reccommend recomend refered referiang refering reffered rela relaly relevent repeteadly responnsibilty responsability responsiblity rwite scirpt seach severeal shoudl shoudln simpley smae smoe soem sofware sohw sould specfic specif spectum statment stong stuctured substancial substatial succsess sucess sytem tahn taht targetted tath teh tehy tghe thast theese theri thgat thge thier thign thigns thigsn thna thnig thnigs thru thsi thsoe thta thyat tiem tihs timne tiome tje tjhe tkaes toghether traditionnal trafic tranform twpo tyhat tyhe uise usally useing usualy ususally vell verfication verison vetween veyr visable vistors vrey vyer vyre waht wass watn weas wehn whant whcih whic whihc whith whlch whn whta wich wih wiht wille wirting witht witn wiull wnat wnated wohle wokr wokring woudl wriet writen wrok wroking ws wtih wupport yeasr yeras yersa ytou yuo.