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.

---

What is Software Piracy?

There are several kinds of software piracy. The bottom line... Read More

Cisco Certification: Five Things To Do DURING Your CCNA Exam

There are plenty of articles out there about how to... Read More

What Stands Behind The Software Description?

With thousands of web pages added to the Net every... Read More

Is Your Family Protected?

When you think... Read More

Off The Record - Tips For Picking Recording Software

Need software to record your voice, streaming audio or musical... Read More

Ukraine: a Prospective Player on the World Software Outsourcing Market

The destruction of the Soviet Union about 15 years ago,... 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

Lotus Domino Implementation and Development: Infrastructure ? Present and Future

Domino server is a buffer between the operation system and... Read More

Internet Security Threats: Who Can Read Your Email?

Before being able to choose a secure Internet communication system,... Read More

IT Strategy for Midsize Business: Microsoft vs. Java, Great Plains & CRM

Midsize business or non-profit organization should decide if one-vendor solution... Read More

Microsoft CRM Data Conversion FAQ

Microsoft Business Solutions CRM data conversion deserves FAQ type of... Read More

Cisco Certification: Introduction To ISDN, Part IV

In part III of this ISDN primer, we learned that... Read More

Microsoft and Webmasters

Does Microsoft care for WebmastersIt's always been a problem with... Read More

FreeDOS

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

SQL scripts for Project Accounting: Microsoft Great Plains series ? overview for developer

Microsoft Business Solutions Great Plains has Project Accounting module where... Read More

Downloading Spyware Removers: Think Before, not After

Just imagine: you are walking, say, towards your car, and... Read More

How to Evaluate Staffing Software

If you are in the market for new staffing software,... Read More

My Experience - Making a Vision into Reality

Disclaimer: All the thoughts expressed are my views only! Your... Read More

Microsoft CRM Customization Secrets ? Second Edition

This article is for advanced Microsoft CRM SDK C# developers.... Read More

Microsoft Great Plains Nationwide Remote Support

ERP Consulting industry is on the way to serve clients... Read More

Microsoft Small Business Manager Customization Options - Overview

Microsoft Business Solutions Small Business Manager is Great Plains Dexterity... Read More

Microsoft Great Plains Remote Support - Overview

Microsoft Great Plains is now standard mid-market ERP application, serving... Read More

Start Developing Your Own Software

Learning how to program software seems like a daunting task... Read More

ERP for Large Corporation ? New Selling Strategy

Our opinion is based on our Microsoft Business Solutions Great... Read More

Great Plains Custom Development: Dexterity, VBA, SQL, Crystal, eConnect ? Overview For Programmer

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

Free Preventive Maintenance Software

While several preventive maintenance software manufacturers offer free trials for... Read More

Understanding Document Management

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

Microsoft Great Plains Implementation & Customization: Computer Parts Retailer Example

Microsoft Great Plains fits to majority of horizontals and retail... Read More

A Case Study on Selecting Contract Management Software

Professional services firm cuts costs and improves productivity with integrated... Read More

IT Department Skills to Support Microsoft Great Plains and Microsoft CRM

Microsoft Great Plains as ERP and Microsoft CRM as... Read More

Great Plains Bill of Materials Setup & Customization for Process Manufacturing ? Overview

Microsoft Great Plains has full-featured Manufacturing suite of modules: Capacity... Read More

Corporate ERP Selection: Microsoft Great Plains

In our opinion, traditional approach when you select ERP/MRP system... Read More

CRM 101: Customer Relationship Management for Beginners

Customer Relationship Management, abbreviated "CRM," is the term for a... Read More