Microsoft Great Plains Oil & Gas - Implementation & Customization Highlights
Oil & Gas production is under the strict safety and environmental standards and requirements at the company, industry and governmental levels. Microsoft Great Plains serves the wide spectrum of horizontal markets.

Microsoft Great Plains Project Accounting - Overview For IT Director/Controller
Simple budgeting and project tracking - if this is your goal - consider it, especially if you already have Great Plains implemented in your company. Poor integration with Microsoft Office tools - as of right now Microsoft is in process of moving all its ERP packages.

Microsoft Great Plains e-Commerce - additional considerations for programmer
And this is where Great Plains structure seems to be not transparent. Open Great Plains, if on version 7.

Microsoft Great Plains Data Conversion - Overview For Developer
how do we convert our old system data for initial Great Plains setup - read this and you will have the clues on where to look further. MS Excel - yes - sometime you can use it for legacy data massage before feeding it into Great Plains.

Begun, The Browser Wars Have
Early reports do, however, indicate that their new browser will only work with Windows XP, leaving many users out in the cold still. Even if Microsoft does get it's act together there is one thing they'll never have - cross-platform compatibility.

Easy Guide to RAID Recovery
Any individual or company could benefit from having a RAID RECOVERY system in place. While researching this article on RAID recovery she gained a new respect for computer technology.

How To Make Good Use of Spreadsheets
Now let's look at some of the uses you can put spreadsheets to. As we have seen, Spreadsheets have many useful features, which make calculation of figures simpler.

Choose your Java Wisely
  From java 1. Java has come along a long way.

Rapid Application Development - Is it Really a Need of Today?
Rapid Application Development (RAD) is a software development methodology. As the name suggests, RAD technique allows RAPID application development, with development time, usually, 30 to 90 days.

Instant Messaging is a Sweet Way to Communicate
When a message is received you are informed instantly on your desktop, you don't have to be at an email site.   There's a contact list and when you go on-line, it automatically tells you who of your connections are on and off-line at that moment.

If you are MCSE+I - CRM will recruit all your MS Exchange, Active Directory, MS SQL Server, Windows domain security, Windows 2003 Server, Web publishing and HTML knowledge and experience. Exchange, Active Directory, SQL Server, etc (while traditional CRM applications, such as Siebel were biased toward multiplatform compatibility. Unix, Oracle, Windows, SQL Server) and move up to business logic paradigm shift. We know the examples when 5 employees companies make a decision to implement and have surprising success in Microsoft CRM implementation. Microsoft seems to be allowing the enthusiasts to create the market niche and then move in with its own or purchased and beefed up solution.

Microsoft technical support encourages you to use Microsoft CRM SDK objects and discourages you from direct SQL server programming. If you need to change data on the store level from Microsoft CRM custom screen - you should consider placing web service on the SQL Server hardware in the store to deal with the store-initiated transaction. So, RMS design fundamentals were minted a long time before Microsoft CRM. Microsoft RMS has Headquarters and Store databases. This is open source tool, you can download it from Microsoft site and it is description of Microsoft CRM classes and methods with sample codes in C# and VB.

