 |
Edi for Microsoft Great Plains Dynamics Gp – Highlights
Author: Andrew Karasev  | Posted: 08-10-2007 | Comments: 0 | Views: 25 | Rating: (62)  (?) 
 Electronic Document Interchange or EDI is popular bundle of various technologies, allowing you to submit or accept PO requests from/to your partners: vendors or customers. In this article we do not assume new “modern EDI” trends to think that XML format interchange is also EDI, we will think about EDI in traditional manner, where EDI is fixed length (text, with some exceptions) field format, where each line might be header, details (lines) and footer (trailer) with the options to have more flexible lines definitions. The goal of this article is to give you highlights, assuming that you are Great Plains developer, programmer or IT specialist, on how to integrate EDI compliant systems with Microsoft Dynamics GP Great Plains
1. GP technology overview. When talking about EDI, you should think about GP from the position of Great Plains Database platform, current version 10.0 is available on Microsoft SQL Server 2005/2000 only (and MSDE and SQL Select, which in fact is reduced version of MS SQL Server). If you consider to deploy integration tools, such as GP Integration Manager (IM) or GP Dexterity, you should think about performance and the volume of your EDI transactions per day or one integration session (and how frequent do you plan to have these sessions)
2. SQL Stored Procedures, Views, DTS packages and queries. In our opinion this is the most efficient and fastest way to export EDI transactions from Great Plains. You should invest some time into formatting SQL select statement output (such functions as CAST and CONVERT)
3. IM and Dex. These tools should be considered to be deployed if you plan importing EDI files. Integration Manager allows you to use ODBC connection to import documents, however fixed-length EDI format brings some technical challenge (it is not comma or tab delimited file and IM needs help here). If you plan to deploy Integration Manager, consider preprocessing fixed length files with DTS package or SQL Linked Server query to reformat it to tab delimited text file. If you are comfortable with Dexterity – this tool allows you to call SQL stored procedures, where you can do fixed-length fields parsing
4. eConnect – this tools is oriented toward XML streams and parameters, so, we do understand your enthusiasm to deploy this tool as it is friendly to eCommerce MS Visual Studio C# and VB.Net developer, however EDI technology might be a bit “archaic” for eConnect project
Rate this Article:
Current: 0 / 5 stars - 0 vote(s).
Article Source: http://www.articlesbase.com/software-articles/edi-for-microsoft-great-plains-dynamics-gp-highlights-229681.html
About the Author:Andrew Karasev, Alba Spectrum Group: http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918, serving Microsoft Dynamics GP Great Plains customers in USA/Canada nationwide. Local service is available in Houston, TX: Richmond, Sugar Land, Katy, Rosenberg, Missouri City, Pearland, Friendswood, Meadows, Mission Bend, Jersey Village; Chicago, IL: Naperville, Aurora, Bolingbrook, Romeoville, Joliet, Wheaton, Lisle, Downers Grove, Schaumburg, Elk Grove, Lombard, Woodridge, Darien, Westmont, Batavia, St. Charles, Elgin, Crystal Lake. Service is also available in Houston and Dallas metros, plus internationally in Canada, Australia, New Zealand, South Africa, Oceania and UK
|
Submitting articles has become one of the most popular means of generating quality backlinks and targeted traffic to your website. Join us today - It's Free! |
|
Related Articles
The Importance of Real Time Reporting Capabilities
By: T. Jones | 12/11/2007 | Software
Most medical practice management software will contain some sort of reporting capabilities. These will range from very basic reporting, to having an advanced reporting writing function.
As a user, it is important to understand the value reports can bring to your organization. It is also imperative that the user not spend too much time writing reports. A system that can bring advanced reporting, based on real time data will be a very valuable tool to the user and organization.
Deciding on a New ERP Solution? Choosing Working With the Right Microsoft Partner Could Make the Difference in your Systems Success
By: Monique Tatum | 05/09/2007 | Software
The right Microsoft Certified Partner will prove invaluable as your new ERP solution is implemented, but having your solution set up correctly in the first place is only half the battle. Your chosen consulting firm for implementation should do much more than integrate and optimize your solution.
Great Plains Version Upgrade – Microsoft Dynamics Gp Installation Notes
By: Andrew Karasev | 07/10/2007 | Software
Microsoft Business Solutions Great Plains Dynamics GP version update technology seems to be straight forward – you insert new version CD and upgrade will be launched automatically with wizard. Proven Great Plains Dexterity technology will determine your current version and it will replace first GP workstation side files
Microsoft Great Plains Integration Manager 10.0 Technical Notes
By: Andrew Karasev | 17/11/2007 | Software
Microsoft Dynamics GP version 10.0 advanced such new technologies as eConnect in and this seems to be general trend to walk away from proprietary tools, such as Microsoft Dexterity to Microsoft specific platforms, such as .Net, COM+ and MS SQL Server Stored Procedures
Great Plains Dynamics Gp: Programming, Integration, Customization
By: Andrew Karasev | 21/12/2007 | Software
Microsoft Great Plains ERP is wide spread in USA and Canada, as well as in English speaking countries. As we see XXI century progressing, more technical skills are becoming the norm and so to say requirements in MRP system implementation
Submit Article About Microsoft Dynamics
By: Andrew Karasev | 22/02/2008 | Software
Alba Spectrum Group, one of the leading technology information portals, invites Microsoft Dynamics GP, AX, CRM, SL, RMS, NAV gurus, authors and contributors submit their articles, press releases
Great Plains Automatic Batch Posting Overview
By: Andrew Karasev | 17/05/2008 | Software
If you know Microsoft Dynamics GP architecture, Dexterity business logic, you probably realized that standard Great Plains Integration tools, such as Integration Manager, eConnect, which are typically deployed in eCommerce integration scenarios, allow you create only so-called work transactions: SOP Invoice is the most popular transaction type
Great Plains Setup: Installation, Data Conversion, User Training
By: Andrew Karasev | 15/06/2008 | Software
Microsoft Dynamics GP ERP system is targeted to mid-size businesses, and Small Business Financials is for smaller companies. It is common norm on the MRP market, when mid-size accounting software requires professional installing, support, data migration and reports design
Latest Software Articles
Personalize Your Desktop With Wallpapers
By: Rober Ron | 19/07/2008
It is a common sight that office computers bear the company’s logo as their wallpapers. On the other hand, computers at home use the pre-installed wallpapers like the image of nature. But an exciting person like you does not want to stick to the traditional images of wallpapers.
More Desktop Wallpaper Selections
By: Rober Ron | 19/07/2008
Using desktop wallpapers would not help make your computer achieve a more optimized performance. Though it does not do any significance on how your computer works, many are still hooked to the free desktop wallpapers offered in the internet today.
Free Desktop Wallpapers
By: Rober Ron | 19/07/2008
Computers all look alike. And because you want to set your very own computer apart from the others, you search for ways on how you can improve it. Then one day, you learned the latest trend among computer owners today—the use of desktop wallpapers.
Finding the Perfect Wallpaper the Easy Way
By: Rober Ron | 19/07/2008
Looking for new desktop wallpapers is no longer a tedious job. You don’t have to move mountains just to use the wallpaper of your choice. Instead, with just a few clicks you can now find and avail of the free desktop wallpapers. And presto! You now have a more customized desktop.
Desktop Wallpapers
By: Rober Ron | 19/07/2008
Once you open your desktop, it is the blank and uninteresting look of the monitor that first catches your eyes. And during the long hours of work, the blank screen provides no soothing effect to your eyes and spirit.
Desktop Customization Through Free Wallpapers
By: Rober Ron | 19/07/2008
You are trying to beat the 8 o’clock rush hour because you don’t want to be late at work. This could not be the situation if you did not burn the midnight oil trying to finish your office report. Before you went to sleep, you set the alarm hoping that it would be your shining armor in waking you up but to no avail, your alarm doesn’t went off. So here you are, running with all your might just to make it on time before your boss gives you another nasty look.
Beautify Your Desktop Computer
By: Rober Ron | 19/07/2008
Though computers are one of the most important technological breakthroughs today, there still remains a fact that this machine is dull and boring. They just sit in the corners of the room and are only noticed once you are about to use them.
Be One With the Stars With Bollywood Wallpapers
By: Rober Ron | 19/07/2008
Movie stars invade every aspect of the world. You not only see them in movies, commercials, posters, internet, and tabloid. But wait, you can also be with these famous superstars at any time of the day as desktop wallpapers also feature the familiar faces of movie stars. Wallpapers not only feature Hollywood superstars but you can also find Bollywood wallpapers today.
More from Andrew Karasev
Great Plains Consultant in Chicago, San Diego: Nationwide Support
By: Andrew Karasev | 19/07/2008 | Software
Microsoft Dynamics GP ERP is the member of Dynamics product family. If you decided to implement Great Plains in your organization, you probably came through the process of corporate ERP selection and decided to trust Microsoft Dynamics brand.
Great Plains Dynamics Gp Reseller: Nationwide Support
By: Andrew Karasev | 18/07/2008 | Software
If you are looking for new implementation of Microsoft Great Plains, you need first to locate Dynamics GP (which is new name of this ERP product) VAR, who will become your consulting and implementation partner. VAR selection should be based on your criteria.
Great Plains Customization: Reportwriter Modified and Custom Reports Overview
By: Andrew Karasev | 17/07/2008 | Software
In Microsoft Dynamics GP Report Writer is integrated reports modification tool, where you can modify such reports as Blank SOP Invoice form or Purchase Order to place your company logo there.
Great Plains Consultants and Developers Provide Nationwide Support
By: Andrew Karasev | 16/07/2008 | Software
If you have Microsoft Dynamics GP installed and implemented in your organization, and you are looking to get second opinion on your current system setup, customization, integration projects
Great Plains Consultant: Functional and Technical Support Overview
By: Andrew Karasev | 15/07/2008 | Software
If you are looking for Microsoft Great Plains consultant, or programmer, please review this publication to get oriented.
Great Plains Consultant, Var and Customization Partner
By: Andrew Karasev | 14/07/2008 | Software
You can get Microsoft Dynamics GP Great Plains licenses through GP certified Partner channel. Each GP reseller carries certified technical and functional consultants to be in the program.
Great Plains Customization: Dexterity Code Upgrade Overview for Consultant
By: Andrew Karasev | 13/07/2008 | Software
Microsoft Dynamics GP add-ons are often written in Great Plains Dexterity – with new and sometimes alternative GP forms and windows where the buttons, have scripts and forms themselves have procedures and functions.
Great Plains Var and Reseller: Software Licenses Overview
By: Andrew Karasev | 12/07/2008 | Software
Microsoft Dynamics GP is supported by Microsoft Business Solutions through partners or resellers channel and you should expect the changes in user licensing, purchasing options, software and implementation financing.
|
|
Computers 
