Finale Knowledge Base

Labels Avery 5160 for Purchase Order Cases by Product ID

This report prints labels for the items in a purchase shipment (converting any cases to equivalent number of individual items). The labels show the Product ID, Mfg Product ID, and Description, in addition to the barcode itself, which is the Product ID.


{
"attrName": "##other003",
"name": "Labels Avery 5160 for product IDs in order, case equiv",
"group": "##other",
"sortOrder": 62001,
"type": "report/pivotTable",
"params": {
"dataSet": "orderItem",
"filters": [
{
"filter": "productStatus",
"param": [
"PRODUCT_ACTIVE"
]
},
{
"filter": "orderOrderUrl",
"isParameter": true,
"param": "##null"
},
{
"filter": "productProductUrl",
"isParameter": true,
"param": "##null"
}
],
"rowDimensions": [
{
"dimension": "productProductId",
"width": 0.0254
},
{
"dimension": "productDescription",
"width": 0.0254
},
{
"dimension": "productUserUser10000",
"width": 0.0254,
"group": "sheet"
}
],
"metrics": [
{
"metric": "orderItemQuantityCaseOrCaseEquivalentSum",
"width": 0.0254
}
],
"namedParameters": [],
"pageTemplate": {
"paperLabel": "##5260Singles",
"paperLabelSize": [
0,
0
],
"sheetPrintMultiple": {
"type": "##variable",
"variable": "orderItemQuantityCaseOrCaseEquivalentSum"
},

}
}
}