Microsoft Great Plains Business Solutions, later renamed to Microsoft Business Solutions was sending multiple signals to Dynamics customers to migrate to SQL Server, later on to upgrade to Great Plains Standard on MSDE. Microsoft obviously had no plan to keep this multiplatform capability and Great Plains was optimized to MS SQL Server and with the introduction of MSDE - the need to keep entry level Dynamics on Ctree/Btrieve disappeared. So - Great Plains was running on MS SQL Server, Ctree (Faircom - if you remember 1995-96 Macintosh era), Pervasive SQL (Btrieve. Unfortunately MBS did several rough turns in the process of this migration from ctree/Pervasive to SQL/MSDE. Tune Migration Tool, select all the tables in all the modules, click the button and wait a few hour - and you are in the SQL World.

You are doing migration from Pervasive/Ctree to Microsoft SQL Server/MSDE, especially when you have third-parties without migration tools. Server side - Installation creates security environment (logins) on MS SQL Server or MSDE, creates system database - DYNAMICS and then company databases. Net, Crystal Reports and Microsoft CRM SDK developer. Microsoft Great Plains is main mid-market application from Microsoft Business Solutions. You don't have support for your old Great Plains - then you have to select your Microsoft Business Solutions Partner and pay for the annual support/enhancement plan - you will get new registration key and will be ready for the upgrade.

The tendency is that if company uses Microsoft-driven computer park (Windows domain, SQL Servers, MS Exchange) the rest of the ERP/CRM applications are Windows-oriented. This integration also has Dexterity interface for Stores-GP Companies mapping and could work as nightly or real time SQL Server routine. Well - you can do it either from Oracle or from MS SQL Server side - in both cases you have linking tools and heterogeneous queries mechanisms. The above mentioned integration could be altered and tuned by programming MS BizTalk server (it can use either BizTalk runtime or regular license. However you can have successful bridge between non-Microsoft ERP and Great Plains.

However there are specifics, and Dexterity customization should be analyzed and tuned to work with MS SQL Server, if it was originally designed for btrieve/ctree. You can use MSSQL Server Linked Server construction to link to Pervasive/Ctree data. Pervasive SQL/Ctree migration to MS SQL - If you are still on these old platforms - then you are in trouble - you will be without Microsoft technical support by the end of 2004. Great Plains Dexterity Customizations - Microsoft announced that its products will be moved to. Crystal Reports, SQL Stored Procs and triggers, Web Publishing (Visual Studio.

Nowadays, however - and this is a good thing - most of Great Plains installations are moved to SQL Server - so you can use Dexterity for custom forms drawing only and make the buttons run SQL stored procedures. Integration Manager, VBA/Modifier, Great Plains Dexterity, SQL Server stored procedures to name a few. SQL queries - as a developer you have unlimited potential in using SQL queries, because the database in MS SQL Server. Microsoft Business Solutions Small Business Manager is Great Plains Dexterity based application and successor and small business market niche version of Microsoft Great Plains. Net, Crystal Reports and Microsoft CRM SDK developer.

In other words, it is a big chat server, you join a group (channel) and you talk in an open forum type environment or one on one. There are about fifty really mainstream IRC networks (groups of servers) you can connect to. It is a group of networked server computers that let clients (or users) connect and passes their message among the networked servers in almost real time. It is a shareware program that doesn't disable after a given time period, however it does have a nag screen when you first load it, if you don't register it. I have used the program for many years faithfully.

Net, SQL, Backup Exec 9, Ghost Server Corporate Edition 7. Some programs reported not working are webservers such as Internet Information Services (IIS), Remote Desktop, File Sharing. With the advent of 'Service Pack 2' for Windows XP operating system, Microsoft have really made the forums hum. Applications which may not work are programs that have to contact a server to work at all, some ftp, multimedia streaming software, 'new mail' notifications in some email applications. It really needed a dvd movie to accompany it to visually show what you had to set before starting up any 'third party' applications, but this was not thought necessary because Microsoft were offering free technical support via a free phone number.

You can deploy MS SQL Server linked server to show your third party or even heterogeneous data on MS CRM screens. You use MS SQL Server scripting to pull the data from third party system (but not to update data in the CRM - you should use MS CRM SDK for this purpose. Oracle, DB 2, Sybase, Lotus Notes Domino, SAP, Pervasive SQL 2000, Ctree or any ODBC compliant database. Net - and we see that Microsoft-oriented IT departments take an initiative and implement MS CRM with minimal outside help. In this small article we will try to give you highlights on how to implement Microsoft Business Solutions CRM for worldwide operations with restricted internet connection.

Net web publishing - Microsoft Great Plains data sits on Microsoft SQL Server. Microsoft Great Plains ReportWriter supports Barcode fonts and you can print out barcodes off the inventory control items list. Let's consider industry requirements and their implementation in Microsoft Great Plains. If automated shipment is the most business processes critical requirement - you can implement Supply Chain solution, integrated with Microsoft Great Plains. In the case of custom internet application you can deploy.

The easiest way is to have this implemented as Stored Procedure in MS SQL Server company database. At the same time Great Plains, now being moved on MS SQL Server platform allows you to deploy standard tools to customize and fit to these requirements, when you don't need rich custom functionality, just few touches. In Microsoft Great Plains borrowers are usually customers in the Accounts Receivables module (RM00101 table - customer master. Using SQL Exec statement you can build formula on the fly, considering multiple case scenarios and calculations. Microsoft Business Solutions Great Plains is very generic accounting application out of the box and has multiple modules to address specific horizontal or vertical market requirements.

If you've got shell or telnet access to your server, you can backup MySQL data by issuing the mysqldump command. You can discuss about this article or any PHP/MYSQL related issues in our Discussion Forums. If you need to restore existing databases, you'll need to use MySQLImport. For more information on MySQLImport, you can check out. If you have to re-build your database from scratch, you can easily restore the mysqldump file by issuing the following command.

If you have legacy system on MS SQL Server - let's say you are transportation company and have in-house developed cargo tracking database. Microsoft will not support your customization if you use undocumented class or do direct SQL access to CRM database. Instead of SQL Server you can have other database (ORACLE, MS Access, PervasiveSQL to name a few) - you can access multiple Database platforms via ADO. Never create your custom SQL objects (like stored procedure, SQL view, table) in MS CRM database. Net you can analyze all the classes, used by Microsoft developers to create MS CRM - you will discover that most of them are not documented in MS CRM SDK.

Crystal Report link to Pervasive/Ctree - you have to install Pervasive SQL ODBC driver from Great Plains Dynamics CD. Microsoft Great Plains Tables Structure - Launch Great Plains and go to Tools->Resource Description->Tables. Lunch Microsoft Access and make a link to Microsoft Great Plains tables. Some introduction into Great Plains Software products, now Microsoft Business Solutions. If you are database administrator who is supporting the version on Pervasive SQL.