Inventory Item Association Report

Inventory Item Association Report

Info
Module: Reports
Path: Reports > Inventory Reports > Inventory Item Association Report
Topic: Inventory Item Association Report
Version(s):  
Editions: 

What Is Inventory Item Association Report

  1. Inventory Reports
    1. Inventory Item Association Report - See all base item products and the inventory items associated to them.  You can filter by Client, Product Group, and Products. The "Products" filter allows you to see all products, only products that have inventory associated, or only products that have no inventory associated.  Columns are: Item Name, Description, Product Group, External Sku, Client, Active, Weight, Unit Count, Prod Offer Count, and Inventory Count.

Making The Connection

Where Will I See This Within OLX?

This will allow you to determine if there are any items that don't have inventory associated and should or to double check that product items have the correct inventory item associated.

What Imports/Exports Relate to Return Report?

  1. OLX Inventory Sky Association - allows inventory items that have already been added to the OrderLogix application to be associated with OLX Products. These associations can both be added or deleted with this import.

Setup

This is a report that you can create an automated schedule for, in order to deliver the data via email or to an FTP site.
Select control options from the report tool bar.

Preview



You'll notice control buttons displayed just above the results :
  1. View Report  - Displays results
    1. The tool bar will display 
  2. Hide Controls - Hides report filters
  3. Show Controls - Displays report filters
  4. Show Schedules  - Displays list of scheduled reports
  5. Show Instances - Displays list of previously ran and pending reports. Click on the status to review the job log.
  6. 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
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 client of the source of the order
Show Inactive (Client)
Show in the report:
  1. Checked - show active and inactive Clients
  2. Unchecked - only show active Clients
The product group of the items on the order
  1. All Products
    1. base items with and without inventory assigned
  2. With Inventory Items
    1. base items with inventory assigned
  3. Without Inventory Items
    1. base items with no inventory assigned



Column Definitions

Column
Definition
Item Name
Base item name
Description
Base item description
****Inventory Items
Inventory item SKU
Product Group
Base item product group
****Sell from Location
assigned to base item
External Sku
Base item external SKU
****QTY
Inventory item quantity
Client
Client assigned to base item
****UOM
Inventory item unit of measurement
Active
  1. True
  2. False
****UOM Count
Inventory item unit of measurement count
Weight
Base item weight
Unit Count
Base item unit count
Prod Offer Count
How many product offers are associated to base item
Inventory Count
How many inventory items are associated to base item



Copyright 2019
Revised 1.29.2026