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
      ],
      "templateContent": "<div style=\"position:absolute;left:4.5in;top:0.5in;height:24pt;width:3.5in;font-weight:bold;font-size:24pt;line-height:1;text-align:right;color:#aaa;\">\n  SALE ORDER\n</div> \n<div style=\"position:absolute;left:0.5in;top:38pt;height:20pt;width:4in;font-weight:bold;font-size:18pt;line-height:1;text-align:left;\">\n  {{primary.groupName}}\n</div>\n\n{{#if pageTemplateFirst}}\n\n<!-- HEADER -->\n<div style=\"position:absolute;left:0.5in;top:60pt;height:3in;width:4in;font-size:10pt;text-align:left;line-height:1.2;\">\n  {{primary.addressFormatted}}\n  {{#if primary.telecomNumberFormatted}}<br>Phone: {{primary.telecomNumberFormatted}}{{/if}}\n  {{#if primary.telecomFaxNumberFormatted}} &nbsp; Fax: {{primary.telecomFaxNumberFormatted}}{{/if}}\n</div>\n<div style=\"position:absolute;left:0.5in;top:120pt;height:12pt;width:4in;font-size:10pt;font-weight:bold;text-align:left;line-height:1.2;\">\n  SALE NUMBER: {{order.orderId}} <br>\n  SALE DATE: {{order.orderDate}} <br>\n</div>\n<div style=\"position:absolute;left:3.05in;top:120pt;height:12pt;width:4.45in;font-size:10pt;font-weight:bold;text-align:left;line-height:1.2;\">\n  {{#if order.customerPo}}CUSTOMER PO: {{order.customerPo}} <br>{{/if}}\n  {{#if order.settlementTermName}}TERMS: {{order.settlementTermName}} <br> {{/if}}\n</div>\n\n<div style=\"position:absolute;left:0.5in;top:156pt;height:17pt;width:2.4in;font-weight:bold;font-size:10pt;background-color:#eee;padding:3pt;border-width:0.5pt 0.5pt 0 0.5pt;border-color:#888;\">\n  Ship from\n</div> \n<div style=\"position:absolute;left:0.5in;top:173pt;height:64pt;width:2.4in;font-size:10pt;padding:3pt;border-width:0.5pt 0.5pt 0.5pt 0.5pt;border-color:#888;\">\n  {{order.shipFromFormatted}}<br>\n</div> \n\n<div style=\"position:absolute;left:3.05in;top:156pt;height:17pt;width:2.4in;font-weight:bold;font-size:10pt;background-color:#eee;padding:3pt;border-width:0.5pt 0.5pt 0 0.5pt;border-color:#888;\">\n  Bill to\n</div> \n<div style=\"position:absolute;left:3.05in;top:173pt;height:64pt;width:2.4in;font-size:10pt;padding:3pt;border-width:0.5pt 0.5pt 0.5pt 0.5pt;border-color:#888;\">\n    {{order.billToFormatted}}<br>\n</div> \n\n<div style=\"position:absolute;left:5.6in;top:156pt;height:17pt;width:2.4in;font-weight:bold;font-size:10pt;background-color:#eee;padding:3pt;border-width:0.5pt 0.5pt 0 0.5pt;border-color:#888;\">\n  Ship to\n</div> \n<div style=\"position:absolute;left:5.6in;top:173pt;height:64pt;width:2.4in;font-size:10pt;padding:3pt;border-width:0.5pt 0.5pt 0.5pt 0.5pt;border-color:#888;\">\n    {{order.shipToFormatted}}<br>\n</div> \n<br>\n<br>\n<br>\n<br>\n<br>\n<br>\n<br>\n<br>\n<br>\n<br>\n<br>\n<br>\n<br>\n<br>\n<br>\n<br>\n{{else}}\n<div style=\"position:absolute;left:0.5in;top:56pt;height:12pt;width:4in;font-size:10pt;font-weight:bold;text-align:left;line-height:1.2;\">\n  SALE NUMBER: {{orderOrderId}} <br>\n</div>\n{{/if}}\n\n{{#sectionEnd}}\n<div style=\"position:absolute;left:0in;top:-6pt;height:3pt;width:7.5in;border-width:.5pt 0 0 0;border-color:#000;\"></div>\n{{#if order.adjustmentListFormatted}}\n  <div style=\"position:absolute;left:4in;top:0in;width:3.5in;font-weight:bold;font-size:10pt;line-height:1.33;text-align:right;color:#000;\">\n    {{#each order.adjustmentListFormatted}}{{amountFormatted}}<br>{{/each}}\n  </div>\n  <div style=\"position:absolute;left:4in;top:0in;width:2.5in;font-weight:bold;font-size:10pt;line-height:1.33;text-align:right;color:#000;\">\n    {{#each order.adjustmentListFormatted}}{{description}}<br>{{/each}}\n  </div>\n{{/if}}\n{{/sectionEnd}}\n\n<br>\n<br>\n<div style=\"font-weight:bold;font-size:10pt;line-height:1;text-align:left;\">\nNOTES: \n </div>\n{{orderUserSaleUser10000}}\n<br>\n<br>\n<br>\n<br>"
    }
  }
}