Tag Archives: featured
chart

Refreshable Excel report for historical GL trial balance in Dynamics GP

Want to see your historical General Ledger trial balance in Excel? Yes, you can always print out the one from GP and dump it to Excel and manipulate the results, but there is an easier way. Below is a stored procedure you can use to create this. As an added bonus, if you’re using GP Reports Viewer you can […]

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

Follow

Get every new post delivered to your Inbox.

Join 1,992 other followers