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.
elite cleaning services Mundelein ..Let us give you - developer some hints in the... Read More
While I was preparing some personal background information for a... Read More
The intuitive algorithm.Roger Penrose considered it impossible. Thinking could never... Read More
Not all of us have the luxury of working both... Read More
Introduction: The creating of a computer program involves a number... Read More
Microsoft CRM has built-in conversion tool, however you should probably... Read More
The most important things you can do for your computer... Read More
Microsoft Great Plains might be considered as ERP platform to... Read More
Table of Contents1) Introduction 2) Related Work 3) Framework 4)... Read More
The Windows registry is a huge database that ensures normal... Read More
Innovative Maintenance Systems (IMS) is one company that offers solutions... Read More
Remember old good days when your company probably had Great... Read More
In the case when you represent mid-size or mid-size-to-large business,... Read More
Do you remember that frustrating feeling when you find an... Read More
Not every software testing project can or should be automated.... Read More
While I was in college, if you would have asked... Read More
Microsoft Business Solutions Small Business Manager is scaled down Great... Read More
MS CRM is very close to document workflow automation, including... Read More
In this short FAQ style article we would like to... Read More
Customer Relationship Management (CRM) is a strategy and processes used... Read More
Should one use Windows Update?This topic has good and valid... Read More
Microsoft Business Solutions Great Plains is mid and even corporate... Read More
ERP is the acronym of Enterprise Resource Planning. Multi-module ERP... Read More
RSS (Really Simple Syndication) is a way for a site... Read More
Some companies that are in need of fleet management may... Read More
Airbnb cleaning service Mundelein ..Some introduction into Great Plains Software products, now Microsoft Business... Read More
Customer Relationship Management or CRM is a combination of enterprise... Read More
Traditionally we were considering functionally rich systems, such as SAP,... Read More
In our small article we'll consider Microsoft Business Solutions Great... Read More
Microsoft Business Solutions ? Great Plains has captured the US... Read More
The fact that a software tester is a most infamous... Read More
Microsoft Business Solutions ? Navision is an integrated solution for... Read More
In this article you will find some background information about... Read More
If you are software developer or database administrator - we... Read More
Today's business world is fast-paced. No matter what it is... Read More
If you have been running Windows XP for a couple... Read More
Microsoft Great Plains is now targeting large and midsize businesses... Read More
It is a well known fact that Java as a... Read More
Microsoft Business Solutions Great Plains as new ERP for multinational... Read More
IBM Lotus Notes with Domino email server is traditional document... Read More
Ok... Where to start?Well, I guess I will start at... Read More
Language development computer: Computer-based method for aiding language development seems... Read More
Great Plains Inventory Management (IV) module gives your business a... Read More
We've all seen the ads on TV for Netzero 3G.... Read More
Microsoft bought Navision, Denmark based software development company, along with... Read More
Having from five to ten and more favorite screensavers is... Read More
This article is the third of a series of articles... Read More
The adware and spyware definitions list is very long. But... Read More
Looks like Microsoft Great Plains becomes more and more popular,... Read More
Now that spyware is the single most dangerous threat to... Read More
Software |