In response to a reader request, I have created this new view based on my Vendor Yearly Totals view that will show monthly totals for your Dynamics GP Vendors for all years. This view will show both the numbers and names of the months and assumes that you have 12 periods corresponding to the calendar […]
Continue reading
Archive | Dynamics GP RSS feed for this section
Decisions Fall 2011 – GP Day is today
December 6, 2011 
3 Comments
Come talk to us about new features in GP Reports Viewer at MSDynamicsWorld’s Decisions Fall 2011 today. I will be there all day along with our senior developer and SRS expert Mickie Stamm.
Continue reading Protect your investment in Microsoft Dynamics GP
November 7, 2011 3 Comments
MSDynamicsWorld.com has just published my new article called Protect Your Investment: Five Things You Must Document in a Microsoft Dynamics GP Solution. For more of my articles on MSDynamicsWorld, take a look at my profile page. And while you’re there, don’t forget to register for Decisions Fall 2011.
Continue reading SQL view for SOP email setup in GP 2010
October 24, 2011 9 Comments
I am starting to work with emailing SOP documents using Dynamics GP 2010 and new functionality that we are going to be releasing in an upcoming build of GP Reports Viewer. It’s pretty cool stuff, however, as I am working with customers to set this up, we’re finding that out-of-the box GP does not have any […]
Continue reading SQL view for bank deposits and receipts in Dynamics GP
October 6, 2011 11 Comments
About a year ago I published a view for a Checkbook Register and have received some follow up requests asking for a way to show the receipt details. Primarily this request seems to come from the need to see the difference in dates between the receipts and the deposits for tracking down possible bank reconciliation issues. I didn’t want to […]
Continue reading SQL view for current Payables aging in Dynamics GP
September 30, 2011 51 Comments
Over the past few years I have had several requests for a summary current Payables aging report that can be easily exported into Excel. Yes, you can play with the Report Writer aging report to take out the headers and make it export to Excel, but sometimes there are other reasons for wanting a report outside […]
Continue reading SQL view for user activity in Dynamics GP
September 12, 2011 21 Comments
There are many different pieces of code that I have seen for this over the years, but more often than not what our users ask me for is a way to quickly see who is logged into GP, what company, and when did they log in. While this can easily be seen on the User Activity window (GP | […]
Continue reading SQL view for sales by item by month
August 29, 2011 48 Comments
Here is a new Dynamics GP SQL view in reponsse to a reader that liked my view for sales by item by year, but wanted to see the same thing by month. I am making a few assumptions (listed in the view comments), and am hard coding one year at a time (2011 in this example). You can easily […]
Continue reading SQL view for sales by item by year
August 11, 2011 34 Comments
I had a request from a blog reader for a view that shows sales of items by year. This seemed like pretty useful code to create, so I put the following view together. I am making a few assumptions (listed in the view comments), and am hard coding years from 2005 through 2011. You can easily change the years or […]
Continue reading Microsoft Dynamics GP 2010 Implementation – now on Kindle!
June 23, 2011 3 Comments
Yes, you read that right – my Microsoft Dynamics GP 2010 Implementation book is now on Kindle! I have been thinking about getting a Kindle for a while, and have admired the few I have seen owned by friends and family, but there was no compelling enough reason for me to get one. Until now, […]
Continue reading Sign up for Decisions Spring 2011
May 24, 2011 3 Comments
MSDynamicsWorld.com is putting on another virtual show in a few weeks called Decisions Spring 2011. My company, Flexible Solutions, has been a sponsor at the last few Decisions events and they just keep getting better. All the Dynamics products have their own day, Dynamics GP day is June 15. You can read all about the exciting […]
Continue reading Dynamics Month at Packt Publishing
May 16, 2011 1 Comment
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 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 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 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 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