Dynamics,Integration,Great,Pla computer Dynamics GP Integration: Great Plains Technology Partner Not


Gone are those times when the companies and the organisations didn't need a hi-tech system to handle them. Owing to the considerable increase in the business sector and thus, an enormous increase in the complexity of the organisational struc ----------------------------------------------------------Permission is granted for the below article to forward,reprint, distribute, use for ezine, newsletter, website,offer as free bonus or part of a product for sale as longas no changes a


In this article we will not be covering Dynamics GP ISVthird party add-ons.  It might look a bittechnical to IT director, and at the same time you, as programmer may expectmore technical details, as we are trying to keep balance: 1.      Integration Manager.  This tool is very friendly to GP User, and ifthis is your role, plus you are familiar with GP master documents andtransactions types, you should try to build simple integration, use existingsample integrations as a reference and study materials.  If you are on GP version 10.0, IM has twotypes of Connectors: traditional OLE based (require login to the GP workstationas OLE Server and launching IM from there - integration works with the currentcompany) and eConnect (they are built upon eConnect technology stack, should bea way faster, do not require GP workstation, however you will need specialprocedure to install eConnect connectors, especially Admin domain account oryour GP local server Admin account; if by whatever reason you change eConnectAccount Password, please change it in also in Administrative Tools ->Component Services -> COM+ Applications - > Properties - > Identity -this is one of the most asked questions). If you think about IM as very simple and pretty restricted tool, wewould like to give you advanced scenario. Consider the situation, when you have legacy Sales Order ManagementSystem in Oracle, and you need to move Sales Orders and New Customers to GP SOPmodule.  In this case, consider to createMS SQL Server Linked Server to Oracle, and SQL Heterogeneous View, which willpull data from Oracle and will check the Invoice existence in SOP10100 (WorkSOP Docs) or SOP30200 (Historical SOP Docs). This view should allow you to create ongoing integration of CustomerOrders to GP. You can schedule integration with Windows Scheduling customapplications, available for moderate fee on Software market, or simply have GPIM user to launch integration every day or every few hours.  Please, check with your Dynamics GP VAR on IMmodule license 2.      eConnect. This tool is open for Microsoft Visual Studio C#, VB or other .Netprogramming language software developer. Initially it was dedicated to ecommerce programmers to open Great Plainsas back office accounting.  We recommendyou to look at eConnect if your current GP version is 10.0 or 9.0.  If you are on earlier version: 8.0, 7.5, 7.0,6.0, 5.5, 5.0, 4.0, 3.2, Great Plains Accounting for DOS, Windows or Mac,please consider upgrade to version 10.0 or if you are on Great Plains Dynamics,consider deploying either Integration Manager, Import Utility, Dexterity ordirect SQL Insert.  eConnect is simple ininclusion into MS Visual Studio project as Library, and then you should be ableto program by examples, provided in eConnect SDK.  In fact in Integration Manager 10.0 most ofthe objects are available in eConnect connector version, so you can try IM,however eConnect allows you to have more control over integration, andespecially important feature is real time integration option, where you couldcall eConnect methods upon ecommerce invoice and payment placement event 3.      Dexterity. It is native Great Plains development environment, and it has access toall the GP Objects, including master records, work, open and historicaltransactions, plus custom Dexterity add-ons created tables, fields, forms andwindows.  You should not immediatelyconsider to drop IM and eConnect as no longer feasible integration options, asDex has some drawbacks - it is not open source programming language, itrequires relatively long programming learning curve.  You may consider to get Dynamics GP Dexteritytraining for your IT programmers, if you are facing huge Great Plainsimplementation with numerous customizations and existing logic modifications,especially when you work for large organization with challenging ecommerce,logistics, warehouse management.  For therest of us, we recommend outsourcing Dexterity integration programming toDynamics GP ISV with Dex software development factories.  One of the good examples of Dex customadd-ons is Alba Spectrum Posting Server or Autopost, allowing you to breakthrough eConnect limitations on inability to post Batches and individualtransactions 4.      Import Utility. This tool is in our opinion rather archaic and useful if you are onCtree or Pervasive SQL 2000.  SinceDynamics GP 8.0 the only supported DB Platform is Microsoft SQL Server: MS SQL2000 for 8.0, 9.0 and 10.0, MS SQL 2005 for 9.0, 10.0, MS SQL 2008 for10.0.  We recommend you direct SQL insertfor SQL Server based installations.  IUdoesn't validate GP business logic and such is similar in its potential harm tobusiness logic inconsistency as direct SQL insert statement 5.      Direct SQL Scripting.  Please, try not to be too enthusiastic aboutfeeding data into Great Plains via SQL Query Analyzer.  Consider the fact that eConnect is written inSQL Server encrypted stored procedures and likely the intended SQL feeding isalready covered in one of its Procedures. Consider to invest some time in eConnect training, as if you dointegration in eConnect libraries, versus custom SQL scripting - business logicvalidation should not be an issue, as eConnect is replicating Dexterity businesslogic.  If these advises are notapplicable to you, please go ahead with SQL scripting.  Dynamics GP Tables structure could be foundin GP SDK (install from CD#2), plus here: Dynamics GP -> Setup-> ResourceDescription -> Tables.  We stronglyrecommend to be very conservative and try your integration first in the testcompany or in Fabrikam Lesson Company - here try to enter similar transactionsin GP user interface and then review how records were recorded in the tablesand finally then begin your coding 6.      Dynamics GP Integration in Internationalenvironment.  Please note that GP isgenerally localized and supported in English speaking countries: USA, Canada (includingFrench Quebec version), UK, Australia, South Africa, Oceania, New Zealand,India, Pakistan or English Business Specking South East Asia, plus it istranslated and partially localized for Spanish specking Latin America.  GP has potential to be translated tonon-Unicode compliant languages: Russian, Lithuanian, German, Polish, Czech,Serbian, Turkish, etc.  However werecommend you to consider ERP tax code compliance question.  In some international situations SAP BusinessOne with GL or transactions integrations to Dynamics GP might be better option,especially if SB1 is localized for your country 7.      Alternatives to Dynamics GP Great Plains.  If you feel that GP is too expensive,consider Microsoft Small Business Accounting or if this is too simple, considerSAP Business One.  If you believe that GPis too poor in its functionality, consider switching to next level in MicrosoftDynamics ERP products hierarchy - AX, formerly known as Axapta 8.      If you need additional help, please call us:1-866-528-0577, internationally 1-630-961-5918, [email protected] or skype:albaspectrum.  We would be happy to giveyou your industry case from Great Plains customization and integrationperspective, as well as to give you second opinion, if you are not happy withyour current Dynamics GP Partner support level

