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

    • 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 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 ...

    • Move Inventory

      Module: Inventory Path: Company Data>Inventory>Move Inventory Topic: Move Inventory Version(s): Version 5.1 and up Editions: All Editions What Are Move Inventory The move inventory screen allows inventory to be moved from one storage location to ...

    • Category List

      Module: Inventory Path: Products > Inventory > Category List Topic: Category List Version(s): Version 5.1 and up Editions: All Editions What Are Category List The values that are defaulted in the system will display when creating an inventory item. ...

    • Adjust Inventory

      Module: Inventory Path: Products>Inventory>Adjust Inventory Topic: Adjust Inventory Version(s): Version 5.1 and up Editions: All Editions What Is Adjust Inventory It is recommended to utilize the OLX Inventory Adjustment Import instead of making ...