As many variations for item quantity summaries as I think I have posted on this blog, there is always another one to be had. A request from a reader brings us a monthly version of my Sales Quantities by Item by Year. The view below shows the total item quantity sold by site by month for […]
Read more
Archive | Dynamics GP RSS feed for this section
SQL view for SOP sales by customer by month
June 7, 2013 
11 Comments
Someone asked me for code to get monthly SOP sales and I could have sworn I already had that. But I searched and didn’t come up with anything, so here is a new view to show SOP sales (the total of SOP invoices less returns) by month. As usual, I am making a few assumptions (listed […]
Read more Assign sequential numbers in SQL Server
May 7, 2013 2 Comments
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 SQL view for current Receivables aging detail in Dynamics GP
May 1, 2013 2 Comments
Another reader request brings us this new script. Below is a view for current Receivables aging in detail. This code is only looking at functional currency and will return one row per open (unpaid) receivables transaction. I am hard-coding the aging using the following buckets and aging by due date: Current 31 to 60 Days 61 to […]
Read more SQL view for current Payables aging detail in Dynamics GP
April 24, 2013 10 Comments
I have received a few requests for a detailed version my Current Payables Aging Summary view. Here it is. This code is only looking at functional currency and will return one row per open (unpaid) payables transaction. I am hard-coding the aging using the default aging setup installed with GP, which is aging by due date and using the […]
Read more Changing part of a string in SQL Server using REPLACE
March 11, 2013 3 Comments
This latest SQL Server tip comes from the Feb/March 2013 GP Reports Viewer newsletter. Have you ever needed to change part of a string in SQL Server? I have seen this come up in a variety of situations, like needing to change account names in the General Ledger or needing to show something differently when […]
Read more SQL view for sales quantities by item by site by year
February 28, 2013 2 Comments
Below is another variation on my view for sales by item by year and view for sales quantities by item by year. This one shows the total item quantity sold by site by year. The view below makes a number of assumptions (listed in the view comments in green), and I am hard coding years from 2006 through 2013 […]
Read more SQL view for Fixed Allocation Accounts in Dynamics GP
January 23, 2013 4 Comments
Below is a view that will return a list of the distribution accounts and percentages for all active fixed allocation accounts in your Dynamics GP. Nothing fancy, but sometimes it is easier to have a report of these rather than have to look at them on the screen, especially when you have a lot of […]
Read more 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 SQL view for rolling 12 months of sales by item in Dynamics GP
August 27, 2012 4 Comments
Rolling twelve month reports are not always very easy to create, and I have been seeing more requests for them, so I thought I would show an example of one way to do this. The view below is a variation of my sales by item by month view, however instead of specifying all months in […]
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...
-
-
-
