Category: Life Hacks

GP #LifeHacks 163: Smartlists gone WILD!! Search Functionality explained

One of the MANY things that sets Dynamics GP apart from other ERP solutions… SMARTLISTS BABY!!!

Smartlists are a linear list of your data.  You can customize them easily but out of the box, there are lists for all transactions, vendors, customers, and TONS of other things.

With the SmartList tool (free/included with Microsoft Dynamics GP) you have the ability to do some valuable filtering of your data… this filtering is made available through data ‘Search’ options.

A simple search example would be, show me all the transactions for Vendor XYZ… and BOOM, there they are… but what if your search is a little more complex that that?  Let’s take a look at the options for basic and advanced search functionality.

Continue reading “GP #LifeHacks 163: Smartlists gone WILD!! Search Functionality explained”

GP #LifeHacks 101: Use dimensions WITHOUT Analytical Accounting! MDA to the rescue!

AA (Analytical Accounting) provides the ability to add additional details to transactions without adding new segments to your chart of accounts.  It does a lot of other ‘fun’ stuff, but before you dive into the deep end… consider an alternative… consider Multidimensional Analysis (MDA for the acronym fans out there).

Once thought to be removed from Dynamics GP (and maybe even some folks still believe it is not in GP), MDA lives and breathes in Dynamics GP and is an underutilized feature… so let’s take a look at this functionality!

What is MDA and how does it work?

Continue reading “GP #LifeHacks 101: Use dimensions WITHOUT Analytical Accounting! MDA to the rescue!”

GP #LifeHacks 110: Post Financial Transactions to History

Does this sound familiar?  “I can’t close my fiscal year yet… the audit is not finished.”

Closing a fiscal year in Dynamics GP does a few things, but in particular, it closes the Profit and Loss account balances out to the retained earnings account.

Many customers fear closing their fiscal year because their previous years work is not complete.  This causes complications with summary windows as well as with Financial Reporting.

I believe, in most cases, that the fiscal year can be closed right on schedule… just like closing any other month… no need to wait… no need to rebuild reports to create a make shift ‘balance brought forward’.  Just use the ‘Post to History’ functionality.

Let’s take a brief look at this…

Continue reading “GP #LifeHacks 110: Post Financial Transactions to History”

GP #LifeHacks 113: Resetting Forgotten System Password

Some of the administrator type functions in Dynamics GP use a system password in order to provide a thin layer of protection against unintentional and/or inappropriate use.

This password often gets misplaced, forgotten, or just disappears with turnover.

I have some good news for you if you fall into this situation… A SQL Script can be used to reset the password.

Continue reading “GP #LifeHacks 113: Resetting Forgotten System Password”

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”

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 to Excel.  What exports easily to Excel?  SMARTLISTS!!! YEAH THEY DO!

Let’s make this year-end process easier by creating a Smartlist for year end W2 data! 

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 the batch tries posting (that we notice) or, at month end, when things aren’t necessarily making sense when reviewing our financials or our reconciliations.

Here is a tip to help make sure that postings that go to ‘Batch Recovery’ are noticed much sooner than month end, and helps save us tons of time!

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 site so that I, and my followers, were reminded of this #GPLifeHack.

Normally folks create cash receipts and then, during a second step, create a deposit to match the batch of cash receipts that they took to the bank.  The cash receipts batch is usually a one to one relationship with the deposit.  So turn your two step process into one by implementing “Automatically post deposits from cash receipts”.

Here is a brief overview of how this feature.

Continue reading “GP #LifeHacks 126: Automatically create bank deposits from Cash Receipts”