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...]
Acumatica Inventory Aging Report
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...]
Acumatica Comma-Separated List of Purchase Orders for a Vendor using Velixo Reports
You can use Velixo Reports and Acumatica to get a comma-separated list of Purchase Orders for a list of Vendors. … [Read more...]
Acumatica Comma-Separated List of Purchase Orders for a Vendor using Microsoft Excel
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...]
Acumatica Comma-Separated List of Shipments for a Sales Order using a Generic Inquiry and SQL View
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...]
Acumatica Dashboard Tips and Tricks (Part 2)
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...]
Acumatica Dashboard Tips and Tricks (Part 1)
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...]