Victoria Yudin

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

June 14, 2013 by Victoria Yudin 4 Comments

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

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

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, GP Reports code, GP Reports Viewer, Sales Order Processing, SQL code

SQL view for current Receivables aging detail in Dynamics GP

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

GP Reports code, GP SQL view, Receivables, SQL code

SQL view for current Payables aging detail in Dynamics GP

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

GP Reports code, GP SQL view, Payables, SQL code

Changing part of a string in SQL Server using REPLACE

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

GP Reports code, GP Reports Viewer, 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 Fixed Allocation Accounts in Dynamics GP

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

General Ledger, GP Reports code, 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 Variable Allocation Accounts in Dynamics GP

August 23, 2012 by Victoria Yudin 7 Comments

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 the screen, specially since you have to click on […]

General Ledger, GP Reports code, 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

Concatenating strings in SQL Server

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

GP Reports code, GP Reports Viewer, 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

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

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

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

SQL view for Variable Allocation Accounts in Dynamics GP

SQL view for commissions details in Dynamics GP

Dynamics GP SOP line items with serial numbers and comments

Concatenating strings in SQL Server

SQL view for sales quantities by customer by item by year

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”