Microsoft Dynamics GP 10.0 is SQL 2005 application, however direct SQL scripting to feed or integrate eCommerce orders or invoices and payments might be complicated, due to rich GP business logic and
United States of America (Press Release) September 11, 2007 --
Alba Spectrum Group, 1-866-528-0577, 1-630-961-5918, help@albaspectrum.com http://www.albaspectrum.com
Microsoft Dynamics GP 10.0 is SQL 2005 application, however direct SQL scripting to feed or integrate eCommerce orders or invoices and payments might be complicated, due to rich GP business logic and its required validation in data integration. As eCommerce typically sends sales data to Great Plains Sales Order Processing module, which is really eConnect covered area, we recommend you first research Microsoft Dynamics GP eConnect technology, we will review eConnect in brief in this article below. Direct data feeding via SQL stored procedures is also OK if you try to restrict your integration functionality: do not allocate inventory items in SOP lines, create sales orders rather than invoices (to avoid building up GL distribution in your SQL scripting). Let’s begin:
1. eConnect. This tool and SDK was specially developed for eCommerce programmer, and later on Microsoft Business Solutions advanced eConnect and now it is covering other modules: POP, Payroll, General Ledger, etc. If you dig deeper, you will figure out that the heart of eConnect is set of encrypted SQL stored procedures. These procedures imitate GP Dexterity business logic in creating, deleting, modifying master records and work transactions. eConnect should be preferred tool as it validates Dex business logic and is recommended by MBS for e-commerce developers. If you think that eConnect is not a relevant tool for you, you can go ahead and take SQL querying route
2. eConnect and Batches posting. GP architecture has several phases of transaction life: work, open and history and among these phases only work transactions could be created in eConnect and be submitted for GP operator approvals. In eCommerce application you often want to post payments against invoice plus you want invoice to be posted and scheduled for delivery. If this is the case, you should research Alba Spectrum Posting Server, which is extension to eConnect and by technology it is Great Plains Dexterity application, appealing to Dex source code – developer places approved GP batches to custom table and posting server calls GP Dexterity native logic to post the batches
Andrew Karasev, Alba Spectrum Group, 1-866-528-0577, 1-630-961-5918, help@albaspectrum.com http://www.albaspectrum.com, servicing customers in Chicago, Houston, Dallas, Rockford, Milwaukee; Illinois, Texas. Via remote support we serve USA Nationwide: California, New York, Virginia, Florida, Georgia, Colorado, Minnesota, Utah, Canada: Toronto, Montreal, Vancouver, Quebec-City. Please note that our local service is available in Chicago area: Naperville, Downtown Chicago, Warrenville, Bolingbrook, Romeoville, Joliet, Aurora, Lisle, Downers Grove, Schaumburg, Elk Grove, Lombard. In Houston Metro: Richmond, Sugar land, Rosenberg, Stafford, Meadows, Katy, Mission Bend, Pasadena, Pearland.
Microsoft Dynamics GP 10.0 is SQL 2005 application, however direct SQL scripting to feed or integrate eCommerce orders or invoices and payments might be complicated, due to rich GP business logic and its required validation in data integration. As eCommerce typically sends sales data to Great Plains Sales Order Processing module, which is really eConnect covered area, we recommend you first research Microsoft Dynamics GP eConnect technology, we will review eConnect in brief in this article below. Direct data feeding via SQL stored procedures is also OK if you try to restrict your integration functionality: do not allocate inventory items in SOP lines, create sales orders rather than invoices (to avoid building up GL distribution in your SQL scripting). Let’s begin:
1. eConnect. This tool and SDK was specially developed for eCommerce programmer, and later on Microsoft Business Solutions advanced eConnect and now it is covering other modules: POP, Payroll, General Ledger, etc. If you dig deeper, you will figure out that the heart of eConnect is set of encrypted SQL stored procedures. These procedures imitate GP Dexterity business logic in creating, deleting, modifying master records and work transactions. eConnect should be preferred tool as it validates Dex business logic and is recommended by MBS for e-commerce developers. If you think that eConnect is not a relevant tool for you, you can go ahead and take SQL querying route
2. eConnect and Batches posting. GP architecture has several phases of transaction life: work, open and history and among these phases only work transactions could be created in eConnect and be submitted for GP operator approvals. In eCommerce application you often want to post payments against invoice plus you want invoice to be posted and scheduled for delivery. If this is the case, you should research Alba Spectrum Posting Server, which is extension to eConnect and by technology it is Great Plains Dexterity application, appealing to Dex source code – developer places approved GP batches to custom table and posting server calls GP Dexterity native logic to post the batches
Andrew Karasev, Alba Spectrum Group, 1-866-528-0577, 1-630-961-5918, help@albaspectrum.com http://www.albaspectrum.com, servicing customers in Chicago, Houston, Dallas, Rockford, Milwaukee; Illinois, Texas. Via remote support we serve USA Nationwide: California, New York, Virginia, Florida, Georgia, Colorado, Minnesota, Utah, Canada: Toronto, Montreal, Vancouver, Quebec-City. Please note that our local service is available in Chicago area: Naperville, Downtown Chicago, Warrenville, Bolingbrook, Romeoville, Joliet, Aurora, Lisle, Downers Grove, Schaumburg, Elk Grove, Lombard. In Houston Metro: Richmond, Sugar land, Rosenberg, Stafford, Meadows, Katy, Mission Bend, Pasadena, Pearland.
Email
Print
SPAM
LEAVE A COMMENT
