Microsoft Great Plains is becoming more and more popular and we see new purchases among midsize and large corporations, where, in our opinion, Microsoft SQL Server DB administrator position is a must. If you are database administrator and you are part of the decision making team, purchasing Microsoft Business Solutions Great Plains for your corporation, we would like to set your expectation on the level of SQL knowledge, skills and experience needed to support Microsoft Great Plains in-house
? Data querying. Microsoft Great Plains has decent ReportWriter, which allows users to create and modify existing reports, however the recommended tool, and you will soon understand that if you need really challenging reports (Sales Commissions, Bill of Lading, Sales Order Status with Purchasing info, Regional Sales, etc.) ? you need to deploy Crystal Reports or Crystal Enterprise. Crystal Report itself is usually based on the view or stored procedure. So ? you should expect to be familiar with Great Plains tables architecture and be capable to create select statement with multiple joins and unions
? Data Repair. You should be ready to save GP table prior to data repair: select * into SOP10100_Copy from SOP10100 and then use update statement to fix incorrect values. If you need to load SOP10100 back from the backup table ? first drop DEX_ROW_ID column and then use: insert into SOP10100 select * from SOP10100_Copy.
? Backup and Restore. Great Plains has DYNAMICS database which stores system info, such as users, security, companies, etc. and each company has its own database. You should be able to restore mostly company databases from the backup. This seems to be trivial routine.
? Technical Support. When you have issues with posting or need help from Microsoft Business Solutions Technical Support, you place case through customer source and you should expect the technician provide you with SQL scripts to fix your data.
? Some Useful Scripts. You need to be able to delete locked user: delete activity where userid='TOM', also very popular is batch recovery script, you need to unlock the batch in SY00500 table: Posting Definition Master
? Do not expect. Replications (except probably snapshot) ? it adds GUID column and then Great Plains Dexterity runtime can not upgrade the modified tables. Referential Integrity is not used, Varchar or NVarchar are not used ? the reason is ? Dexterity architecture, which was initially designed with database independence in mind. Logins and access management ? Great Plains uses its own security, which is translated into SQL logins with encrypted password.
? Moving Great Plains on the new SQL Server. It is often confusing for the DB Admin. Besides physical move through backups or detach/attach DB you need special scripts to transfer GP security and users logins, these scripts are available through MBS tech support or feel free to call you MBS partner.
? Advanced Techniques. If you need to notify your GP users on the specific event in GP ? such as invoice was paid, you can deploy SQL emailing: xp_send_mail. This procedure could be called in the trigger for the apply payments table.
? Data Integration. XML inbound and outbound streams for the integration stored procedures is becoming defacto standard. Also you should be familiar with heterogeneous SQL queries: OPENROWSET and linked server conceptions.
Happy implementing! You can always appeal to us to help you with your system. Give as a call 1-630-961-5918 or 1-866-528-0577, help@albaspectrum.com
Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies ( http://www.albaspectrum.com ), Microsoft Business Solutions Great Plains, Microsoft CRM, Navision, Microsoft RMS, Microsoft Business Portal customization company, serving clients in Chicago, Boston, New York, Miami, Atlanta, Houston, Dallas, Denver, Los Angeles, San Francisco, San Diego, Seattle, Minneapolis, Phoenix, Toronto, Montreal, Brazil, Mexico, UK, Australia, Canada, UK, Europe, Russia an having small offices in multiple states and internationally.
family-safe home cleaners Morton Grove ..Your computer cost you from hundreds to thousands of dollars,... Read More
For a windows user like me, just can watch with... Read More
The title of "software engineer" has got to be among... Read More
Anyone who has ever used Microsoft Word knows that it... Read More
So, why should you use any O/R mapping tool? I... Read More
I love new technology. I am still ready to wait... Read More
Microsoft CRM is relatively new player on the now becoming... Read More
Looks like Microsoft Great Plains becomes more and more popular,... Read More
We were recently faced with a decision: either to let... Read More
Sticky Noteshttp://www.deprice.com/stickynote.htmWith StickyNote 9.0, you can create beautiful 3D notes... Read More
Most computer users use spreadsheets software such as Microsoft Excel... Read More
Does Microsoft Have any Real Competition? Copyright (c) 2003 Gregory... Read More
This article will not attempt to advocate the use of... Read More
Security flaws have long plagued Internet Explorer (IE), the market-dominating... Read More
Microsoft Business Solutions Great Plains was purchased from Great Plains... Read More
This is intermediate level SQL scripting article for DB Administrator,... Read More
Microsoft Business Solutions Great Plains as new ERP for multinational... Read More
Buying accounting software is a major investment. It's an important... Read More
SyncUp, a file synchronizer is designed to assist the home... Read More
Microsoft Business Solutions Great Plains, former Great Plains Software Dynamics... Read More
Many Webmasters have never bothered to view their website's server... Read More
Case study: A secretary using Corel WordPerfect 7 is often... Read More
Microsoft Great Plains is now targeting large and midsize businesses... Read More
During the years of our consulting practice, which comes back... Read More
With the advent of 'Service Pack 2' for Windows XP... Read More
home cleaning services Wilmette ..Great Plains Fixed Assets Management module is a robust tool... Read More
Now is the time to look at an alternative to... Read More
Microsoft CRM is winning market share step-by-step from such the... Read More
Not all of us have the luxury of working both... Read More
There are plenty of articles out there about how to... Read More
Most people understand that the "hardware" part of their computer... Read More
Customer Relationship Management (CRM) is a strategy and processes used... Read More
With so many Microsoft Windows related viruses, errors, and other... Read More
There are certain pluses and minuses in both cases and... Read More
Although we don't know whether Microsoft ever envisioned such a... Read More
#5 All your hardware components like Printers, PCs etc come... Read More
Customer Relationship Management or CRM is a combination of enterprise... Read More
Looks like Microsoft Great Plains becomes more and more popular,... Read More
Microsoft Great Plains and Microsoft Retail Management System (Microsoft RMS)... Read More
Microsoft Client Relation Management system (Microsoft CRM) and Microsoft RMS... Read More
Are you ready? SQL Server 2005, the next-generation data management... Read More
A UNIX Shell is in simplest terms, a command line... Read More
One day, you suddenly realize that your computer started to... Read More
The purpose of Project Management Software is to provide an... Read More
1. What determines the software price? Is it Per Seat... Read More
As of now - Great Plains Dynamics/eEnterprise is transformed/renamed into... Read More
Microsoft Business Solutions CRM is now approaching the phase of... Read More
Microsoft Great Plains is main Microsoft Business Solutions accounting package... Read More
In the new era of internet marketing the problem of... Read More
According to a survey conducted by InfoTrends/CAP Ventures entitled "Content-Centric... Read More
Software |