Before you download:
Clean your PC from errors
Microsoft  Project Green phase one is reflected in Microsoft Great Plains/DynamicsGP 9.0 realization. It is exposed to .Net developer currently through eConnect andas time goes  more and more eConnect object will have XML web service interfaces. In this small article we will be touching the set of object, deployed in eCommerceapplication, using Microsoft Dynamics GP as a backend. Sales Order Processing (SOP). In the light eCommerce case  you push data intoSOP10100  SOP Header table and SOP10200  SOP Line table. If you do create SalesOrders Only, do not accept deposits against sales order  then you do not care aboutSOP Distribution table: SOP10102. All these tasks could be realized througheConnect.  Inventory Tables. If you sell from your inventory (not just services), then youuse Inventory module tables: IV00101  Item master, IV00102  Item QTY master, thelast one shows you quantity at the specific location and in general  Receivable Management Tables. RM00101  Customer master  in case if you createand register new customer or update existing customer info in Great Plains.  eConnect extensions. Obviously eConnect will be repeating the logic of formerGreat Plains Dexterity objects. In Great Plains you typically create workdocuments: Quotes, Orders, Invoices and then you post them individually or in thebatch  posting process is functionally assigned to the operator, this is why youwill have hard time to program it via eConnect (which allows you to create workdocuments). You will need eConnect extensions or simply stored procedures, whichpost work records in Sales Order Processing and potentially Receivable Managementmodules  it is not recommended to create ones from scratch  posting and ordertransferring logic is very complicated.  Stored Procedures approach. We see more and more cases when eCommerce is builtaround Microsoft Small Business Financials, former Microsoft Small Business Manager in such a situation eConnect might be too expensive and too complex  you may needjust several SOP oriented stored procedures to create SOP orders and invoices at theback end in SOP SQL tables. The advice to the developer in the case of SmallBusiness Financials  ask SBF user to create sample transaction  Sales Order andwatch how did it distribute across SOP tables  you will get the idea andreplication pattern for your SQL coding  Development Tools. Microsoft Visual Studio.Net is becoming the tool of choice(over now legacy Microsoft Dexterity or Great Plains Software Dexterity). Howeverif you are eCommerce developer  you will have to use SQL scripting. Usually thefirst question is  where do I get Great Plains table structure description:Tools->Resource Description->Tables. Sometimes developers ask about Great PlainsIntegration Manager. This tool is in process of being rewritten with eConnectpanidea. Integration Manager up to version 8.0 was relatively slow in its technicalability to integrate bulk number of records  it used legacy OLE Server technology  Great Plains was OLE Server and IM used GP screens to validate integration records. New integration manager should be more powerful and it is in the process of thecreation as we write these lines.  Microsoft Dynamics CRM web front. In some cases we see this scenario. MicrosoftGreat Plains  MS CRM integration is in process of being rewritten on eConnect  currently it uses BizTalk server (and does a nice job, however sometimes you have toprogrammatically tune the BizTalk integration). In CRM you can create Account orContact that will be integrated to Great Plains Customer, then Order when submittedcan be integrated to Great Plains if needed. Sometimes developers complain, thatthey have to force credit limit for the CRM Account to be non-zero  in order forthe invoice to come through
About Alba Spectrum Technologies. Alba Spectrum Technologies is joint venture ofseveral IT and business consulting companies, now operating as single businessentity. We have local presence in the Houston, Chicago, New York, Los Angeles, SanDiego, Dallas, Miami, Atlanta, Denver, Phoenix, New Orleans, Minneapolis, SanFrancisco, LATAM & Brazil, Germany, Russia, South East Asia and Oceania. We believein the coexistence of Java (J2EE, EJB, Linux, Unix), Oracle and Microsoft (.Net, C#,VB) platforms and systems and specialize in several product lines and cross platformintegration, customization, heterogeneous report design, plus we provide ERP/CRMsystems comparison and reviews, not being committed to just on MRP platform. We alsostake on XML cross-platform data interchange to be advanced in the coming decade.
Alba Spectrum Technologies websites: http://www.albaspectrum.com http://www.greatplains.com.mx http://www.enterlogix.com.br http://www.ronix-systems.de
