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 [...]
Read more
Tag Archives: Dynamics GP
How much training and for whom?
December 22, 2010
0 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.
Read more Seven proven tips for effective user training
December 17, 2010
2 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 [...]
Read more SQL queries for fiscal years and periods in Dynamics GP
November 24, 2010
4 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 [...]
Read more A new Dynamics GP blog – all the way from Canada
November 22, 2010
10 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, [...]
Read more Dynamics GP 2010 implementation book coming soon
November 15, 2010
21 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 [...]
Read more Get the most out of Dynamics GP
October 9, 2010
4 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 [...]
Read more Dynamics GP build numbers and service packs
September 11, 2010
7 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. I have also added some helpful links below each version. [...]
Read more5 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.
Read moreNew 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 [...]
Read more The Dynamics GP Cookbook is here
July 14, 2010
3 Comments
Mark Polino’s book, titled Microsoft Dynamics GP 2010 Cookbook, is out ahead of schedule! I think that’s the first time I have ever heard of something like that happening. I’ve already got my copy and as soon as I get a few minutes I am going to start reading it. In the meantime, you can read a [...]
Read moreAwesome resources available from Mark Polino
June 17, 2010
0 Comments
Mark Polino, one of the very first Dynamics GP bloggers and someone who has personally inspired me often with his writing, has done some spring cleaning on his blog. There is a ton of great content, but I would like to point out these two great resources: SQL Scripts - one location with descriptions and links for many [...]
Read moreCrystal Reports is not going anywhere
June 2, 2010
1 Comment
Are you using Crystal Reports with Dynamics GP? Are you starting to hear rumors that Crystal Reports is not supported with GP anymore? Don’t worry, Crystal Reports is not going anywhere. For more on this, take a look at my latest article for MSDynamicsWorld.com, The Good News for Users of Crystal Reports with Microsoft Dynamics GP.
Read moreMy Book
-
SQL view for Payables GL distributions in Dynamics GP
-
Using credit cards to pay vendors in Dynamics GP
-
Year end close in Dynamics GP
-
SQL view for Payables payment apply detail in GP
-
SQL view for all posted GL transactions in Dynamics GP
-
SQL view to show AP apply information in GP
-
SQL view with all SOP line items in Dynamics GP
-
Granting access to a new SmartList in Dynamics GP
-
Sales Transaction Entry GL distributions in Dynamics GP
- Dynamics GP Trial Balance in Excel using FRx
-
Finding resources
-
SQL view for sales quantities by customer by item by year
-
Emailing SOP invoices in GP 2010 made easy with GP Reports Viewer
-
Microsoft Dynamics Mayhem
-
SQL view for current Receivables aging in Dynamics GP
-
SQL view for sales quantities by item by year
-
SQL view for customer yearly totals in Dynamics GP
-
SQL view for vendor yearly totals in Dynamics GP
-
Happy New Year – 2012
-
SQL view to show monthly totals for Dynamics GP Vendors
-
Victoria Yudin: Hi Khan, GP does not store information about who ...
- Dynamics Confessor Blogspot - GP Technical Blogs - Microsoft Dynamics Community: [...] each module. If you are creating reports, or...
-
I Khan: Hi Victoria, I created a SmartList using Segment ...
-
-
kyle: Victoria, you have some great AP payment/apply sql...
-
-
-
Bill Schulz: Victoria - Your site is awesome. Thanks for thi...
-
Debbie: Thanks Victoria! I ran the query and had no resul...
-
