Dynamics GP Integration Technology Highlights
Modern Corporate ERP application is not something isolated. The majority of new implementations require connection with the legacy parts of your IT infrastructure. Even when you plan to discontinue legacy applications, you do it in the evolutionary manner, step-by-step. ERP integration is recommended methodology. Today we would like to review Great Plains integration tools and scenarios. This paper is not intended to be very technical and it might be recommended to company management team for setting up the goals for the integration project homework. Let’s begin with integration tools review:
1. Integration Manager. This instrument validates business logic and is data compromise proof. Having long years working with IM, we would like to reassure that everything, that you can do in other integration tools you can do directly in Integration Manager (one exception is Dexterity). Integration Manager is end user friendly and at the same time it is open for advanced SQL Queries, VBA event driven custom scripts, incoming parameters translation. Latest versions 10.0 and 2010 have eConnect connectors, making IM performance in fact the same as direct eConnect programming. There are some areas, where IM doesn’t have integration options, Invoicing module for example, but eConnect doesn’t work with Invoicing as well. If you have to do Invoicing direct integration, consider Dexterity programming. However before you go this direction, please know that Sales Order Processing module has the same functionality plus additional features, where both IM and eConnect are in your disposition
2. eConnect. Its libraries could be included into your Microsoft Visual Studio .Net web project, where can find code samples in C#, VB and C++. Initially it was introduced around 2003 for ecommerce programmers as the tool to enable ecommerce shopping cart integration as SOP Invoice or Sales Order with potential customer deposit/credit card payment. Modern day eConnect covers most of the modules: General Ledger, SOP, POP, Receivable Management, Payable Management, US Payroll, Inventory Control, Project Accounting as the top of the list. If you need to program integration from non-Microsoft operating system or environment, such as Linux/PHP/MySQL, Oracle, Mac, please read the next paragraph about web services
3. Web Services. This is abstraction level, which allows you to call eConnect methods via HTTP post or SOAP. Such technologies as SOAP allow you to call eConnect and manipulate GP master records and documents from Linux, Unix, Oracle, Macintosh platforms, or virtually from everything that supports web service call technology
4. Dexterity. This is the architecture of initial Great Plains Dynamics and it is still the foundation of modern Dynamics GP. There are no limits for Dex programmer on what could be modified, altered or added to this application business logic. However, Dexterity is semi proprietary and its Sanscript programming is not recommended for somebody, who is not working for consulting firm, as the learning curve might be a show stopper. We would like to come through on of the Dexterity integration extension example – Posting Server. Alba Spectrum Posting Server allows you to schedule the batch for automatic posting directly from your MS Visual Studio project or from another software development environment. Posting Server is programmed in Dexterity with extensive reference to the Source Code
5. Direct SQL Insert Statements. GP doesn’t prohibit direct SQL insertion, however this is not something you should try right away, as being excited about SQL programming and making initial steps in your new ERP table structure and data flow discovery
6. Table Import tool. This is rather similar to SQL direct insertion, this method was great for non MS SQL Server DB platforms for earlier Dynamics versions, especially 7.5, 7.0, 6.0, 5.5, 5.0 on Pervasive SQL 2000 and Ctree. We would only recommend it for historical versions, where direct Microsoft SQL Server Query Analyzer is not available
7. Case Studies: eCommerce. Here in our experience we have to confess, that Integration Manager does perfect job in quasi real time shopping cart integration scenarios. Theoretically it is possible to pull paid shopping carts directly from MySQL, Oracle, Microsoft Access or other ODBC compliant database, but in reality the majority of our ecommerce customers preferred to do every few minutes shopping cart export into coma or tab delimited text file and then pull it into SOP transaction via scheduled IM integration (every several minutes as well)
8. Case Studies: Manufacturing. Imagine you are mid-size production company with existing in-house developed simple MRP system. It might be Microsoft Access, FoxPro, Visual Basics, MySQL/PHP. Now – you would like to post Bill of Materials all the way through GL in GP automatically. We recommend Alba Spectrum Posting Server with Workflow, where initial integration could be done in Dexterity Sanscript programming and the rest is our traditional Posting Server features
9. Case Studies: Healthcare Nurse Placement industry. The challenge was to send billable time and expense reports into GP, where we recommended posting into Project Accounting Timesheets, Expenses. The set of SQL Stored procedures was created to move timesheets and expenses into PA document batches
10. Case Studies: International Business or Multinational Corporation. Headquarters in Chicago had GP as its Corporate ERP system, while in Brazil it is not localized and we recommended SAP Business One with the daily GL transactions consolidations via Export to Excel in SB1 and import via IM to Great Plains
11. Case Studies: Collection Agency. Here your customers are reversed into your vendors. In our experience we did in in the Integration Manager via VBA scripting and Names Translation (vendor to customer translation could be done in Excel and then loaded into IM integration)
12. Case Studies: Advertising Agency. Here you have the problem of overselling advertising space to your new customers, who could easily go bankrupt and block your collection efforts. At the same time, you would like to keep these customers and prospects to enter the advertising space. There is Collection Management module, recommended for your environment
13. Some advices on the international projects. Please, check if GP is localized for your targeted country. In general – it is localized for English, Spanish (except continental Spain, sometimes Brazil is mistreated – they speak there Brazilian Portuguese, not Spanish), Arabic speaking countries. If you are in Russian, Serbian, German, French (except Quebec province in Canada), Italian, Chinese, Japanese, Korean speaking country, consider alternative Corporate or Small Business ERP package. We recommend you to take a look at Dynamics AX Axapta or SAP Business One. In Brazil, consider also Microsiga, while in Russian Federation we recommend you to take a look at 1S Bukhgalteria
About the Author
Andrew Karasev is Great Plains Certified Master, MVP, help@efaru.com 1-866-304-3265, 1-269-605-4904. He is also the initiator of eFaru project http://www.efaru.com and founder of Alba Spectrum information space
Semi and Fully Integrated Dishwashers from E&S Trading
|
|
1 1/8 Ritchey Pro Logic Zero PF Road Bike Semi Integrated Road Bike Headset $49.99 |
|
|
BOSCH SHE3AR55UC SEMI INTEGRATED DISHWASHER $0.99 |
|
|
Fisher Paykel DD365TI1 36″ Semi-Integrated Single Drawer Dishwasher $748.00 |
|
|
FSA Dia-Compe Zero-Stack 1-1/8 Semi-Integrated Headset Zero Stack $10.00 |
|
|
Fisher Paykel DD24STI7 Semi Integrated Single Dish Drawer $699.00 |
|
|
HS002 New Alloy Carbon Road MTB / TT Bike Semi Integrated Headset 1 1/8″ 140g $23.99 |
|
|
HS003 Brand New Alloy Road / MTB / TT Bike Semi Integrated Headset 1 1/8″ 110g $15.99 |
|
|
HS004 Brand New Alloy Road / MTB / TT Bike Semi Integrated Headset 1 1/8″ 110g $15.99 |
|
|
25000 GAMES+WORDPRESS SEMI-AUTOMATIC ARCADE GAMING BLOG + INTEGRATED ADSENSE $31.00 |
|
|
Prana Sz M- Duck Cloth Cotton Utility Pant- Semi Integrated Belt- Gusset Crotch $20.00 |
|
|
Ritchey 1 1/8 Inch Semi Integrated Road or Mountain Bike Headset New!! $49.99 |
|
|
Ritchey Pro Logic Zero PF Semi Integrated Road Bike Headset New!! $49.99 |
|
|
Vision TRIMAX SI 31.8/41/RB SEMI-INTEGRATED BAR $278.71 |
|
|
90g Super Light Threadless Semi Integrated MTB Bike Headset Internal $25.99 |
|
|
New Matrix INTERNAL headset (semi-integrated),1-1/8″ US $45.00 |
|
|
Black Ops Semi Integrated F/S Cycling Headsets NEW $14.38 |
|
|
Electrolux EIDW6305GS Semi-Integrated Dishwasher FREE SHIPPING! $1,099.00 |
|
|
BBB Semi-Integrated Bicycle Headset Road 41.4mm, 1 1/8, Black $74.23 |
|
|
Semi Integrated Threadless Headset 44mm 1 1/8 Internal – Red $20.50 |
|
|
Semi Integrated Threadless Headset 1 1/8″ Internal 44mm $16.56 |
|
|
Carbon Semi-Integrated Headset 1-1/8″ $9.99 |
|
|
Brand new OEM 1-1/8″ Semi-Integrated Headset $4.99 |
|
|
1-1/8″ Semi-Integrated Headset For MTB bicycle $4.99 |
|
|
1-1/8″ Semi-Integrated Headset For MTB & ATB, Trekking $4.99 |
|
|
1-1/8″ Carbon Semi-Integrated Headset MTB Bike 44mm $9.99 |
|
|
Hope Integral Semi Integrated Headset Black 1 1/8” Bike Head set zero stack $112.99 |
|
|
NECO Sealed Bearing Threadless Headset Semi Integrated PURPLE $29.26 |
|
|
FSA Orbit 1.5 ZS 1/8 – 1.5″ Zero Stack Internal Semi Integrated Tapered Headset $69.95 |
|
|
MORTOP HI-65 Semi Integrated Headset Gold 1 1/8″ INCH ROAD MTB BIKE $43.99 |
|
|
DCS DD24DUT7 Semi-Integrated Double Dishwasher $999.00 |
|
|
Token TK011AB Bike Internal Semi-Integrated Headset Alloy 1 1/8″ 18 mm Road MTB $31.99 |
|
|
New Acros Block Lock ZS Semi-Integrated Headset Black 1 1/8″ $74.95 |
|
|
Electrolux 24″ Semi Integrated Dishwasher – Black – *E1DW6305GB $499.50 |
|
|
FSA Orbit Z Bike Internal Semi-Integrated Headset Alloy 1″ 11.4 mm Road MTB New $33.99 |
|
|
Crisp Ultima Semi Integrated Scooter Deck and Flex Brake BLACK $102.60 |
|
|
Ritchey WCS Semi Integrated HEADSET Sealed Bearings Road Mountain Bike R300 $34.48 |
|
|
Ritchey WCS Semi Integrated HEADSET Sealed Bearings Road Mountain Bike R300 $37.62 |
|
|
DS75452N / DS75452 / 75452 / National Semi Integrated Circuit 10 pc LOT $7.50 |
|
|
Blue Label ZS44 1 1/8” RED Headset Semi Integrated Anodised Intergra $28.21 |
|
|
Blue Label ZS44 1 1/8” BLACK Headset Semi Integrated Anodised Intergra $26.99 |
|
|
Blue Label ZS44 1 1/8” BLUE Headset Semi Integrated Anodised Intergrated $26.99 |
|
|
Blue Label ZS44 1 1/8” GOLD Headset Semi Integrated Anodised Intergra $26.99 |
|
|
Blue Label ZS44 1 1/8” RED Headset Semi Integrated Anodised Intergra $26.99 |
|
|
FSA ORBIT Z 1 1/8 Integrated & Semi In Threadless Sealed Bearing Headset 36 x 45 $83.00 |
|
|
INTEGRATED CIRCUITS,NATION SEMI-CONDUCTOR, P/N DP8307N A+ 20 PIN DIP, 2PCS $3.99 |
|
|
Electrolux IQ-Touch Series EIDW6305GW Semi-Integrated Dishwasher IN WHITE $749.00 |
|
|
AEST Anodised Bike 1 1/8″ Semi Integrated Threadless Headset Sealed Bearings MTB $29.80 |
|
|
AEST Anodised Bike 1 1/8″ Semi Integrated Threadless Headset Sealed Bearings MTB $29.80 |
|
|
AEST Anodised Bike 1 1/8″ Semi Integrated Threadless Headset Sealed Bearings MTB $29.80 |
|
|
AEST Anodised Bike 1 1/8″ Semi Integrated Threadless Headset Sealed Bearings MTB $29.80 |
|
|
AEST Anodised Bike 1 1/8″ Semi Integrated Threadless Headset Sealed Bearings MTB $29.80 |
|
|
New Force Alu semi-integrated Headset 1-1/8″ – 1-1/2 Tapered Black 15104 $22.99 |
|
|
Crisp Ultima Semi Integrated Scooter Deck and Flex Brake BLACK CHROME $102.60 |
|
|
Integrated Urban Water Management: Arid and Semi-Arid R $137.57 |
|
|
BOSCH EVOLUTION 800 SERIES Semi-Integrated DISHWASHER SHE68P06UC Black $799.00 |
|
|
New Lite-Pro 44mm Semi-integrated Headset for Dahon folding bike $45.99 |
|
|
NEW LG INTL LDS4821BB DISHWASHER W/SEMI-INTEGRATED ELECTRONIC PANEL & DIGITAL $656.27 |
|
|
NEW LG INTL LDS4821WW DISHWASHER W/SEMI-INTEGRATED ELECTRONIC PANEL & DIGITAL $614.20 |
|
|
Samsung DMT800RHS Semi-Integrated Dishwasher FREE SHIPPING $899.00 |
|
|
Samsung DMT800RHB Semi-Integrated Dishwasher FREE SHIPPING $849.00 |
|
|
Samsung DMT800RHW Semi-Integrated Dishwasher FREE SHIPPING $849.00 |
|
|
BOSCH SEMI-INTEGRATED DISHWASHER SHE65P06UC $699.00 |
|
|
BOSCH SHE68P02UC SEMI-INTEGRATED DISHWASHER, White $799.00 |
|
|
Electrolux EIDW6305GW Semi-Integrated Dishwasher FREE SHIPPING $999.00 |
|
|
Electrolux Series EIDW6305GB Semi-Integrated Dishwasher FREE SHIPPING $999.00 |
|
|
MOWA CHS Semi-Integrated Headset,1-1/8″,NIB,Orange $32.95 |
|
|
MOWA CHS Semi-Integrated Headset,1-1/8″,NIB,Green $32.95 |
|
|
MOWA CHS Semi-Integrated Headset,1-1/8″,NIB,Blue $32.95 |
|
|
KCNC Radiant R2 Semi-Integrated Headset,75g,1-1/8,SIL $99.95 |
|
|
*NEW Cane Creek ZS Semi Integrated Headset W/Star Nut $39.99 |
|
|
NEW SARS Semi integrated 1 1/8″ Sealed Headset Purple $39.19 |
|
|
KCNC Kudos-Q1 Semi-integrated 1-1/8″ Headset / Black $44.95 |
|
|
EIDW6305GW Electrolux Semi Integrated White Dishwasher $850.00 |
|
|
*NEW Cane Creek ZS Semi Integrated Headset W/Star Nut $39.99 |
|
|
*NEW Cane Creek ZS Semi Integrated Headset W/Star Nut $39.99 |
|
|
CANE CREEK 1 1/8 Threadless Semi-Integrated Headsets $14.99 |
|
|
Integrated Urban Water Management: Arid and Semi-Arid Regions: UNE.. – Paperback $497.12 |
|
|
New Bicycle Bike Steel 1-1/8″ Semi-Integrated TD Headset Black $14.99 |
|
|
Breville Barista Express BES860XL machine with grinder $580.00 The Barista Express%2C with its integrated conical burr grinder and dosing control%2C helps deliver the optimum path for beans to espresso in under a minute%2C ensuring a smooth and thick cr%E9ma%2E The measured dose is delivered straight into the coffee filter to maximize luscious cr%E9ma with every extraction%2E… |
|
|
Breville Refurbished Barista Express Scratch/Dent Prog Espresso with Grinder $599.99 With its integrated conical burr grinder and dosing control, The Refurbished Barista Express delivers the optimum path from espresso bean to thick crema in less than two minutes. Non-pressurized café style single-wall filters allow for experimentation of grind size, grind amount and tamping pressure to explore the art of espresso. Pressurized dual-wall filters help beginners by delivering smooth … |
|
|
Espressione Cafe Roma Deluxe Espresso Machine with Built-in Grinder, Anthracite Grey $330.00 The beautiful and powerful Cafe Aroma Deluxe espresso/cappuccino and grinder machine is ready to serve your every coffee need. Whether for one shot or a group festivity this is the all-in-one coffee power-house. Professional performance in an espresso coffee machine with elegant refined design. Complete with a fully incorporated professional grinder, anti-drip valve, thermometer to check boiler te… |
|
|
Maytag : MDD8000AWS 24 Semi-Integrated Double Dishwasher Drawer – Stainless Steel $1,449.00 Spend less time doing dishes with this dishwasher that features an internal food chopper that grinds and washes away food particles and a NSF-certified sanitize option that eliminates most bacteria for clean… |
|
|
Fisher Paykel DD24DCX7 Semi-Integrated Double DishDrawer 14 Place Settings, Stainless Steel $1,158.00 We imagined the ideal dishwasherand the concept of the DishDrawer was born Years of research and refinement have created an appliance that offers a compelling blend of form and function Each drawer is independently operated allowing you to wash… |
|
|
Fisher Paykel DD24SCX7 Semi-Integrated Single DishDrawer 7 Place Settings, 9 Cycles Stainless Steel $649.00 We imagined the ideal dishwasherand the concept of the DishDrawer was born Years of research and refinement have created an appliance that offers a compelling blend of form and function Each drawer is independently operated allowing you to wash… |
|
|
Fromm Shear Jay2 4.1 * 6.5 #j41650 $99.99 * CRANE DESIGN Ergonomic design with a short thumb handle angled downward – takes strain off the thumb, arm and shoulder. * ROTATING THUMB RING INSERT Prevents friction and bruising. Removable. * SEMI-INTEGRATED CUTTING EDGES Hollow – ground, honed blades – perfect for slice cutting. * SPECIAL STEEL High – quality & high – gloss polished finish. * UNIQUE HARDENING For durable sharpness. * PATENTED… |
|
|
Fromm Shear Jay2 4.2 Thinner (34-tooth Thinner) * 6 Long #j42600 $99.00 Jay2 4.2 THINNER (34-tooth) * 6.0″ Long * CRANE DESIGN Ergonomic design with a short thumb handle angled downward – takes strain off the thumb, arm and shoulder. * ROTATING THUMB RING INSERT Prevents friction and bruising. Removable. * SEMI-INTEGRATED CUTTING EDGES Hollow – ground, honed blades – perfect for slice cutting. * SPECIAL STEEL High – quality & high – gloss polished finish. * UNIQUE HA… |
|
|
Jay2 1.1 5.75 hair shears J11575 OFFSET DESIGN: Ergonomic design with a short thumb handle angled downward – takes strain off the thumb, arm and shoulder. SEMI-INTEGRATED CUTTING EDGES: Hollow-ground, honed blades – perfect for slice cutting. SPECIAL STEEL: High quality & high gloss polished finish. UNIQUE HARDENING: For durable sharpness. PATENTED SCREW: For fine adjustment of the smooth cutting action. To suit you. DE… |
|
|
Panasonic Toughbook CF-74 Semi-Rugged Notebook PC – Intel Core 2 Duo 2.0GHz, 2GB DDR2, 80GB HDD, Combo, 13.3 Display The powerful Panasonic Toughbook CF-74 Notebook PC is designed for professionals on-the-go, offering optional integrated mobile broadband and industry-leading durability. The Panasonic Toughbook CF-74 Notebook PC features an Intel Core 2 Duo 2.0GHz processor, Wi-Fi, Bluetooth, Combo multi drive and a large 13.3” daylight-readable LCD. Rugged features, such as a shock-mounted flex-connect hard… |
Tags: affmage, amazon, article, ebay, integrated, lang, mage, semi, semi integrated, source
