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”→
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:
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 get this task accomplished, along with some words of ‘wisdom’ (ok, I know, humor me!) Continue reading “GP #LifeHacks 128: How to apply the payroll tax updates – Dynamics GP”→
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”→
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”→
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!”→
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”→
I have been using Mass Close for a few years now. Not many Microsoft Dynamics GP users use it (in my experience). I like to use it because it is origin specific closing, versus Series specific closing – the later is used by most everyone.
The ‘trouble’ with Series closing is that there are times when you need to enter transactions into certain areas for the previous month. What folks typically do is open and close the series over and over again to achieve this. Mass Close eliminates this need and adds extra internal controls to the closing process.
In this blog I’ll cover the mass close option, as well as share a SQL view that I turned into an Excel Report for easy managing of origin status! Continue reading “GP #LifeHacks 112: SQL View turned Excel Report for Fiscal Period Closing data”→
If you’ve heard any of my ‘soapbox’ special discussions recently, you know that I am a huge fan of the enhancements flooding into Microsoft Dynamics GP. In particular, I love to explore the workflow functionality!
Today I was asked a great question about controls involving turning a requisition into a PO. At first, I was thinking that workflow handled this type of ‘control’. However, after some discussion, I realized I was not listening well enough, and in fact, there is an easy way a requisition user can change the quantity, amount, etc… as they turn the requisition into a PO – after it was approved! YIKES!!!! GP Life Hack #176 – Requisition to PO – A Workflow gap identified! (and fixed!)
Putting a vendor on ‘Hold’ is a helpful option when we want to prevent any payments from being made against a particular vendor. This can be done for a variety of reasons, for example, (and my favorite!) we might put a vendor on hold until we receive their W9 document.
This allows us to continue entering invoices but prevents payments being made to that vendor…. for all of that vendor’s invoices.
But… wait. What if I just have a question about a particular invoice and don’t want to accidentally pay it, but do not want to put the vendor on hold?
GP Life Hack #152 – Put individual Payable Documents on Hold