Inventory Item List Report Definitions

Inventory Item List Report Definitions

Info
Module: Reports
Path: Reports > Inventory Reports > Inventory Item Report
Topic: Inventory Item Report
Version(s):  5.1 and up
Editions: All

What Is 

Reports > Inventory Item Report - View inventory item data.
This report shows inventory item information for all the inventory items in the system

Making The Connection

Where Will I See This Within OLX?

Inventory is seen when orders are created and shipped.

What Imports/Exports Relate to Return Report?

  1. OLX Inventory Adjustment Import (orderlogix.com)
  2. OLX Inventory SKU Import (orderlogix.com)
  3. OLX Inventory Supplier Import (orderlogix.com)
  4. OLX Inventory Synchronization Import (orderlogix.com)

Setup




You'll notice control buttons displayed just above the results. Review Report Tools (orderlogix.com) article for more information on how to utilize each control button. :
  1. View Report  - Displays results
    1. Displays the toolbar 
  2. Hide Controls - Hides report filters
    1. Show Controls - Displays report filters
  3. Show Schedules  - Displays schedule editor
    1. Format filter will display at top of screen
    2. Delivery and Encryption tabs will display on bottom left of screen
  4. Show Instances - Displays list of previously ran and pending reports. Click on the status to review the job log.
  5. Close  - Close out of the report popup.

Report Definition

Filter Definitions

FilterDefinition
CategoryThe category of the inventory item
Category Show InactiveCategories that are no longer active in the system
Category Show avg cost and valueIf this checkbox is checked the Avg Cost and Value columns will be displayed
SupplierThe preferred supplier of the inventory item (None if not selected)
Supplier Show Inactive
Suppliers that are no longer active in the system
  1. All:
    1. Will display all inventory items.
  2. Low Level Only:
    1. Will only display inventory items where total items <= Reorder Level.
  3. Backordered Only:
    1. Will only display inventory items that have a backordered quantity > 0



Column Definitions

Column
Definition
SKU
The SKU of the inventory item
Short Description
The short description of the inventory item
Pref Supplier
The preferred supplier of the inventory item (None if not selected)
Quantity On Hand
The number of inventory items on hand
Committed
The number of inventory items committed
Total Items
Quantity On Hand + Total Items
On Order
The number of items currently in an active purchase order
Reorder Level
The reorder level of the inventory item
Stock Level
  1. * NEED: When the inventory item has a backordered quantity > 0.
  2. LOW: When Total Items <= Reorder level.
  3. OUT: When Total Items = 0
Back Ordered
The number of inventory items backordered
Avg Cost
This is the cost of each item and is calculated automatically when new inventory is received (using the Receipts screen).
Value
This is the total inventory value for a particular item. This is calculated automatically when new inventory is received (using the Receipts screen), or when the inventory is manually adjusted (using the Adjustment screen)



Grouping Definitions

No grouping

Copyright 2019
Revised 9.18.2024



    • Related Articles

    • Inventory Item Location Report Definitions

      Module: Reports Path: Reports > Inventory Reports > Inventory Item Location Report Topic: Inventory Item Location Report Version(s): 5.1 and up Editions: All What Is Inventory Item Location Report Inventory Reports Inventory Item Location Report - ...

    • Inventory Item List

      Module: Inventory Path: Products > Inventory > Inventory Item List Topic: Inventory Items Version(s): Version 5.1 and up Editions: All Editions What Are Inventory Items The core element of the OrderLogix inventory system is the Inventory Item that ...

    • Inventory Item Association Report

      Module: Reports Path: Reports > Inventory Reports > Inventory Item Association Report Topic: Inventory Item Association Report Version(s): Editions: What Is Inventory Item Association Report Inventory Reports Inventory Item Association Report - See ...

    • Supplier Item Report Definitions

      Module: Reports Path: Reports > Inventory Reports > Supplier Item Report Topic: Supplier Item Report Version(s): 5.1 and up Editions: All What Is Supplier Item Report Inventory Reports Supplier Item Report - View supplier item data. Making The ...

    • Warehouse Report Definitions

      Module: Reports Path: Reports > Inventory Reports > Warehouse Report Topic: Warehouse Report Version(s): 5.1 and up Editions: All What Is Warehouse Report Inventory Reports Warehouse Report - View warehouse data. Making The Connection Where Will I ...