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
Archive by Author
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 Coding specific dates in SQL Server
September 13, 2010 3 Comments
Quite often when writing reports I need to write a formula to calculate dates. Dates are not very straightforward to code in SQL Server, and I have started keeping a list of various formulas so that I do not have to re-write the code every time. I have previously posted some code on calculating date differences in SQL, […]
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 readingRenaming tables in Crystal Reports
July 20, 2010 22 Comments
From the May 2010 GP Reports Viewer newsletter comes a tip for renaming the tables (or views or stored procedures) on Crystal Reports. Some may ask why this in needed – I actually use this quite a bit in the following scenario. I often find that I am using one report as a template for another […]
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 reading 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 […]
Continue readingUpdates to SQL view to show all GL distributions for AP transactions
June 25, 2010 9 Comments
I have made a number of updates to my SQL view to show all GL distributions for AP transactions since I first published it. Some of these were in response to comments asking for additional fields, others were added when I came across new data to test with. Rather than publish another post with the latest revisions, I have updated the […]
Continue readingAwesome 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 […]
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