Category: Life Hacks

Come Join Me! Excel Life Hacks

About this Session: Excel Life Hacks

Title:

Excel Life Hacks | Tips and Tricks for Excel Users to Save You Time!

Description:

Life Hacks are designed for the end user to save time and be more efficient. Join me for this session to learn better ways to get the job done and show off your new Excel skills back at the office! We will cover everything from formulas to charts – and we will have a blast doing it too! Join me for this fast and fun session to cover over FORTY tips and tricks for Excel!

Continue reading “Come Join Me! Excel Life Hacks”

GP #LifeHacks 137: Add a SQL View to Smartlist using Designer

Dynamics GP offers a very good tool to create your own Smartlists… Smartlist Designer.
One of the cool things users can do is incorporate custom SQL views into Smartlist through SmartList designer… this can be a HUGE time saver and really gives you the ability to get data you would normally not be able to get in a normal Smartlists.
Below are the steps needed to add a SQL View to your Smartlists.
Continue reading “GP #LifeHacks 137: Add a SQL View to Smartlist using Designer”

GP #LifeHacks 106: Change the Dynamics GP Splash Screen

Changing the Dynamics GP Splash Screen is not only fun and cool (yeah, I said it!) but it is very useful as well!
If you are not familiar with a splash screen, Wikipedia describes it like this:
A splash screen is a graphical control element consisting of a window containing an image, a logo, and the current version of the software. A splash screen usually appears while a game or program is launching.
Ok, not bad… so the GP Splash Screen looks like this:

So how do we change it? And what is so cool about it? Keep reading and I will walk you through the steps.
Continue reading “GP #LifeHacks 106: Change the Dynamics GP Splash Screen”

GP #LifeHacks 141: Hide/Mask Social Security Numbers

Are you using the robust HR and Payroll module for Dynamics GP?  If so, I hope you are masking social security numbers on your reports!
A relatively new feature (GP 2015 R2) in the HR/Payroll module allows for automatically masking of SSN’s on certain reports.  It’s actually quite simple.
Here is a step by step on how to implement this feature on some key reports in your system.  It’s a piece of cake!! Continue reading “GP #LifeHacks 141: Hide/Mask Social Security Numbers”