Inventory Item Location Report Definitions

Inventory Item Location Report Definitions

Info
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

  1. Inventory Reports
    1. Inventory Item Location Report - View inventory item location data.

Making The Connection

Where Will I See This Within OLX?

This report displays information for items in locations.

What Imports/Exports Relate to Inventory Item Location Report?

  1. OLX Inventory Adjustment Import
  2. OLX Inventory SKU Import
  3. OLX Inventory SKU Association Import

Setup


Preview



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 Definitions

Using Calendar Icon to Set Date(s) is a good article to review when running reports manually or scheduling for automation.

Filters

Filter
Definition
Report Layout
3-layer filter to display report data (see Grouping below)

example if set to Order Date/Order ID/ DNIS:

Expand
  1. None
    1. will not expand any of the selected groupings and only show the first layer of the Groupings set in Report Layout
  2. One
    1. will expand only the first Grouping to display the first and second layer of the Groupings set in Report Layout
  3. Two
    1. will expand all Groupings to display all layers of the Groupings set in Report Layout
Format
(only shows when setting up a schedule)
This is the format that the report will export in:
  1. PDF
  2. Excel
  3. CSV
The category of the inventory item
Show Inactive (Category)
Show in the report:
  1. Checked - show active and inactive Category
  2. Unchecked - only show active Category
The warehouse of the location
Show Inactive (Warehouse)
Show in the report:
  1. Checked - show active and inactive Warehouse
  2. Unchecked - only show active Warehouse
The floor/aisle/section/shelf in the warehouse
Show Inactive (Locations)
Show in report:
  1. checked - show both active and inactive locations
  2. unchecked - show only active locations
The inventory item
Show Inactive (Item)
Show in report:
  1. checked - show both active and inactive Inventory Item
  2. unchecked - show only active Inventory Item
The unit of measure of the inventory item at the location
Show Inactive (UOM)
Show in the report:
  1. Checked - show active and inactive UOM
  2. Unchecked - only show active UOM
Only show items that need restocking
  1. checked only inventory items in locations that are below their restock level will be displayed
  2. unchecked



Grouping/Report Layout

Grouping
Definition
CategoryCodeThe category of the inventory item
The floor/aisle/section/shelf in the warehouse
The unit of measure of the inventory item at the location
The inventory item Sku
The warehouse of the location

 Column Definitions

Column
Definition
SKUThe inventory item Sku
Short Description
The short description of the inventory item
Category
The category of the inventory item
Quantity At Location
The quantity currently at the location
Restock Level
The restock level of the inventory item at the location
Location UOM
The unit of measure for the inventory items at the location




Copyright 2019
Revised 1.29.2026