Export Quantity On Hand Stock Levels to Excel

This report is useful for exporting your current quantity on hand stock levels by sublocation to an excel file. You may then use this excel file to copy and paste into a new stock take or change. You can easily add a column to the exported Excel File to reset your current stock levels to zero at all sublocations, and then copy and paste this information into a Batch Stock Take import.

{
  "attrName": "##stock016",
  "name": "Export Stock Levels to Excel by Sublocation",
  "group": "##stock",
  "sortOrder": 64102,
  "type": "report/pivotTable",
  "params": {
    "dataSet": "stock",
    "grandTotal": "##none",
    "filters": [
      {
        "filter": "stockType",
        "isParameter": true,
        "param": [
          "STOCK_ITEM_ON_HAND"
        ]
      },
      {
        "filter": "productStatus",
        "isParameter": true,
        "param": "##null"
      },
      {
        "filter": "productProductUrl",
        "isParameter": true,
        "param": "##null"
      },
      {
        "filter": "productCategory",
        "isParameter": true,
        "param": "##null"
      },
      {
        "filter": "productManufacturer",
        "isParameter": true,
        "param": "##null"
      },
      {
        "filter": "stockLocation",
        "isParameter": true,
        "param": "##null"
      },
      {
        "filter": "stockMagazine",
        "isParameter": true,
        "param": "##null"
      },
      {
        "filter": "stockEffectiveDate",
        "isParameter": true
      }
    ],
    "rowDimensions": [
      {
        "dimension": "stockMagazine",
        "width": 0.0254,
        "label": "Sublocation"
      },
      {
        "dimension": "productProductId",
        "width": 0.035306
      },
      {
        "dimension": "stockPacking",
        "width": 0.0127
      },
      {
        "dimension": "stockLotId",
        "width": 0.0254
      },
      {
        "dimension": "stockQuantity",
        "width": 0.01524
      },
      {
        "dimension": "productDescription",
        "width": 0.0635,
        "label": "Description"
      },
      {
        "dimension": "productStdPacking",
        "width": 0.0127,
        "label": "Std Packing"
      }
    ],
    "metrics": [],
    "pageTemplate": null
  }
}