Gps Scratch
2009
Ecommerce Shopping Cart Microsoft Dynamics Gp Integration Options
Microsoft Dynamics GP was formerly known as Great Plains Dynamics. GP is very popular Corporate ERP platform for various industries, especially in mid-market ERP niche. This application could be used as integration back office for external applications, such as eCommerce, Sales Automation and various Business Management Systems. Great Plains has several integration tools and this is important to pick the right one for your case. In this small publication we are reviewing ecommerce shopping cart mapping and integration programming to Dynamics GP:
1. Shopping Cart Mapping. Usually in Dynamics GP you import Shopping Cart as Sales Order Processing Invoice or Sales Order. Sales Order gives you more options in designing fulfillment, approval cycle, picking and packing as Sales Order should be finally transformed into the Invoice. If you like to have it as simple as possible and you do not care about Order execution phases, you may send shopping cart directly to SOP Invoice. On both Order and Invoice in Dynamics GP you can have Customer deposit (in the form of Check, Cash or Credit Card payment). eCommerce Shopping Cart items could be either normal Sales Inventory items, Services, Miscellaneous Charges, etc. in GP or even non-inventory items (not registered in Inventory control)
2. eCommerce Catalog. Here you need to decide if you would like to originate all your items and prices from Dynamics GP inventory module, or just push everything from ecommerce (in that case items and prices are have ecommerce origin). It is often the question about self sufficiency of your ecommerce web application – if you are building ecommerce from scratch, you may decide to use as much GP logic and objects as possible. On the other hand – if your ecommerce is pretty complex in its logic and works in production for many years – good approach would be simple shopping cart push to GP SOP transaction
3. Shopping Cart integration options. One of the easiest and the most reliable methods is Integration Manager in GP. IM maybe called by operator, or it could be scheduled to run every half an hour (quasi real time mode) or every night (batch mode). If your ecommerce sits in non Microsoft platform, such as Oracle, PHP/MySQL/Linux, we recommend you to review Advanced ODBC queries in IM< where you can call something like MS SQL Server cross platform Select statements (those could be shaped as SQL Views, if desired). If you absolutely need real time integration, where shopping cart posting in ecommerce should automatically trigger its move to Dynamics GP invoice – consider eConnect programming. eConnect is GP SDK, where you can add eConnect libraries directly to your Microsoft Visual Studio C# or VB.Net ecommerce web application and control GP objects from there (SOP Invoice, Customer, Item and others). We do not recommend direct SQL scripts for integration as you have very high potential to violate GP business logic – use eConnect or IM instead, where you can have the same results (probably with lesser learning curve) and automatic business logic validation (within IM routines or eConnect objects)
4. Automatic GP transaction or batch posting from ecommerce application. Both eConnect and Integration Manager allow you to create master records (customer, address, item) and work transactions (Invoice or Sales Order) and place them in the batch for further review and posting directly in GP by Great Plains user. If you would like to do all the job from ecommerce, including batch posting, you need Alba Spectrum Posting Server
5. How to get further help? Please, call us: 1-866-528-0577, 1-630-961-5918 or email us: help@albaspectrum.com
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
|
|
GP Lithium Coin Batteries 3V Size CR1220 ( Pack of 5 ) $2.99 - Brand new GP CR1220 Lithium Cell Battery- Quantity: 5 Total Batteries- Nominal Voltage: 3 Volts.- GP batteries are formulated to provide an economical and reliable power source for low to medium drain applications such as;watches, cameras, remote controls, and other devices.- These are not off-brand Asian batteries. These are name brand, high quality batteries made by one of the most recognized … |
|
|
5X Super GP Battery Pack Lithium Coin 3V CR2032 $2.00 - Brand new GP CR2032 Lithium Cell Battery- Quantity: 5 .- Nominal voltage: 3 Volts.- GP batteries are formulated to provide an economical and reliable power source for low to medium drain applications such as; watches, toys, remote controls, flashlights, calculators, and other devices.- These are not off-brand Asian batteries. These are name brand, high quality batteries made by one of the most r… |
|
|
2X Super GP Batteries High Voltage Alkaline 6V 476A $3.99 - Brand new GP 4LR44 Super Alkaline Battery- Quantity: 2 Total Batteries- Nominal Voltage of 6 Volts. 105 mAh Nominal Capacity.- GP batteries are formulated to provide an economical and reliable power source for low to medium drain applications such as; Remote controls, flashlights, and other devices.- These are not off-brand Asian batteries. These are name brand, high quality batteries made by on… |
|
|
Durable Semi Hard Protective GPS Carrying Case for Garmin nüvi 260W 4.3-Inch Widescreen Portable GPS Navigator $23.99 This elegant carrying case has been manufactured to fit your GPS Navigator. Made of a high grade durable plastic and a soft padded interior to help protect your device from any unnecessary bumps, dents, and scratches. Upon opening this case you will notice two restraint strap that protect your device from falling-out. You will also notice a fishnet pocket that allows for storage of small accessori… |
|
|
11 Piece Tool Set for Apple Macintosh Computers, iPods, and iPhones $6.99 New from Silverhill Tools is a useful kit that helps with doing many of the routine tasks associated with Mac ownership, including accessing memory slots or opening housings. Compatible with many macs, including but not limited to: MacBook Pro 15.4″ MacBook Pro 17″ MacBook (Aluminium) MacBook (White or Black) PowerBook G4 Aluminium 17″ PowerBook G4 Aluminium 12″ PowerBook G4 Aluminium 15″ … |
|
|
Superior Communications Superior Rubberized Ferrari Red Shell For Motorola RAZR $4.99 Protects phone from bumps and scratches with easy access to side buttons Includes clear 360 detachable ratcheting belt clip… |
|
|
Brown Flashlight GP Discovery CREE LED w/AAA (runs over 100,000 hrs) NEW!! - Brand New GP discovery cree led torch key ring w/AAA (brown) UI=1 LCE202- Super Bright CREE LED Flashlight. Runs over 100,000 Hrs.- Durable Aluminium Casing. Color: Brown.- Non-Slip Rubber Grip.- Weather Proof and Shock Proof.- Battery included.- Metal Key Ring.- Key chain flashlight with super bright CREE LED (LED lifetime up to 100000 hours). Features include twist on/off head, focusing optica… |
|
|
AmazonBasics Hard Carrying Case for 5-Inch GPS (Black) $9.99 AmazonBasics products are quality electronics accessories offered at a great value. Made in China. … |
|
|
iOttie Windshield Dashboard Car Mount Holder for iPhone 4S 4 3GS Samsung Galaxy S2 Epic Touch 4G HTC EVO 4G Rhyme DROID RAZR BIONIC INCREDIBLE 2 CHARGE Google BlackBerry Torch LG Revolution GPS Compact Size 360 degree Rotatable $13.99 iOttie “Easy-Flex” car mount holder is designed with functionality as the main focus. iOttie “Easy-Flex” windshield mount is extremely compact, has a super strong suction cup that will stick to any glass surface. The holder base and the bracket arm rotate 360 degree for virtually any position that is needed. It can be mounted in less than a minute and is also heat resistant. Rather your phone has … |
|
|
4.3 EVA Case for Garmin Nuvi 265wt 1300 1350 1370t GPS $0.01 Hard case protects your device from accidents during daily usage.Zip it up and protects your device from dust and scratches.Feature with durable all around zipper holds your device securely in the case.Includes a lanyard allows you to carry your case on your wrist.Dimensions: 4.7 x 3.4 x 1.0 inches / 119 x 86 x 25 mm.Measure your device and compare it to measurements above to ensure a good fit.Col… |
Comment