February 2012 is Microsoft Dynamics Mayhem month over at Packt Publishing, the publishers of my Microsoft Dynamics GP 2010 Implementation book. What does this mean for you? If you have been waiting to pick up a copy of any of the Dynamics books (this includes GP, CRM, AX, NAV and even Sure Step), this is the [...]
Read more
SQL view for Payables payment apply detail in GP
I have published SQL views that return all posted Payables payments in Dynamics GP and Payables apply information to help identify what payments (or credits) paid off an invoice, however another frequent request is for a list of payments and their apply information. Below is a view that returns a list of all posted payments with details on how [...]
Read more
Using credit cards to pay vendors in Dynamics GP
There are a number of different ways to record paying vendors with credit cards in GP. This is a topic that comes up periodically in newsgroups and I would like to share what I have personally found to be the most straightforward and comprehensive way. This is a long one but at least there will be [...]
Read more
Year end close in Dynamics GP
Every year we get a slew of phone calls about closing the year in GP. Usually these start in December and I thought I would beat the rush this year. Here are some resources and notes I have compiled over the years on the year end close. I will add to this post as I find more [...]
Read more
SQL view to show AP apply information in GP
Here is a corollary to the view I posted last week. The view below will show you what payments/credit memos were applied to payables transactions in GP. If you have SmartList Builder you can easily incorporate this SQL view into a new SmartList. [Update: You can also use this in Crystal with the changes I made on [...]
Read more
February 12, 2012


