Here is a new Dynamics GP SQL view in reponsse to a reader that liked my view for sales by item by year , but wanted to see the same thing by month. I am making a few assumptions (listed in the view comments), and am hard coding one year at a time (2011 in this example). You can easily change the year as needed for one year at a time