Based on some reader requests, this new view is a combination of my All SOP Line Items view and the recently posted script showing how to get a concatenated list of serial numbers in SQL. This new view will return all posted (history) or unposted (open) Sales Order Processing line items with the associated serial numbers (or lot numbers). […]
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
Concatenating strings in SQL Server
May 21, 2012 6 Comments
This SQL Server tip comes from the April 2012 edition of the GP Reports Viewer newsletter. A request that we have seen many times when creating SOP invoices for Dynamics GP is to concatenate serial numbers. So if there is an item with serial numbers, instead of showing a list with one serial number per […]
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
SQL view for sales quantities by customer by item by year
March 9, 2012 7 Comments
Seems like no many how many variations of sales reports there are, people will always want more. I recently had a request for something similar to my view for sales quantities by item by year, but also adding in the customer. Below is code for a view to accomplish this. This view makes a number of […]
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
Microsoft Dynamics Mayhem
February 12, 2012 5 Comments
February 2012 is Microsoft Dynamics Mayhem month over at Packt Publishing, the publishers of my Microsoft Dynamics GP 2010 Implementation book. What does this mean for you? If you have been waiting to pick up a copy of any of the Dynamics books (this includes GP, CRM, AX, NAV and even Sure Step), this is the […]
Read more
SQL view for current Receivables aging in Dynamics GP
January 25, 2012 37 Comments
I have created a variation on my view that shows all unapplied Receivables transactions to show customer aging in buckets. This is only looking at functional currency and will return data in summary, meaning one row per customer with a balance. I am hard-coding the aging using the default aging setup installed with GP, which is aging by […]
Read more
SQL view for sales quantities by item by year
January 23, 2012 9 Comments
Ever since I published my view for sales by item by year I started receiving requests for the same type of view showing quantities instead of amounts. There are two ways of doing this, once from inventory and another from sales. Hard to say which is the best, as I have seen arguments for both, […]
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
Happy New Year – 2012
January 2, 2012 14 Comments
I found out yesterday that I have been awarded the Microsoft Most Valuable Professional Award for Dynamics GP for another year. This makes the 8th year in a row for me. I am very honored to get this award again and would like to thank everyone that reads my blog – this would not be possible without you! […]
Read more
SQL view to show monthly totals for Dynamics GP Vendors
December 9, 2011 6 Comments
In response to a reader request, I have created this new view based on my Vendor Yearly Totals view that will show monthly totals for your Dynamics GP Vendors for all years. This view will show both the numbers and names of the months and assumes that you have 12 periods corresponding to the calendar […]
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 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
-
SQL view for all posted GL transactions in Dynamics GP
-
Sales Transaction Entry GL distributions in Dynamics GP
-
SQL view for sales by item 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
-
Voiding a partially applied Payables transaction in Dynamics GP
-
Big announcement for Microsoft Dynamics GP’s Extender module
-
Victoria Yudin: Jimmy, Thanks for the heads up, the links should ...
-
-
Brian: Good morning Victoria. I am new to GP and I'm t...
-
-
Rolan Hinayon: Hi Victoria I am newbie here but it feels li...
-
Jimmy Darkmoon: Great blog. But the zip files says "no archive fo...
-
Flor: Great! So simple yet so effective unlike other com...
-
-
Calvin: Thanks Victoria, that worked. I gave permissions t...
-
