Free Inv
Dynamics GP Ecommerce Programming and Integration Notes
Microsoft Dynamics GP is open to ecommerce programmer via eConnect SDK, as well as Microsoft SQL Server programmability tools (typically Stored Procedures and Views). Before you dive into technical project of eConnect programming, please, review Great Plains Integration Manager module and its customization options: VBA scripting of Before Document Commit (as very common modification point) event; you can schedule IM integration with Windows Macro or deploy free and ready for purchase applications, extending basic Windows Macro with additional functionalities. Dynamics GP Integration Manager based (for version 10.0 and future versions 11.0 and up) on eConnect technology (in addition to supporting old OLE Server integrations), meaning that IM integration should be able to achieve the same goal with less efforts. And as you should expect the same limitations for eConnect as you have for Integration Manager – most often manifesting limitation is eConnect and Integration Manager Batch Posting inability. Now straight to the Great Plains eCommerce Developing topic:
1. eConnect is Software Development Kit, written in SQL Stored Procedures (encrypted), it allows you to program GP master records (Customer, Vendor, Employee, GL Account, Inventory Item, Address, Project, Budget, etc.) and so-called Work Transactions: SOP Quote, Order and Invoice, POP Purchase Order, GL Transaction, Employee Paycheck, Inventory Adjustment and Transfer, to give the idea. eConnect is friendly and requires very short learning curve for Microsoft Visual Studio .Net C#, VB and other .Net compliant languages programmers. Additional pluses if you have XML, SQL Scripting skills
2. Sales Order Processing and Inventory Control modules and tables. These two are the most popular in ecommerce integrations. SOP tables have SOP prefix (famous SOP10100 transaction header and SOP10200 lines), and Inventory INV (INV00101 – item master and INV00102 Quantity master) respectively. Sometimes, especially in old Great Plains ecommerce legacy integrations you find Invoicing module (IV prefix)
3. Posting problem. In ecommerce application you often want to do all the way transaction processing: Sales Invoice creation and modification, applying credit card payment deposit, allocating merchandise, approving and posting Sales Order Processing batch (or individual transaction). Here, you will hit the wall and realize that Posting functionality is not included in eConnect or Great Plains Integration Manager. There is no shortcut here (we assume that you are Not Dynamics GP Dexterity software developer with tons of programming experience, including Dexterity Source Code Programming), you will need to purchase Dynamics GP Add-On, we recommend Dynamics GP Posting Server, also known as Autopost
4. Dynamics GP eCommerce SQL Scripting. If you have the opinion that your ecommerce integration routine is very simple and eConnect is too cumbersome and heavy in being considered for deployment, you can always rescue to SQL direct insertion statement. Please review GP table structure: Dynamics GP -> Settings -> Resource Description -> Tables. Or, simply install GP Software Development Kit from CD #2. Dynamics GP Business Logic might be too complex for intuitive programming, so if you will get the buggy situation, consider creating test transaction in GP user interface and review the records in GP tables. If you prefer proven set of stored procedures – we offer them as Order Connector, feeding data into SOP tables
5. Feel free to call us on Microsoft Dynamics GP eCommerce integrations concerns: 1-866-528-0577, help@albaspectrum.com
About the Author
Andrew Karasev, Alba Spectrum, 1-866-528-0577, help@albaspectrum.com http://www.albaspectrum.com Please visit our info portal http://www.pegasplanet.com Serving Chicagoland and Northern Illinois customers in Chicago downtown, Naperville, Lisle, Schaumburg, Aurora, Joliet, Romeoville, Downers Grove, Plainfield, Evanston, Glenn Ellyn, Wheaton, Batavia, St. Charles, Elgin, Crystal Lake, Morris, Channahon, Kankakee, Lombard, Hinsdale, Des Plaines, Gary, Oak Park, Alsip, Lyons, plus San Diego, Houston and USA and Canada Nationwide via remote support
M200RepTar’s 10TH LOBBY FREE INV!!!!!!
|
|
BT MERIDIAN M3310 Black Telephone Free Delivery Inc VAT Inv 90 Days RTB Warranty $31.35 |
|
|
BACKLIGHT INVERTER LJ97-01922A SSI400_16T01 REV 0.0 INV40N16B 40RV525U FREE SHIP $30.50 |
|
|
Christmas Moss – Live Aquarium Plant (FREE Ship!) INV $5.65 |
|
|
BACKLIGHT INVERTER LJ97-01922A SSI400_16T01 REV 0.0 INV40N16B 40RV525U FREE SHIP $33.99 |
|
|
Nano CO2 Diffuser – Aquarium Plants (FREE Ship!) INV $8.50 |
|
|
Robertshaw 4090-216 Gas Oven Safety Valve 3/8″ Inv. NEW Old Stock Free Shipping $40.00 |
|
|
Windelov Java Fern – Live Plant Tank (FREE Ship) INV $4.70 |
|
|
Heto – Aquarium tank cleaner (FREE Ship!) INV $9.45 |
|
|
Siphon – Water Change and Gravel Clean (FREE Ship!) INV $6.60 |
|
|
CO2 Tablets – Planted Tank CO2 Diffuser (FREE Ship) INV $5.65 |
|
|
FREE SHIP ON MULTIPLES, NIPPON CHEMI-CON 375V 2700uF DC BUS CAPACITOR INV=2202 $5.82 |
|
|
FREE SHIP ON MULTIPLES, NIPPON CHEMI-CON 375V 2700uF DC BUS CAPACITOR INV=2200 $5.82 |
|
|
MOLDAVITE-CHLUM 6.4Ct UNIQUE LEAF GREEN-FREE FORM FOR TOP END JEWELRY-TRUE INV. $12.00 |
|
|
The Free Market Capitalist’s Survival Guide: How to Inv $23.27 |
|
|
Backlight Inverter SSI_400_14A01 INV40N14B LJ97-02098A many TV models FREE SHIP $21.99 |
|
|
Pearl Moss-Fish Tank Live Aquarium Plant(FREE S&H) INV $5.65 |
|
|
Tricho – Live Aquarium Moss Plant Java (FREE Ship) INV $5.65 |
|
|
Cryptocoryne lingua x 3 (FREE Ship) Live Plant INV $4.70 |
|
|
The Free Market Capitalist’s Survival Guide: How to Inv $16.57 |
|
|
NEW BACKLIGHT INVERTER BOARD SST320_4UA01 INV32T4UA NEW FREE SHIPPING $21.99 |
|
|
Rhinox Co2 Diffuser Tubing ( FREE Ship !) INV $4.74 |
|
|
CHEVY BOWTIE EMBLEM SYMBOL BAGDE GOLD CHROME OEM ORIGINAL FREE SHIPPING $19.01 |
|
|
TWO Maxon 49-sa HANDS FREE COMMUNICATORS, fm 2 way radios INV=2388 $23.52 |
|
|
PITCAIRN ISLAND 1980 20c WHEELBARROW INV WMK NH – FREE SHIP $125.00 |
|
|
Anubias Gold – Live Aquarium Plant Fish FREE Ship INV $5.65 |
|
|
FREE PICKUP: LB White Torpedo Heater Mdl 296E Propane based INV=820 $99.00 |
|
|
Flame moss – Live Aquarium Plant Aquatic FREE Ship INV $5.65 |
|
|
Apple Dc, Power Supply/ Sata/ Inv – 593-0964 A FAST FREE SHIP $29.95 |
|
|
Giant Marimo ball x 1 (FREE Ship) Live Moss Plant INV $8.08 |
|
|
EXTRAS SHIP FREE Robert Arthur,The Mystery of the Screaming Clock (The Three Inv $1.75 |
|
|
Fissidens splachnobryoides ( FREE Ship !) INV $5.69 |
|
|
Red Tiger Lotus – Live Aquarium Plant (FREE Ship!) INV $7.50 |
|
|
Moss wall Mesh – Decorate bare tank (FREE Ship!) INV $9.49 |
|
|
Star Moss – Tropical Plant Aquarium (FREE Ship!) INV $4.70 |
|
|
Cryptocoryne bekettii x 3 pcs ( FREE Ship !) INV $5.65 |
|
|
Pellia x 1 bag (FREE Ship) Live Aquarium Plant Fish INV $5.65 |
|
|
Crypt wendtii green x 3 stalks ( FREE Ship !) INV $4.70 |
|
|
Heto – Aquarium Fish Tank Algae Cleaner (FREE Ship) INV $7.55 |
|
|
Crypt pontederiifolia x 3 (FREE Ship) Aquarium Fish INV $5.65 |
|
|
Cryptocoryne wendtii brown x 3 pcs ( FREE Ship !) INV $5.65 |
|
|
Java Fern – Live Aquarium Plant ( FREE Ship !) INV $3.79 |
|
|
Christmas Moss – Aquarium moss wall (FREE Ship!!) INV $4.70 |
|
|
Anubias barteri petite (FREE Ship) Live Plant Fish INV $6.60 |
|
|
Windelov Fern x 1 bunch ( FREE Ship ! ) INV $4.70 |
|
|
Echinodorus amazonicus x 3 (FREE Ship) Live Plant INV $5.65 |
|
|
Anubias Lanceolata x 1 rhizome ( FREE Ship !) INV $4.70 |
|
|
Plagiomnium Trichomanes – Live plant ( FREE Ship !) INV $6.60 |
|
|
Aponogeton madagascariensis x 1 (FREE Ship) INV $9.40 |
|
|
D8125INV Inovonics Interface Module. New in Box Free Shipping $44.95 |
|
|
Nano diffuser – Supply CO2 for Plants ( FREE Ship!) INV $9.40 |
|
|
INFINITI EMBLEM SYBOL BAGDE CHROME OEM ORIGINAL USED FREE SHIP $17.90 |
|
|
TOYOTA SEQUOIA EMBLEM SCRIPT BAGDE CHROME OEM ORIGINAL USED FREE SHIP $17.90 |
|
|
LEXUS EMBLEM SCRIPT SYMBOL BAGDE CHROME OEM ORIGINAL USED FREE SHIP $14.90 |
|
|
KIA EMBLEM SYBOL BAGDE CHROME BLACK OEM ORIGINAL USED FREE SHIP $14.90 |
|
|
INFINITI EMBLEM SYBOL BAGDE CHROME OEM ORIGINAL USED FREE SHIP $17.90 |
|
|
MITSUBISHI EMBLEM LOGO CHROME TRIPLE DIAMOND OEM ORIGINAL USED FREE SHIP $12.90 |
|
|
KIA EMBLEM SYBOL BAGDE CHROME BLACK OEM ORIGINAL USED FREE SHIP $14.90 |
|
|
3.5L HIGH OUTPUT EMBLEM SCRIPT BAGDE CHROME BLACK OEM ORIGINAL USED FREE SHIP $14.90 |
|
|
BMW EMBLEM BAGDE CHROME BLACK BLUE ROUND USED OEM ORIGINAL FREE SHIPPING $13.01 |
|
|
Rhinox CO2 Diffuser Tubing ( FREE Ship !) Aquarium INV $4.74 |
|
|
The Free Market Capitalist’s Survival Guide: How to Inv $16.89 |
|
|
Absolutely Free, Frank Zappa & The Mothers of Inv, Excellent $23.26 |
|
|
HAWK 400 WATT POWER INVERTER INV-400 – NEW IN BOX – FREE SHIPPING $49.00 |
|
|
Wooden workbench, Free pick-up in Berkeley, IL 60163 INV=2602 $9.00 |
|
|
Wooden workbench with Drawers, Free pick-up in Berkeley IL INV=2603 $10.00 |
|
|
HUGE WELDED WORKBENCH WITH WOODEN TOP, free pick-up in Berkeley IL INV=2605 $106.00 |
|
|
1894 Newfoundland 10 Cents VF/XF INV#33-26 FREE SHIP U. $69.00 |
|
|
The Free Market Capitalist’s Survival Guide: How to Inv $23.12 |
|
|
Absolutely Free, Frank Zappa & The Mothers of Inv, Original recording remastered $22.50 |
|
|
Anubias broad leaf (FREE Ship!) Live Aquarium Plant INV $4.70 |
|
|
Weeping Moss (FREE Ship!) Live Aquatic Plant INV $5.65 |
|
|
Anubias eyes x 2 (FREE Ship) Live Aquarium Plant INV $5.69 |
|
|
Round Pellia – Live Aquarium Plant ( FREE Ship !) INV $5.60 |
|
|
Plagiomnium affine – Live Plant Fish (FREE Ship) INV $5.65 |
|
|
Filter Guard – Protect filter & fish (FREE Ship !) INV $5.65 |
|
|
Plant Net – Secure Riccia and Moss ( FREE Ship !) INV $6.64 |
|
|
Rubra – Pond Live Fish Koi Lotus Plant (FREE Ship!) INV $5.65 |
|
|
Co2 Tablet – Aquarium Plant Diffuser ( FREE Ship !) INV $5.60 |
|
|
Mini Marimo x 1 pcs – Limited stock! FREE Ship! INV $7.17 |
|
|
Net Pot – Live Aquarium Plant FishTank (FREE Ship!) INV $4.74 |
|
|
Anubias nana – Live Aquarium Plant ( FREE Ship !) INV $4.70 |
|
|
Balansae x 3 – Live Aquarium Plant Fish( FREE Ship) INV $5.65 |
|
|
Check Valve x 3 – Aquarium Air Pump (FREE Ship!) INV $4.70 |
|
|
JOICO VERO CREME 2.5oz~INV TUBE@ $10.74 THIS SHADE ONLY /FREE SHIP IN US $10.64 |
|
|
Bubble Counter – Aquarium CO2 Diffuser (FREE Ship) INV $5.65 |
|
|
Java Moss x 1 bag (FREE Ship!) INV $9.49 |
|
|
Tropical Pineapple Passion Single Serving Teapot for One By Artist Shari Erickson – 2 Pc Tea Pot and Tea Cup $19.99 This is a brightly colored stacked 2 piece ceramic teapot and teacup “Tea for One”, with a tropical pineapple and floral palm design. American contemporary artist Shari Erickson gained early recognition as a figurative muralist in her home town of Atlant… |
|
|
AIMS Power 2000 Watt, 12 Volt Pure Sine Wave Power Inverter (PWRI200012S) $420.99 New exclusive NEPT (New Equipment Protection Technology) design prevents excessive spikes from damaging your equipment Pure Sine Wave Advantage: Motors run cooler and last longer, Microwaves heat in normal times TV monitors will be crystal clear (as good as using city power), Medical equipment often requires pure sine wave for proper operation, Digital clocks keep time accurately. Informational Ma… |
|
|
Aims 5000 / 10000 Watt dc to ac Power Inverter $599.99 New exclusive NEPT (New Equipment Protection Technology) design prevents excessive spikes from damaging your equipment. Modified Sine Wave Advantage: More portable than pure sine wave inverters Lighter weight Lower cost Informational: Manufactured in ISO certified factory, since 1984 Tested EMC, LVD 100% factory line test and QC approval processes *FEATURES: * 5000 Watt max continuous power * Modi… |
|
|
Aims 400 / 1200 Watt dc to ac Power Inverter $49.99 The AIMS 400 Watt modified sine wave power inverter provides ample power to run all devices continuously which are rated at 400 watts or less. With a peak of 1200 watts, the 400 watt power inverter will fit many applications. All of the inverters from InvertersRus come with all the necessary cables, a 1 year warranty and one full year of FREE tech support. *New exclusive NEPT (New Equipment Protec… |
|
|
The Biggest Loser The Workout $3.99 Join the competition for the title “the biggest loser” and get some fitness assistance from trainer Bob Harper and some of the cast from the first two seasons of the popular reality program. Tailor the regimen to your own needs, choosing from six separate routines, from low to high intensity, including segments for stretching, sculpting, and strength. 100 min. Soundtrack: English; bonus footage…. |
|
|
ChemFree ToiletClean Non-toxic Toilet Bowl Cleaner (2 units) $13.15 Non-toxic and chemical free Chemfree ToiletClean Toilet Cleaner is one of the greenest and most eco-friendly ways to keep your toilet clean for 5 years or 50,000 flushes. (Safe for Septic systems!) Hydro-electric power plants use the physics principles incorporated in this non-toxic Toilet Bowl Cleaner to keep water intakes clean for years. Made in the U.S.A., eco-friendly and non-toxic, Chemfre… |
|
|
Carnation Instant Breakfast Lactose Free VHC 250 mL VANILLA Case: 24 $47.75 Balanced Nutritional Drink combines nutrient density and great taste to address unintentional weight loss and support Med Pass Program success. Each 250 ml serving provides 560 calories and 22.5 grams of protein, making it a nutritional solution for diminished appetites and fluid-restricted diets. The caloric density also makes it highly attractive as a medication pass beverage. It has a light, sm… |
|
|
Lumene Premium Beauty Rejuvenating Day Cream SPF 15 1.7 fl oz (50 ml) $17.00 Premium Beauty with Arctic Sea BuckthornFor Mature Skin with SPF 15A nourishing and strengthening day cream protects your skin against environmental influences. Optimal UVA/UVB – ratio against skin aging and age spots. SPF 15 – medium protection.Arctic Sea Buckthorn + Peptides for Nurtured Skin:Arctic Sea Buckthorn is a rare, handpick berry which grows wild at the arctic sea coast. The beneficial … |
|
|
YummyEarth Organic Lollipops, Hot Chili Pops (15 Count), 3-Ounce Pouches (Pack of 6) $9.95 Yummy Earth Organic Hot Chili Pops tastes much better than mass produced chemical candy because we choose real fruit extracts and planet friendly organic ingredients to sweeten our lives and yours. The Best Taste on Earth. YummyEarth. Good for us. Good for Mother Earth…. |
|
|
Stanley PCI109 100 Watt Inverter with Installation Adaptor $29.99 Simply plug into vehicle and access instant power on the road!… |