Tag Archives: featured

Create a refreshable Excel report based on a SQL Server stored procedure

A long awaited new feature is being released today for our GP Reports Viewer – Excel reports. What I think is truly amazing about this new feature is the fact that you can set up an Excel report based on a stored procedure to allow users to enter parameters and also to improve performance of your reports. […]

Continue reading

SQL stored procedure for all open AR transactions by customer name

A little variation on my Unapplied AR Transactions view, this SQL stored procedure will return all open (unapplied) receivables transactions for customers with a name containing what is supplied as the parameter. In case you’re wondering why I am all of a sudden posting a stored procedure, I am going to follow this up later […]

Continue reading
flying-credit-card

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 […]

Continue reading
officechairguy

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 […]

Continue reading

Follow

Get every new post delivered to your Inbox.

Join 1,625 other followers