Tag Archives: featured
3d small person and a service bell. 3d image. Isolated white background.

Updating Dynamics GP data directly in SQL

I would like to start by saying that I do not normally advocate updating Dynamics GP data directly in SQL Server. Most of the things you need to do should be handled either inside the Dynamics GP application or with integration tools like Integration Manager or eConnect. This is especially true of transactional data and […]

Continue reading
3d small person in a pose of surprise. 3d image. White background.

Did you know you can change Void dates on Payables transactions?

I often surprise people by telling them to change the void dates when they void Payables transactions in Dynamics GP. If you’re voiding something that was just entered, leaving the defaulted dates is usually fine. However, when you are voiding an old check because you’re going to re-issue it, you typically want to void using the same date as the […]

Continue reading

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
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