Effective inventory management is crucial for any manufacturing or distribution business. In Acumatica, the inventory module tracks stock levels, warehouse locations, and movement history. However, having access to this raw data isn’t enough—you need clear, actionable reports that help you understand your inventory performance at a glance.

AstraReports gives you the power to create sophisticated inventory reports that transform complex warehouse data into meaningful insights. Let’s explore how to build a comprehensive inventory and warehouse reporting solution in AstraReports.

Key Inventory Data Points in Acumatica

Before building your reports, it’s important to understand the main Acumatica tables that contain inventory information:

IN.InventoryItem: Contains the master list of items, including item ID, description, unit of measure (UOM), and item class. This is your foundation table for any inventory report.

IN.ItemWarehouseDetails: Stores warehouse-specific data for each item, including quantity on hand (QtyOnHand), quantity available (QtyAvail), and quantity in transit (QtyInTransit). This table is essential for understanding stock levels across multiple warehouse locations.

IN.ItemLotSerial: If your business uses lot or serial numbers for tracking, this table contains detailed lot/serial information for items.

IN.INTran: Records every inventory transaction (receipt, issue, return, etc.), allowing you to track historical movement and calculate turnover rates.

Understanding these tables and their relationships is the foundation for building effective inventory reports.

Creating a Stock Level Report

The most common inventory report is a stock level report that shows current quantity on hand for each item across all warehouses. Here’s how to build one:

Start by creating a new report in AstraReports and select IN.InventoryItem as your primary table. You’ll immediately have access to item information like item ID, description, and unit of measure.

Next, add the IN.ItemWarehouseDetails table. This is where you’ll find the crucial stock level information—specifically QtyOnHand, QtyAvail, and QtyInTransit. Link these tables using the InventoryItemID field, which appears in both tables.

Now you can design your report to show:

• Item ID and Description
• Warehouse Code
• Quantity On Hand
• Quantity Available
• Quantity In Transit
• Unit of Measure

For added context, you might want to group by warehouse or item class. This gives your team a clear picture of where inventory is physically located and its current status.

Calculating Inventory Turnover

Inventory turnover is a critical performance metric that shows how quickly your company sells and replaces inventory. A high turnover rate indicates efficient inventory management, while a low rate may signal overstocking or slow-moving items.

To calculate turnover, you need two pieces of information:

Cost of Goods Sold (COGS) over a period (usually annual)

Average Inventory Value during the same period

Turnover Ratio = COGS ÷ Average Inventory Value

In AstraReports, you can pull COGS data from the GL (General Ledger) module by querying the GL.GLTran table for transactions related to inventory accounts. Then, you’ll calculate average inventory value using the IN.ItemWarehouseDetails and IN.InventoryItem tables, factoring in item cost and current quantities.

Once you have both values, you can add a calculated field in AstraReports to compute the turnover ratio. Group results by product line or warehouse to identify which areas of your inventory are performing well and which may need attention.

Identifying Slow-Moving and Obsolete Items

Beyond simple stock levels and turnover, many companies struggle with slow-moving or obsolete inventory—items that sit on shelves consuming valuable warehouse space and tying up cash.

To identify these items, you’ll want to combine several data points:

• Last receipt date: When was the item last received into inventory?
• Last issue date: When was the item last sold or used?
• Current quantity: How much do we still have?
• Item cost: How much cash is tied up in this inventory?

You can gather this information by joining IN.InventoryItem with IN.INTran (the transaction history table) and using aggregate functions like MAX() to find the most recent receipt and issue dates.

Once you identify items with no activity in the past 12 months but still have positive quantities on hand, you can flag them for review. This allows your team to decide whether to liquidate, return, or repurpose these items.

Reorder Point Analysis

Many companies establish reorder points—minimum stock levels that trigger purchase orders for replenishment. AstraReports can help you monitor whether your team is respecting these thresholds and alert you to potential stock-outs.

In Acumatica, reorder points are typically stored in the IN.InventoryItem table (fields like MinQty or ReorderPoint, depending on your configuration). You can create a report that shows:

• Current quantity on hand
• Reorder point threshold
• Quantity below reorder point (if applicable)
• Items at risk of stock-out

By adding conditional formatting or alerts to this report, your procurement team can stay ahead of potential shortages and ensure production isn’t disrupted.

Building a Comprehensive Inventory Dashboard

Rather than relying on a single static report, many companies benefit from a comprehensive dashboard that brings together multiple views of inventory data:

• Stock levels by warehouse
• Items below reorder point
• Top 10 slow-moving items
• Turnover ratio by product line
• Inventory value trends

AstraReports allows you to create multiple reports and embed them into a custom dashboard accessible directly within Acumatica. This gives your team real-time visibility into inventory performance without leaving the system they use daily.

With the right reports in place, you can transform raw inventory data into actionable insights that drive better decision-making and improve your bottom line.