Stock Items by Location and BinRack (with levels)

Overview
List of all stock items with stock levels, locations, and bin rack locations. Data is displayed for a location that has been selected.

Selection Criteria

Linnworks will select the items to be included in the report based on the following criteria

Parameters - The following parameters can be used to configure this report

  • Location: The name of the Linnworks location, used for stock levels and values

Rules - internal logic applied to extract only those records that fulfil the specified criteria

  • All inventory items are included
  • Bin/rack values are not displayed for batched items. 

Reported Values

The following values are returned by the report

Values - Column names and description

  • Item Title: The title for the Linnworks inventory item as seen in the General tab.
  • SKU: The SKU / Item number for the Linnworks inventory item.
  • Item Description: The Metadata for the Linnworks inventory item as seen in the General tab.
  • Retail Price: The retail price defined for the Linnworks inventory item as seen in the General tab.
  • Weight: The defined weight for the Linnworks inventory item as seen in Postage Definition.
  • Purchase Price: The purchase price defined for the Linnworks inventory item as seen in the General tab.
  • Barcode Number: The barcode number for the Linnworks inventory item as seen in the General tab.
  • Height: The defined height for the Linnworks inventory item as seen in the General tab.
  • Width: The defined width for the Linnworks inventory item as seen in Postage Definition.
  • Depth: The defined depth for the Linnworks inventory item as seen in Postage Definition.
  • Tax Rate: The defined tax rate for the Linnworks inventory item as seen in the General tab. This overrides the system default. If the value is -1, the item uses the system default Tax Rate.
  • Category Name: The Linnworks category assigned to the Linnworks inventory item as seen in the General tab.
  • Default Postal Service: The preferred postal service for the Linnworks inventory item as seen in Postage Definition.
  • Default Packaging Group: The preferred packaging group for the Linnworks inventory item as seen in Postage Definition.
  • Level: The stock level including stock assigned to Open Orders.
  • StockValue: This is the stock value at this location, based on the amount of stock in this location and purchase price
  • Minimum Level: Used for reordering stock when the level drops to this level
  • In Order Book: Stock in Open Orders.
  • On Order: Stock that is due to be delivered in Purchase Orders.
  • Available: Stock level minus any assigned stock in Open Orders.
  • BinRack Number: The identifier for the physical location in the warehouse used to store the inventory item.
    NB!  BinRack values are not displayed for batched items.