Here is a cool little SQL Server tip from the April GP Reports Viewer newsletter. Say you have a list of rows and you want to assign sequential numbers to them, so that you always know which one is first, second, etc. Or so that you can display line numbers. This is often a need […]
Read more
Tag Archives: Dynamics GP
Happy New Year – 2013
January 1, 2013 
22 Comments
It’s now become a little tradition of mine to sit in front of the computer when I get up on New Year’s Day, sipping coffee and checking my email…hoping that I once again can write a little blog post like this one. I just got that email I was waiting for, letting me know that […]
Read more How to add a sparkline to a report in SSRS
November 27, 2012 3 Comments
Introduction: This blog post is written by my friend and colleague Mickie Stamm. Mickie is a fabulous Dexterity, SQL and application developer and is one of the great minds behind GP Reports Viewer. By Mickie Stamm: In the last GP Reports Viewer newsletter I wrote about using rectangles as containers in SQL Server Reporting Services […]
Read more Voiding a partially applied Payables transaction in Dynamics GP
October 11, 2012 4 Comments
Periodically I get calls or see questions online about how to void a partially applied Payables transaction in Dynamics GP. This is one area where the Payables module differs drastically from the Receivables module and you have to jump through some hoops to actually accomplish this. The issue is that when you go to void […]
Read more Big announcement for Microsoft Dynamics GP’s Extender module
October 8, 2012 19 Comments
Last week, while searching for something on Microsoft’s PartnerSource, I came across an announcement that Microsoft is discontinuing sales of the Extender module and that both sales and support of Extender will revert back to eOne Solutions, the original developer of Extender, starting February 1, 2013. Please note that eOne has always sold a more […]
Read more Using Lookups in GP Reports Viewer to make parameter selection more user friendly
May 31, 2012 3 Comments
One of the critical elements in reporting is parameter selection. During report creation it is essential to make sure that the proper parameters are added to the report to correctly filter on the data the users want to see. However, it doesn’t just stop there. To ensure user friendly reports it is also very important […]
Read more Finding resources
May 12, 2012 5 Comments
Almost on a daily basis I find myself looking for things like system requirements, end of support dates, build numbers and downloads for the various products that I work with. Even though search engines have greatly improved over the last few years, I still often struggle to find this information. While I consider myself to […]
Read more Emailing SOP invoices in GP 2010 made easy with GP Reports Viewer
February 29, 2012 9 Comments
Background / The Problem For many companies a long awaited new feature introduced with Dynamics GP 2010 was the ability to email SOP (Sales Order Processing) invoices directly from GP. Many of our customers have started to offer emailing of invoices to their customers and are seeing an increased number of requests for emailed invoices. However, […]
Read more SQL view for customer yearly totals in Dynamics GP
January 9, 2012 8 Comments
As a follow up to my SQL view for vendor yearly totals, here is something similar for customers. I have combined sales less credits/returns in one column, please take a look at the notes above the code (on lines 5 through 16 below) to see more details about the logic I am using. The code […]
Read more SQL view for vendor yearly totals in Dynamics GP
January 4, 2012 8 Comments
There has been a lot of talk lately about the year end close Payables and Receivables. I feel like I have spent the last week or two justifying my reasoning for not needing to perform the year end close for Payables and Receivables to many of my customers and blog readers. (For more on this, […]
Read more Decisions Fall 2011 – GP Day is today
December 6, 2011 3 Comments
Come talk to us about new features in GP Reports Viewer at MSDynamicsWorld’s Decisions Fall 2011 today. I will be there all day along with our senior developer and SRS expert Mickie Stamm.
Read more Protect your investment in Microsoft Dynamics GP
November 7, 2011 3 Comments
MSDynamicsWorld.com has just published my new article called Protect Your Investment: Five Things You Must Document in a Microsoft Dynamics GP Solution. For more of my articles on MSDynamicsWorld, take a look at my profile page. And while you’re there, don’t forget to register for Decisions Fall 2011.
Read more SQL view for SOP email setup in GP 2010
October 24, 2011 9 Comments
I am starting to work with emailing SOP documents using Dynamics GP 2010 and new functionality that we are going to be releasing in an upcoming build of GP Reports Viewer. It’s pretty cool stuff, however, as I am working with customers to set this up, we’re finding that out-of-the box GP does not have any […]
Read moreMy Book
-
Using credit cards to pay vendors in Dynamics GP
-
SQL view for Payables GL distributions in Dynamics GP
-
Year end close in Dynamics GP
-
SQL view for all posted GL transactions in Dynamics GP
-
SQL view with all SOP line items in Dynamics GP
-
Granting access to a new SmartList in Dynamics GP
-
SQL view to show AP apply information in GP
-
SQL view for Payables payment apply detail in GP
-
Sales Transaction Entry GL distributions in Dynamics GP
-
SQL view for sales by item by month
-
SQL view for sales quantities by item by site by month in Dynamics GP
-
SQL view for SOP sales by customer by month
-
Assign sequential numbers in SQL Server
-
SQL view for current Receivables aging detail in Dynamics GP
-
SQL view for current Payables aging detail in Dynamics GP
-
Changing part of a string in SQL Server using REPLACE
-
SQL view for sales quantities by item by site by year
-
SQL view for Fixed Allocation Accounts in Dynamics GP
-
Happy New Year – 2013
-
How to add a sparkline to a report in SSRS
-
Lien Mock: I would also make sure there aren't any remaining ...
-
Mike: Well, shoot. Thank you for the replies!...
-
Victoria Yudin: Mike, Sorry, I've not run into this situation bef...
-
-
-
-
Sarah: Many thanks - I would love that report even withou...
-
-
-
