AugForums.com

An Acumatica User Group

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

The Wyatt.ERP Technique for Generic Inquiries

February 18, 2022 by Tim Rodman

Acumatica Generic Inquiries are very powerful. Learn the Wyatt.ERP Technique to make them even more powerful in your organization. What is the Wyatt.ERP Technique for Generic Inquiries in Acumatica? I call it the Wyatt.ERP Technique because Wyatt.ERP (click here) is the person on AUGForums.com that I learned this technique from. His username is a clever play on the famous Wyatt Earp lawman in the Old American West. WANTED DEAD OR ALIVE: Tricky problems that you don’t think … [Read more...]

Filed Under: Acumatica Learning Tagged With: Acumatica, Acumatica Blog, Acumatica Generic Inquiries, Acumatica Generic Inquiry Guide, Acumatica Learning, Acumatica Training, Acumatica Tutorials, Acumatica User Group, Acumatica Video Training

Acumatica Inventory Aging Report

January 17, 2022 by Tim Rodman

Are you looking for an Inventory Aging report in Acumatica? Here is one way that you can build one using a Generic Inquiry. Does Acumatica have an Inventory Aging report? Well, not out-of-the-box, but we can build one. Acumatica does have the Inventory Valuation (IN615500) report which looks like this: But, what if we want to see the Total Cost broken out between different Aging Buckets? 30 days, 60 days, 90 days, etc. We can list the aging buckets as separate … [Read more...]

Filed Under: Acumatica Learning Tagged With: Acumatica, Acumatica Blog, Acumatica Generic Inquiries, Acumatica Generic Inquiry Guide, Acumatica Learning, Acumatica Training, Acumatica Tutorials, Acumatica User Group, Acumatica Video Training

Acumatica Comma-Separated List of Purchase Orders for a Vendor using Velixo Reports

February 11, 2021 by Tim Rodman

You can use Velixo Reports and Acumatica to get a comma-separated list of Purchase Orders for a list of Vendors. … [Read more...]

Filed Under: Acumatica Learning Tagged With: Acumatica, Acumatica Blog, Acumatica Generic Inquiries, Acumatica Learning, Acumatica Reporting Tools, Acumatica Training, Microsoft Excel, Velixo Reports

Acumatica Comma-Separated List of Purchase Orders for a Vendor using Microsoft Excel

February 2, 2021 by Tim Rodman

You can use Microsoft Excel and OData in Acumatica to get a comma-separated list of Purchase Orders for a list of Vendors. … [Read more...]

Filed Under: Acumatica Learning Tagged With: Acumatica, Acumatica Blog, Acumatica Generic Inquiries, Acumatica Learning, Acumatica Reporting Tools, Acumatica Training, Microsoft Excel, Power BI

Acumatica Comma-Separated List of Shipments for a Sales Order using a Generic Inquiry and SQL View

January 26, 2021 by Tim Rodman

You can use a SQL View in Acumatica to generate a comma-separated list of Shipments for a Generic Inquiry list of Sales Orders. … [Read more...]

Filed Under: Acumatica Learning Tagged With: Acumatica, Acumatica Blog, Acumatica Generic Inquiries, Acumatica Learning, Acumatica Reporting Tools, Acumatica SQL Views, Acumatica Training

Acumatica Dashboard Tips and Tricks (Part 2)

December 28, 2018 by Tim Rodman

How do you get started with Acumatica Dashboards? Here are some Acumatica Dashboard Tips and Tricks to help you. This post is part 2 of 2. … [Read more...]

Filed Under: Acumatica Reporting Tagged With: Acumatica, Acumatica Blog, Acumatica Dashboards, Acumatica Generic Inquiries, Acumatica Learning, Building Dashboards in Acumatica

Acumatica Dashboard Tips and Tricks (Part 1)

November 30, 2018 by Tim Rodman

How do you get started with Acumatica Dashboards? Here are some Acumatica Dashboard Tips and Tricks to help you. This post is part 1 of 2. … [Read more...]

Filed Under: Acumatica Reporting Tagged With: Acumatica, Acumatica Blog, Acumatica Dashboards, Acumatica Generic Inquiries, Acumatica Learning, Building Dashboards in Acumatica

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

  • EP 161: Arline Welty – Evaluate Acumatica with YOUR DATA before you buy (Podcast) January 12, 2026
  • EP 160: How long does it take an Automation Schedule to run in Acumatica (Podcast) November 7, 2025
  • EP 159: Mark Safran – Smartsheet Dashboards with Acumatica data (Podcast) October 29, 2025
  • EP 158: Garrett Rochell – Acumatica Upgades, especially with the Modern UI (Podcast) October 4, 2025
  • acuCONNECT 2025 – Visualizing Inventory Balance $ and Service Level % TOGETHER September 19, 2025

Recent Forum Posts

  • Brynn Rutherford

    Can't export GI's to excel that contain the FATrans DAC after upgrade to 2025 R1 in less than 25 min

    Hi, We have a Fixed Asset Generic Inquiry that combin...

    By Brynn Rutherford , 3 days ago

  • Lunar Windbloom

    RE: Feeling Stuck on Making a Sandbox of our Database

    @timrodman @toonsix Thank you! I need to figure out why...

    By Lunar Windbloom , 1 week ago

  • Tim Rodman

    RE: Attribute Input Mask

    Regular Expressions are a standard Linux thing and you ...

    By Tim Rodman , 1 week ago

  • Tim Rodman

    RE: Feeling Stuck on Making a Sandbox of our Database

    Ya, if you can't get the size down by deleting the snap...

    By Tim Rodman , 1 week ago

  • Tim Rodman

    RE: What Triggers a Customization to need a Restart?

    @tlaird self-hosting totally makes sense to me for peop...

    By Tim Rodman , 1 week ago

  • Tim Rodman

    RE: Invoice subreport for line-level tax breakdown not tieing to taxes subtotal

    It's not really an Acumatica problem huh; it's a math p...

    By Tim Rodman , 1 month ago

  • Rob Neal

    Invoice subreport for line-level tax breakdown not tieing to taxes subtotal

    We have a customer with a modified SO invoice form that...

    By Rob Neal , 1 month ago

  • Tim Rodman

    RE: Generic inquiry with information from Audit history(CT301000)

    @graemelm Just pulled it in as a Custom DAC fed by the ...

    By Tim Rodman , 2 months ago

  • Tim Rodman

    RE: Importing Acumatica User Roles / User Security Permissions from Excel

    @astra-mathis thank you for the detailed instructions. ...

    By Tim Rodman , 2 months ago

Terms of Use & Disclaimers :: Privacy Policy

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