One issue that will come up from time to time when working with Dynamics SL using Windows Authentication is being able to access data across databases. Windows Authentication is specifically designed to “prevent” that functionality. In other words Windows Authentication is in place to provide strong security in spite of the ease that an integrated login brings. There is a way around the problem of getting at the data you need while obeying good security practices.The first step is to set up an additional SQL user that you can use to assist with the need to get to the additional database. Grant that user the rights needed to make the queries work. Next, add a modified stored procedure to include a “With Execute” as clause. That is pretty … [Read more...] about Dynamics SL Cross Database Queries
Dynamics SL and Inventory Replenishment Savings
My friend in Houston, TX, Kurt Bradley, a successful Dynamics SL consultant for the past 25 years, shared this story with me. Other than worksheets and “inventory by walking around” there are few lower cost options for distributors suffering through the challenges of trying to figure out what inventory to buy without overstocking.A distributor that is a longtime client has been using Dynamics SL and its predecessor, Solomon III, since 1987. They have kept their business simple and, in the past, had been able to adequately manage stock levels using Order Management, Inventory, and the core financial modules. But, over the course of the past decade, there has been a dramatic shift in their supply chain as domestic manufacturers have … [Read more...] about Dynamics SL and Inventory Replenishment Savings
Dynamics Promotion through May 31, 2013
Effective now through May 31, 2013, current Microsoft Dynamics GP and SL customers can receive up to a 20% discount off the Microsoft standard list price for additional user licenses purchases. A minimum purchase of one user license is required, up to a maximum of 20 additional user licenses.In addition, if you sign-up for this offer you'll receive one Management Reporter training class FREE (an $800 value). The June class is full but July and August classes have room. If you have questions or are interested in taking advantage of this great offer, please contact Carol Simonson at (763) 412- 4315 or csimonson@boyerassoc.com.Thank you! … [Read more...] about Dynamics Promotion through May 31, 2013
5 Top Reasons to Attend Dynamics GP and SL User Group Events
Each year we hold a client event for both our Dynamics GP and Dynamics SL clients and event the attendance continues to grow This year the events are being held on May 15 (Dynamics SL) and May 22 (Dynamics GP) at the Microsoft Technology Center in Edina, MN.Now our Dynamics GP consultants may rightfully be able to claim a good part of the success on the Dynamics GP side, but both sessions (GP and SL) equally draw great interest from attendees. So why do they keep coming back for more? Here are my five top answers to why more and more people attend these Microsoft Dynamics ERP events each year.1. 50 Tips in 60 minutesMost users like to learn better ways to do their work. There are always new features and functions of the products … [Read more...] about 5 Top Reasons to Attend Dynamics GP and SL User Group Events
Payroll Implementation Musings
Jon Augdahl from the Boyer & Associates staff recently implemented in-house payroll in Dynamics SL for a large client with more than 2,000 employees. Implementing a payroll module can be tricky if it’s not correctly, fortunately this was a quick implementation that was completed in just a couple of months., We wanted to share a few things that Jon learned, and some tips that might help you if you decide to implement an in-house payroll system: 1. Staff – make sure that you have adequate staff to get you through the first month or two on the new system, and the last month on the old system. Payroll is the one module where making mistakes can be catastrophic. There will be many changes during a payroll implementation. Data … [Read more...] about Payroll Implementation Musings
Lessons from Implementing HR for a Large Dynamics SL Client
This post will discuss changing or updating the system and processes that affect the most valuable asset your organization has- your employees. Timing and accuracy was on Paul James (Boyer consultant) mind during the entire implementation of the HR component for a large Dynamics SL client located on an Indian Tribe in Northern Minnesota.As you can see above, this nice HR module for Dynamics SL was created in the Dynamics SL toolset so minimal user interface training or integration is needed during the implementation.The most important lesson that became apparent as our project was starting was the need for communication between Payroll and Human Resources. Like many organizations, this firm’s employees’ paychecks consist of inputs … [Read more...] about Lessons from Implementing HR for a Large Dynamics SL Client
GPUG Thrives in Minneapolis
If you are extremely interested in Dynamics GP and our Boyer twice a year meetings are not enough for you, please consider joining the Dynamics GP User Group (GPUG). Kristen Hosman, from the Boyer staff, is a member and would be happy to be your host for the next meeting. Some of the meetings are virtual so you don’t even need to leave work. Kristen has attended the GPUG Summit as well and can share with you what that was like last year.The Dynamics GP User Group (GPUG) is a place for users to share their experiences and learn more about GP. The group is made up of Partners and users who share the ambition of utilizing GP and all it has to offer. The community of users gets together remotely and face-to-face to share knowledge and best … [Read more...] about GPUG Thrives in Minneapolis
Getting Dynamics SL 2011 Working with Windows 8
Accountants hate change and Windows 8 brings us a lot of immediate change. We have a very busy, very technical consultant on our staff that told me he was too busy for Windows 8 and reinstalled Windows 7 on his laptop. What did I do? I bought a Windows Phone. I figured that if I could force myself to learn Windows 8 on the phone, using it on the computer would be that much easier. So I’ve had the phone for about a week and I’m getting used to it. Like most gadgets I’ve missed my iPhone a bit but am making great strides and I love the screen size of my Nokia 920.Below are the steps you need to follow as compiled by Jeff Larson, our Dynamics SL Environment specialist. Jeff is creative and able to get even unsupported environments … [Read more...] about Getting Dynamics SL 2011 Working with Windows 8
Real Value in Upgrading to Dynamics GP 2013
If you are a Dynamics GP Version 10 or Version 2010 user, you may think this post is going to be mostly about the 150 new features that are part of Dynamics GP 2013. …but “What’s New in GP 2013?” has already been covered by a few good bloggers.This post is about the slew of additional value that Microsoft is providing to its user base simply for paying your annual enhancement plan and transitioning to GP 2013.The first thought that comes to my mind is that unlimited payroll users are free. We had a client 3 years ago pay over $40,000 for payroll and HR. Now most of the costs to making this transition are in paying us to setup their payroll. Here in Minnesota more than in other places I’ve lived (Illinois, Pennsylvania) people avoid … [Read more...] about Real Value in Upgrading to Dynamics GP 2013
How to Add an SSRS report to the Dynamics SL 2011 Menu
This post is a technical post. I should warn you that if you do not do report writing or technical work with Dynamics SL you may fall asleep after the second sentence of the next paragraph. Please forward the link immediately to your more technical counterparts if you are in danger of a slumber episode. You should be able to make it beyond the bullets below regardless of your technical abilities or your attention span.By and large, the process for adding an SSRS report to the Dynamics SL 2011 menu is the same as adding any other report to the SL menu.First you need to create the report, which gives you an RDL file in the case of the SSRS report instead of the RPT of a Crystal Report. Copy that file into the Usr_Rpts directory (in … [Read more...] about How to Add an SSRS report to the Dynamics SL 2011 Menu
