# Acumatica Generic Inquiry Design Template > Source: https://netray.co/tools/acumatica-generic-inquiry-design-template > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer A fill-in design specification for a Generic Inquiry (SM208000): purpose, tables and joins, result columns, parameters, access rights and test cases. ## Category other-erp ## Erp Acumatica ## Audience - Acumatica consultant - Business analyst - ERP administrator ## Tool **Kind:** template **Output:** document **Fields:** #### Company **Key:** company **Type:** text **Default:** Northfield Fabrication Inc. #### Inquiry title **Key:** gi_name **Type:** text **Default:** Open Production Orders by Work Center #### Author **Key:** author **Type:** text **Default:** A. Rivera #### Date **Key:** date **Type:** date **Default:** 2026-10-20 #### Business purpose **Key:** purpose **Type:** textarea **Default:** Give the production supervisor a daily list of released production orders with remaining quantity and promised date, grouped by work center. #### Primary table **Key:** primary_table **Type:** text **Default:** AMProdItem #### Joined tables **Key:** joins **Type:** textarea **Default:** InventoryItem on InventoryID, Customer on CustomerID (left join) #### Conditions **Key:** conditions **Type:** textarea **Default:** Status equals Released, Quantity Remaining greater than 0 #### Parameters **Key:** params **Type:** text **Default:** Warehouse, Promised Date From, Promised Date To #### Roles with access **Key:** audience **Type:** text **Default:** Production Supervisor, Planner **Blocks:** #### Generic Inquiry Design Specification **Body:** Company: {{company}} Inquiry: {{gi_name}} Author: {{author}} Date: {{date}} #### 1. Business purpose **Body:** {{purpose}} #### 2. Data source **Body:** Primary table: {{primary_table}} Joins: {{joins}} #### 3. Conditions and parameters **Body:** Conditions: {{conditions}} Parameters (shown above the grid): {{params}} #### 4. Result grid columns **Table:** **Columns:** - Column heading - Source object.field - Sort - Total - Link to screen **Rows:** **0:** Order number **2:** Asc **0:** Item **0:** Remaining qty **3:** Sum **0:** Promised date #### 5. Access and publishing **Body:** Roles with access: {{audience}} Site map location: ______ Expose via OData: Yes / No Expose to Power BI: Yes / No #### 6. Test cases **Table:** **Columns:** - Test - Input - Expected result - Pass **Rows:** **0:** Default parameters **0:** Date range with no data **0:** User without role **2:** Not visible #### Approvals **Signatures:** - Business owner - Acumatica administrator - Developer **Notes:** Table and field names are examples; confirm the actual DAC and field names in the Generic Inquiry designer on your version. Treat this as a design starting point and adapt it to your change control process. ## Content **Intro:** A Generic Inquiry in Acumatica is easy to build and easy to build badly. This template captures the purpose, tables, joins, conditions, parameters and security up front so the build takes an hour and the result matches what the business asked for. **Sections:** #### How to use the template **Body:** Fill the fields at the top, then print or export the document and complete the grid column table with the business user. Writing the column list first forces the conversation about what the user really needs to see. Hand the finished spec to whoever builds the inquiry on the Generic Inquiry screen, and keep it with your configuration documentation so the next consultant understands why joins and conditions exist. #### Design choices that matter **Body:** The primary table decides performance and the shape of the result. Join only what you display or filter on, use left joins when the related record may be missing, and add conditions in the inquiry rather than filtering on screen. Parameters should be limited to what the user changes daily. Decide early if the inquiry is also exposed through OData for Power BI or Excel, because that affects naming and security. **Bullets:** - Start from the most selective table - Prefer fewer joins, test with real volumes - Name columns for the business, not the database - Set navigation links so users can drill to the source screen #### Testing and handover **Body:** Test with empty results, a large date range and a user who lacks the role. Compare totals to an existing report or screen before release. Record the access rights and the site map location in the spec so support can answer who can see it. When data volumes grow, revisit the joins first, since an extra join on a transaction table is the most common cause of slow inquiries. **Cta:** If your team keeps building one inquiry after another for the same questions, we can show you how a read-only natural language layer over Acumatica data reduces that backlog. **Faq:** #### What is a Generic Inquiry in Acumatica? **Answer:** It is a configurable query tool, opened on the Generic Inquiry screen, that lets an administrator combine tables, set conditions and define result columns without writing code. The result appears as a screen with a grid, and can be exported or exposed through OData. #### Should I use a Generic Inquiry or a report? **Answer:** Use a Generic Inquiry for interactive lists, filtering and export. Use a report designed in the report designer when you need a pixel-controlled printable layout with grouping and headers, such as an invoice or a formal document. #### Why is my inquiry slow? **Answer:** Usually too many joins on large transaction tables, missing selective conditions, or sorting on non-indexed fields. Remove joins you do not display, add a date or status condition, and test the filter against production-sized data. #### Can I secure a Generic Inquiry by role? **Answer:** Yes. Access is granted through the access rights for the inquiry screen, so you can limit it to specific roles. Remember that data visibility for the underlying records can also be restricted by branch or restriction groups. ## Search terms acumatica generic inquiry template, acumatica generic inquiry design, acumatica gi joins, acumatica sm208000, acumatica report requirements template, acumatica inquiry specification, acumatica gi parameters, acumatica custom report spec --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json