When Great Plains C/S+ was introduced on MS SQL Server 6. This tool allows you place custom buttons and editable fields on the forms and attach VBA scripts to these buttons and fields. The negative side of this was - you can not have your custom piece running on Btrieve or Ctree platforms, where Dexterity cursors were the only way to work with the database. We'll wait the next version - but even now it is very promising and it doesn't require you to be programmer to customize Great Plains. Dexterity design was based on several longevity principles.
Dexterity, VBA/Modifier, SQL, ReportWriter, Crystal Reports. Third party modules may have their own utility for upgrade. Mekorma, Kampdata, Horyzon, Wennsoft, Avalara, Truepay, Trinity, Intellisol to name a few. Great Plains, Solomon, Navision and Axapta - and so has different priorities. 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. Your company had tough time three years ago, your former Great Plains Partner had the same of even larger problems, trying to stay in business. SET (to identify Dexterity third parties, you use), FORMS.
MS Exchange Server 2003/2000, Active Directory, MS SQL Server, Crystal Reports Enterprise, MS Outlook client, Microsoft IIS,. Net with MS CRM SDK and SQL queries to legacy database. Typical case - if you are freight forwarding client and have cargo tracking system - you should more likely have lookup from the MS CRM account screen to the customer current shipments statuses. Usually MS CRM ties together existing legacy business systems and replaces large portion of them. Because MS CRM is web application - it can be used by remote users and automate operations across the whole South America and even Worldwide.
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. In gadgets team you have product manager, who should see all the sales worldwide, also you create regional teams for European, America, Australian etc markets and then make gadgets manager as team member of all these teams. We first talk about vertical security, to give you conception of the matrix-type of security, realized in MS CRM. If you use MS CRM Web or Outlook clients - these are just two types of presentation level clients.
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. VPN will allow SQL Enterprise manager connect over the secured VPN connection. 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. The best scenario is VPN with remote desktop access (Windows XP Pro or Windows 2000 Pro.
You need to migrate to MS SQL Server ASAP - or you will be out of support. You need to migrate from Pervasive SQL/ctree to Microsoft SQL Server/MSDE. Don't pay for upgrade as is - you will lock yourself with the problems. 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. You have bunch of Great Plains Dexterity, VBA, SQL customizations and need upgrade and your former GP reseller is not providing customization upgrade services (due to the fact that all developers were laid off several years ago.
MS SQL Server, Ctree and Btrieve (later on Pervasive SQL 2000), in 1998 Great Plains Software made it available for MS SQL server only. Right - you have to use these custom SQL scripts to post transactions, created with eConnect. Yes - exactly - it was initially developed for eCommerce programmers. Later on eConnect was extended on the majority of Great Plains modules, including distributions. This means that no more eOrders - you just need the connector which will allow you to address Great Plains objects from your eCommerce application.
Both Linux and Windows come in Desktop and Server editions. Linux is fast catching up and is evolving from a server operating system to a desktop operating system. Microsoft came up with Firewall and Anti Spyware products, but these programs run in the background and eat up your computer's precious memory. Both Windows and Linux are GUI based operating systems. If you are looking an OS for your server, never even think about Windows.
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. 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. Currently we are confident in MS Great Plains ability to automate the following industries. 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. We have to tell you here that proposed solution is for large corporate clients only.
If you have SQL database, sitting on the same or linked SQL Server - you can create ASPX. Direct SQL touch - in #4 above I described you the scenario with MS Exchange handlers - this would be ideal world if MS CRM SDK does the job. 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. Refer to MS Exchange SDK onsyncsave event handling. Then simply apply some MS CRM SDK programming - you need some COM+ objects creation and VB programming experience.
Please, note however that Great Plains here is taken as the example, similar approach will work for other SQL based systems. Navision (SQL Database or C/SIDE database), Microsoft RMS, Solomon as well as Oracle and other non-Microsoft products. EDI was introduced long time ago for UNIX systems and in most of the cases appears in the form of Header, Lines and Trailer of predefined fixed position fields. 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. Communication with UNIX EDI Client or Server - each case requires individual approach.
Navision has native (or C/SIDE) platform as well as it is available on MS SQL Server. We would say that this integration is usually programmed on SQL level and XML inbound/outbound streams. SQL will give you more integration and reporting options (beyond Jet-Reports) - you can deploy Crystal reports (without C/ODBC. We believe that Great Plains is the easiest to setup and launch. Do not be afraid of the Native database - it has legendary strength.
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. XBRL is an XML-based specification that uses accepted financial reporting standards and practices to export financial reports across all software and technologies, including the Internet. If you need to pull data out of the Navision database on a regular basis one of the other options is a better choice. I would recommend using this tool for occasional reporting requests only. Using Excel you can create reports on any table of data from within any granule in Navision.
Lockbox is Dexterity piece, so it is in the hand of Dexterity Developer, if you need to improve it for your corporation. Virtually if you have corporate account in any bank - lockbox processing module does the job - because you map lockbox file at your will in Lockbox Maintenance screen. 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. Also feel free to use new tools, such as Extender or eConnect.
|
|