Microsoft Great Plains Integration Scenarios

<h1>Microsoft Great Plains Integration Scenarios – Edi, Ecommerce</h1>Author: <a title="Andrew Karasev" href="http://www.articlesbase.com/authors/andrew-karasev/32149.htm">Andrew Karasev</a> Microsoft Dynamics GP, successor of Great Plains Software Dynamics and eEnterprise is very popular ERP platform, deployed as accounting back office and integrated with various business management system. Among the most typical scenarios of GP MRP integration are Electronic Document Interface EDI and eCommerce. Let’s consider and compare the methodologies, integration and software development tools, programming techniques and customization option

1.	EDI. Electronic Document Interchange is relatively matured technology and typically it is realized in the form of fixed length text formatted files or text streams. Newer approach may consider new generation of similar to EDI in concept XML streams. When we are talking about GP, we should expect two types of EDI integrations – when you are vendor (in this case you receive EDI formatted either Sales Order Processing orders or invoices or Accounts Receivables invoices); and when you are customer (in this case you place EDI purchase orders to your vendors). From the technology standpoint, EDI is not really difficult in standard and even custom realization and programming. Microsoft Dynamics GP, starting with version 8.0, is supported on the only DB platform – Microsoft SQL Server. Current version of Microsoft Great Plains is 10.0, available on MS SQL Server 2005 or 2000. You program EDI streams with SQL select command, and you format text fields with cast or convert constructions. When you import external EDI streams you, it is when you create SOP Invoices, you should consider utilizing eConnect

2.	eCommerce. If you are e-commerce programmer, please invest your time in eConnect technology learning. You probably heard about eConnect and about the fact that it was dedicated initially to e-commerce software developers. We would like to sort of popularize eConnect and say this – if you do eCommerce integration from scratch, you have to feed eCommerce orders and invoices into GP tables: SOP10100, SOP10200. However, you should know that eConnect already has this job done for you in eConnect business objects – encrypted stored procedures. There are several situations when you should break through eConnect restrictions. First one is the fact that eConnect replicates Dexterity business logic (DYNAMICS.DIC is Microsoft Dexterity dictionary, where all the core modules business logic is stored) and even trusting astonishing SQL Server performance, you can still have concerns that eConnect might be a bit slow, if you transactions volume crosses thousand records per session. If eConnect performance is in question, you may consider doing simplified integration in SQL stored procedures using insert into logic. The second eConnect limitation is absence of posting logic – in order to post SOP batches you will need to deploy Albaspectrum posting server

About the Author: Andrew Karasev, Alba Spectrum Group, <a target="_blank" href="http://www.albaspectrum.com">http://www.albaspectrum.com</a> <a href="mailto:help@albaspectrum.com">help@albaspectrum.com</a> 1-866-528-0577, 1-630-961-5918, serving customers USA/Canada nationwide: Illinois, California, New York, Quebec, Ontario, Colorado, Utah, Wisconsin, Florida, Texas. Local service is available in Houston & Dallas: Richmond, Sugar Land, Katy, Rosenberg, Missouri City, Pearland, Friendswood, Meadows, Mission Bend, Jersey Village, Fort Worth; serving GP customers in Chicago, IL: Naperville, Aurora, Joliet, Wheaton, Bolingbrook, Romeoville, Lyons, Niles, Downers Grove, Lisle, West Chicago, Barrington, Schaumburg, Elk Grove Village, Lombard, Morris, Ottawa, Marseilles, Seneca, Oswego, Plainfield, Darien, Winchester, Hinsdale 
Article Source: <a href="http://www.articlesbase.com/">ArticlesBase.com</a> - <a href="http://www.articlesbase.com/software-articles/microsoft-great-plains-integration-scenarios-edi-ecommerce-245810.html" title="Microsoft Great Plains Integration Scenarios – Edi, Ecommerce">Microsoft Great Plains Integration Scenarios – Edi, Ecommerce</a>

Microsoft Dynamics GP, successor of Great Plains Software Dynamics and eEnterprise is very popular ERP platform, deployed as accounting back office and integrated with various business management system. Among the most typical scenarios of GP MRP integration are Electronic Document Interface EDI and eCommerce. Let’s consider and compare the methodologies, integration and software development tools, programming techniques and customization option

