Create customer and product queries

Written By Ascend knowledge base (Administrator)

Updated at September 13th, 2023

The Customer and Product query tools let you easily create your own custom reports in Ascend to fit your needs.

You can access your custom repots by clicking the Reports icon on the Ascend desktop. Then click the icon near the top to open the query screen you want.

Screenshot of the Cust. Query and Prod. Query icons

Create a customer or product query

There are some slight differences between the customer and product query screens, but for the most part, your options are the same.

  1. Choose a Report Type using the dropdown menu. The report type options vary based on if you're creating a Customer or Product Query
  2. Set a date range or check the box for All Dates instead
  3. Decide how your results should appear using Order By
  4. Choose the Sort Order
  5. Under Return Set, All is selected by default - but you can change that to Top by Number or Top by Percent to see specific results
    Screenshot with the Report Type section highlighted
  6. Use the Search Field dropdown and the Search Constraint dropdown, and type a keyword in the Search Criteria box, if needed.
    Screenshot with the Search Field dropdown and the Search Constraint dropdowns highlighted
  7. Use the filers on the right side to narrow down your results even more.
    For example, check the box for Category to see all the categories in the shop in the next column. Now check the box for Bikes.Screenshot with the Filters section highlighted
    Note: When you select a Category, any lower-level child categories for the Category are included in your report as well.
  8. If you filter by category or vendor, you can also check the box for Not in Category or Not in Vendor.
    Side by side screenshots, one has the Not in Category button not clicked and highlighted. The other has the Not in Vendor check box unchecked and highlighted
    Note: If you select Vendor filters, keep in mind that once an item is received, Ascend cannot tell which vendor the product came from. Products will display for every vendor you could possibly receive the product from - so if it isn’t a proprietary item, you could get duplicated quantities for each result.
  9. Look at the lower left field, where you can see an auto-generated summary of the report being generated.
    Screenshot with the box under Current Report highlighted
  10. If needed, select the Totals Only icon. This is a great tool to see total sales, COGS, Discounts, etc. over a period of time for all your products, specific categories, Work Orders, and so on.
    Screenshot with the Totals Only icon highlighted
  11. Select Execute.

Working with the results

After you run your report, you can do a lot with the results.

Highlight a product or customer in the middle of the screen to see specific information about them on the bottom. For example, a highlighted customer might show any sales items sold to that customer in your date range.

In this image, a highlighted product in the top shows us when it was sold in our date range and included transaction information such as which customer bought it.

Screenshot of the Product Query window

You can print, email, or export these results as needed - the icons in the middle apply to the that table of data, while the icons in the lower part of the screen apply to those results.

Or print Mailing Labels for the customers using the Label icon. But you might want to check the box for Add “Or Current Resident” to Mailing Labels first.

Screenshot of the dropdown under Label open and Individual is selected

Additional Resources