Menu

Export the Inventory Activity Query to Support Targeted Analysis

The Inventory Activity Query is command central for quantities, commitments and costs for items and locations. You may not be aware that there is an Excel Export available on the On Hand Listing that allows you export the specific elements of interest and lay the groundwork for further analysis.


The On Hand Listing is available from the Inventory Activity Query. The standard report offers 3 formats

  • Committed Quantities: In addition to the On Hand Quantity, the following fields will be displayed: On Order, Committed to Sales, Committed to Production, Committed to Ship, Available to Ship.
  • Current Costs: In addition to the On Hand Quantity, the following fields will be displayed: Distributed Amount, Last Cost, Average Cost, Standard Cost, Base Price.
  • Stocking Constraints: In addition to the On Hand Quantity, the following fields will be displayed: Minimum Stock, Maximum Stock, Order Quantity Multiple, Economic Re-Order, Safety Stock.

Each of these formats is very informative but fixed in terms of its layout. If you choose the option to export to Excel, you can control the exact columns and essentially pull elements from any of the formats. Here’s how:

  1. From the Printer icon on the Inventory Activity Query, choose the option for Inventory On Hand Listing.
  2. The Sort Level options will not impact the exported data. The data in the worksheet will appear initiallly sorted by Item.
  3. As noted above, you can ignore the Report Format Options section. The contents of the export will be determined by the Export Configuration.
  4. In the Quantities to Include section, select the categories of quantities that should be inlcuded in the export. Each of the criteria are considered as “and” conditions that further the limit the selection of records.
  • On Hand: Positive, Negative (Oversold) or Zero (Out of stock)
  • On Order: Positive, Negative or Zero
  • In Transit: Positive, Negative or Zero
  • Committed to Sales: Positive, Negative or Zero
  • Committed to Production: Positive, Negative or Zero
  • Committed to Ship: Positive, Negative or Zero
  1. On the next screen, select whether to display the Stocking or Selling Unit of Measure and the number of decimals to use for quantities and costs.
  1. The next 2 screens contain Selected Range options that can be used to identify which items get considered for inclusion in the export. 
  2. Finally, on the Routing Tab, select the ‘Send Output To’ option of MS Excel and then click the Configure button to select the columns for the export.
  1. On the final screen, specify the filename to be used for the export as well as settings for whether column headings should be included and whether the spreadsheet should be cleared of old data before being populated with the results of the new export.
  2. Click Finish to complete the configuration.
  3. Save the parameters for future use and click Process to generate the export.

A message will display, indicating that the information is being exporting to Excel

When finished open the worksheet generated by the export

