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.
tidy up service Glenview ..While I was preparing some personal background information for a... Read More
It would be easy to think, like most people apparently... Read More
If you have Microsoft Great Plains and support it for... Read More
It's not very often I get excited about a software... Read More
Microsoft Great Plains - Microsoft Business Solutions accounting and ERP... Read More
The objective for Zandi Digital is to make available clever... Read More
Several software companies design programs for preventive maintenance. Most of... Read More
GroupwareThe internet is full of 1.5 million to 7 million... Read More
Are you one of those people that keeps track of... Read More
Microsoft Great Plains is one of the Microsoft Business Solutions... Read More
Microsoft Business Solutions Great Plains has several options to enable... Read More
IBM Lotus Domino or Microsoft Exchange?The severe competition continues for... Read More
If you copy something from a Web site or elsewhere...... Read More
Microsoft Great Plains fits to majority of horizontals and retail... Read More
What is Software?Software is a set of instruction written to... Read More
When it comes to running an office, the SOHO entrepreneur... Read More
Stealing company information used to be the specialty of spies... Read More
In part III of this ISDN primer, we learned that... Read More
I started using PIP (Picture It Publishing) Platinum 2002 right... Read More
This article will not attempt to advocate the use of... Read More
Do you want to get quality software at a reasonable... Read More
Mapping Software Improves Data VisualizationFrom the outset, it is important... Read More
When you visit department stores and see that majority of... Read More
MSN messenger is a pretty cool invention. I mean I'm... Read More
The Windows Indexing Service provides you with the ability to... Read More
maid service near Winnetka ..Let's say that you have a software project that's under... Read More
Microsoft Business Solutions is now in process of creating so... Read More
Have you noticed WordPerfect is gearing up for a comeback... Read More
Since Version 8.0 Microsoft Business Solutions Great Plains & Great... Read More
Microsoft Business Solutions Navision serves both European and American megamarkets.... Read More
Microsoft Great Plains and Microsoft CRM become more and more... Read More
Fundraising software lets you connect with donors in a way... Read More
Executive SummaryAn effective plan for entering, cleaning and updating the... Read More
.Net Framework is a platform or development environment to seamlessly... Read More
There are certain pluses and minuses in both cases and... Read More
Microsoft Business Solutions Great Plains, former Great Plains Software eEnterprise,... Read More
For a long time now Microsoft's Internet Explorer has ruled... Read More
Today's business world is fast-paced. No matter what it is... Read More
Microsoft Great Plains is main Microsoft Business Solutions accounting package... Read More
Make-or-Break Factors in Success and ProfitabilityFor quick printers, estimating can... Read More
In the Clinton era the status quo was simple: you... Read More
SyncUp, a file synchronizer is designed to assist the home... Read More
Microsoft Business Solutions Great Plains is very popular ERP platform... Read More
Microsoft Business Solutions Great Plains has substantial market share among... Read More
It is really interesting that a bug can create problem... Read More
Follow the steps below to quickly design, generate, and deploy... Read More
A wiki is an editable text-based website. But you don't... Read More
Microsoft Great Plains is main Microsoft Business Solutions product, targeted... Read More
C++ Function templates are those functions which can handle different... Read More
The term "document management" and "paperless office" is the subject... Read More
Software |