Recommended: Click here to run a Free driver update scan »
When you are facing e-commerce transactions volume growth  typical solution is toremap backoffice ERP system to more scalable. In this small article we consider thecase, when you remap eCommerce to Microsoft Great Plains Dynamics GP. If you makeyour homework and search the internet to understand your options, you will see thatseveral out of the box solutions are out there, however it is typically not what youare looking for: you would like to keep your existing ecommerce solution withshopping cart, checkout and credit card processing. In this case  you way iseCommerce integration to Microsoft Dynamics GP Remapping technology. LetÂ's assume that you had something like SAP Business One,where you deployed SAP B1 SDK and programmed eCommerce to SB1 integration inMicrosoft Visual Studio C# project. When you remap to GP  you also use MS VisualStudio and C# programming language and GP integration tools, described in the nextsection eConnect. The core logic of eConnect is realized as a set of SQL storedprocedures and you can manipulate such GP objects as Customer, Sales Invoice (orOrder if you plan to transfer order to invoice later on) Automatic Posting dilemma. Looking back to SAP Business One  there when youcreate Invoice  it is already  posted . In the case of Great Plains  Invoice iscreated in so-called  work status, then typically placed into the batch forapproval and posting by GP operator. eConnect does allow you to create SalesInovice, but it doesnÂ't allow you to post it automatically from eCommerceapplication. This is natural restriction of Great Plains Dexterity architecture Posting Server. This solution is available for purchase and it uses MicrosoftDexterity posting engine. What you need to do as eCommerce developer is to placethe batch into the table, and so approving it for posting. Posting Server checksthe approved batches table every five seconds and posts the content of the table. Alba Spectrum Posting Server requires GP workstation running on separate computer  expect one additional user license Excurse to Microsoft Dynamics GP Dexterity. It was designed as a shell, writtenin C programming language to resolve DB and OS dependency. Dex.exe is theapplication and it launches dictionaries, such as DYNAMICS.DIC. you can find Dexdictionaries, listed in Dynamics.set file. Programming Dexterity should be left toprofessionals, as it proprietary and pretty unique scripting language: sanscript  plus dex programmer should be familiar with dex architecture and tables structure. Dexterity enables various customizations, integrations, modifications to existing GPbusiness logic
Andrew Karasev, Alba Spectrum Group. http://www.albaspectrum.comhe lp@albaspectrum.com 1-866-528-0577, 1-630-961-5918, serving MS Dynamics GPcustomers locally in Houston: Richmond, Rosenberg, Dallas, Katy, Sugar Land,Galveston; Chicago: Naperville, Aurora, Morris, Glen Ellyn, Winchester, Oak Park,Lyons, Alsip, Lemont, Seneca, Ottawa, Joliet, Plainfield, Romeoville, Barrington,Crystal Lake, Rockford, DeKalb, Wheaton, Lisle, Downers Grove, Batavia, St. Charles,Norway. Dex customizations USA/Canada nationwide support is available via remotesupport/connection: California, Minnesota, Florida, New York, Virginia, Oregon,Arizona, Pennsylvania, Vermont, Rhode Island, New Mexico
