AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • In-Person Gatherings
    • Power BI Workshop
    • Podcast
    • Rolodex
    • 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 164: Phil Steichen – Vibe Coding your own Business Intelligence tool (Podcast) February 19, 2026
  • EP 163: Daryl Bowman – Dissecting the new Acumatica Calendar Board (Podcast) February 9, 2026
  • EP 162: Gabriel Michaud – Catching up on new cool stuff in Velixo and Excel (Podcast) February 2, 2026
  • Acumatica Summit 2026 – Day 2 Keynote (Seattle, WA) January 27, 2026
  • Acumatica Summit 2026 – Day 1 Keynote (Seattle, WA) January 26, 2026

Recent Forum Posts

  • Tami

    RE: Production Orders with all material on hand

    @timrodmanrodman Question for you. What table joins d...

    By Tami , 42 minutes ago

  • Brynn Rutherford

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

    @timrodman - It won't let me attach the file. I will em...

    By Brynn Rutherford , 1 day ago

  • Tami

    RE: Production Orders with all material on hand

    @timrodman Thank you! We just upgraded to 2025R1 in ...

    By Tami , 1 day ago

  • Tim Rodman

    RE: Production Orders with all material on hand

    @tlynn Looks like someone already created a product ide...

    By Tim Rodman , 1 day ago

  • Tami

    RE: Production Orders with all material on hand

    @timrodman Yes! If that parameter was optional it wo...

    By Tami , 1 day ago

  • Tim Rodman

    RE: Can not delete an automated schedule

    I doubt it since Business Events are stored on the Busi...

    By Tim Rodman , 2 days ago

  • Tim Rodman

    RE: Production Orders with all material on hand

    Is the problem with this Critical Materials (AM401000) ...

    By Tim Rodman , 2 days ago

  • Tim Rodman

    RE: Update the Unit Rate for Existing Project Templates

    The following worked for me.   Here's the Data...

    By Tim Rodman , 2 days ago

  • Tim Rodman

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

    Can you export the Generic Inquiry to XML and upload it...

    By Tim Rodman , 2 days 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.