Victoria Yudin

Assign sequential numbers in SQL Server

May 7, 2013 by Victoria Yudin 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 […]

Dynamics GP, featured, GP Reports code, GP Reports Viewer, Sales Order Processing, SQL code

SQL view for sales quantities by item by site by year

February 28, 2013 by Victoria Yudin 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 […]

GP Reports code, Sales Order Processing, SQL code

SQL view for rolling 12 months of sales by item in Dynamics GP

August 27, 2012 by Victoria Yudin 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 […]

GP Reports code, Inventory, Sales Order Processing, SQL code

SQL view for commissions details in Dynamics GP

July 19, 2012 by Victoria Yudin 3 Comments

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 other than what was intended. That said, if you find that you are using the commissions functionality […]

GP Reports code, Receivables, Sales Order Processing, SQL code

Dynamics GP SOP line items with serial numbers and comments

June 4, 2012 by Victoria Yudin 9 Comments

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). […]

GP Reports code, GP SQL view, Sales Order Processing, SQL code

SQL view for sales quantities by customer by item by year

March 9, 2012 by Victoria Yudin 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 […]

GP Reports code, GP SQL view, Inventory, Sales Order Processing, SQL code

Emailing SOP invoices in GP 2010 made easy with GP Reports Viewer

February 29, 2012 by Victoria Yudin 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, […]

Dynamics GP, GP 2010, GP Reports Viewer, Sales Order Processing

SQL view for sales quantities by item by year

January 23, 2012 by Victoria Yudin 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, […]

GP Reports code, Sales Order Processing, SQL code

SQL view for sales by item by month

August 29, 2011 by Victoria Yudin 41 Comments

Here is a new Dynamics GP SQL view in reponsse to a reader that liked my view for sales by item by year, but wanted to see the same thing by month. I am making a few assumptions (listed in the view comments), and am hard coding one year at a time (2011 in this example). You can easily […]

GP Reports code, Sales Order Processing, SQL code

SQL view for sales by item by year

August 11, 2011 by Victoria Yudin 33 Comments

I had a request from a blog reader for a view that shows sales of items by year. This seemed like pretty useful code to create, so I put the following view together. I am making a few assumptions (listed in the view comments), and am hard coding years from 2005 through 2011. You can easily change the years or […]

GP Reports code, Sales Order Processing, SQL code

SQL view for last sale date of item

March 31, 2011 by Victoria Yudin 12 Comments

An interesting question came up in response to my last SQL view showing the last sale by customer and item. How do you show the latest sale of an item and who the customer was for that particular sale? This is a bit more difficult, as you have to make two passes through the data, first […]

GP Reports code, GP SQL view, Sales Order Processing, SQL code

SQL view for last sale by customer and item

March 29, 2011 by Victoria Yudin 15 Comments

When was the last time a particular customer bought a particular item? Here is a little view that will tell you. For other Dynamics GP views and reporting tips, take a look at my GP Reports page. Or check out the SOP Tables page for more details about reporting on SOP data. ~~~~~ CREATE VIEW view_Last_Sale_By_Customer_Item AS /******************************************************************* […]

GP Reports code, GP SQL view, Sales Order Processing, SQL code

What’s with all these dates?

September 8, 2009 by Victoria Yudin 11 Comments

There are many different dates stored in Dynamics GP. This is typically a good thing, my philosophy is that it is always better to have more data than you need and not the other way around. However, it can get confusing rather quickly since a lot of the labels for the dates sound very similar. I will attempt […]

Dynamics GP

Bank Reconciliation, Dynamics GP, General Ledger, Payables, Purchase Order Processing, Receivables, Sales Order Processing

Assign sequential numbers in SQL Server

SQL view for sales quantities by item by site by year

SQL view for rolling 12 months of sales by item in Dynamics GP

SQL view for commissions details in Dynamics GP

Dynamics GP SOP line items with serial numbers and comments

SQL view for sales quantities by customer by item by year

Emailing SOP invoices in GP 2010 made easy with GP Reports Viewer

SQL view for sales quantities by item by year

SQL view for sales by item by month

SQL view for sales by item by year

SQL view for last sale date of item

SQL view for last sale by customer and item

What’s with all these dates?

Search this blog:

My Book

Email Subscription

GP Reports Viewer Newsletter

RSS Feeds

Latest Tweets

Links

Forums

Blogroll

Pages

Categories

Hits since 9.17.2008

Archives

Follow “Victoria Yudin”