Every month, we send a "Top 100 Best Sellers of the Year" email newsletter to our customers. In Sage 50, we could create a "best sellers" list simply by creating a Stock Report, selecting to add the column for Sales Qty Year to Date, exporting to Excel, then sorting that column from Largest to Smallest. Voila.

In Sage 100, we're slightly stumped. We haven’t found anything that would be equivalent despite experimenting with all of these reports: Inventory Sales Analysis, Inventory Item Listing with Sales Hist, and Monthly Sales Report. No luck.

The only one remotely close to meeting our needs was Inventory Sales History Report, but because of how every report is formatted (including this one), it’s impossible to sort by quantity sold while keeping the item code and title on the same line.

It seems like something that probably has a simple solution. Any ideas?