AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • Rolodex
    • Podcast
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • GI Library
    • Consulting
  • Register

Custom Explore Query

December 28, 2013 by Tim Rodman

One of my favorite features in Sage 500 is Business Insights Explorer. Recently though, I was pleased to discover that Acumatica has a similar feature.

Each module in Acumatica has an Explore section in the Work Area area. For example, in the Accounts Payable module, there are five menu options available in the Explore section: Vendor Summary, Vendor Details, Bills Pending Payments, Checking Pending Printing, and 1099 Year Summary.
2013-12-27_014758

However, you have the option to add your own menu options using the Generic Inquiry feature located at System -> Customization -> Manage -> Generic Inquiry.

Just create a title for your inquiry and fill out the tabs on the bottom. I’m going to create a simply list of vendor invoices by filling out the following information in the Generic Inquiry screen:

2013-12-27_022223

2013-12-27_022303

2013-12-27_022419

2013-12-27_022540

2013-12-27_022620

2013-12-27_022724

As long as you fill out the Site Map Location and Site Map Title fields, your new custom inquiry should be available on the Acumatica menu like this (after you save it of course):

2013-12-27_022943

In my Vendor Invoices inquiry, you can now just input a beginning and ending invoice date, then click the Refresh icon, and the list of invoices will appear in the grid below. Since Acumatica knows what each field is, it makes the file attachment and record note icons available for each record in the grid. It also gives you a hyperlink on the Reference Nbr. and Vendor fields which allows you to click the link and automatically be taken to the actual invoice or vendor screens.

2013-12-27_023032

 

In conclusion, this is a very flexible and powerful feature that allows you to create data inquiry screens on the Acumatica menu that are customized to fit your company’s specific business needs.

Filed Under: Miscellaneous Tagged With: Acumatica, Acumatica Blog, Acumatica Generic Inquiry, Acumatica Training, Acumatica vs. Sage 500, Sage 500 ERP Explorer Alternatives

By using this website, you agree to our Terms of Use (click here)
Building Generic Inquiries & Pivot Tables

Online Members

 No online members at the moment

Recent Blog Posts

  • acuCONNECT 2025 – Visualizing Inventory Balance $ and Service Level % TOGETHER September 19, 2025
  • EP 157: acuCONNECT 2025 Preparation – Part 4 (Podcast) September 16, 2025
  • EP 156: acuCONNECT 2025 Preparation – Part 3 (Podcast) September 6, 2025
  • EP 155: Chris Hackett – Update on Acumatica User Groups (Podcast) August 26, 2025
  • EP 154: acuCONNECT 2025 Preparation – Part 2 (Podcast) August 5, 2025

Recent Forum Posts

  • Travis

    RE: Pick List report suddenly not splitting on Shipment

    I never found a solution initially - here I am 3 years ...

    By Travis , 2 weeks ago

  • ToonSix

    RE: Feeling Stuck on Making a Sandbox of our Database

    Delete as many snapshots as possible before making a ne...

    By ToonSix , 2 weeks ago

  • Retha

    RE: Printing Product Labels from Purchase Receipt

    I have read the article on the How to print multiple pr...

    By Retha , 3 weeks ago

  • Paul Lambert

    RE: Generic Inquiry into Business Event to monitor Import Scenarios

    An idea I've been brainstorming and haven't yet tested ...

    By Paul Lambert , 3 weeks ago

  • Jacky Mao

    How to make Customer Class ID available in Business Events for AR302000 (Payments and Applications)

    Hi everyone, I’m trying to create a Business Event fo...

    By Jacky Mao , 3 weeks ago

  • Lunar Windbloom

    Feeling Stuck on Making a Sandbox of our Database

    Hi all! Hope your day is going well! It's finally the...

    By Lunar Windbloom , 1 month ago

  • Tim Laird

    RE: [SOOrder.Status] = 'Open' always returns false

    @russ Customer Classes are user maintained, so you setu...

    By Tim Laird , 1 month ago

  • Tim Laird

    RE: What Triggers a Customization to need a Restart?

    OK, one more update. This creeped up again this weeken...

    By Tim Laird , 1 month ago

  • russ

    RE: [SOOrder.Status] = 'Open' always returns false

    This trick doesn't seem to work anymore. At least not ...

    By russ , 1 month ago

Terms of Use & Disclaimers :: Privacy Policy

Copyright © 2025 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

wpDiscuz