|
Microsoft Great Plains Integration Scenarios: EDI, eCommerce Alba Spectrum
Alba Spectrum Group, http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918
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. Lets 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
Company: Alba Spectrum Group
|
| Related press releases |
Ecommerce design for Microsoft Dynamics GP Great Plains Alba Spectrum [2007-08-18 03:29:33]
Alba Spectrum Group http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918
Microsoft Great Plains backed ecommerce websites are very popular and considering Alba Spectrum ...
|
|
Microsoft Dynamics GP Great Plains Integration and Upgrade Service in Chicago ... [2007-11-02 07:45:12]
Former Great Plains Software, later on Microsoft Business Solutions Great Plains and currently finally Microsoft Dynamics GP ERP application serves to midsize and large US businesses, also it has Cana...
|
|
eConnect Posting Extension: Alba Spectrum Autoposting Server [2008-05-21 22:54:55]
If you are ecommerce developer, who are programming in C# or VB.Net with some SQL stored procedures, then more likely you are deploying Microsoft Dynamics GP eConnect SDK to integrate eCommerce websit...
|
|
Microsoft Dynamics GP 10.0 Visual Studio Development notes Alba Spectrum [2007-08-26 04:23:08]
Alba Spectrum Group, http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918
If you are eCommerce programmer and plan to dive into Microsoft Great Plains e-commerce web des...
|
|
Microsoft Dynamics GP 10.0 Implementation in Chicagoland Alba Spectrum [2007-09-03 03:29:31]
Alba Spectrum Group, http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918
If you are business owner or IT director, you are probably in charge of ERP selection, licenses...
|
|
Web Design for Microsoft Dynamics GP: custom ecommerce solutions Alba Spectrum [2007-08-18 05:19:13]
Alba Spectrum Group, http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918
More articles are published about Microsoft Great Plains Dynamics GP 10.0. Very hot topic is e...
|
|
eConnect eCommerce Posting Server for Dynamics GP Alba Spectrum [2007-09-22 02:52:59]
Alba Spectrum Group: http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918
If you are eCommerce .Net c#, VB or SQL developer, you need to know eConnect Microsoft Dynami...
|
|
Microsoft Great Plains Integration Scenarios: EDI, eCommerce Alba Spectrum [2007-10-26 04:31:30]
Alba Spectrum Group, http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918
Microsoft Dynamics GP, successor of Great Plains Software Dynamics and eEnterprise is very popu...
|
|
Microsoft Dynamics GP Great Plains and MS CRM tandem as corporate ERP Alba Spe... [2007-09-08 06:16:58]
Alba Spectrum Group, http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918
Microsoft Dynamics ERP products family includes both Great Plains and Microsoft CRM, so it is i...
|
|
Microsoft Great Plains Boca Raton, FL Alba Spectrum Group [2007-12-23 04:52:45]
Microsoft Business Solutions Great Plains is gaining market share as we write these lines. Alba Spectrum Group is announcing its Florida GP consultants headcount increase. If you have concerns about...
|
|
|
|
| Repton 2 |
 Repton 2, the eagerly-awaited sequel!
The challenge continues ... spirits, transporters, skulls, puzzle pieces, and now savepoints by popular request!
* Three varied scenarios!
* Easy-to-use editor, include your own images as puzzle pictures! |
|
| 123 Flash Chat Software |
 123 Flash Chat Server Software can add a chat room to your website in minutes. It is a live chat solution for networking. It has multiple skins & mutiple chat client, such as iPhone Chat, Avatar Chat, offering seamless integration to your database. |
|
| SnapaShot |
 Smallest free screen capture tool, SnapaShot is great for taking screenshots of different size. Just open Snapa, resize its window to fit the area you want to save, and press "save it" button. |
|
| OfficeCalendar for Microsoft Outlook |
 Share Microsoft Outlook calendar, email, contact, and task information with this affordable Exchange alternative. Makes Outlook calendar sharing and Outlook group calendaring easy. Works with Microsoft Outlook 2000, XP, 2003 and 2007. Free trial. |
|
| DBEXform |
 Make database application development and use as easy as using word processor or spreadsheet with DBEXform. It builds application logic in background and frees developer to just on building interfaces. Support for Microsoft Sql and Access databases. |
|
| egrID3 COM Add-In for Microsoft Excel |
 egrID3 COM Add-In for Microsoft Excel adds functionality to fast mp3 ID3 v1.x, v2.3, v2.4 tag reading and altering, playlists generation, FreeDB querying, file names handling and full Unicode support on all operations. Handle compressed v2.x frames. |
|
| GetGo Download Manager |
 Free Download Manager, Downloader and Accelerator. An Essential Internet Tool for Increasing Speed, Resuming, Scheduling, and Organizing. Integration with Browsers allows quick download of recognized file types according to their extensions. |
|
|
Latest press releases
