Tag Archives: Inventory

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

April 20, 2017 by Victoria Yudin 12 Comments

By popular request I have created a variation on my rolling 12 months of sales by item to show a rolling 12 months of sales by item and site ID in Dynamics GP. This view will return the last 12 months, not including the current month. So if you’re running this today – April 20, […]

Continue reading →
Dynamics GP, GP Reports code, GP SQL scripts, Inventory SQL code, SOP SQL code, Uncategorized
, , ,

Dynamics GP sales amounts and quantities for rolling 12 months

March 14, 2017 by Victoria Yudin 17 Comments

Dynamics GP sales amounts and quantities for rolling 12 months

Continue reading →
Dynamics GP, GP Reports code, GP SQL scripts, Inventory SQL code, SOP SQL code
, , ,

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

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

Continue reading →
Dynamics GP, GP Reports code, GP SQL scripts, Inventory SQL code, SOP SQL code
, , ,

SQL view for sales quantities by customer by item by year

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

Continue reading →
Dynamics GP, GP Reports code, GP SQL scripts, Inventory SQL code, SOP SQL code
, , , ,

Dynamics GP inventory by location with dates and sites

January 29, 2011 by Victoria Yudin 13 Comments

In response to a request from a reader, I have created a new version of the Inventory with Dates script to show the same information by Site ID. I also added a Quantity on Order column. You can see more Dynamics GP Inventory scripts here. Or visit my GP Reports page for links to additional GP […]

Continue reading →
Dynamics GP, GP Reports code, GP SQL scripts, Inventory SQL code
, , ,

SQL view for Inventory Price Levels in Dynamics GP

August 9, 2010 by Victoria Yudin 16 Comments

When you are creating prices for different price levels in Dynamics GP, there is no easy way to see these, or to see all the prices for a particular price level. Below is a view that can help with this. ~~~~~ CREATE VIEW view_Inventory_Price_Levels AS /******************************************************************* view_Inventory_Price_Levels Created on Aug 9, 2010 by Victoria Yudin – […]

Continue reading →
Dynamics GP, GP Reports code, GP SQL scripts, Inventory SQL code
, , ,

SQL view for inventory items and dates

December 4, 2009 by Victoria Yudin 45 Comments

This view is a little bit of a twist on my previous SQL view for inventory quantities on hand. The results of this view will give you a list of your Microsoft Dynamics GP inventory items, current quantities and the last sales and purchase dates along with the vendor. For other SQL views on Dynamics GP data, please visit […]

Continue reading →
Dynamics GP, GP Reports code, GP SQL scripts, Inventory SQL code
, , ,

SQL view for inventory quantities on hand

June 18, 2009 by Victoria Yudin 27 Comments

I haven’t had much time to blog lately as we have added functionality to our GP Reports Viewer product that allows seamless replacement of SOP reports in Dynamics GP and the amount of interest has been overwhelming.  However, I just needed to create a new SmartList to show current inventory quantities on hand with their costs and I […]

Continue reading →
Dynamics GP, GP Reports code, GP SQL scripts, Inventory SQL code
, , ,

SQL view to show customer pricing

January 7, 2009 by Victoria Yudin 16 Comments

Here is a view to show customer specific item pricing in Dynamics GP when using standard pricing.  This will work either with SmartList Builder or Crystal Reports as I have made sure not to put any spaces in the names.  If you are using SmartList Builder this means you may want to go down the […]

Continue reading →
Dynamics GP, GP Reports code, GP SQL scripts, Inventory SQL code
, , ,

Year end close in Dynamics GP

November 14, 2008 by Victoria Yudin 102 Comments

Every year we get a slew of phone calls about closing the year in GP. Usually these start in December and I  thought I would beat the rush this year. Here are some resources and notes I have compiled over the years on the year end close. I will add to this post as I find more […]

Continue reading →
Dynamics GP, GP 10.0, GP 2010, GP 2013, GP 2015, GP 8.0, GP 9.0
, , , , , , , ,

Dynamics GP Inventory table information

October 23, 2008 by Victoria Yudin 0 Comments

I’ve posted up a new page with GP Inventory table information.  You can see the entire list of modules available so far on the main GP Reports page.  That page also has links to additional resources and the GP SQL views I’ve posted recently.  I’ve gotten some requests for other modules, so I’ll work on putting those together next.  Is there […]

Continue reading →
Dynamics GP
, ,