Looking at PC World’s The 10 Most Overrated Productslist this morning I came accross one near and dear to me: Overrated: Windows XP; Underrated: Windows Vista. I have been using Vista for well over a year now. Love it. Absolutely love it. One of the reasons I do what I do is that I love technology. […]
Continue reading
Archive by Author
What version of SQL Server am I running?
October 5, 2008 
4 Comments
Here is a summary list of the major releases and service packs for Microsoft SQL Server: SQL RTM SP 1 SP 2 SP 3/3a SP 4 2000 8.00.194 8.00.384 8.00.532 8.00.760 8.00.2039 2005 9.00.1399 9.00.2047 9.00.3042 9.00.4035 9.00.5000 2008 10.00.1600.22 10.00.2531 10.00.4000 10.00.5500 10.0.6000.29 2008 R2 10.50.1600.1 10.50.2500 10.50.4000 10.50.6000.34 2012 11.00.2100.60 11.00.3000.0 11.00.5058.0 […]
Continue readingGP Table Information
October 3, 2008 1 Comment
We have been collecting a lot of information while creating reports with GP for all these years. Some of it is stored in our overworked and under-rested brains (well, most of it)…but a bit here and there we’ve actually committed to some sort of electronic format. I will be adding to it over time, but […]
Continue readingSQL Server 2008 Videos
October 2, 2008 2 Comments
I just came across this very un-Microsoft looking Microsoft webiste for SQL Server. There are a number of videos here geared towards different audiences. I haven’t watched them all, but I did find Scott Konersmann’s video about upgrading to SQL 2008 very interesting. And some of the For Fun videos are pretty funny – especially “It […]
Continue readingNo more Small Business Financials
October 1, 2008 1 Comment
I remember when I first heard about Microsoft Small Business Financials (SBF). I think the unofficial name was something like Great Plains Basic. This was before it actually came out with the name Small Business Manager. Ah, how Microsoft loves to change product names. But I digress. We had many prospects at the time that were just not […]
Continue readingMicrosoft to redefine Partner Program
September 29, 2008 1 Comment
When Microsoft bought Great Plains Software in 2001 most existing GP Partners that were not Microsoft Partners already became part of the Microsoft Partner Program. It took many years to actually integrate all the systems and databases and my personal experience has shown that this integration is not quite complete yet. In the meantime, partners have been getting used to the […]
Continue readingWhat Service Pack am I on?
September 27, 2008 12 Comments
Something I find very useful is to have a chart of all the various service packs and versions so that I can quickly determine what build numbers really mean and where to find them inside GP. Click here for a PDF with the GP 10.0 service pack versions. And below are charts for GP […]
Continue readingLimitations on data in GP?
September 23, 2008 0 Comments
One of the benefits of Dynamics GP being on Microsoft SQL Server is that there are virtually no limitations on the number of entries of a particular type. But the question does come up a lot. What’s the maximum number of customers or customer addresses, or sales transactions, or line items can I have in GP […]
Continue readingNew Microsoft Ads
September 22, 2008 0 Comments
The new Microsoft ads, part of the $300 million “Windows. Life without walls” campaign are histerical! Two of them feature Bill Gates and Jerry Seinfeld and some other news ads are coming soon to combat Mac’s ads blasting Windows Vista. You can even try to become part of the ads and appear on the Times Square billboards. […]
Continue readingThe Funniest T-Shirts
September 19, 2008 0 Comments
I just got an e-mail update for what I think are the funniest t-shirts. In general Despair, Inc. is a wonderful source of entertainment for me. Their calendars are fabulous and the ability to get them printed up with custom messages for each day is really cool.
Continue readingService Pack 4 for Dynamics GP 9.0
September 17, 2008 0 Comments
Service Pack 4 for Dynamics GP 9.0 is out! Looks like this is the last Service Pack for GP 9.0. On one hand I find that a little strange since GP 9.0 will be supported until 2011. On the other hand, GP 9.0 is very stable and I really don’t hear of too many things that […]
Continue readingJust back from The Partner Event
September 17, 2008 0 Comments
First morning back from going to The Partner Event in Fargo. We had a wonderful time – met a lot of great people, got some excellent advice in the sessions, gave away lots of prizes, and won some money playing blackjack. Can you ask for more out of a trip? I love going to these […]
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 to show AP apply information in GP
-
Sales Transaction Entry GL distributions in Dynamics GP
-
SQL view for Payables payment apply detail 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