Software Information

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.


MORE RESOURCES:

BBC News

Apple unveils software updates, new laptop
San Francisco Chronicle,  USA - 2 hours ago
The presentation included updates to the iLife and iWork software suites, a new 17-inch MacBook Pro with an 8-hour battery and a new digital rights ...
Video: Steve Jobs Weight Loss Due to Hormone Imbalance AssociatedPress
Macworld goes for the soft sell with budget-minded software USA Today
Apple's Macworld Surprise Is the Software PC Magazine
CNNMoney.com - Macworld
all 2,804 news articles


Seattle Post Intelligencer

Microsoft's MacBU embraces the "software plus services" mantra
Seattle Post Intelligencer - 15 hours ago
In an interview, Eric Wilfrid, who was appointed general manager of the MacBU in late October, framed both moves as part of Microsoft's shift to a "software ...
Apple Security: Time To Stop Feeling Superior? InformationWeek
Microsoft touts Mac-Windows collaboration at Macworld Computerworld
Macworld.Ars: Microsoft intros 2 new apps for Mac Office users Ars Technica
InfoWorld - Baltimore Sun
all 128 news articles


TrustedReviews

ITunes embraces 3-tier pricing, will remove anti-copy software
Los Angeles Times, CA - 4 hours ago
Apple also updated much of its software. The latest version of iPhoto scans for individual faces so computer users can label photos of friends or family, ...
Apple changes iTunes prices; removes copy protection USA Today
Apple Offers All ITunes Songs Without Copy Protection Bloomberg
Labels OK DRM-Free ITunes Tracks MediaPost Publications
Washington Post - CNET News
all 900 news articles


BMC Software stock up after analyst upgrade
Forbes, NY - 11 hours ago
AP , 01.06.09, 06:18 PM EST BMC Software Inc. shares climbed Tuesday after a UBS analyst upgraded the business software maker, saying its cost cutting ...
BMC Software (BMC) NewsBite - BMC Upgraded By UBS Market Intelligence Center
Movers roundup: Best Buy, BMC Software Forbes
all 9 news articles


Callidus Software Presents at 11th Annual Needham Growth Stock ...
International Business Times, NY - Jan 5, 2009
Callidus Software is scheduled to present on Thursday, January 8, between11:30 am and 12:00 pm ET in the Fahnestock Room. A breakout session isscheduled ...
Ultimate Software to Present at the Needham Growth Stock Conference Trading Markets (press release)
Callidus Software Schedules Fourth Quarter and Full Year 2008 ... PR Newswire (press release)
all 27 news articles


Save Mart Supermarkets Deploys Integrated Retalix Supply Chain ...
MSNBC - 9 hours ago
That's why we turned to Retalix -- for the experience of their personnel and the rich grocery functionality of the company's software. ...


the unwired

windows software,
CNET News, CA - 10 hours ago
Serious DJs who add scratch and mix effects to their 2009 countdowns will want professional software such as Virtual DJ. With beat-matching, looping, ...
fring Releases New Software Updates for Windows Mobile Version SlashPhone
Fring for Windows Mobile CNET News
all 11 news articles


VMware Taps Borland CEO for Chief Operating Officer
PC World - 11 hours ago
Virtualization giant VMware has named Borland Software CEO Tod Nielsen to the newly created position of chief operating officer, in the latest chapter of a ...
Borland chief executive takes new COO role at VMware Bizjournals.com
Borland Software reports preliminary Q4 financial results ... RTT News
VMware hires away Borland CEO CNET News
WELT ONLINE - Austin American-Statesman
all 66 news articles


Market Wire (press release)

IBM Lotus Delivers New "Social" Notes and Free Symphony Software ...
CNNMoney.com - 13 hours ago
At Macworld, IBM (NYSE: IBM) today announced the availability of Lotus Notes 8.5 collaboration software with social computing features for all Mac OS X ...
Macworld: IBM finalizing free Symphony office suite for Macs Computerworld
Lotus Notes 8.5 ships, free IBM Symphony suite coming MacNN
IBM unveils Lotus Notes 8.5 VNUNet.com
eWeek - Computer Business Review
all 34 news articles


Times Online

Apple Introduces New Version of ILife Software at Macworld Show
Bloomberg - 16 hours ago
6 (Bloomberg) -- Apple Inc. introduced a new version of its iLife software today at the Macworld conference, a show marked by the absence of Chief Executive ...
Apple takes another small step on to the Web CNET News
Apple unveils raft of new Mac software Times Online
Apple's Entry Into Online Office Apps Is Confusing, Laughable Wired News
BBC News - Macworld
all 218 news articles

Software - Google News

home | site map
© 2006