All integrationsAccounting & Finance

Oracle NetSuite

Run NetSuite from your workflows: add and update customers, contacts and vendors, create sales orders, invoices, vendor bills and journal entries, bill orders and record payments, find records or run SuiteQL queries, and start workflows when customers, sales orders or invoices are added or changed.

actions
24
triggers
4

Triggers

Start a workflow when something happens in Oracle NetSuite.

  • New customerRuns when a customer, lead or prospect is added to Oracle NetSuite.
  • New sales orderRuns when a sales order is created in Oracle NetSuite.
  • New invoiceRuns when an invoice is created in Oracle NetSuite.
  • Sales order created or changedRuns when a sales order is created or changed in Oracle NetSuite, such as when it is approved, fulfilled or billed.

Actions

Steps a workflow can run in Oracle NetSuite.

  • Create customerAdd a customer, a company or a person, with their email, phone, subsidiary, currency and payment terms.
  • Get customerGet one customer with their contact details, terms and balance.
  • Update customerChange a customer's name, email, phone, terms or comments, or make them inactive. Only the fields given change.
  • Find customersFind customers by name, company or email, newest first. Returns one page; pass 'next_offset' as Skip for more.
  • Create contactAdd a contact person, optionally linked to the customer or vendor they work for.
  • Find contactsFind contacts by name or email, or a company's contacts, newest first.
  • Create vendorAdd a vendor (supplier), a company or a person, with their email, phone, subsidiary, currency and payment terms.
  • Find vendorsFind vendors by name, company or email, newest first.
  • Find itemsFind the products and services you sell or buy, by name or description, optionally of one type.
  • Create sales orderCreate a sales order for a customer with one or more item lines, approved or pending approval.
  • Get sales orderGet one sales order with its status, totals and lines.
  • Find sales ordersFind sales orders by customer, status and date, newest first.
  • Bill sales orderCreate the invoice for a sales order from its lines, as Bill does in NetSuite. The order must be ready to bill.
  • Create invoiceCreate an invoice for a customer with one or more item lines.
  • Get invoiceGet one invoice with its status, lines, total and the amount still due.
  • Find invoicesFind invoices by customer, status and date, newest first, with what is still due on each.
  • Record invoice paymentRecord a customer's payment of an invoice, in full or in part, as Accept Payment does in NetSuite.
  • Create vendor billEnter a bill from a vendor with one or more expense lines, ready to approve and pay.
  • Create journal entryPost a journal entry: an amount from one account to another, or several lines that balance.
  • Get recordGet any record, such as an estimate, purchase order or custom record, by its type and internal ID, with its lines.
  • Create recordCreate any kind of record from its fields, named as NetSuite's REST API names them, such as a task, estimate or custom record.
  • Update recordChange fields on any kind of record. Only the fields given change.
  • Delete recordDelete any record by its type and internal ID. This can't be undone, and NetSuite refuses when other records depend on it.
  • Run SuiteQL queryRun a SuiteQL query, NetSuite's SQL, and get one page of its rows. Use ? in the query for each of the values given, in order.

Automate Oracle NetSuite with Lodol.

Connect Oracle NetSuite and ask your AI for your first workflow.

Free plan, no credit card