Victoria Yudin

| |

SQL view for sales quantities by item by site by month in Dynamics GP

Posted 5 days ago

by VictoriaYudin

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...
SQL view for SOP sales by customer by month

Posted 12 days ago

by VictoriaYudin

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...
Assign sequential numbers in SQL Server

Posted 1 month ago

by VictoriaYudin

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...
SQL view for current Receivables aging detail in Dynamics GP

Posted 1 month ago

by VictoriaYudin

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...
SQL view for current Payables aging detail in Dynamics GP

Posted 1 month ago

by VictoriaYudin

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...
Changing part of a string in SQL Server using REPLACE

Posted 3 months ago

by VictoriaYudin

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...
SQL view for sales quantities by item by site by year

Posted 3 months ago

by VictoriaYudin

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...
SQL view for Fixed Allocation Accounts in Dynamics GP

Posted 4 months ago

by VictoriaYudin

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...
Happy New Year – 2013

Posted 5 months ago

by VictoriaYudin

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...
How to add a sparkline to a report in SSRS

Posted 6 months ago

by VictoriaYudin

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...
Voiding a partially applied Payables transaction in Dynamics GP

Posted 8 months ago

by VictoriaYudin

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...
Big annoucement for Microsoft Dynamics GP’s Extender module

Posted 8 months ago

by VictoriaYudin

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...
Coding for specific dates in Crystal Reports

Posted 9 months ago

by VictoriaYudin

Below is an old tip from one of the GP Reports Viewer monthly newsletters . In the past few months I have had to look this up several times, because I just cannot seem to remember the syntax, so I thought I would put it on my blog, where it will be easier...
SQL view for rolling 12 months of sales by item in Dynamics GP

Posted 9 months ago

by VictoriaYudin

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...
SQL view for Variable Allocation Accounts in Dynamics GP

Posted 9 months ago

by VictoriaYudin

Below is a view that will return a list of the distribution and breakdown accounts for all active variable 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...
SQL view for commissions details in Dynamics GP

Posted 11 months ago

by VictoriaYudin

Commissions are typically difficult to create generic reports for, as many companies have unique commission structures. We find that out-of-the-box functionality in GP does not really work for most companies and often the commissions are recorded in ways...
Dynamics GP SOP line items with serial numbers and comments

Posted over 1 year ago

by VictoriaYudin

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...
Using Lookups in GP Reports Viewer to make parameter selection more user friendly

Posted over 1 year ago

by VictoriaYudin

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...
Concatenating strings in SQL Server

Posted over 1 year ago

by VictoriaYudin

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...
Finding resources

Posted over 1 year ago

by VictoriaYudin

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...
SQL view for sales quantities by customer by item by year

Posted over 1 year ago

by VictoriaYudin

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...
Emailing SOP invoices in GP 2010 made easy with GP Reports Viewer

Posted over 1 year ago

by VictoriaYudin

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...
Microsoft Dynamics Mayhem

Posted over 1 year ago

by VictoriaYudin

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...
SQL view for current Receivables aging in Dynamics GP

Posted over 1 year ago

by VictoriaYudin

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...
SQL view for sales quantities by item by year

Posted over 1 year ago

by VictoriaYudin

Even 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...

Microsoft Dynamics GP

About Victoria Yudin