Page 1 of 3123

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.

Taken from:
SQL view for sales by item by year

August 11, 2011 · Victoria Yudin · No Comments
Tags: , , , , , , ,  · Posted in: Blogs I Follow Total Views: 331

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 …

Read more here:
Management Reporter versions

July 4, 2011 · Victoria Yudin · No Comments
Tags: , , ,  · Posted in: Blogs I Follow Total Views: 714

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, …

See the original post here:
Microsoft Dynamics GP 2010 Implementation – now on Kindle!

June 23, 2011 · Victoria Yudin · No Comments
Tags: , , , , ,  · Posted in: Blogs I Follow Total Views: 592

Sign up for Decisions Spring 2011

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 …

Follow this link:
Sign up for Decisions Spring 2011

May 24, 2011 · Victoria Yudin · No Comments
Tags: , , , , , , ,  · Posted in: Blogs I Follow Total Views: 340

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

I was creating a SmartList for a customer recently and was using the GL11110 and GL11111 views in GP for monthly summaries of P&L accounts, but wanted to show the month names instead of period ID’s to make it a bit more user-friendly. I could have linked to the fiscal period setup table to get the period names, but …

See the rest here:
Getting the name of a month from the month number in SQL Server

May 23, 2011 · Victoria Yudin · No Comments
Tags: , , , , , , ,  · Posted in: Blogs I Follow Total Views: 498

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 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 …

See more here:
SQL view for all GL transactions in Dynamics GP

April 27, 2011 · Victoria Yudin · No Comments
Tags: , , , , , , ,  · Posted in: Blogs I Follow Total Views: 430

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. 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 …

Read more:
SQL view for last sale date of item

March 31, 2011 · Victoria Yudin · No Comments
Tags: , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 370