Inventory Item List Report Definitions

Inventory Item List Report Definitions

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

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

Column Definitions

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

    • Item List Report Definitions

      You can use the (product) Item list report to view product items by Client, Product Group, or Active status.   The report shows the (product) Item Name, Description, Product Group, External SKU, Client, Active Status, and number of product offers for ...

    • 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 See all base item products and the inventory items ...

    • Inventory Item Location Report Definitions

      This report display information for items in locations. Definitions Inventory Item Location Report Column Definitions SKU The inventory item Sku Short Description The short description of the inventory item Category The category of the inventory item ...

    • Supplier Item Report Definitions

      This report display supplier item information. Definitions Supplier Item Report Column Definitions Supplier The supplier name Item The inventory item Sku Supplier Sku The supplier Sku for the inventory item Unit Of Measure The unit of measure for the ...

    • Product Offer List Report Definitions

      This report lists all product offers entered into OLX and information on the scripts they are attached to (if applicable). Definitions Product Offer List Report Column Definitions Name The product offer name also displays product offer commission ...