1. EDI. Electronic Document Interchange is relatively matured technology and typically it is realized in the form of fixed length text formatted files or text streams. Newer approach may consider new generation of similar to EDI in concept XML streams. When we are talking about GP, we should expect two types of EDI integrations – when you are vendor (in this case you receive EDI formatted either Sales Order Processing orders or invoices or Accounts Receivables invoices); and when you are customer (in this case you place EDI purchase orders to your vendors). From the technology standpoint, EDI is not really difficult in standard and even custom realization and programming. Microsoft Dynamics GP, starting with version 8.0, is supported on the only DB platform – Microsoft SQL Server. Current version of Microsoft Great Plains is 10.0, available on MS SQL Server 2005 or 2000. You program EDI streams with SQL select command, and you format text fields with cast or convert constructions. When you import external EDI streams you, it is when you create SOP Invoices, you should consider utilizing eConnect

2. eCommerce. If you are e-commerce programmer, please invest your time in eConnect technology learning. You probably heard about eConnect and about the fact that it was dedicated initially to e-commerce software developers. We would like to sort of popularize eConnect and say this – if you do eCommerce integration from scratch, you have to feed eCommerce orders and invoices into GP tables: SOP10100, SOP10200. However, you should know that eConnect already has this job done for you in eConnect business objects – encrypted stored procedures. There are several situations when you should break through eConnect restrictions. First one is the fact that eConnect replicates Dexterity business logic (DYNAMICS.DIC is Microsoft Dexterity dictionary, where all the core modules business logic is stored) and even trusting astonishing SQL Server performance, you can still have concerns that eConnect might be a bit slow, if you transactions volume crosses thousand records per session. If eConnect performance is in question, you may consider doing simplified integration in SQL stored procedures using insert into logic. The second eConnect limitation is absence of posting logic – in order to post SOP batches you will need to deploy Albaspectrum posting server

Andrew Karasev, Alba Spectrum Group, http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918, serving customers USA/Canada nationwide: Illinois, California, New York, Quebec, Ontario, Colorado, Utah, Wisconsin, Florida, Texas. Local service is available in Houston & Dallas: Richmond, Sugar Land, Katy, Rosenberg, Missouri City, Pearland, Friendswood, Meadows, Mission Bend, Jersey Village, Fort Worth; serving GP customers in Chicago, IL: Naperville, Aurora, Joliet, Wheaton, Bolingbrook, Romeoville, Lyons, Niles, Downers Grove, Lisle, West Chicago, Barrington, Schaumburg, Elk Grove Village, Lombard, Morris, Ottawa, Marseilles, Seneca, Oswego, Plainfield, Darien, Winchester, Hinsdale

Rate this Article:

0 / 5 stars - 0 vote(s)

Re-Publish

Article Source: http://www.articlesbase.com/software-articles/microsoft-great-plains-integration-scenarios-edi-ecommerce-245810.html

Article Tags: Ecommerce, Microsoft Dynamics Gp

Related Articles
Related Q&A

Latest Software Articles
More from Andrew Karasev

DSA Organizations Views Warehouse Control Systems Integral to 2010 Success

By: Thomas Cutler | 22/12/2009
DSA Organizations Views Warehouse Control Systems Integral to 2010 Success

Payroll software more than software as a service

By: Daniel Adams | 22/12/2009
ADP is the UK’s leading supplier of payroll services, time and management systems, HR software solutions and related services for all types of businesses. Contact us at ADP to find out more about payroll services, time & attendance systems and HR software solutions. Call 0800 180 4994.

Get More From PlayStation 2

By: Sarah Reddingworth | 22/12/2009
Do you have a PlayStation 2? Do you want to get more out of it? This amazing gaming console brought out to the world in 2000 is one which has taken the world. Now you can discover how to extend it!

How to convert MOD to AVI MPEG WMV MP4 VOB 3GP?

By: lazerer | 22/12/2009
How to convert MOD files to AVI MPEG WMV MP4 VOB 3GP? Follow this guide and you will find it can’t be much easier to make your MOD files playable on computer, iPhone, iPod, Blackberry, Zune, PSP, Creative Zen, etc.

How to Rip DVD on a Mac (including Snow Leopard)

By: Kindour | 22/12/2009
The following guide is going to show you how to rip DVD's to all sorts of video and audio formats on Mac OS X (including Snow Leopard) using DVD Ripper for Mac. It also shows several tips and tricks you need to pay attention to while using this Mac DVD Ripper to rip DVD on your Mac machine.

How to organize photos collection by removing duplicate files?

By: John SWA Smith | 22/12/2009
How to organize photos collection by removing duplicate files? There was a time when we used to take pictures using cameras with films which had to be developed to get the required pictures and it used to be difficult to get their soft copy. But now with digital photography you can simply load pictures into your computer using a data cable or a memory card, and it also save photographers the trouble of keeping hard copies of their photo albums in a safe place.

