Sage 100

I'm trying to pull sales data that can be sliced and diced by customer, SKU, date, sales rep, etc. but ties exactly to the GL. So far, the reports I can get using Microsoft Query all have great data, but it won't tie to the GL. There has to be a simple…