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 reading
Archive by Author
Adding 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 readingWhen does my SQL Server support end?
October 29, 2008 15 Comments
Did you know that mainstream support for SQL 2012 ended in July of 2017? Here is a list of the SQL versions and the relevant release and support end dates: SQL Server Version Release Date End of Mainstream Support End of Extended Support Link SQL 7 Mar 01 1999 Dec 31 2005 Jan 11 […]
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 readingCrystal Reports book recommendation
October 20, 2008 3 Comments
Recently I picked up an excellent book on Crystal Reports. I was looking for answers to some of my more difficult questions, primarily in the area of special formatting and cross tab reports. This book has helped answer my questions and then some. Since I get asked for recommendations on Crystal Reports books all the time, I thought I […]
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 readingWindows 7 to be called … Windows 7
October 14, 2008 0 Comments
Looks like Microsoft decided on an official name for the next version of Windows, internally called ‘Windows 7’. After names like XP and Vista, the new naming is pretty simple – Windows 7. You can see a bit more background and reasoning in Mike Nash’s blog about it. (Mike Nash is a Microsoft Corporate VP, Windows Product Management.) […]
Continue reading FRx Service Packs
October 13, 2008 12 Comments
Here is another handy list with all the service pack build versions for FRx 6.5 and 6.7. You will need to have access to either PartnerSource or CustomerSource to be able to get to all the links below. FRx FRx 6.7 Available for GP FRx 6.5 RTM 6.7.141 SP 1 6.7.1013 08/30/2004 6.5.38 SP 2 6.7.2013 […]
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 readingBest breakfast!
October 10, 2008 1 Comment
Anyone that knows me well will tell you that not only do I not cook, but I should not be allowed near a stove. Disasterous things have been known to happen simply by my proximity to a stove, or really any cooking implements. I’m lucky I am still allowed in the kitchen. However, I got really […]
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 for Payables payment apply detail in GP
-
Sales Transaction Entry GL distributions in Dynamics GP
-
SQL view to show AP apply information 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