Australia Accounting Software Secondary Functions

By: Steele Rudd | 22/12/2009
In addition to the core modules and functionalities of accounting software products and applications, there are also certain secondary modules and functionalities that have been incorporated to make these products as useful as they can be in providing a holistic solution to your organisation’s accounting needs.

The Distinction Between Paid And Free Video Editing Software

By: Lance Carr | 22/12/2009
If you are in search of video editing programs and have noticed that there are a few free ones available then the issue is, why pay for video editing programs?

Great Plains Support: Covering All Versions - Dynamics GP, Pervasive SQL, GPA for DOS

By: Andrew Karasev | 22/12/2009 | Software
All versions of Microsoft Dynamics GP and its predecessor Great Plains Dynamics and eEnterprise, plus earlier versions of GP on Pervasive SQL 2000 or Ctree (including Mac based Faircom version), as well as Great Plains Accounting for DOS, Windows or Macintosh are supportable. In this small publication we will review all versions of GPA, Great Plains and Microsoft Dynamics GP (from earlier 1990th up to May 2010) and their support methods.

Microsoft Dynamics GP Customization Support and Recovery Service

By: Andrew Karasev | 19/12/2009 | Software
If you have current or old version of Great Plains Dexterity custom add-on module, or another modification type, such as Modifier with VBA scripts or eConnect application (including the case when it is Microsoft Visual Studio .Net C# or VB ecommerce integration project), GP Integration Manager advanced customization with VBA events handling scripts, simple or Advanced ODBC data sources, Great Plains Macros (including such cases, when you are moving ongoing transactions and master records...

eCommerce B2B and B2C Shopping Cart Integration to Microsoft Dynamics GP Programmer Notes

By: Andrew Karasev | 17/12/2009 | Software
If you are working for the organization, deploying Microsoft Dynamics GP, formerly also referred as Great Plains Dynamics and your next step is ecommerce shopping cart integration to your Corporate ERP (Microsoft Great Plains Dynamics GP), we would like to recommend you this small publication written in FAQ technical style.

Microsoft Dynamics GP Nationwide Remote Support

By: Andrew Karasev | 16/12/2009 | Software
This Corporate ERP application was also known as Great Plains Dynamics and Microsoft Great Plains, and its predecessor was Great Plains Accounting for DOS, Windows and Macintosh. Good news is - all Great Plains versions are supportable and help is close to you, just phone call away. This small publication should give you introduction about Dynamics GP web session based nationwide and international support: what is web session with phone conference number or skype phone...

Development for Microsoft Dynamics GP, formerly known as Great Plains: Dexterity, eConnect, eCommerce programming

By: Andrew Karasev | 16/12/2009 | Programming
Microsoft Dynamics Corporate ERP and CRM family of products includes Dynamics GP (formerly known as Great Plains Dynamics, eEnterprise, Great Plains Select on Pervasive SQL and Ctree), AX (formerly known as Axapta), NAV (known as Navision), SL (Solomon), Microsoft Dynamics CRM (this is CRM application, it might be part of Corporate ERP, but technically it is just CRM).

SAP Business One 8.8 for Multinational Company: Russia, Brazil, China Notes

By: Andrew Karasev | 06/12/2009 | Software
With anticipated release of SAP B1 version 8.8 traditional separation into A and B lines will be merged. As you may know, that such languages and localizations as Russian, English, German for SB1 2007 and 2005 were in A and other languages, for example Brazilian Portuguese, Chinese were in B (SB1 2007B or SB1 2005B).

Microsoft Dynamics GP Development: Dexterity, eConnect, Extender

By: Andrew Karasev | 04/12/2009 | Software
If you have Microsoft Dynamics GP (earlier versions known as Great Plains Dynamics, eEnterprise, Great Plains Accounting for DOS, Windows and Mac) as your Corporate ERP, and you plan to undertake customization project, please read this small publication to get information session on Dynamics GP modification tools.

Microsoft Dynamics GP ECommerce Partner in Chicago

By: Andrew Karasev | 03/12/2009 | Software
e-Commerce web site integration is real challenge, especially when your Corporate ERP is Microsoft Dynamics GP (formerly known as Great Plains Dynamics, eEnterprise, Great Plains Select, Great Plains Accounting for DOS, Windows and Macintosh), and your ecommerce web application is PHP/MySQL/Linux or Unix/Oracle based.