Sold Stock Between Dates (by Location and Currency)

Overview
This report summarises the stock sold within the specified time period. The results are further subdivided by the Order Country and the Currency the orders were placed in.

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

  • Date Range: An inclusive range based on the date the order was placed on the sales channel
    • Start date: From the start of the day for the specified date
    • End Date: To the end of the day for the specified date

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

  • Only processed orders are included
  • Cancelled order excluded from the report

Reported Values

The following values are returned by the report

Values: Column names and description

  • Location: This is the Linnworks location that the order has been assigned to
  • cCurrency: This is the currency used on the order or set in the channel config for that sales channel
  • ItemTitle: The title for the Linnworks inventory item (found on the General tab)
  • ItemNumber: The SKU / Item number for the Linnworks inventory item
  • Category: The Linnworks category assigned to the Linnworks inventory item (found on the General tab)
  • SoldQuantity: This is the number of units sold between the specified dates
  • SoldValue: This is the retail value of the stock sold between the specified dates
  • StockValueSold: This is the value of the stock sold, based on the purchase price, between the specified dates
  • PostageCharged: This is the total amount of postage costs charged for
  • StockLevel: 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
  • StockMinLevel: Used for reordering stock when the level drops to this level
  • InOrderBooks: Stock quantity in Open Orders
  • StockAvailable: Stock level less any assigned in Open Orders

Grouping - Items that match across the following criteria will be grouped on a single row in the report

  • Location
  • ItemTitle
  • ItemNumber
  • Level
  • Category
  • Currency
  • StockValue
  • StockMinLevel
  • Inorderbooks
  • StockAvailable