Stock Movement

Overview
The report shows opening and closing stock level for each inventory item between two dates for a specific location. Includes Purchases made, Returns, Scraps, processed orders totals and stock cost

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, the purchase order was created in Linnworks or the return was created in Linnworks
    • Start date: From the start of the day for the specified date
    • End Date: To the end of the day for the specified date
  • Location: This is the Linnworks location that the stock has been assigned to
  • Include composites: When ticked, the report will include those items. If left ticked off the report will only and just show single items 

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

  • The report will only show SKUs where there has been a change in stock

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
  • Category: The Linnworks category assigned to the Linnworks inventory item
  • OpeningLevel: The stock level on the specified start date
  • OpeningStockValue: The stock value on the specified start date
  • PendingPurchases: The amount of stock in purchase orders with the status of Pending
  • UndeliveredPurchases: The amount of stock in purchase orders with the status' of Open or Partial that is yet to be delivered
  • DeliveredPurchases: The amount of stock in purchase orders with the status' of Open or Partial that has already been delivered
  • Sales: Quantity sold, in units, from selected location in the selected time span (based on order processed date)
  • Returns: Quantity returned, in units, from the selected location in the selected time span
  • ScrapItems: The amount of stock that has been scrapped from the selected location in the selected time span
  • WarehouseIN: Quantity, in units, of stock that has been brought into the location as a result of warehouse transfers
  • WarehouseOUT: Quantity, in units, of stock that has been left the location as a result of warehouse transfers based on the date the transfer status was updated to Accepted
  • DirectAdjustment: This is the sum of all direct adjustments made to stock level in the My Inventory screen
  • BookedInDirectly: This is the amount of stock that has been brought into the system via the Stock In feature, where it was not associated with a purchase order
  • Total: This is the total sales, in currency, of the stock item from the selected location in the selected time span
  • TotalStockCost: This is the total stock cost, purchase price multiplied by number of sales
  • Closing Level: This is the stock level on the specified end date
  • ClosingStockValue: This is the stock value on the specified end date