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.

---

XML Parser and Their Types

XML parser is a software module to read documents and... Read More

Crystal Reports For Microsoft RMS ? Overview For Developer/Report Designer

If you are software developer or database administrator - we... Read More

Microsoft Great Plains - Payroll & HR Inexpensive Solution? Not Any More

Microsoft Great Plains is main Microsoft Business Solutions accounting package... Read More

Intro to UNIX Shells

A UNIX Shell is in simplest terms, a command line... Read More

Microsoft Office Selecting Secrets

Stop the Runaway MouseWhat's the "runaway mouse?" You've seen it...you... Read More

Groupware: Avoid the Ad Hoc Shuffle

GroupwareEfforts are continually made to manage the unavoidable ad hoc... Read More

Not All Project Management Software is Created Equal

The purpose of Project Management Software is to provide an... Read More

Microsoft Great Plains Distribution, Barcoding, Consignment ? overview for consultant

Microsoft Great Plains ? ERM from Microsoft Business Solutions and... Read More

Microsoft Great Plains Beverage Production & Distribution ? Implementation & Customization Highlight

Microsoft Business Solutions Great Plains has many years of successful... Read More

OEComplete ? A Personal Information Manager

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

Reporting Tools for Microsoft Great Plains ? Overview For Developers

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

IBM Lotus Domino or Microsoft Exchange?

IBM Lotus Domino or Microsoft Exchange?The severe competition continues for... Read More

DB Integration - Software for Combine MS Access Databases

Our company, Novaprof Inc., developed unique software - DB Integration.... Read More

Microsoft CRM for Corporate Business ? Working Offline

If your company has regional and worldwide operations, you might... Read More

Linux Secrets

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

FreeDOS

Before September 1995, Microsoft Windows was an MS-DOS program. DOS... Read More

Microsoft Great Plains: Getting New Users Licenses ? Annual Service Plan FAQ

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

Microsoft Retail Management System (RMS) SQL Customization ? Overview for Programmer

Microsoft Retail Management System serves retail single store as well... Read More

How a Bug Challenges to a Software Professional

It is really interesting that a bug can create problem... Read More

Microsoft CRM: Data Conversion ? Import from Act!

Best Software Act! is very popular CRM for small and... Read More

MSN Messenger Is A Sweet Way To Communicate

MSN messenger is a pretty cool invention. I mean I'm... Read More

The True Meaning of Freeware

The vast majority of us will have, at some point,... Read More

Constructionalist Parsing - Deciphering Natural Language

The research in the field of Natural Language Processing usually... Read More

The Top 5 Wrong Reasons For Not Hiring Testers

Considering whether or not your software company should hire a... Read More

Data Quality Best Practices for Salesforce.com

Executive SummaryAn effective plan for entering, cleaning and updating the... Read More

Crystal Reports - Microsoft SQL Server

Microsoft SQL Server is the leader for inexpensive and middle... Read More

Spyware Definitions List

The adware and spyware definitions list is very long. But... Read More

Ukraine: a Prospective Player on the World Software Outsourcing Market

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

COSMIC: A Small Improvement on the Symons Method

The COSMIC FP (function point) software quality metric, is no... Read More

Will Adobe Manage to Replace Industry Work Horse Quark Express by Giving Adobe InDesign for Free?

And kill the best layout software in the process of... Read More

What is Fleet Maintenance Software?

Simply put, fleet maintenance allows companies to monitor and maintain... Read More

Design a Web Album Using Adobe Photoshop- Part 2

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

Microsoft CRM Implementation & Customization: MS CRM Fax Gateway

With this small article we are continuing Microsoft Business Solutions... Read More