NetSuite Limitations

  1. When querying using joins, you must cite specific columns. For example, this query is not supported:
    select * from CUSTOMER_M
  2. Simultaneous connections to NetSuite are not supported because NetSuite allows only a single login for one account.
  3. You can only write Standard and Custom records.
  4. For both UPDATE and UPSERT queries, an UPSERT operation is performed.
  5. 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.