Dynamics,Integration,Great,Pla

computer

Equipment Rental Software – Features And Cost

Equipment rental management software is an essential thing these days for any equipment rental company.A well-developed equipment rental software provides you with a variety of features that can really help you maintain and organise your cus ...

computer

5 Big Reasons Why I Migrated From Angularjs To React

I have 5 main reasons for my angularjs to react migration. No, it's not a comparison on which is better. A comparison between apples and oranges would make no point. React is a library, and angular is a framework. Both can do stuff in their ...

computer

How to troubleshoot McAfee error 2318?

Security software means McAfee! For many computer users, McAfee antivirus is the only choice for security software as it provides all the features and tools which are necessary for device and data protection. This robust antivirus merely sho ...

computer

Manage Multiple Counter With AlignBooks Point of Sale

Fulfilling your businesss needs which can grow your firm is our aim. AlignBooks is better known for providing a strong pillar to newly started or midway businesss. Those companies who dont want to fall back with irregularity manage the inven ...

computer

How to Autoplay Embedded YouTube Videos

Source: How to Autoplay Embedded YouTube VideosEmbedding a video or audio enables the users to share their videos with any of their preferred sites or any social networking platforms. They can do so by copying the embedded link of the parti ...

computer

3 Major Mistakes to Avoid in Retail Business

Truth be told, nearly half of the retail businesses survive longer than four years and which can be something to ponder for a newbie before stepping into the industry. However, this being said, it is also true that you can excel in the indus ...

computer

Start Your Own Computer Repair Business

1. Know your street value. In the early 90's, running a PC repair business centered around selling parts and products, with service on the side. Today, it's about selling hours. If you run a business, you need to consider the X3 rule. That m ...

computer

How Establishments Show Up in Restaurant Searches

The revolutionary rise of technology has made things easy-peasy for consumers in the restaurant industry. Unlike the old days, the availability of innumerable platforms has made it possible for diners to choose from various searching options ...

computer

GuildWars 2 :

The last expansion pack for Guild Wars 2 was Path of Fire, which was released in 2017 and brings you a new enemy-Balthazar, the evil god of war. Although this doesn't sound like another expansion pack currently in production, some fans ma ...

computer

Customer Support at the time of COVID-19 Pandemic

COVID-19 is the worst crisis of our time as we observe social distancing protocols being imposed all around the world. While these measures are a step in effectively managing the COVID-19 pandemic, Hospitality and Retail businesses are confr ...

computer

How to Choose a Contract Management Solution (CLM)?

Contract life cycle management (CLM) systems can simplify and automate contract creation, negotiation, execution and storage. They are an intelligent alternative to the tedious hand tools formerly used for these tasks, which lacked visibili ...

computer

Contacting Google Live Person to Resolve Your Issues

Users are fond of all the Google supported products and look forward to the best services. Also, Google as a whole has never disappointed its users and helped them at every point with its commendable services. Also, being a customer-oriente ...

computer

how to uninstall discord

How to Uninstall Discord in Windows 10? has supported open source technologies, our tool is secure and safe to use. To uninstall a discord from your windows, you'll use this method which is given below.USING THIRD PARTY TOOLS1. Firstly, you ...