Denis Joseph Nexum Hardware.

Qty Wholesale

Dynamics GP Ecommerce Shopping Cart Integration Options

If you have Microsoft Dynamics GP implemented in your organization as Corporate ERP application and now you are looking for phase two, where such nice feature as ecommerce shopping cart is subject for the integration, this small publication is for you.  First of all we would like to share with you our believes  that ecommerce shopping carts, such as Magento/PHP (especially when you are on Linux), ASP.Net Storefront, Nop Commerce and others, are pretty robust and there is no real need to program shopping cart from scratch internally (until you are really huge ecommerce wholesaler or retailer, where you prefer to have complete control over program proprietary business logic and source code, and have the budget to afford that kind of luxury approach).  In our case, we tried to give you ecommerce add-on for Microsoft Dynamics GP (often referred by its historical name Great Plains Dynamics and eEnterprise, in case if you have some confusion with the application name) where you simply follow setup wizard, selecting your ecommerce shopping cart name from drop down list on one of the initial steps.  Other steps are specific to Dynamics GP typical integration with ecommerce: settings in Inventory Control, Sales order Processing modules:

1. Ecommerce Shopping Cart Image in Great Plains.  It is typically Sales Order Processing Invoice or Sales Order with Customer Deposit in the form of Credit Card payment (especially in B2C scenario, while in B2B scenario you may sell on account, and prepayment is optional).  If you plan to allocate Invoice or Order lines automatically directly from the Shopping Cart, you need to specify default ecommerce SOP Document ID as the one with automatic allocation (in this case item line fulfillment happens instantly as ecommerce document is transferred to GP).  If you would rather prefer to fulfill the lines via Warehouse Management System/Barcoding on the warehouse floor, then pick document ID where allocation is set to manual.  Second important concept is default ecommerce Inventory Site ID – in Great Plains it is important to have default settings to minimize data entry per document.  In the case of Sales Order Processing document each one may have default site ID, and if it is specified – each line will be automatically allocated (or assigned for manual fulfillment) from the specified site.  Inventory control hosted Site object is participating in the logic is such distribution modules as Sales Order Processing, Purchase Order Processing, Bill of Materials, Manufacturing Suite of Modules, Invoicing (this module however is rather legacy, we do not recommend it for serious consideration in eCommerce implementation)

2. eCommerce and Non-inventory items.  For smaller ecommerce retailers, especially specializing in very volatile (changing every week or month) reselling catalogues of items, you may decide to completely abandon such Inventory Control features as Quantity on-hand, returned, damaged, in-service and only track items sold through Sales Reports (based on SOP30200 and SOP30300 tables – document header and line history).  If you transform your ecommerce shopping cart document lines into non-inventory items in Dynamics GP SOP – item id is simply capitalized text (or flow of the characters), then description is the combination of Capital/Small letters, digits and delimiting characters, plus there is no pricelist (you must specify QTY sold, price and cost if known)

3. eCommerce integration technology.  Our Add-on ecommerce module is based on Alba Spectrum proprietary technology Order Connector.  According to our performance tests, Order Connector is more efficient, comparing to Dynamics GP SDK eConnect (both technologies as based on SQL stored procedures, however Order Connector is geared toward light weight Sales Order Processing transaction logic, where eConnect validates 100% of the Dynamics GP SOP business logic, which might contribute to longer stored procedures execution time and in our opinion and taking into consideration the set of processes in ecommerce add-on module – only some of the business logic must be validated, the rest of the logic realm is really optional)

4. What if your organization is in position to sponsor ecommerce shopping cart programming from scratches?  If shopping cart is generic ecommerce shopping cart interface compliance, we might be able to incorporate it into our ecommerce add-on for Dynamics GP.  If your shopping cart is really complex and proprietary, feel free to call us for estimation.  We have really challenging carts integrated in the past, especially in such environments as Linux/PHP/MySQL.  Plus there are unlimited options to move proprietary shopping cart document to Dynamics GP via Text or Advanced ODBC connection in Integration Manager.  IM is capable to provide you quasi real time integration (every 20 minutes, or you name the time interval), being scheduled in Windows Scheduled Tasks on the Server (there are multiple shareware and even freeware, providing calling Executable program with DOS parameters), the same approach could be called when new ecommerce shopping cart document is triggered as being completed directly in ecommerce application (you can simply call IM with parameters from your ecommerce web application code)