Up Next
  • The Invisible Factory: Whitepaper
    The Invisible Factory: Whitepaper
  • PlantGauge Data Sheet
    PlantGauge Data Sheet
  • Software Data Sheet
    Software Data Sheet
  • Distribution Suite Data Sheet
    Distribution Suite Data Sheet
  • Project Manufacturing Data Sheet
    Project Manufacturing Data Sheet
  • PlantCare Overview
    PlantCare Overview
  • PlantUp! Datasheet
    PlantUp! Datasheet
  • SteppingStones Overview
    SteppingStones Overview
  • Inventory Control and Costing
    Inventory Control and Costing
  • Manufacturing CRM
    Manufacturing CRM
  • Production and Scheduling
    Production and Scheduling
  • Procurement and Materials
    Procurement and Materials
  • Sales Management
    Sales Management
  • Make-to-Order Make-to-Stock
    Altron Automation Achieves Precision and Cost Savings
    Altron Automation halved purchasing costs and reached 99.5% inventory accuracy by upgrading to INDUSTRIOS ERP, enabling real-time inventory management, automated job tracking, and data-driven process improvements for scalable, efficient growth.
    Altron Automation, a leading Michigan-based systems integrator for the automotive and heavy truck industries, transformed its operations by upgrading its INDUSTRIOS custom manufacturing ERP.
    Read Success Story
    Make-to-Order Make-to-Stock
    AMPCO Sustains Growth and Efficiency with INDUSTRIOS ERP
    AMPCO doubled sales and maintained fast lead times by upgrading to INDUSTRIOS ERP, absorbing vendor cost increases, reducing production delays, and improving quoting accuracy—enabling efficient, customer-focused growth.
    American Metal Products Company (AMPCO), a Portland-based tube bending and metal forming specialist, doubled sales over three years while maintaining fast lead times and competitive pricing
    Download Success Story
    Make-to-Order
    Cam Tran Modernizes Operations, Achieves 80% Payroll Time Savings
    Cam Tran upgraded to INDUSTRIOS ERP, cutting payroll processing time by 80% and automating data tracking. Real-time production monitoring and lean-ready workflows now drive efficiency, collaboration, and scalable growth.
    Cam Tran Co. Ltd., a leading North American transformer manufacturer, modernized its payroll and production processes by upgrading to the latest INDUSTRIOS ERP.
    Download Success Story
    Make-to-Order Make-to-Stock
    Real-Time Inventory and Scheduling Power Leone Fence’s Growth
    Leone Fence increased customer satisfaction by 40% through real-time inventory visibility, automated subcontractor scheduling, and seamless ERP integration, enabling proactive purchasing, accurate order tracking, and scalable growth.
    Leone Fence, the largest commercial and industrial fence installer in the Greater Toronto Area, transformed its operations by integrating INDUSTRIOS with Sage 300 ERP.
    Download Success Story
    Project Manufacturing
    Plas-Tech Automates Job Tracking and Inventory for Greater Efficiency
    Plas-Tech Inc. improved inventory accuracy and automated job tracking with INDUSTRIOS ERP, enabling real-time material visibility, data-driven cost analysis, and streamlined reporting to support efficient, scalable growth.
    Plas-Tech Inc., a custom plastic fabrication company in Concord, Ontario, transformed its operations by implementing INDUSTRIOS ERP.
    Read Success Story
    Make-to-Order
    Pratt & Larson Unifies Inventory and Shipping with INDUSTRIOS
    Pratt & Larson unified inventory and shipping with INDUSTRIOS, enabling real-time tracking, seamless workflows, and faster order fulfillment that improved accuracy, financial clarity, and client satisfaction across artisan tile production.
    Pratt & Larson Ceramics, a premier artisan tile manufacturer, transformed its operations with INDUSTRIOS custom manufacturing ERP.
    Download Success Story
    Make-to-Stock
    SmithCo Manufacturing Automates Labor & Payroll with INDUSTRIOS ERP
    SmithCo Manufacturing automated labor tracking and payroll with INDUSTRIOS ERP, gaining real-time job cost visibility, and streamlining production management. Seamless integration boosted efficiency, accuracy, and positioned SmithCo for continued growth.
    SmithCo Manufacturing, a leading producer of side dump trailers in Le Mars, Iowa, transformed its operations by implementing INDUSTRIOS ERP. Key achievements include:
    Read Success Story
    Make-to-Order
    UMC Optimizes Shipping and Inventory with INDUSTRIOS
    Universal Motion Components (UMC) streamlined shipping and improved inventory planning with INDUSTRIOS ERP. Enhanced data access and automated purchasing enable faster, more accurate deliveries, and support operational growth.
    Universal Motion Components (UMC), based in Costa Mesa, California, is a leading supplier of drive line components for the agriculture and construction industries.
    Download Success Story
    Make-to-Stock
    Universal Stenciling Grows Efficiently with INDUSTRIOS ERP
    Universal Stenciling streamlined inventory and accelerated order fulfillment using INDUSTRIOS ERP. They now fulfill 90% of orders within 24 hours and manage over 3,000 raw materials with accuracy.
    Universal Stenciling & Marking Systems, a family-owned innovator in marking, stenciling, and coding equipment since 1904, leveraged INDUSTRIOS ERP to:
    Download Success Story
    Harnessing the power of employee engagement through real time metrics

    Explore the concept of the employee engagement and how technology can impact adoption of practices that foster employee engagement. Jacques Decarie, Vice-President of Sales and Marketing with INDUSTRIOS and Jenice Rideout, President of HR Navigation Inc. provide an overview of how to apply practices to drive your team to exceptional performance.

    What's New - Handling Order to Cash processes with INDUSTRIOS

    This webinar provides an overview of how INDUSTRIOS can help you handle business processes from the time an order is received to the point where it is converted to cash. Areas covered include: Navigation, Customers, Sales Orders, Shipping and Reporting.

    What's New - Inventory Control and Costing

    Eva DeGasperis, Principal at Industrios, and Jacques Decarie, Vice President of Sales and Marketing, take a deep dive into inventory control and costing. Hear Eva talk quantity constraints, unit tracking, cost elements, valuation methods, and much, much more.

    Webinar: How the Invisible Factory will help get you back on course

    As owner of a manufacturing company, you shouldn’t be on the shop floor. You’re needed at the helm, steering the business to where it needs to go. From software to human resources, here’s what IndustriOS’ Invisible Factory can do for you.

    Webinar: INDUSTRIOS on the Cloud

    Jacques Decarie, INDUSTRIOS, and Joe Cudzik, Expedient, explain your cloud options and address your questions about ERP. You’ll learn about accessibility 24/7 on any device, enhanced security, disaster recovery and much more.

    ERP Business Benefits for Manufacturers
    Practical Business Intelligence for Manufacturers