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.

Related Articles:

Dr. Billie Blair is Redefining Best Business Practices in Her New Break out Bestseller, All the Moving Parts, Organizational Change Management
Business Productivity - Dr. Billie Blair is Redefining Best Business Practices in Her New Break out Bestseller, All the Moving Parts, Organizational Change Management. In her new multi-media explosion, All the Moving Parts: Organizational Change Management CEO and Organizational Management Expert, Dr. Billie Blair has hit the ground running and is not looking back as she redefines best business practices and productivity and continues to remind her clients and readers, "Even if your business feels like it is in a state of chaos you don't have to be."

USC Consulting Group's Chris Saunders Named to Society of Critical Care Medicine Advocacy Committee
Team to address workforce and reimbursement issues, disaster preparedness.

Kinaxis Director of Business Consulting Selected by Supply & Demand Chain Executive as a "Pro to Know"
Kerry Zuber Honored for Vision and Commitment to Customer Excellence in Annual Listing of Top Supply Chain Industry Professionals

The Waters Consulting Group Releases Report on Succession Planning in Local Governments
Firm specializing in public sector HR services publishes findings of study that explored Succession Planning in local governments The Waters Consulting Group, a firm that specializes in human resources, compensation, performance management, executive recruitment services and Succession Planning for local governments, today announced the release of "A Gathering Storm: Succession Planning in the Public Sector." The report is based on the findings of The Waters Consulting Group's study that measured the opinions of local government employees regarding Succession Planning.

Performance Based Safety, LLC Expands Services to Include International Safety Consulting Work
Performance Based Safety, LLC has begun reaching out to the international market to offer their specialized safety consultant expertise.

Microsoft Business Solutions Partner – How to Launch New IT Consulting Practice
In the new era of internet marketing the problem of severe competition comes into the first position. If you look back into 1990-th you will find high tech companies using traditional sales techniques: purchasing local and regional businesses contact lists, making cold calls and then trying hard sales closing techniques, such as "selling to the top" – IBM style, selling to VITO (very important top officer), etc.

Pro-Link GLOBAL Visa & Immigration Services Adds Key Senior Consultant to Their U.S. Global Immigration Team Making Global Immigration More Accessible
Kate Boyd, an experienced global immigration consultant, graduate of the University of Kansas and accredited Paralegal recently joined Pro-Link GLOBAL, the "one-stop" global visa and immigration practice for U.S. Immigration attorneys and Global Corporations.

Blue Prairie Group Announces the Addition of New Human Resource Consultant
Blue Prairie Group's human resource practice continues to grow with the addition of Rachael McCalla to the company. Rachael draws from a background in industrial psychology and extensive experience working with personnel related issues.

HBH Gas Systems Announces Exclusive Propane System Construction and Consulting Agreement with Blossman Gas
HBH?s central propane gas systems provide off-grid developments with clean-burning, economical propane from a single, centralized underground tank.

Microsoft Great Plains GL: General Ledger – Overview For Consultant
Microsoft Business Solutions Great Plains is marketed for mid-size companies as well as Navision (which has very good positions in Europe and emerging markets where it can be easily localized). Great Plains Inventory control is pretty robust and here we would like to give you highlights on standard functionality as well as what could be added to its standard features.


Privacy Policy | Copyright/Trademark Notification