NetSuite Limitations

  • When querying using joins, you must cite specific columns. For example, this query is not supported:
    select * from CUSTOMER_M
  • Simultaneous connections to NetSuite are not supported because NetSuite allows only a single login for one account.
  • You can only write Standard and Custom records.
  • For both UPDATE and UPSERT queries, an UPSERT operation is performed.
  • In the Write to DB stage, the maximum batch size permitted for an insert operation is 200 and the maximum batch size for an update operation is 100.