Stock Item Sold Pivoted Monthly

Overview
The report shows all stock items based on the search conditions specified and displays sold quantity, sold value and stock value (at the time of sale) in a pivoted table

Selection Criteria

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

  • Start Date: This will be midnight on the 1st day of the selected month. For instance, entering 3rd June would search from 1st June
  • End Date: The search will end on the final day of the preceding month. For instance, entering September 2nd will search until August 31st
  • Search Item: Linnworks stock item number or title will try to find items whose SKU/title is similar to the one entered in the search
  • Supplier: Supplier assigned to stock item in Linnworks
  • Location: Location for sales, stock levels, returns and purchase orders
  • Category: The Linnworks stock item category
  • Include Extended Property Name: This will add a column and show the relevant data for the selected extended poperty

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

  • If month for StartDate and EndDate is the same (e.g. from 3rd to 8th of June is selected), then report will display data for whole of June (starting from the 1st of June)
  • Only processed orders are included

Reported Values

The following values are returned by the report

Values: Column names and description

  • SKU: The SKU / Item number for the Linnworks inventory item
  • itemtitle: The title for the Linnworks inventory item (found on the General tab)
  • Colour: This column will depend on whether an extended item property is selected. In this example, colour was selected
  • CurrentLevel: Stock level including stock assigned to Open Orders
  • MinimumLevel: Used for reordering stock when level drops to this level
  • PurchasePrice: The purchase price defined for the Linnworks inventory item (found on the General tab)
  • RetailPrice: The retail price defined for the Linnworks inventory item (found on the General tab)
  • DefaultSupplier: This is the default supplier, as defined in Linnworks
  • Category: The Linnworks category assigned to the Linnworks inventory item (found on the General tab)
  • MonthsQty The quantity sold in selected month(s) (based on order received date)
  • Months Value The totals of the price per unit over the selected date range
  • Months Stock The totals for the sold dispatch stock unit cost over the selected date range