Labels Dymo 1" x 2-5/8" Short Code UPC for N Copies of Stock Item

This report prints labels for one or more items in your stock. You pick the number of labels to print per item. The labels show the Product ID, Packing, Lot ID, and Description, in addition to the UPC barcode itself, which is automatically generated by Finale.

Finale automatically generates UPC barcodes called "short codes" for all your stock items. Each short code is automatically entered into the scan lookup table, where it is mapped to three fields: Product ID, Packing, and Lot ID. In other words, when you scan the UPC short code with a scanner, the scanner will lookup which Product ID, Packing, and Lot ID that short code corresponds to.

If you use existing UPC codes from your suppliers or from blocks of UPC numbers that you have bought to identify your own products globally, then this is not the right report. You can customize this report, however, to use your own UPC number stored in a custom field instead of using the automatically generated short code.

The template includes filter options for category and manufacturer and sublocation, since companies with large numbers of items may need to print labels in multiple batches to save time and to avoid making a single document that has too many pages.

The labels are 1" x 2-5/8" suitable for a label printer that prints on rolls.

{
  "attrName": "##other003",
  "name": "Labels Dymo 1\" x 2-5/8\" short code UPC for N copies for stock item",
  "group": "##other",
  "sortOrder": 62001,
  "type": "report/pivotTable",
  "params": {
    "dataSet": "stock",
    "filters": [
      {
        "filter": "productStatus",
        "param": [
          "PRODUCT_ACTIVE"
        ]
      },
      {
        "filter": "productProductUrl",
        "isParameter": true,
        "param": "##null"
      },
      {
        "filter": "productCategory",
        "isParameter": true,
        "param": "##null"
      },
      {
        "filter": "productManufacturer",
        "isParameter": true,
        "param": "##null"
      },
      {
        "filter": "stockLotId",
        "isParameter": true,
        "param": null
      },
      {
        "filter": "stockPacking",
        "isParameter": true,
        "param": null
      },
      {
        "filter": "stockMagazine",
        "isParameter": true,
        "param": "##null"
      }
    ],
    "rowDimensions": [
      {
        "dimension": "productProductId",
        "width": 0.0254
      },
      {
        "dimension": "stockLotId",
        "width": 0.0254
      },
      {
        "dimension": "stockPacking",
        "width": 0.0254
      },
      {
        "dimension": "stockShortCode",
        "width": 0.0254,
        "group": "sheet"
      },
      {
        "dimension": "productDescription",
        "width": 0.0254
      }
    ],
    "metrics": [],
    "namedParameters": [
      {
        "key": "parameter_000",
        "label": "Quantity per label"
      }
    ],
    "pageTemplate": {
      "paperLabel": "##custom",
      "paperLabelSizeWidth": "2.625in",
      "paperLabelSizeHeight": "1.000in",
      "paperLabelSize": [
        0.06667501818894496,
        0.02540000692912189
      ],
      "sheetPrintMultiple": {
        "type": "##variable",
        "variable": "parameter_000"
      },
      "templateContent": "\n<div style=\"position:absolute;top:0.1in;left:0.15in;width:100in;font-size:10pt;font-weight:bold;text-align:left;line-height:1.1;\">\n  {{productProductId}}\n</div>\n\n<div style=\"position:absolute;top:0.1in;left:0.25in;width:2.225in;font-size:8pt;text-align:right;\">\n {{stockPacking}} {{stockLotId}}\n</div>\n\n<div style=\"position:absolute;top:0.24in;left:0.55in;width:1.5in;height:0.44in\">\n  <img style=\"display:block;width:1.5in;height:0.44in;\"  \n       src=\"barcode:format=UPC,{{stockShortCode}}\">\n</div>\n\n<!-- Display bottom left corner -->\n<div style=\"position:absolute;top:0.67in;left:0.15in;width:2.325in;font-size:10pt;text-align:left;\">\n  {{productDescription}}\n</div>\n\n<br> <br> <br> <br> <br> <br> <br> <br> \n<br> <br> <br> <br> <br> <br> <br> <br>"
    }
  }
}