Hi I am having trouble creating a search over advi...
# suitescript
d
Hi I am having trouble creating a search over advintercompanyjournalentry where i retrieve linesubsidiary and duetosubsidiary for each line. trying to add either I am getting this type of error,
Copy code
SSS_INVALID_SRCH_COL An nlobjSearchColumn contains an invalid column, or is not in proper syntax: duetofromsubsidiary.
my search options:
Copy code
{
  "type": "transaction",
  "filters": [
    {
      "name": "recordtype",
      "operator": "is",
      "values": "advintercompanyjournalentry"
    }
  ],
  "columns": [
    "account",
    "accounttype",
    "internalid",
    "amount",
    "currency",
    "class",
    "subsidiary",
    "trandate",
    "tranid",
    "trandate",
    "transactionnumber",
    "type",
    "lineuniquekey"
  ]
}