5. eConnect versus Integration Manager.  Dynamics GP eConnect SDK is really powerful instrument, initially it was dedicated to ecommerce programmers, to open Great Plains objects and transactions for ecommerce shopping cart integration.  In our opinion eConnect became stable and bug free with introduction of Dynamics GP version 9.0, so we do recommend you to try yourself (especially when you are considering yourself as practicing Microsoft Visual Studio C# or VB.Net coder).  The best scenario to deploy eConnect libraries, is when your ecommerce website is programmed in Microsoft Visual Studio.  In the case, when you are on Linux e-commerce platforms, there are ways to call Windows DLL as well as eConnect methods (stored procedures) indirectly via Linux to Windows bridges, however it might give you too much hard time and learning curve.  So, if you are on Linux, Unix, Oracle/Java, IBM DBII platforms, we would rather encourage you to reconsider exporting ecommerce shopping cart into text (tab or comma delimited) file or even cross-platform compliant XML format.  Regarding Integration Manager and eConnect performance comparison, you might be aware that Integration Manager for Dynamics GP version 10.0 (and especially current version 2010/11.0, as we are writing these lines in September 2010) introduced eConnect integration connectors, where IM integration is in fact calling the same SQL Stored procedures as if you deploy eConnect libraries directly in your Visual Studio Web Project, so the performance should be comparable

6. Which version is recommended prior to diving into ecommerce integration project?  The answer depends on the scope of the project.  You might be fine deploying Integration Manager on all the versions of Dynamics GP and even legacy Great Plains Dynamics and eEnterprise: 9.0, 8.0, 7.5, 7.0, 6.0, 5.5, 5.0, 4.0 (please note that Integration Manager works even for such archaic DB platforms as Pervasive SQL 2000/Btrieve and Ctree) .  However if you are looking forward to integrate real time ecommerce shopping cart directly from Magento, ASP.Net Storefront or other full-featured shopping cart platform, we recommend you to upgrade to Dynamics GP at least version 10.0

7. Combining Ecomerce with Warehouse Management System and Barcoding technologies.  If you are seeking for complete automation, where Shopping Cart is scheduled for automatic fulfillment on the warehouse floor via barcode scanning, we recommend you to consider Alba Spectrum WMS Add-ons for Microsoft Dynamics GP

8. If you are expanding internationally as ecommerce wholesaler or retailer.  Here you need to familiarize yourself with such concept as Corporate ERP localization.  It typically includes two components: local or regional language support and tax code or local country business regulation compliance (custom code, invoice form, sometimes government approved chart of accounts and how transactions should be posted in GL – good examples are France or Russian Federation).  Current version of Dynamics GP is 2010/11.0 as well as version 10.0 are localized for English speaking countries: USA, UK, Ireland, Canada (Including French speaking Quebec province with Montreal), Spanish speaking Latina America, Caribbean basin, Oceania, South East Asia, where English language is in use as the language of business.  If you are multinational subsidiary, expanding internationally and your country is not listed here, please consider to give us a call for consultation or consider another Corporate ERP platform for you overseas subsidiary: Dynamics AX Axapta or if you prefer SAP platform – SAP Business One.  Also you have to be aware that Dynamics GP Dexterity platform doesn't support Unicode based languages (typically hieroglyph characters based alphabets, such as Chinese, Japanese, Korean)

9. For further information, please call us 1-866-528-0577, email us help@albaspectrum.com  By the nature of our service we are available for WMS implementation USA, Canada nationwide.  Local service is available in Western Michigan: St. Joseph, Kalamazoo, Grand Rapids, Muskegon, Holland, New Buffalo; in Chicagoland, North Western Indiana, Southern California (Los Angeles, San Diego, Irvine, Orange County), Houston and Dallas areas of Texas

About the Author

Andrew Karasev, Alba Spectrum Group, http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918, serving GP customers USA and Canada Nationwide: California, Minnesota, New York, Quebec, Ontario, Illinois, Texas, Georgia, Arizona, Nevada, Virginia, Florida, new Mexico, Iowa, Indiana, Alaska, Hawaii. Local service is available in Houston/Dallas: Richmond, Rosenberg, Katy, Galveston, Sugar Land; in Chicago: Naperville, Aurora, Plainfield, Romeoville, Batavia, Downers Grove, Schaumburg, Rockford, Elgin, Crystal Lake, Joliet, Hinsdale, Lisle, Montgomery, Oswego

Bayer Ames Ketostix, 50 Qty.. Box of 50 $25.67 Manufacturer: Bayer. Box of 50. Dip-and-read test for urine ketones. Customers also search for: Discount Ames Ketostix, 50 Qty. , Buy Ames Ketostix, 50 Qty. , Wholesale Ames Ketostix, 50 Qty. , Blood Glucose Monitoring Supplies

Lincoln Lubrication Fitting Assortment - Qty 24. Each $22.76 Manufacturer: Lincoln Lubrication. Each. Features and Benefits: 24 assorted grease fittings in six popular sizes blister packed on one card Customers also search for: Discount Fitting Assortment - Qty 24, Buy Fitting Assortment - Qty 24, Wholesale Fitt

Bayer Keto-Diastix Reagent Strips, 100 Qty.. Bottle of 100 $39.35 Manufacturer: Bayer. Bottle of 100. Tests for glucose and ketones in the urine. Customers also search for: Discount Keto-Diastix Reagent Strips, 100 Qty. , Buy Keto-Diastix Reagent Strips, 100 Qty. , Wholesale Keto-Diastix Reagent Strips, 100 Qty. , Blood

Qty 2-Q6511xd $724.99 QTY 2-Q6511XD

for Iphone 3G White Back Housing Battery Cover Free Shipping Wholesale $6.12 Paypal payment No MOQ Large QTY in stock,fast delivery Bulk order for more discount rate Mixed color available

Wholesale CE and RoHS certificate 3*1W LED Bulb TT-067 $69.3 Item No.: TT-067 Lamp Base: E27 Input Voltage: 110V-240V Power: 3*1W LED QTY: 3pcs

promotion!!!wholesale 100pcs*4.3mm mood rings,change color rings,temperature ring,fashion jewellery,free shipping+gift $21.88 width:about 4.3mm QTY:100pcs packing:with display+color pages+gift

QTY 1 TR050-CTDB-S1BA & QTY 2 MR050-A01A $561.99 QTY 1 TR050-CTDB-S1BA & QTY 2 MR050-A01A

QTY 1 EC-L2KAA-YF-B, QTY 8 MR-L4MQN-01 $3454.99 QTY 1 EC-L2KAA-YF-B, QTY 8 MR-L4MQN-01

Qty 2-Sam-Scx-4216d3 $151.99 QTY 2-SAM-SCX-4216D3

Qty 2-Sam-Scx-4100d3 $152.99 QTY 2-SAM-SCX-4100D3

Pnc-Kxtg1062m Case Qty $320.99 PNC-KXTG1062M CASE QTY

100pcs Hot sale! New Arrival Novelty Gun rifle Pen/ Gift pen/ Promotion pen wholesale Free Shipping $24.95 wholesale

Hotsale! 6 COLORS New syringe pen/Ball pen/ Fashion pen wholesale 80pcs/lot Free Shipping $25 wholesale

S.C Free Shipping Wholesale - Cell Phone Accessories/Wallet Case for Iphone 4/dropshipping OLDPH00006 $14.62 1.Phone Accessories , For Iphone Wallet, Phone Case 2.100% sheep skin leather 3.Factory Directly 4.Small Qty accepted

wholesale 6 pieces NEW RED HEART FIRE SKY CHINESE LANTERNS BIRTHDAY WEDDING PARTY $10 Features: Fuel Body including 100% Brand New. Weight: 73g QTY:1PCS. Duration: 10-12 min Diameter: 40cm

wholesale 30 pieces NEW RED HEART FIRE SKY CHINESE LANTERNS BIRTHDAY WEDDING PARTY $45.26 Features: Fuel Body including 100% Brand New. Weight: 73g QTY:1PCS. Duration: 10-12 min Diameter: 40cm

wholesale 500 pieces NEW FIRE SKY CHINESE LANTERNS BIRTHDAY WEDDING PARTY $440 Features: Fuel Body including 100% Brand New. Weight: 73g QTY:1PCS. Duration: 10-12 min Diameter: 40cm

Free shipping,wholesale 20 pcs plated silver rose ring fashion ring $13.68 Description Material : alloy pearl Size : 1.8cm color:as picture Qty: 10 pcs per packing

The Crackhouse (Wholesale) $6 The Crackhouse (Wholesale) - Fat Joe Feat Lil Wayne

Wholesale eleclysis ionizer $110 $110 factory produce , wholesale $110

Wholesale water purifier $110 $110 factory produce , wholesale $110

Wholesale bacelets 12pcs 925 silver P mixed color and styles bracelets with free pretty box $88.42 QTY:6*2pcs Material: 925 silver p lenght:19cm--22cm color:as the picture 6pcs mixed color and styles braceletes (as the pictures

LOT 10 Back Housing Battery Cover Case For IPhone 3G Free Shipping Wholesale $33.68 Offer all kinds of spare parts Paypal payment No MOQ Large QTY in stock,fast delivery Bulk order for more discount rate

S.C Free Shipping Wholesale + 100% soft genuine sheep leather Wallt for iPhone 3g 3gs 4g case cover bag + credit Card holder $14.62 1.Wallet for Iphone , Card Case,Leathe Card Case 2.100% sheep skin leather 3.Factory Directly 4.Small Qty accepted

Free shipping wholesale TV best hot selling 4 led stick & click Taillights/Emergency/Touch Lamps/Nightlight as seen on tv $12.2 Name: Emergency lights trunk Color: Silver Material: Plastic Weight:0.04kg LED qty:4pcs.

QTY 1 EC-LLKAA-YF-B, QTY 4 MR-L4MQN-01 $3259.99 QTY 1 EC-LLKAA-YF-B, QTY 4 MR-L4MQN-01

5 stages water purifier filters OEM wholesale $25 factory wholesale

25 Inch Boston Fern Bush x48 Qty of 6 $123.83 Allstate Floral amp; Craft is a leading importer of artificial silk flowers handwrapped flowers flowering bushes foliage and plants.Also featured in our vast inventory are floral containers fruits amp; vegetables cactus and ribbon.We offer seasonal items with a major emphasis on Christmas trees wreaths garlands swags; along with themed trees decorations ornaments berries and accessories.Our inventory consists of over 10 000 items with various programs and price points to fit your wholesale and retail needs.For quality price and services Allstate Floral amp; Craft offers it all. Allstate Floral amp; Craft Inc. is a leading importer of artificial silk flowers handwrapped flowers flowering bushes foliage and plants. Also featured is their high quality of floral containers fruits amp; vegetables cactus and ribbon. We offer seasonal items with a major emphasis on Christmas trees wreaths garlands swags; along with amp;quot;themedamp;quot; trees decorations ornaments berries and accessories.25 Inch Boston Fern Bush

Wholesale 1000pcs Aquarium Check Valve $194.74 Factory Price For Wholesale Purchase

Wholesale 1000pcs Aquarium Checka Valve $221.05 Factory Price For Wholesale Purchase

Wholesale Alkaline Water machine $110 $110 factory produce , wholesale $110

solar panels 80wp wholesale $115.46 solar panels poly high quality wholesale by aliexpress

Wholesale District, Omaha, Nebraska $24.99 Wholesale District, Omaha, Nebraska - Premium Poster

Career Opportunities in the Retail and Wholesale Industry $59.4 Career Opportunities in the Retail and Wholesale Industry

Wholesale! Free shipping NEW 5th (8GB real memory) MP3/MP4 player $27.37 Factory wholesale

Wholesale household Alkaline Water ionizer $110 $110 factory produce , wholesale $110

USA alkaline water ionizer,110V, wholesale OEM $199 factory produce , wholesale $110