May is Dynamics Month over at Packt Publishing, the publisher for my Dynamics GP 2010 Implementation book, Mark Polino’s Dynamics GP 2010 Cookbook and a newly published Dynamics GP 2010 Reporting book. Now, I personally believe that every month is Dynamics month ;-), but if you’ve been waiting to get your Dynamics books, now is […]
Continue reading
Archive by Author
SQL view for all GL transactions in Dynamics GP
April 27, 2011 
43 Comments
I have been asked a few times now to add unposted General Ledger transactions to my Posted GL Transactions view. Here it is. This view also excludes voided transactions and introduces new columns for transaction status and source doc. To see more information about GL tables in Dynamics GP, visit my GL Tables page. For more Dynamics […]
Continue reading SQL view for last sale date of item
March 31, 2011 35 Comments
An interesting question came up in response to my last SQL view showing the last sale by customer and item. How do you show the latest sale of an item and who the customer was for that particular sale? This is a bit more difficult, as you have to make two passes through the data, first […]
Continue reading SQL view for last sale by customer and item
March 29, 2011 18 Comments
When was the last time a particular customer bought a particular item? Here is a little view that will tell you. For other Dynamics GP views and reporting tips, take a look at my GP Reports page. Or check out the SOP Tables page for more details about reporting on SOP data. ~~~~~ CREATE VIEW view_Last_Sale_By_Customer_Item AS /******************************************************************* […]
Continue reading Vote for the top 100 most influential Microsoft Dynamics people
March 17, 2011 8 Comments
DynamicsWorld is once again holding their annual vote for the top 100 most influential Microsoft Dynamics people. If you’ve been inspired or helped by anyone you can show your appreciation by voting for them. The main voting page has a list of all the nominees and a bunch of links to the polls, but it’s a […]
Continue reading Customer shipping addresses in Dynamics GP
February 18, 2011 16 Comments
Need to see a list of all the shipping addresses for your Dynamics GP customers? You can use the view below which pulls out the ship to address and the associated tax schedule, shipping method , salesperson, etc. To see other SQL views for Dynamics GP receivables data, take a look at the Receivables SQL Views page. For […]
Continue reading Yearly Fixed Assets depreciation totals in Dynamics GP
February 15, 2011 13 Comments
Around this time of year we get a lot of questions about closing the year for the Dynamics GP Fixed Assets module, since you cannot run January depreciation until you close the prior year. And right after we start getting requests for reports of prior year depreciation. Here is a view that shows year to date, last year […]
Continue reading Mark Polino interviews…me!
February 14, 2011 1 Comment
Mark Polino, one of the original Dynamics GP bloggers, a fellow Microsoft Dynamics GP MVP and book author, just published an interview with me about my book, Implementing Dynamics GP 2010. This was the first book interview I did and I was a little nervous, but Mark is a very good listener and knows just how […]
Continue reading New look for my blog
February 11, 2011 6 Comments
Every once in a while I like to change the look and feel of my blog. Partly because I get bored with the same old, same old. Partly because I think everyone else does. too. New blog themes can also offer new features. Over the past week I have been transitioning to a new blog theme with what I hope […]
Continue reading Results of SQL Server poll
February 8, 2011 0 Comments
It has been about a month and 119 people voted, so I wanted to share the results of my SQL Server poll. I asked what version of SQL Server my readers were using for their Dynamics GP and here are the results: While I am glad to see that only a few voters (5%) are on […]
Continue reading Dynamics GP inventory by location with dates and sites
January 29, 2011 13 Comments
In response to a request from a reader, I have created a new version of the Inventory with Dates script to show the same information by Site ID. I also added a Quantity on Order column. You can see more Dynamics GP Inventory scripts here. Or visit my GP Reports page for links to additional GP […]
Continue reading Change GP fiscal period names using SQL Server
January 27, 2011 15 Comments
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 Microsoft Monday at Packt Publishing
January 24, 2011 2 Comments
Packt Publishing, the company that published my book, Implementing Microsoft Dynamics GP 2010, is starting a Microsoft Monday campaign. In addition to releasing a slew of new Microsoft books, there are offering some great discounts and a weekly raffle – you can win a one year subscription to PacktLib, their online digital book library.
Continue reading SQL Server poll
January 14, 2011 5 Comments
I am starting to see articles and blog posts about Microsoft SQL Server 2011 everywhere, so I thought I would poll my readers to ask versions of SQL Server you are using. The poll is below: Once I have some results back, I will post an update. In the meantime, keep in mind that SQL Server […]
Continue reading 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 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