The lines are not according to sequence I set from Celigo after creation

Integrator.io
,
1

I am sending the below request to NetSuite from Celigo, but post creation the lines are not in the order as I want it to be. Any idea what to do here?

{
  "nlobjFieldIds": {
    "celigo_nlobjTransformId": 139308950,
    "orderstatus": "B",
    "class": 18,
    "location": 22,
    "entity": 49894516,
    "memo": "POS Transaction",
    "custbody_magenta_txn_id": "26020710130307220407220400019951",
    "custbody_magenta_txn_number": "07220400019951",
    "custbody_magenta_txn_total": -3,
    "custbody_magenta_txn_discount": -9,
    "custbody_magenta_txn_sales_person": "111195",
    "custbody_magenta_voidedinvoicenumber": "072203020589",
    "custbody_magenta_txn_invoicenumber": "072204018884",
    "custbody_magenta_customer_number": "0722032289",
    "custbody_magenta_return_reason": "CHANGE OF MIND",
    "custbody_return_reason": 29,
    "shipaddresslist": "",
    "billaddresslist": "",
    "custbody_pos_name": "Till 04",
    "custbody_erply_json": "{\"Notes\":\"POSTransaction\",\"Nuserid\":\"111195\",\"Ninvoiceid\":\"072204018884\",\"NsalesPersonCode\":\"111195\",\"NTransactionNumber\":\"07220400019951\",\"NTransactionId\":\"26020710130307220407220400019951\",\"NcustomerNumber\":\"0722032289\",\"NfileRows\":\"SH1:RC1:SM4:SL4:MD2:602:TN1:JN2:GE1\",\"Nbatch\":\"3f6344ca-a91a-4331-b8b7-4daf4f6d4499\"}",
    "celigo_replaceAllLines_item": "true"
  },
  "nlobjSublistIds": {
    "item": {
      "lines": [
        {
          "line": 1,
          "item": 696137,
          "isclosed": "false",
          "rate": 32.7,
          "amount": 32.7,
          "grossamt": 35.97,
          "location": 22,
          "quantity": 1,
          "price": -1,
          "custcol_txn_line_return_reason": "CHANGE OF MIND",
          "custcol_txn_line_return_reason_detail": "",
          "custcol_magenta_txn_linenumber": 1,
          "custcol_discount_name": "_OFFR",
          "custcol_discount_reason": 2001
        },
        {
          "line": 2,
          "item": 74885,
          "custcol_erply_original_item": 696137,
          "isclosed": "false",
          "rate": -4.09,
          "amount": -4.09,
          "grossamt": -4.5,
          "location": 22,
          "quantity": 1,
          "price": -1,
          "custcol_magenta_txn_linenumber": 2,
          "description": "KWH POS item discount",
          "custcol_discount_name": "_OFFR",
          "custcol_discount_reason": 2001
        },
        {
          "line": 3,
          "item": 249607,
          "isclosed": "false",
          "rate": 32.7,
          "amount": 32.7,
          "grossamt": 35.97,
          "location": 22,
          "quantity": 1,
          "price": -1,
          "custcol_txn_line_return_reason": "CHANGE OF MIND",
          "custcol_txn_line_return_reason_detail": "",
          "custcol_magenta_txn_linenumber": 3,
          "custcol_discount_name": "_OFFR",
          "custcol_discount_reason": 2001
        },
        {
          "line": 4,
          "item": 74885,
          "custcol_erply_original_item": 249607,
          "isclosed": "false",
          "rate": -4.09,
          "amount": -4.09,
          "grossamt": -4.5,
          "location": 22,
          "quantity": 1,
          "price": -1,
          "custcol_magenta_txn_linenumber": 4,
          "description": "KWH POS item discount",
          "custcol_discount_name": "_OFFR",
          "custcol_discount_reason": 2001
        }
      ]
    }
  }
}

image
image629×749 16.9 KB