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 … 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 … Continue reading GP #LifeHacks 106: Change the Dynamics GP Splash Screen

GP #LifeHacks 128: How to apply the payroll tax updates – Dynamics GP

Microsoft has released the most recent tax rate changes for GP Payroll, and you want to get them in your system.  No problem! It's not as hard as you think but it does have some requirements and precautions that come along with the process. Below is a quick step by step guide on how to … Continue reading GP #LifeHacks 128: How to apply the payroll tax updates – Dynamics GP

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 … Continue reading GP #LifeHacks 141: Hide/Mask Social Security Numbers

GP #LifeHacks 119: Year End Wage Data in a Smartlist using a SQL View

As year end quickly approaches, I wanted to share with my followers a very helpful #GPLifeHack that turns your year end wage file data into a Smartlist for easy auditing and review! There is an 'edit' report for W2's but it's in long form and difficult to review - plus it is not easily exported … Continue reading GP #LifeHacks 119: Year End Wage Data in a Smartlist using a SQL View

GP #LifeHacks 108: Batch Recovery – Tip to manage this like a pro using Startup folder!

Microsoft Dynamics GP has a great feature that captures posting processes that have issues or get interrupted.  This is EXTREMELY helpful and helps protect GP users against many different reasons a batch would fail to post. Normally we go into Batch Recover (Microsoft Dynamics GP>Tools>Routines>Batch Recovery) for two reasons:  We either receive an error when … Continue reading GP #LifeHacks 108: Batch Recovery – Tip to manage this like a pro using Startup folder!

GP #LifeHacks 126: Automatically create bank deposits from Cash Receipts

Over the past few years, many new features of Microsoft Dynamics GP were included with each roll-out.  Because of an accelerated cadence of releases, many of these new features go unnoticed and therefore, unused. I came across this little nugget the other day and I wanted to post a quick write up to my blog … Continue reading GP #LifeHacks 126: Automatically create bank deposits from Cash Receipts