Microsoft Great Plains Security Setup - Overview For Consultant

Microsoft Business Solutions Great Plains is very good fit for mid-size company and probably good budget solutions for large corporation. Former product name was Great Plains Dynamics / eEnterprise. Both versions: old and new are Great Plains Dexterity written and Dexterity itself was planned as database and computer platform independent / transferable shell back in earlier 1990th. Currently Great Plains (version 8.0 and coming 8.5) is MS SQL Server based and the last multi-database version 7.5 (available on Pervasive SQL and Ctree/Faircom). But considering former goal ? Microsoft Great Plains has security model, which is independent from MS SQL security and works in parallel with SQL Security

User Classes and Users

? Users. Users has nothing to do with MS SQL Logins, however if you are on SQL version ? users are translated to SQL as logins and given access to all Great Plains related database: DYNAMICS and companies

? User Classes. You can automate users creation, by including new user to the class or transferring old user to different class and by doing so you have an option to reset security from the class. On the user level you can supercede class security. Class works for all the companies, while User can have different security right in each different company Objects: Windows, Reports: modified and alternate modified

? Confuse? Yes ? this is normal reaction. These all confusing terms come from the architecture of the system ? you need to know architecture highlights to recognize the terminology.

? Modified Reports. These are modified via Great Plains Reporting tool: ReportWriter ? Tools->Modify->ReportWriter and select the report you want to modify. The most popular is SOP Long Invoice form. When you are done with the modification (placing logo, etc.), you need to assign security either to the users who will be printing this report or user classes: Setup->System->Security select user id, company, product (Great Plains), type as Modified Reports, series Sales and you will see SOP Invoice Long form available in the list, mark it and you will have it available for this user.

? Modified Forms. If you purchased Great Plains Modifier ? you can modify the form, for example on Customer Maintenance screen you could place the button and attach VBA script to it ? you should have VBA/Modifier with customization site enabler license. This is the realm of VBA programmer. Security should be given to the modified form.

? Alternative Modified Forms and Reports. If you have in-house Dexterity customization working with SOP Entry screen for example ? the technology works this way ? it imports existing SOP entry screen from DYNAMICS.DIC dictionary (original Great Plains) into custom dictionary, created by Dexterity developer. Here this form is known as Alternative Form. You can go to further complexity and modify this one with Modifier and get Alternative Modified Form.

Advanced Security

? Security for specific customers, accounts, etc. ? you can protect specific object in Great Plains with this advanced security module. We'll just mention this fact and do not touch details Problems

? Central versus Local dictionary. If you have security for the user to use, say SOP Long Invoice form modified (taken from REPORTS.DIC), and you have Reports.DIC placed on local machine (check you DYNAMICS.SET file). When you give this user new computer and do not take care on transferring REPORTS.DIC from the old machine ? user will get error message ? can not open report: dictionary not found. The same is applicable to modified forms

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.

---

15 Questions to Ask Your Software Vendor

When making a decision to buy any piece of software... Read More

How to Build a Basic CSS Layout

Designing without tables by using CSS layouts is fast becoming... Read More

Microsoft Moves to Small Business Accounting/Retail Market ? Stakes and Thoughts

In this small article we will be looking at the... Read More

Popular Fleet Maintenance Programs

Some companies that are in need of fleet management may... Read More

Beware of The Pirated Software E-Mail Scams!

You have gotten those E_Mails buy software at deep discounts.... Read More

Microsoft Great Plains Integration Manager: Using Continuum ? Overview for Developer

Microsoft Business Solutions Great Plains has I'd say end user... Read More

Microsoft Great Plains Accounting/ERP Implementation ? Finance Industry Customization Example

Microsoft Business Solutions Great Plains is very generic accounting application... Read More

Most Dangerous Types of Spyware are on the Rise: How to Choose the Weapon

Bad News - the Threat is Bigger than it SeemedHow... Read More

Accessing XML Using Java Technologies

The most important benefit of XML is its simplicity. Though... Read More

Microsoft CRM Custom Design & Development: SDK, C#, SQL, Exchange, Integration, Crystal Reports

Microsoft CRM is new player on the CRM software... Read More

OEComplete ? A Personal Information Manager

OEComplete is a utility for managing the personal information of... Read More

ERP Implementation: Success Factors

As seeing large number of implementations ? in our case... Read More

Chinese Input - Step by Step Instruction on How to Input Chinese Characters in English Windows XP

Enabling Chinese input is quick and easy, there are only... Read More

Put Some Pizazz in Your Software Arsenal

The software giants don't do everything and don't always produce... Read More

Introducing GRML

Creating a new markup language.Introduction.General Reuse Markup Langauge, or GRML,... Read More

Editing Your Photos Using Microsoft Picture It Publishing Platinum 2002 - A Great Dinosaur

I started using PIP (Picture It Publishing) Platinum 2002 right... Read More

Great Plains Dexterity ? Microsoft Great Plains Customization Overview

Microsoft Business Solutions Great Plains, former Great Plains Software Dynamics... Read More

Design a Web Album Using Adobe Photoshop- Part 2

So let's begin crunching down these 300 images using Adobe... Read More

Software Upgrades Arent Always the Best Move

When my daughter was getting into AOL instant messaging (AIM)... Read More

Software Tools To Help Your Business Sell More

Sales are all about leverage, because there is only so... Read More

SQL Administrator Skills Required to Support Microsoft Great Plains

Microsoft Great Plains is becoming more and more popular and... Read More

Linux Secrets

The first thing that you will notice about Linux Red... Read More

Microsoft Great Plains Upgrade ? Version 8.0 Overview for IT Director/Controller

If you have Microsoft Great Plains as main accounting and... Read More

Think Of This

Think of this, first we had the HAM Radio, then... Read More

Great Plains Dexterity Customization Options ? Overview For Developers

Looks like Microsoft Great Plains becomes more and more popular,... Read More

Microsoft Great Plains as ERP and Microsoft CRM as CRM

If you have Microsoft Great Plains and support it for... Read More

10 Things You Can Do With Photoshop CS2 That You Couldnt Do Before Now

Is Photoshop CS2 worth the upgrade? You bet it is!... Read More

Need of Document Management System (DMS)

Document Management or Enterprise Information Management is perhaps one of... Read More

What to Do if All Screensavers Fun is Grayed Out?

Finally, you have some time to personalize your desktop with... Read More

Can You Calculate Complex Financial Calculations?

Are you a whiz at calculating financial information? Not the... Read More

Groupware as a Document Manager: Collaboration Series #3

This article is the third of a series of articles... Read More

A Guide To Purchasing Professional XP Icons Online And Enhancing Your Applications

Icons are used everywhere; right from software applications, to internet... Read More

Cross-Platform Custom Software Development & Integration ? IT Strategy for Large Corporation

Microsoft Business Solutions products: Great Plains, MS CRM, Navision, Axapta,... Read More