Tag: check-failed
SQL view for sales by item by year
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.
Management Reporter versions
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
Microsoft Dynamics GP 2010 Implementation – now on Kindle!
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.
Sign up for Decisions Spring 2011
MSDynamicsWorld.com is putting on another virtual show in a few weeks called Decisions Spring 2011 .
SQL view for all GL transactions in Dynamics GP
I have been asked a few times now to add unposted General Ledger transactions to my
SQL view for last sale date of item
An interesting question came up in response to my last SQL view showing the last sale by customer and item .