Sample Desktop Alert

Creating Custom Desktop Alerts In Dynamics GP

First off, full credit goes to David Musgrave for sharing the bulk of this code with me and for providing some great troubleshooting help as I worked to call the code properly from VBA. Allow me to share some background information. While at Convergence 2012 in Houston this year, I attended a presentation on the…

Read More

Populate Rounding Account On Multicurrency Payables Transactions Created Via eConnect

If you create multicurrency payables (PM) transactions using eConnect, and you are passing in the distributions manually (by setting CREATEDIST to 0), you may have encountered the same issue I encountered today. When the transaction was created, eConnect also (correctly) added in a ROUND distribution, to account for 0.01 cents worth of FX related rounding…

Read More

Use Dynamic SQL To Generate a Dynamics GP Login Macro

If you run Dynamics GP and have more than a handful of companies, I am sure you have felt the pain of installing or upgrading a 3rd party product, and then having to log in to each company as “sa” to complete the install process. I had to do this recently for a new 3rd party…

Read More

Using SmartList Builder With A Linked Server – It Can Be Done!

We are looking to deploy SmartList Builder + SmartView as an enhanced reporting solution for our internal customers. One of the things I have seen floating around the net is that you can’t use SmartList Builder with a SQL Linked Server. In fact, a number of Dynamics MVP’s alluded to this in a support thread…

Read More

Book Review: Microsoft Dynamics GP 2010 Reporting

Full Disclosure: I was provided a no-charge eBook version for the purposes of this review by the publisher, Packt. Microsoft Dynamics GP 2010 Reporting by David Duncan and Christopher Liley, is a very good, general purpose book on the reporting options available in Dynamics GP. It focuses on the “Big 5” reporting options for Dynamics…

Read More

Troubleshooting Upgrade to Dynamics GP 2010 R2, Part 2

Another error encountered, another error resolved. During the upgrade of the sample database, TWO, I received an error on the procedure SVC_MailProcessLOG. The error message was: ERROR [Microsoft][SQL Server Native Client 10.0]TCP Provider: The specified network name is no longer available. That incredibly helpful error message really means: Perform your GP Utilities run on the…

Read More

Troubleshooting Upgrade to GP 2010 R2

I’ve been working on installing the newly released GP 2010 R2 in a “sandbox” environment. I ran in to an issue performing the upgrade and thought I’d share it in case it helps anyone else. I had the GP 2010 client installed on the same machine I was installing R2 on. Rather than creating a…

Read More

Book Review: Dynamics GP 2010 Implementation by Victoria Yudin

In this post, I review the book Dynamics GP 2010 Implementation by Victoria Yudin.

Upcoming Book Review: Microsoft Dynamics GP 2010 Implementation by Victoria Yudin

Just a quick note that I am hard at work on a review of Victoria Yudin’s new book, “Microsoft Dynamics GP 2010 Implementation“. Watch this space for a full review in the next few days.

Tool for Improving “Mark All” Speed in Contract Administration

This post provides a tool to improve the Mark All speed when working with the Revenue Recognition window in Contracts Administration.