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.

---

Introducing GRML

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

Microsoft CRM Modification ? Overview for IT Specialist

Microsoft CRM is now on the scene and it is... Read More

Programming Language Migration Path

While I was preparing some personal background information for a... Read More

Microsoft Great Plains: Offshore Customization & Development ? Overview for Consultant

When you visit department stores and see that majority of... Read More

Ukraine: a Prospective Player on the World Software Outsourcing Market

The destruction of the Soviet Union about 15 years ago,... Read More

Microsoft CRM Integration With Microsoft Office Documents ? Overview For System Integrator

Microsoft CRM is CRM application, maintained and supported by Microsoft... Read More

Microsoft Navision Database Selection: C/SIDE or MS SQL Server - Overview For IT Specialist

There are certain pluses and minuses in both cases and... Read More

Microsoft Great Plains: Large Scale Implementation

Microsoft Business Solutions Great Plains, Navision, Axapta, Solomon and CRM... Read More

ERP Implementation: Success Factors

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

25 Things Mapping Software Can Do For You

1. With mapping software you can create a report that... Read More

Implementing Microsoft CRM: setup and configuration ? notes for IT specialist

Microsoft Business Solutions CRM is web-based CRM application, deploying all... Read More

A Time-Saving Programming Tactic that Doesn?t Work

Let's say that you have a software project that's under... Read More

Software Tools To Help Your Business Sell More

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

How Do I Get Rid Of That Darn Spyware?

Ad-Aware and Spybot are probably the two most well known... Read More

Is Your Family Protected?

When you think... Read More

Great Plains Dexterity Development: FAQ

Microsoft Business Solutions Great Plains is Dexterity-written application and currently... Read More

Microsoft Great Plains Customization Recovery & Upgrade for Large Corporation

At the end of XX century, in the late 1990th... Read More

Destination: Desktop for Google

First we had the original Google search that evolved into... Read More

How to Upgrade Dexterity Customization ? Tips for IT Manager

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

How the Firefox: How to... Manual Helped Me

A few months back I really got sick of my... Read More

What To Do When Windows Wont Boot

When Windows fails to boot it is normally caused by... Read More

Microsoft Great Plains Logistics & Warehouse Management ? Implementation & Customization Highlights

Logistics automation is often considered as barcoding extension to Sales... Read More

Introduction To ISDN, Part II

In the previous ISDN article, we looked at how and... Read More

Microsoft CRM Messaging through Lotus Domino eMail Server - Balanced Solution

Microsoft CRM and IBM Lotus Notes Domino seem to be... Read More

Understanding Document Management

The term "document management" and "paperless office" is the subject... Read More

The Dirt on Screensavers

Remember back in the days where screensavers were the coolest... Read More

OLAP, An Alternative Technology Over Spreadsheets

Are Spreadsheets Robbing your Enterprise of Competitive Advantage?'90% of "average"... Read More

Explore the Internet in a Whole New Way

For a long time now Microsoft's Internet Explorer has ruled... Read More

Screenshots Vista Windows

Features Additionally, Vista will include many other new features.Aero Vista... Read More

Microsoft Great Plains Integration Manager ? Advanced Techniques

Great Plains Integration Manager scripting and translation - overview for... Read More

Getting Technical Support Help Online

Sometimes your PC will start acting strange for no apparent... Read More

How To Create A Data Capture Procedure Checklist For Your Small Business CRM Software

Fortunately one of the most common reasons cited for the... Read More

Microsoft Great Plains international implementation ? USA / Mexico ? overview for consultant

Microsoft Business Solutions Great Plains was purchased from Great Plains... Read More