NetSuite REST icon

NetSuite REST

Call NetSuite SuiteTalk REST operations.

Actions979

Expense Report → Insert record

AI-generated

Summary

Creates a new NetSuite expense report record by POSTing the supplied data to the NetSuite SuiteTalk REST API.

Inputs

  • isDebugMode — If checked, the node returns the raw HTTP request and response in the output for debugging.
  • customFields — Key/value pairs for custom fields on the expense report; each custom field is defined by its NetSuite internal or external ID.
  • additionalFields — Supplementary expense‑report fields such as account, status, amount, dates and approval flags. Each sub‑field is optional unless required by NetSuite business rules.
  • expense — Array of expense line items; each item may include amount, category, class, department, date, memo, receipt flag, and other standard NetSuite fields.
  • status — The status of the report (e.g., A, B, C, etc.) using NetSuite status codes.
  • accountingapproval — Boolean indicating the report has managerial accounting approval.
  • supervisorapproval — Boolean indicating supervisor approval.
  • complete — Whether the report is marked complete and ready for submission.
  • transaction date fields — Fields like tranDate, duedate, createdDate, lastModifiedDate for setting the report dates.
  • currency fields — Fields such as expensereportcurrency, expensereportexchangerate, amount, total, nonreimbursable, reimbursable.
  • advance — Advance amount to apply to the report.
  • accountingBookDetail — Accounting book entries for the report.

Output shape

a single expense report record returned by NetSuite, including its internal ID and all fields echoed back by the API

If Debug Mode is enabled, the output additionally contains the full HTTP request and response objects.

Examples

Example 1: Insert a basic expense report with two line items

Set isDebugMode=false, provide mandatory expense lines (amount, category, date), optionally set tranDate and status. Node returns the created record ID.

Example 2: Create an expense report marked complete and approved

Provide customFields, set complete=true, accountingapproval=true, supervisorapproval=true, and list expenses. The node creates a report ready for submission.

Example 3: Insert an expense report with a custom record type field

Select CustomRecord type, add customFields entries, and supply expense lines. The report is created with custom field values stored.

Discussion