Tag Archives: featured

SQL view for unposted checks in Dynamics GP

August 29, 2017 by Victoria Yudin 11 Comments

I have been asked more than a few times for a script that shows uposted checks and their apply detail. This can be helpful to replace the Check Batch Edit List report, which is universally hated by all GP users I have spoken to. create view view_unposted_check_batch as — ~ ~ ~ ~ ~ ~ […]

Continue reading →
Dynamics GP, GP Reports code, GP SQL scripts, Payables SQL code
, , , ,

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

November 24, 2014 by Victoria Yudin 16 Comments

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 →
Dynamics GP, Excel reports, GP Reports Viewer
, , ,

Year end close in Dynamics GP

November 14, 2008 by Victoria Yudin 102 Comments

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 →
Dynamics GP, GP 10.0, GP 2010, GP 2013, GP 2015, GP 8.0, GP 9.0
, , , , , , , ,