Microsoft Great Plains Security Setup - Overview For Consultant

Microsoft Business Solutions Great Plains is also excellent for medium-size company and probably good budget solutions for large companies. The previous 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 1990. 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

Classes of users and users

O Users. Users do not have anything to do with MS Access SQL, but if you are on SQL version - users are translated into SQL, such as login and have access to all Great Plains related database: DYNAMICS and companies

Or user classes. You can automate the creation of users, adding a new user to the class or transferring old user to different class and in doing so they have the ability to reset the protection of the classroom. At the user can replace the class of security. Class work for all companies, while the user may have the right to protection in any company other than
Subjects: Windows reports: modified and alternate modified

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

Reports or amended. These are modified via Great Plains Reporting tool: ReportWriter - Tools-> Edit-> ReportWriter and select the report you want to change. The most popular is SOP Long Invoice form. When you are finished with the modification (placing logo, etc.), you must give security for users who will be printing this report or categories of users: Setup-> System-> Security select id, company, product (Great Plains) , such modified ratios, sales number and you will see SOP Invoice Long form available in the list, select it and you will have for this user.

or modified forms. If you have purchased Great Plains Modifier - you can change the form, for example, on the screen of the customer service 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 or modified forms and reports. If you have house Dexterity customization working with SOP entry screen for example - the technology works this way - import existing screen SOP Wikipedia to DYNAMICS.DIC (original Great Plains) into custom dictionary created by Dexterity developer. Here this form is known as an alternative form. You can go to further complexity and modify this one with Modifier and get Alternative modified form.

Advanced Security

or security for specific customers, accounts, etc. - you can protect specific object in Great Plains with this advanced security module. We shall only mention this fact and do not touch the details
Problems

Central or local dictionary VS. If you have protection for the user to use, for example in the form SOP Invoice long modified (taken from REPORTS.DIC), and have Reports.DIC place on the local machine (control file DYNAMICS.SET). When you give this new computer user and not caring REPORTS.DIC transfer from the old machine - you'll get the error message - can not open report: dictionary not found. The same applies to modified forms

Good implementation! You can always turn to us for help with your system. Give as a call 1-630-961-5918 or 1-866-528-0577, help@albaspectrum.com...