Grid Table for Grid Print Templates

The grid print templates for cash sale, invoice, picking ticket, packing slip and quote transactions contain the record.custbody_gridoe_trantemplatedata field. This field contains the data for the grid table. Refer to the following information to learn more about this field.

JSON Code Snippet for Grid Print Templates

The following JSON code snippet shows a sample 2x2 grid table from record.custbody_gridoe_trantemplatedata:

            {1:
  {
    "type": "MI",
    "nameId": "4",
    "name": "Basic Crew Neck Tee"
    "grid": {
      "rowlabel": "Color",
      "collabel": "Size",
      "rowcollabel": "Matrix Item Options",
      "header": [
        {
          "id": "Column1",
          "colAttr": "1",
          "name": "Small"
        },
        {
          "id": "Column2",
          "colAttr": "2",
          "name": "Medium"
        }
      ],
      "data": [
        {
          "id": "Row1",
          "rowattributeid": "1",
          "rowattribute": "blue"
          "columnids": [
            "Column1",
            "Column2"
          ],
          "Column1": {"internalid": 6316},
          "Column2": {"internalid": 6318},
        },
        {
          "id": "Row2",
          "rowattributeid": "2",
          "rowattribute": "red",
          "columnids": [
            "Column1",
            "Column2"
          ],
          "Column1": {"internalid": 6317},
          "Column2": {"internalid": 6319}
        }
      ]
    }
  }
}

Sample 2x2 Grid Table Representation for Grid Print Templates

For grid tables in grid print templates, note that the template may contain an empty record.custbody_gridoe_trantemplatedata field.

The following table represents the sample JSON code into a 2x2 grid table in cash sale, invoice, packing slip, picking ticket, and quote printouts.

Matrix Item Option

(record.custbody_gridoe_trantemplatedata[0].grid.rowcollabel)

Small

(record.custbody_gridoe_trantemplatedata[0].grid.header[0].name)

Medium

(record.custbody_gridoe_trantemplatedata[0].grid.header[1].name)

Blue

(record.custbody_gridoe_trantemplatedata[0].grid.data[0].rowattribute)

Row 1 Col 1 Item ID:

(record.custbody_gridoe_trantemplatedata[0].grid.data[0].Column1)

Row 1 Col 2 Item ID:

(record.custbody_gridoe_trantemplatedata[0].grid.data[0].Column2)

Red

(record.custbody_gridoe_trantemplatedata[0].grid.data[1].rowattribute)

Row 2 Col 1 Item ID:

(record.custbody_gridoe_trantemplatedata[0].grid.data[1].Column1)

Row 2 Col 2 Item ID:

(record.custbody_gridoe_trantemplatedata[0].grid.data[1].Column2)

For information about the other elements included in Grid Print Templates, see the following topics:

JSON Code Snippet for Grid Print Templates

Sample 2x2 Grid Table Representation for Grid Print Templates

Related Topics