I have posted up a new page with Dynamics GP Fixed Assets table information. This is part of my ongoing library of Dynamics GP reporting information. A directory of all the information I’ve posted up so far is on the main GP Reports page.
Continue reading
Archive | Dynamics GP RSS feed for this section
Dynamics GP Integration Manager – vote for product suggestions
November 17, 2008 
0 Comments
Beth Gardner, Support Escalation Engineer for Microsoft Dynamics GP, is looking for votes on product suggestions for Integration Manager. GP users ask us all the time how to get their suggestions implemented – this is the way. Microsoft does look at what customers are saying and the way to get the functionality you want included into future versions is to […]
Continue reading Year end close in Dynamics GP
November 14, 2008 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 readingMDA is here to stay
November 12, 2008 0 Comments
Thanks to Mark Polino at DynamicAccounting.net for alerting me to Microsoft’s announcement that Multidimensional Analysis (MDA) will continue to be sold and supported for Dynamics GP. Mark’s post has a link to the official announcement, however if you do not have access to Microsoft Dynamics PartnerSource you won’t be able to get to it. The basic gist […]
Continue readingSQL view for Crystal Reports to show open AP invoices from multiple companies in GP
November 10, 2008 0 Comments
In my experience Crystal Reports really doesn’t like it when you have spaces in your field names. I’ve gotten a request for a ‘Crystal’ version of the Multicompany Open AP view I posted up a few days ago, so here it is. Please follow the in-line directions in green to change the generic company names […]
Continue readingSQL view to show open AP invoices from multiple companies in GP
November 8, 2008 0 Comments
If you have multiple companies in GP and want to create a quick view to show a combined list of all the open AP invoices, you can use the example below. I am not doing anything fancy here, just hard coding the company names and database ID’s. In my experience this is a set list for most […]
Continue readingAdding Extender Data to SmartLists
November 3, 2008 35 Comments
This has been a very popular question for support lately: “I have created an Extender window, how do I add data from it to my SmartLists?” Extender includes the ability to add fields to both existing SmartLists or ones created in SmartList Builder. Below is an example using GP 9.0. [Click on any of the […]
Continue readingSQL Server – how to get date differences
October 27, 2008 8 Comments
Often, when writing a report, we need to calculate the difference between two dates or the difference between a date and today. For example – how old is an invoice? How many days overdue is an invoice? Below is some SQL code that will help. First, if you need to dynamically get the current date […]
Continue readingWant Dexterity training? Tell David what and where!
October 23, 2008 0 Comments
We commonly refer to David Musgrave as the King of Dexterity. I am sure others do, as well. In a recent post on the Developing for Dynamics GP blog David asked the GP community at large what training we’d like to see and where. This is our chance to be heard and maybe to finally get some local training! Not […]
Continue readingDynamics GP Inventory table information
October 23, 2008 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 SQL view to show AP apply information in GP
October 22, 2008 108 Comments
Here is a corollary to the view I posted last week. The view below will show you what payments/credit memos were applied to payables transactions in GP. If you have SmartList Builder you can easily incorporate this SQL view into a new SmartList. [Update: You can also use this in Crystal with the changes I made on […]
Continue readingSQL view to show what check paid a Purchase Order
October 17, 2008 14 Comments
There is no easy way in Dynamics GP to see what check or credit memo was applied to a particular Purchase Order. Here is a SQL view that can be used in SmartList Builder or any other reporting tool you choose to see this information. For other SQL scripts please visit my GP Reports Page. ~~~~~ […]
Continue readingService Pack 3 for Dynamics GP 10.0
October 16, 2008 2 Comments
Service Pack 3 for Dynamics GP 10.0 has just been released. This service pack is cumulative – it includes all fixes and enhancements that were included in all previous service packs, hotfixes, and compliance updates. It does not include US Payroll tax tables. I have updated my post that details all the GP service pack versions to include […]
Continue readingDynamics GP GL table information
October 13, 2008 0 Comments
A new page has been posted up with the General Ledger table information. A list of all the various pages available can be seen on the main GP Reports page. I have also included links there to some additional reporting resources published by fellow Dynamics GP bloggers.
Continue readingDynamics GP POP table information
October 10, 2008 2 Comments
There is a new page with information now available for Purchase Order Processing tables. I have also updated the Company/System Tables page with more data. As always, you can see a list of all the information available so far on the main GP Reports page, which will also show the dates the individual pages have […]
Continue reading Granting access to a new SmartList in Dynamics GP
October 8, 2008 74 Comments
We have been seeing a lot of questions on granting access to new SmartList Builder SmartLists. Because this is so different from older versions of Dynamics GP, we’ve created a really detailed list to go through it. This may be overkill for some, but it will hopefully cover every needed scenario. (Update: These instructions will work for […]
Continue reading When does my GP product’s support end?
October 8, 2008 22 Comments
Here is a list I refer to all the time when I need to find out when a GP version came out and when support will end: Product Version Product Release/Start Mainstream Support End Extended Support End Additional information GP 6.0 03/31/2004 n/a n/a GP 7.0 03/31/2005 n/a n/a GP 7.5 07/01/2003 01/09/2007 n/a Link […]
Continue readingDynamics GP SOP table information
October 7, 2008 0 Comments
I have posted up a new page for SOP Tables to help with reporting on GP Sales Order Processing data. I also have a complete list with updated dates on my main GP Reports page so that you can see what has new content and what is coming in the future. If there is any information you’d […]
Continue readingMy Last Book
Dynamics GP 2013 Implementation
My Previous Book
Dynamics GP 2010 Implementation
-
Using credit cards to pay vendors in Dynamics GP
-
SQL view for Payables GL distributions in Dynamics GP
-
SQL view for all posted GL transactions in Dynamics GP
-
SQL view to show AP apply information in GP
-
Sales Transaction Entry GL distributions in Dynamics GP
-
SQL view for Payables payment apply detail in GP
-
Year end close in Dynamics GP
- SQL view with AR apply detail
-
Granting access to a new SmartList in Dynamics GP
-
SQL view with all SOP line items in Dynamics GP
-
SQL view for unposted checks in Dynamics GP
-
SQL view for rolling 12 months of sales by item by site in Dynamics GP
-
Dynamics GP sales amounts and quantities for rolling 12 months
-
Updating Dynamics GP data directly in SQL
-
Did you know you can change Void dates on Payables transactions?
-
Refreshable Excel report for monthly actuals vs. budgets in Dynamics GP
-
SQL code to show top X percent of vendor data
-
Discount from Packt Publishing
-
Refreshable Excel report for historical GL trial balance in Dynamics GP
-
Refreshable Excel report for monthly GL budget in Dynamics GP
-
Victoria Yudin: Hi Matthew, This is a limitation in GP. "Why" is ...
-
Matthew: Why does "Sales" type distr...
-
-
Kevin Mackol: Does this still work on new...
-
-
Alex: Hi Victoria, Hi Victoria, Hi Victoria,Thank you so mu...
Victoria Yudin 
Recent Blog Comments