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 [...]
Read more
Customer shipping addresses in Dynamics GP
February 18, 2011
1 Comment
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 [...]
Read more
Yearly Fixed Assets depreciation totals in Dynamics GP
February 15, 2011
6 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 [...]
Read more
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 [...]
Read more
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 [...]
Read more
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 [...]
Read more Dynamics GP inventory by location with dates
January 29, 2011
10 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 [...]
Read more
Change GP fiscal period names using SQL Server
January 27, 2011
8 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 [...]
Read more
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.
Read more 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 [...]
Read more
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 [...]
Read more
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 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...
-
