R01 Aged Inventory Details

Filters

The filter pane for this report includes the following filters.

  • Last Received Date: specify a range of dates to see information for inventory items that were last received during that period.
  • Seller Name
  • Facility Name
  • Item Number: enter specific item numbers to see information just for those items.

  • Channel (B2B, EB2C)

  • SKU Category

Data Elements

The Aged Inventory report lists items that have been listed in inventory for more than 30 days.

Column

Description

Seller ID

A unique identifier for the seller or sub-client, as set up in the order management system. Usually a seller corresponds to one sales channel, for example, a webstore serving a particular geographic region operating under a particular name.

Seller

The name of the the seller or sub-client, as set up in the order management system.

Facility ID

Unique identifier for the warehouse or distribution center.

Facility

Name of the warehouse or distribution center.

Item Number

A unique identifier for the item. Typically, Radial-assigned catalog ID followed by client-assigned SKU number for the item.

Customer Item Number

The client's unique identifier for the item.

UPC Number

Universal Product Code, a manufacturer-assigned number that corresponds to a barcode for the item.

Item Description

A text description of the item.

Last Shipped Date

Date when the Item was last shipped. A date of 1/1/1900 indicates that this information is not available.

Shp Days Aged

The number of days between today and the date the SKU was last shipped.

Last Received Date

The date when the Item was last received. If this information is not available, the date is set to the inventory created date

Rcv Days Aged

The number of days between today and the date the SKU was last received.

Item Cost

Unit cost of the SKU. If this information is not provided by the seller, the value is set to $0.

On Hand Units

The number of units on hand, as indicated in the warehouse management system. This total includes units with inventory stock status of both Available and Unavailable.