When Great Plains C/S+ was introduced on MS SQL Server 6. This tool was initially designed for eCommerce developer, who deploys Microsoft Great Plains as the back end/ERP. This was new feature of Microsoft Great Plains Dexterity version 7. Andrew Karasev is Chief Technology Officer at Alba Spectrum Technologies ( http. We encourage you to analyze your alternatives.
Dexterity, VBA/Modifier, SQL, ReportWriter, Crystal Reports. Net, Crystal Reports and Microsoft CRM SDK developer. Mekorma, Kampdata, Horyzon, Wennsoft, Avalara, Truepay, Trinity, Intellisol to name a few. Third party modules may have their own utility for upgrade. SOP Blank Invoice form, SOP Blank Picking ticket, etc.
If you on MS SQL Server and do not have customization, only ReportWriter reports. Great Plains Professional (high end, more than 10 users) and Standard (low end, up to 10 users) are still Great Plains Dexterity based applications and now they are on MS SQL Server only (Pervasive SQL and Ctree support and upgrade is discontinued. MDB) and SQL custom stored procedures - if any. Net, Crystal Reports and Microsoft CRM SDK developer. Plus you get discounts on the technical support cases placed to Microsoft Business Solutions technical support directly.
MS Exchange Server 2003/2000, Active Directory, MS SQL Server, Crystal Reports Enterprise, MS Outlook client, Microsoft IIS,. And this is due to the fact, that MS CRM utilizes all the resent Microsoft technologies. The same should be said about MS CRM support - your Microsoft Business Solutions CRM Partner can support your installation remotely from say office in San Pablo as if it is located across the street. Microsoft Business Solutions CRM is present several years on the US software market plus it makes advances in Europe. Net with MS CRM SDK and SQL queries to legacy database.
Microsoft CRM schema sits in MS SQL server database, so if you deploy MS CRM SDK to modify/customize your CRM - both presentation clients will get the custom interface. However you can improve MS CRM Exchange connector to catch emails by addresser email or domain, also you can deploy Lotus Notes Domino as email server - check with Alba Spectrum Technologies. Microsoft CRM integrates with GP customers, SOP Orders & Invoices. Microsoft CRM uses Active Directory users and its security is built upon Windows domain security. Net, Crystal Reports and Microsoft CRM SDK developer.
Usually you create your custom Sales Order Processing (SOP) invoice form from one of the GP workstations and then place your reports on the server. If you use IT subcontractors - these folks should be trained on installing new Great Plains workstations (or you should insist on working via terminal server/Citrix. The dilemma for the programmer is - should I know all the details of Great Plains table structure model and document workflow - or probably purchase the set of SQL stored procs to help me. VPN will allow SQL Enterprise manager connect over the secured VPN connection. The plans are the plans, but the realities of Microsoft Great Plains customization signals that Dexterity will stay another 5-7 years as IDE.
You need to migrate from Pervasive SQL/ctree to Microsoft SQL Server/MSDE. You need to migrate to MS SQL Server ASAP - or you will be out of support. Ask for customization analysis - most of the old customization pieces should be migrated to new technologies, like Dexterity to SQL and Crystal Reports, web publishing, eConnect, etc. It is known fact that Microsoft decided to breach contract with Pervasive Software and stop supporting Microsoft Great Plains 7. Microsoft Great Plains, Navision, Solomon and Axapta are Microsoft Business Solutions ERP applications, serving to the whole spectrum of vertical and horizontal markets.
MS SQL Server, Ctree and Btrieve (later on Pervasive SQL 2000), in 1998 Great Plains Software made it available for MS SQL server only. In our small article we'll consider Microsoft Business Solutions Great Plains Sales Order Processing module as eCommerce backend. Right - you have to use these custom SQL scripts to post transactions, created with eConnect.
Microsoft Great Plains is one of the most popular ERP in the US, Canada, Australia, New Zealand, Middle East, Latin America, UK and South Africa. Net, Crystal Reports and Microsoft CRM SDK.
Microsoft came up with Firewall and Anti Spyware products, but these programs run in the background and eat up your computer's precious memory. Linux is fast catching up and is evolving from a server operating system to a desktop operating system. Both Linux and Windows come in Desktop and Server editions. If you are looking an OS for your server, never even think about Windows. I was browsing the Internet with Microsoft Internet Explorer and my machine got infected with loads of spyware in less than 15 minutes.
In the described case we suggest to use SQL stored procedures for calculating checks and Dexterity process server to post checks (creating SQL stored procs for posting would be virtual rewriting 40% of Great Plains Dexterity based payroll module. As all MBS ERPs it has MS SQL Server 2000/2005 database platform and allows you to deploy customizable and altered solution, serving large corporation HR department. Microsoft Business Solutions Great Plains is very good candidate. He is Microsoft Great Plains certified master, Great Plains Dexterity, Microsoft CRM SDK C. Aerospace & Defense, Chemicals, Oil & Gas, Advertising & Publishing, Distribution & Logistics, Beverages, Supply Chain Management (SCM), Pharmaceutical, Nonprofit, Healthcare/Hospitals, Wholesale/Retail, Manufacturing/Assembling, International Business/Multinational Corporation, Government.
If you have SQL database, sitting on the same or linked SQL Server - you can create ASPX. We would like to give you pluses and minuses of Microsoft CRM.
Microsoft CRM SDK - this is software development kit with C# and partly VB. Try to avoid the temptation to create your own SQL view or stored procedure in MS CRM database, instead - create custom database and place your view and stored proc in it. Microsoft technologies dependence - yes, this is true and maybe considered as minus, it doesn't work with Netscape or Mozilla browser.
In the case of non-SQL system, such as old Great Plains Dynamics, ACCPAC on Pervasive SQL - IDE interface will involve ADO/ODBC or Microsoft Access programming. Navision (SQL Database or C/SIDE database), Microsoft RMS, Solomon as well as Oracle and other non-Microsoft products. Communication with UNIX EDI Client or Server - each case requires individual approach. Please, note however that Great Plains here is taken as the example, similar approach will work for other SQL based systems. We would like to give you - programmer, software developer, database administrator the primary clues on producing EDI formatted text from Microsoft Great Plains database.
Navision has native (or C/SIDE) platform as well as it is available on MS SQL Server. SQL will give you more integration and reporting options (beyond Jet-Reports) - you can deploy Crystal reports (without C/ODBC. Navision is more popular in Europe, Navision Software was Denmark based software development company - it was bought by Microsoft in the beginning of XXI century. We would say that this integration is usually programmed on SQL level and XML inbound/outbound streams. If you would like to pick something from Microsoft, or its ERP subdivision - Microsoft Business Solutions, and in case of large public company, you should consider these three.
Using a familiar Microsoft Outlook®-style interface, Business Analytics presents this information to your desk top where easy to use analytical tools allow you to carry out targeted analysis that is tailored by you, for you. Andrew is CTO in Microsoft Business Solutions Partner Alba Spectrum Technologies ( http. Microsoft bought Navision, Denmark based software development company, along with Great Plains Software. Navision (former Navision Attain), Microsoft Great Plains (former Great Plains Dynamics/eEnterprise), Solomon, Axapta. Now Microsoft Business Solutions offers the following ERP applications.
Net, Crystal Reports and Microsoft CRM SDK developer. Microsoft Great Plains is now targeting large and midsize businesses and being matured ERP has advanced, but still very simple in use modules and features. Lockbox is Dexterity piece, so it is in the hand of Dexterity Developer, if you need to improve it for your corporation. VBA Modifier and Continuum are also available. None, Document Number (when you have ACH), Due Date/Oldest Document, Due Date/Oldest Invoice (other than invoices you apply manually), Document Date, Specific Invoices (and you specify them in the list.
|
|