Crystal Report link to Pervasive/Ctree - you have to install Pervasive SQL ODBC driver from Great Plains Dynamics CD. Small companies use Small Business Manager (which is based on the same technology - Great Plains Dexterity dictionary DYNAMICS. Sometimes you have to rescue to Great Plains Dexterity- when you need ongoing data import and you do not own Great Plains Integration manager or when Integration Manager doesn't have the object to deploy. This is proprietary Great Plains Software tool and development environment and you need some time invested, before you can do programming. This will allow you to deploy ODBC connection to Great Plains database.
DIC placed on local machine (check you DYNAMICS. If you have in-house Dexterity customization working with SOP Entry screen for example - the technology works this way - it imports existing SOP entry screen from DYNAMICS. Former product name was Great Plains Dynamics / eEnterprise. We'll just mention this fact and do not touch details
Problems. If you have security for the user to use, say SOP Long Invoice form modified (taken from REPORTS.
Great Plains Accounting is in phasing out -Great Plains Software began this process back in 1995, when it did introduce Great Plains Dynamics and then Great Plains Dynamics/CS. Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies - USA nationwide Great Plains, Microsoft CRM customization company, based in Chicago, California, Arizona, Minnesota, Texas, Florida, New York, Washington, Georgia, Canada, UK, Australia and having locations in multiple states and internationally (www. You can use Great Plains VAR/Partner - in this case your cost is usually lower - but you need to do due diligence - find the partner who has experience and has done at least couple of migrations. Net, Crystal Reports and Microsoft CRM SDK developer. Old Btrieve platform - Microsoft Business Solutions is pulling out all it's products from Btrive/Pervasive SQL.
Usually modification is placing new buttons or fields, which in turn will be given VBA scripts (stored in DYNAMICS. Workstation side - workstation is written in Great Plains Dexterity and has Dynamics. You need first to install Great Plains on SQL Server with exactly the same account/segments structure and then install migration tool (it is Dexterity chunk) on your ctree/Pervasive workstation - then, when you integrate the chunk - you will map it to target SQL-based Great Plains Company, select all system and company tables, click the button and it will move all your tables one-by-one. SQL 2000 to MS SQL/MSDE? MBS has migration tool. In the case when your Great Plains ctree/Pervasive has third parties - you need to check if the vendor has migration tool - otherwise you have to do manual move, use SQL Linked server to your legacy data.
Due to the MBS strategy - Great Plains Dynamics was pulled from other markets, such as continental Europe (Germany, France, Russia) - where Navision and Axapta are the promoted and recommended solutions. Here we need to give you highlights on Great Plains Dynamics initial design. Later on eConnect was extended on the majority of Great Plains modules, including distributions. As you see above - Great Plains allows you to address work tables only - this means that you can not post transactions using eConnect. Other reported issues were related to Sales Order transfer to Invoice/Backorder.
Usually modification is placing new buttons or fields, which in turn will be given VBA s (stored in DYNAMICS. Workstation side - workstation is written in Great Plains Dexterity and has Dynamics. Do I need consultant? It is probably good idea to have consultant to do the upgrade. In the case when your Great Plains ctree/Pervasive has third parties - you need to check if the vendor has migration tool - otherwise you have to do manual move, use SQL Linked server to your legacy data. You need first to install Great Plains on SQL Server with exactly the same account/segments structure and then install migration tool (it is Dexterity chunk) on your ctree/Pervasive workstation - then, when you integrate the chunk - you will map it to target SQL-based Great Plains Company, select all system and company tables, click the button and it will move all your tables one-by-one.
Dynamics & Dynamics C/S+, later on renamed into eEnterprise. This product is not supported by MBS and you can hardly find consultant on the market who knows this application. We strongly recommend you to migrate to Great Plains Standard. What we can do for you is - if something happens - looks technical support database and see if your issue and fix are posted there. Then, migration tool is $2k and your MBS VAR can migrate you to Great Plains Professional or Great Plains Standard.
Small Business Manager has similar to Great Plains structure and similar System DYNAMICS database and the company. Microsoft Business Solutions Small Business Manager is scaled down Great Plains Dexterity based version of Microsoft Great Plains or former Great Plains Dynamics/eEnterprise. Yes - we can go ahead and create stored proc in DYNAMICS and companies databases or Small Business Manager. Look at SOP10100, SOP10200 and other tables with SOP prefix. Usually eCommerce solution works around Sales Order Processing tables.
Graphical platforms battle is pretty much over and now with eCommerce demands, we should look at Great Plains Dynamics tables structure. So as you see - logic is present and structured, but it is not friendly to the developer, who never seen and worked with Great Plains Dynamics. Another issue with eConnect - developers are kind of used to the fact that Microsoft provides free SDK to its products, Microsoft CRM for example has freely downloadable Microsoft CRM SDK. For eConnect you have to pay license and be on Microsoft Business Solutions annual support to get version upgrades. Also if you are ISV and develop your GP integration to your customers - you have licensing issue with Microsoft.
Old-days Great Plains Dynamics on Ctree or Pervasive SQL/Btrieve was excellent and inexpensive solution. Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies - USA nationwide Microsoft CRM, Microsoft Great Plains customization company, based in Chicago, Boston, San Francisco, Seattle, Minneapolis, Los Angeles, Houston, Dallas, Atlanta, and Miami and having locations in multiple states and internationally (www. We do certainly respect the right of Microsoft to compete with Oracle, SAP and PeopleSoft - but what is going on is probably non-planned and side effect of the solution which was made too soon. Of course the need to finish the contract with Pervasive software was a good idea - but cutting your small loyal customers - we actually doubt this. We have multiple examples of our customers who had to switch to Accpac, Adapta Soft and other cheap vendors of Payroll HR versions without limitation on the number of employees.
We encourage you to analyze your alternatives. You are probably lucky if you got nation-wide customization partner directly, because you can save 30% in local implementation and customization rates, due to the fact that nation-wide partner doesn't participate in the bidding, but rather is subcontracted by the winner of the bidding battle. Consulting job is subcontracted to independent consultants and customizations challenge is subcontracted to nation-wide customization partners, such as Alba Spectrum Technologies. Andrew Karasev is Chief Technology Officer at Alba Spectrum Technologies ( http. Regional Partners are still deploying strong sales techniques, but they have rather strong sales force.
Former Great Plains Software Dynamics/eEnterprise and currently Microsoft Business Solutions Great Plains serves midsize and corporate clients as ERP system in the following countries and regions. New sales would be difficult without high quality presentation and visit onsite. Yes - you should probably target existing orphans only. If you consider supporting the country where English is not in use, especially among the system users - you should have multi-lingual support technicians. If you plan to serve remote support clients from the US - you will probably find out that the normal US hourly rates are too high for the remote places.
If we look back to 1990th - we'll see that GPS had Multilanguage support and Great Plains Dynamics / Dynamics C/S+ was localized and translated into multiple languages, including Spanish. Some functionality could be realized through Microsoft Business Portal - which is web-based application. The other way is to have server in Mexico and have relatively inexpensive Microsoft Great Plains data be consolidated with Oracle, SAP, PeopleSoft based system in the USA. Consider Windows 2003 Terminal server licenses. Is supported and you can have both English version in the US and Spanish version in Mexico working of the same Great Plains environment.
It was total success for GPS, we guess, but for Great Plains Dynamics / eEnterprise / Dynamics C/S+ clients it was the time of change. Use the latest one to reload Pervasive for your workstations. Andrew is a Great Plains specialist in Alba Spectrum Technologies ( http. Nobody could predict if Microsoft, Ingress, Oracle, IBM DB2, Btrieve, Ctree/Faircom or somebody else from newcomers will win the market. In such a situation, if you are growing ERP publisher - you need to be flexible and have the ability to switch quickly from one DB platform to another.
When you need cross-modules data on the same report (Bill of Lading, which you could produce on the base of Picking List) you need to move the report you want to customize into your custom DYNAMICS. If you are on Great Plains Standard version. Andrew is Great Plains specialist in Alba Spectrum Technologies ( http. DIC and fill the gaps with RW_ functions - these are allowed to be placed on the report with parameters. Each existing report (Reports section) has associated parameters entry form.
|
Who Is Minding Your Sensitive Data?
Microsoft Great Plains Dynamics on Pervasive SQL.2000 Data Repair - Overview For DBAs