Tag Archives: Inventory
hand truck

SQL view for sales quantities by customer by item by year

March 9, 2012 by Victoria Yudin 2 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
Dynamics GP, GP Reports code, GP SQL scripts, SOP SQL code, Inventory SQL code
, , , ,
boxes

Dynamics GP inventory by location with dates

January 29, 2011 by Victoria Yudin 10 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 [...]

Read more
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 7 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 – [...]

Read more
Dynamics GP, GP Reports code, GP SQL scripts, Inventory SQL code
, , ,

SQL view for inventory items and dates

December 4, 2009 by Victoria Yudin 17 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 [...]

Read more
Dynamics GP, GP Reports code, GP SQL scripts, Inventory SQL code
, , ,

SQL view for inventory quantities on hand

June 18, 2009 by Victoria Yudin 15 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 [...]

Read more
Dynamics GP, GP Reports code, GP SQL scripts, Inventory SQL code
, , ,

SQL view to show customer pricing

January 7, 2009 by Victoria Yudin 12 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 [...]

Read more
Dynamics GP, GP Reports code, GP SQL scripts, Inventory SQL code
, , ,
officechairguy

Year end close in Dynamics GP

November 14, 2008 by Victoria Yudin 60 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 [...]

Read more
Dynamics GP
, , , , , , , ,

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

Read more
Dynamics GP
, ,

Follow

Get every new post delivered to your Inbox.

Join 486 other followers