Modified Sales Order with Custom Notes Field

This report generate sales order with a Notes section in the purchase order. Please note that the Notes field is a custom field that need to be added in the 'Sales Order Custom field' section under Application Setting > Selling.

{
  "attrName": "##saleDocs001",
  "name": "Print sale order",
  "group": "##saleDocs",
  "sortOrder": 62001,
  "type": "report/pivotTable",
  "params": {
    "dataSet": "orderItem",
    "filters": [
      {
        "filter": "orderType",
        "param": [
          "SALES_ORDER"
        ]
      },
      {
        "filter": "orderOrderUrl",
        "isParameter": true,
        "param": "/cartisi/api/order/10035"
      },
      {
        "filter": "orderRecordCreated",
        "isParameter": true,
        "param": "[null,null]"
      },
      {
        "filter": "orderRecordLastUpdated",
        "isParameter": true,
        "param": "[null,null]"
      },
      {
        "filter": "orderStatus",
        "isParameter": true,
        "param": [
          "ORDER_CREATED",
          "ORDER_LOCKED",
          "ORDER_COMPLETED"
        ]
      }
    ],
    "rowDimensions": [
      {
        "dimension": "orderOrderId",
        "width": 0
      },
      {
        "dimension": "orderUserSaleUser10000",
        "width": 0,
        "group": "sheetGroup"
      },
      {
        "dimension": "orderItemItemIndex",
        "width": 0
      }
    ],
    "metrics": [
      {
        "metric": "productProductIdConsolidate",
        "width": 0.022352,
        "label": "SKU #"
      },
      {
        "metric": "productDescriptionConsolidate",
        "width": 0.09906,
        "label": "DESCRIPTION"
      },
      {
        "metric": "orderItemQuantityConsolidate",
        "width": 0.0127,
        "label": "QTY"
      },
      {
        "metric": "productUnitOfMeasureConsolidate",
        "width": 0.0127,
        "label": "UoM"
      },
      {
        "metric": "orderItemUnitPriceConsolidate",
        "width": 0.0127,
        "label": "PRICE"
      },
      {
        "metric": "orderItemSubTotalSum",
        "width": 0.022352,
        "label": "SUB-TOTAL"
      }
    ],
    "namedParameters": [],
    "pageTemplate": {
      "paperLabel": "##letterPortrait",
      "paperLabelSize": [
        0,
        0
      ],

    }
  }
}