Every time I create a new fiscal year in Dynamics GP or show customers how to do it, I get a little frustrated that I have to manually rename all the periods. Some users may not care that instead of January GP displays Period 1, but I don’t think that is very user friendly. So, for more years […]
Continue reading
Archive | Dynamics GP RSS feed for this section
Happy New Year – 2011
January 1, 2011 
13 Comments
The hard-working folks at Microsoft just let me know that I have been awarded the Microsoft Most Valuable Professional Award for Dynamics GP for another year. This makes the 7th year in a row for me. I would like to thank all of the people who have written to let me know that my blog posts and forum […]
Continue reading How much training and for whom?
December 22, 2010 2 Comments
MSDynamicsWorld.com has just published a follow up to my last article about user training, called “Plan your Microsoft Dynamics GP Training: How Much and For Whom?” This article is an excerpt from my book, Microsoft Dynamics GP 2010 Implementation, and discusses some ideas to keep in mind as you plan user training for a Dynamics GP implementation.
Continue reading Seven proven tips for effective user training
December 17, 2010 4 Comments
Planning training for your Microsoft Dynamics GP users? MSDynamicsWorld.com just published an article called “How Great Microsoft Dynamics GP Trainers Do It: Seven Proven Tips for Effective User Training”. This article is adapted from my new book, Microsoft Dynamics GP 2010 Implementation, and is geared towards new GP implementations, although some of these concepts are true for […]
Continue reading SQL queries for fiscal years and periods in Dynamics GP
November 24, 2010 9 Comments
Often when creating reports we’re asked to show the current year vs. last year or select the current fiscal year or period as a date range for values returned. Sometimes dates can be hard-coded, especially when the fiscal year is the calendar year. But some reports can be made more dynamic by using the fiscal periods set up in […]
Continue reading A new Dynamics GP blog – all the way from Canada
November 22, 2010 13 Comments
I had the pleasure of speaking to Jen Kuntz earlier today, who runs Kuntz Consulting Inc. and recently started a blog about her experiences with Dynamics GP. Jen told me about her blog while we were on the phone and I went to check it out right away. Looking at the list of recent blog topics, […]
Continue reading Dynamics GP 2010 implementation book coming soon
November 15, 2010 22 Comments
My book, Microsoft Dynamics GP 2010 Implementation, is off to the publishing house and should be ready to ship soon. While the primary goal of the book is to help with new implementations of GP in small to mid-size companies, there’s something in it for everyone. Just to highlight part of the content, this book has step-by-step […]
Continue reading See you at Decisions Fall 2010
November 2, 2010 3 Comments
Today is Microsoft Dynamics GP day at the Decisions Fall 2010 virtual conference. I will be at the Flexible Solutions booth talking about our GP Reports Viewer add-on. For anyone not familiar with it, GP Reports Viewer is a solution to manage Crystal and SSRS reports inside Dynamics GP. Decisions Fall 2010 is free, so there is no reason not to […]
Continue reading SQL view for Dynamics GP Checkbook Register
October 14, 2010 30 Comments
The view below will return all Checkbook transactions for Dynamics GP. It does not show details for the deposits because I wanted to keep this to one line per transaction, as it appears on the Checkbook Register in GP. To add deposit detail to you report, you can join table CM20300 on CM20200.CMTrxNum = CM20300.depositnumber. You […]
Continue reading Get the most out of Dynamics GP
October 9, 2010 5 Comments
Often when working with companies using Dynamics GP I come across users struggling to find things, taking significant detours to accomplish their tasks, and many that don’t know the application can do what they need. I also frequently get asked for resources to help learn GP better. An amazing resource now available is the Microsoft Dynamics GP […]
Continue reading SQL view for Payables apply detail and GL distributions in Dynamics GP
September 23, 2010 37 Comments
Who doesn’t need yet another view for Payables transactions in Dynamics GP? 🙂 The view below is a combination of my Payment Apply Detail and GL Distributions for AP Transactions views. It lists all Payments, then shows the transactions they were applied to and the GL distributions of those applied to transactions. You can find other Dynamics GP Payables […]
Continue reading Dynamics GP build numbers and service packs
September 11, 2010 34 Comments
I have posted a number of different resources in the past for finding Dynamics GP service pack levels based on build numbers, however, I wanted to put together something where you can check the major service pack builds for the main GP components all in one place. As new service packs come out, I will update […]
Continue reading SQL view for Payables invoices originating from POP in Dynamics GP
September 1, 2010 40 Comments
This Dynamics GP SQL view originated from a request on the Dynamics GP customer forum, but is also something that I can see being useful in a variety of situations. It returns all posted Payables invoices that came from the Purchase Order Processing module with details of the items that were received on each invoice as well […]
Continue reading5 questions to answer when writing a report spec
August 31, 2010 0 Comments
Are you a Dynamics GP user who needs to request a report? Or a consultant working on a report specification for Dynamics GP data? Anyone that needs or creates reports for Dynamics GP can benefit by knowing the Five Questions You Need to Answer When Creating a Microsoft Dynamics GP Report Specification.
Continue readingSQL view for asset account numbers in Dynamics GP
August 10, 2010 4 Comments
Want to see all the account numbers set up for all your Fixed Assets? You can do this in SmartList, but SmartList is sometimes limiting when you want to do complex searches. Here is a view that will return all the account numbers assigned for each asset in Dynamics GP. ~~~~~ CREATE VIEW view_Asset_Accounts AS /******************************************************************* view_Asset_Accounts […]
Continue readingSQL view for Inventory Price Levels in Dynamics GP
August 9, 2010 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 readingNew resource to find Dynamics GP table and field information
July 23, 2010 4 Comments
Since I have posted a lot of Dynamics GP table information and SQL code, I often get asked the question “what table holds ____ “? Sometimes I just know the answer off the top of my head (yeah, I think that’s scary, too), but once in a while I have to look it up. I have various […]
Continue readingSQL view to show yearly totals for Dynamics GP Vendors
July 15, 2010 15 Comments
Below is a view that will show yearly totals for your Dynamics GP Vendors. It’s something we have used internally for a while, but I have recently gotten a few requests for it, so I cleaned it up and am sharing it. This will show yearly totals for calendar years. If you want to use fiscal years […]
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