Archive | November, 2014

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

SQL stored procedure for all open AR transactions by customer name

November 24, 2014 by Victoria Yudin 7 Comments

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 →
Dynamics GP, GP Reports code, GP SQL scripts, Receivables SQL code
, , ,