Dynamics Confessor Blogspot

Dynamics Confessor Blogspot
  • Using Copy and Paste in a GP Macro

    What if you want to copy and paste using a GP Macro? You can easily do it, but there’s a little trick to it. Let’s learn how! The requirement was to create a bunch of manual payments with the User ID of who entered the payment being entered into the comment...
  • Convergence 2014 ! Pre-pre game–Atlanta

    Left for Atlanta this morning (March 1st, 2014). It was cold and foggy in Dallas, so foggy that I had to slow down to read the signs on the highway. Still, I got to the airport on time, to my surprise I was ushered through the TSA Pre-check line. This...
  • Stampede is back!! Or, is it? You decide.

    Check out Pam’s post about the re-emergence of Stampede this fall. But really, ‘Stampede’, that is so last decade. I bet you can come up with a better name! So begins the contest of what to name the new conference. Get all of the details from Pam’s post...
  • Dex.ini switches – my complete list!

    As if configuring Dynamics GP isn’t already enough fun, you can enhance your experience even more by modifying the Dex.ini file. Have fun with it! The dex.ini file is inside the Data folder of your Dynamics GP desktop application. Use Notepad, or any...
  • What’s in a date? PM Transactions

    Recently, I worked with a group that needed to make changes to the dates of some of their posted payables transactions. Of course, you can’t do that through the user interface, so it was SQL to the rescue. While the initial job sounded easy, they were...
  • TSQL - Fun with Dates!

    Are you constantly needing to come up with different relative dates in reports, SmartLists and the like? I found this great list of date calculations from Pinal Dave and Vivek Jamwal . I’m duplicating it here because 1) I’ll be able to find it, and 2...
  • 2013 FICA-Medicare withheld only prints $2,900 on W-2

    Only $2,900. . .what’s up with that? As we all are frantically preparing our W-2s, an anomaly (a bug, really) has reared its head. It applies to those employees with FICA Medicare wages in excess of $200,000. As you know, the 2.35% Medicare rate kicks...
  • W-2 Other Codes for Box 12

    With the W-2 season upon us, I thought now would be a good time to point out some items that should live in Box 12; but often don’t make it there. I’m not attempting to give any tax or accounting advice, just to share some information with you about Box...
  • Dynamics GP Excel Dashboard available now!

    This comes to us from one of Dynamics GP’s finest, the infamous Mark Polino! Jump to www.DynamicAccounting.net/Analytics to get more details. This is the truly painless way to get started with Excel dashboards, have someone else do it for you . Imagine...
  • 2014 Payroll Tax Tables–how to fill out manually

    I’ve been getting quite a few calls lately about how to get the new 2014 tax tables if they can no longer get them from Microsoft. These folks are on versions 9 or 10, so they are out of luck on the download. Scandalous though it may be to remain on an...
  • There is an error with at lease one vendor record, print the customer/vendor record for details

    This is an error I thought I’d add to our ‘When Things Go Wrong’ section. My thanks goes to Alaa Ramadan, who both identified the error and discovered its solution. You can find the thread here . The error presented itself when the user was attempting...
  • Form W-2 Common Errors - Codes for Retirement Plans

    This information comes straight from our friends at the IRS, it describes common mistakes made on Forms W-2. I have run into many of these as our clients begin to prepare their annual filings. If you find that you are missing any of these items, be sure...
  • 'Object reference not set to an instance of an object'

    This must be one of my most hated error messages. Usually, I see it in Integration Manager, but this time it has shown up in Management Reporter. Jake Friedl recently posted a list of things to check when you receive this error. Thank you Jake! This is...
  • Dexterity training in Dallas – Live or Live on-line

    It must be in the air! Come to Dallas, or join us On-Line. I’m doing another Dexterity Fundamentals class in Dallas, TX, December 9th-13th, 2013. This time we are offering it both on-site in Dallas and Live on-line! At last, you can go to a fun-filled...
  • SQL datetime formatting function–convert to string

    I found this looking for something else on the Internet, but I thought it would be a great item for your toolbox. The function was originally written for 2005, but it has worked on everything I’ve tried. Enjoy! Many thanks to Anubhav Goyal , who provided...
  • Linking a Sales Tax Detail to a Vendor

    Follow this method and you can create PM Transactions to the taxing authorities to remit sales tax, no re-keying required. Recently I responded to a post on the GP Community Forum from a user wanting to tie a vendor to the sales tax details so that he...
  • First and Last day of Previous Month

    In the accounting world I so often need to limit my selection criteria to the first and last day of the previous month. This is certainly not a secret formula, but I now have a place where I can look it up. Sadly, I have not memorized this formula First...
  • GP2013 Time to Upgrade!!! Service Pack 2 is out!

    Yay!! Service pack 2 for Dynamics GP 2013 has been released. For everyone waiting for this momentous event, it is here. Many folks hold out until Service Pack two on the theory that the fixes that didn’t make the ‘release to market’ version are fixed...
  • Bootstrapper Error

    Dynamics GP Forum member named ‘BenefitElect’ shared this solution with us. This is a problem that’s otherwise impossible to track down. Thanks to BenefitElect and Microsoft Tech Support, it will be no problem for us. A big THANK YOU to BenefitElect for...
  • Why does my computer get stuck?

    Read this fabulous post from David Musgrave about an annoying problem that, until now, was impossible to figure out. Stop using a ‘fix’, and finally make the problem go away! Here’s the description straight from David: What would then happen is my laptop...
  • Round 5 of the 2013 U.S. Payroll Tax Update is now available for Microsoft Dynamics GP2010 and GP2013

    Microsoft just released round 5 of the 2013 Payroll Tax updates. This update is supported only on GP2010 or GP2013, if you are using version 10, or any previous version, do not attempt to install it. A summary of the changes in this update are as follows...
  • It’s almost here!!! Dexterity in Dallas!

    Come one, come all, we are running the Dexterity class in Dallas the week of June 17th. It runs from Monday, June 17th through Friday, June 21st. The class is definitely a ‘go’, there will be no last minute cancellations. If you have been disappointed...
  • An exception occurred while trying to load or initialize the addin located at Rtc.

    Don’t ya love these error messages? My friend and fellow MVP, Frank Hamelly posted a question on the GP Forum about getting the above error message after loading a fresh install of SQL2012 and GP2013 on his laptop. Frank had previously had GP2012 running...
  • The ‘Other List’ is out and I’m in trouble!

    Well, the ‘Other List’ was released today, and my name was on it. I fear now that my awesomeness has just taken a critical (if not mortal) hit. I need help. The clock is ticking. I need to do something awesome enough for Doug Pitcher to overlook the infraction...
  • Illegal address for field ‘FICA/Med Add Tax Rate in script ‘941_Generate’

    This error has been coming up lately in version GP2010. The solution has been to rename the Forms.dic. So, you need to export any modified forms to a package file. Rename your Forms dictionary and then import the package file, thereby creating a new Forms...