Tag: check-failed

SQL view for sales by item by year

| 08/11/2011 | 0 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.

Continue Reading

Management Reporter versions

| 07/04/2011 | 0 Comments

I am starting to do some work with Management Reporter, so I thought it would be useful to have a list of the versions for various service pack levels. What I have so far is only for version 2.0 and it may not be complete. If anyone has other versions, please let me know and I will update this list

Continue Reading

Microsoft Dynamics GP 2010 Implementation – now on Kindle!

| 06/23/2011 | 0 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, that is. As soon as I saw the email from my book’s editor saying it is now available on it, I placed the order for my own shiny new Kindle . There are some nice deals available, so it’s a great time to buy one.

Continue Reading

Sign up for Decisions Spring 2011

| 05/24/2011 | 0 Comments

MSDynamicsWorld.com is putting on another virtual show in a few weeks called Decisions Spring 2011 .

Continue Reading

Getting the name of a month from the month number in SQL Server

| 05/23/2011 | 0 Comments

I was creating a SmartList

Continue Reading

SQL view for all GL transactions in Dynamics GP

| 04/27/2011 | 0 Comments

I have been asked a few times now to add unposted General Ledger transactions to my

Continue Reading

SQL view for last sale date of item

| 03/31/2011 | 0 Comments

An interesting question came up in response to my last SQL view showing the last sale by customer and item .

Continue Reading