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 my [...]
Posts Tagged ‘Inventory’
SQL view for inventory items and dates
Posted in GP Reports, GP SQL scripts, tagged Dynamics GP, GP Reports, Inventory, SQL code on December 4, 2009 | 6 Comments »
SQL view for inventory quantities on hand
Posted in GP Reports, GP SQL scripts, tagged GP Reports, GP SQL view, Inventory, SQL code on June 18, 2009 | 10 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 wanted [...]
SQL view to show customer pricing
Posted in GP Reports, GP SQL scripts, tagged GP Reports, GP SQL view, Inventory, SQL code on January 7, 2009 | 10 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 [...]
Year end close in Dynamics GP
Posted in Dynamics GP, tagged Dynamics GP, Fixed Assets, General Ledger, Inventory, Payables, Payroll, Receivables, year end close on November 14, 2008 | 20 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 [...]
Dynamics GP Inventory table information
Posted in Dynamics GP, GP Reports, tagged GP Reports, GP table information, Inventory on October 23, 2008 | Leave a Comment »
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 [...]