Some time ago Microsoft announced that Management Reporter was no longer going to get development support. This meant that it was time to start exploring options to replace MR internally for financial reporting. No rush, MR isn't going away soon, but why not explore... At the same time that the announcement occurred, Microsoft also announced … Continue reading GP #LifeHacks 200: Replace Management Reporter with Jet Basics
Payroll for Microsoft Dynamics GP is packed with tons of cool functionality... most importantly.. making sure everyone gets paid! 🙂 How about those deductions and benefits... yup, it handles those too, all represented on the employee pay stub... SWEET! But what happens when a code is inactivated part way through the year... the code no … Continue reading GP #LifeHacks 147: Show Unused Codes On Paystub With YTD Information!
Dynamics GP is bursting at the seems with tons of functionality just waiting to get utilized and in this blog series, I will explore the custom links feature. "Custom Links" is a feature available on many windows in GP and can be a huge help for folks by adding, well... Custom Links to those windows … Continue reading GP #LifeHacks 105: Using Custom Links to Track Packages, Add Images and More!
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 … Continue reading GP #LifeHacks 163: Smartlists gone WILD!! Search Functionality explained
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 … Continue reading GP #LifeHacks 101: Use dimensions WITHOUT Analytical Accounting! MDA to the rescue!
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 … Continue reading GP #LifeHacks 110: Post Financial Transactions to History
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 … Continue reading GP #LifeHacks 113: Resetting Forgotten System Password
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
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
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