netsuite_create_expense_report
Create employee expense reports in NetSuite with line items for expense categories, amounts, currencies, and memos. Includes dry-run mode to preview the API request before submission.
Instructions
Create a new NetSuite expense report for an employee with expense lines. Required: employee, subsidiary, tranDate; per line: category (NS expense category ID), amount; multi-currency: currency. Optional: memo, externalId, expenseList.expense[].expenseDate, department, etc.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| memo | No | ||
| dryRun | No | If true, return the NS request body without calling NS (debug mode) | |
| currency | No | NS currency ID (1=EUR, 2=USD, 3=GBP). Default: '1' (EUR) | |
| employee | Yes | Employee internal ID | |
| tranDate | Yes | Date YYYY-MM-DD | |
| externalId | No | Idempotency key | |
| subsidiary | Yes | Subsidiary internal ID | |
| expenseList | No | Expense lines: { expense: [{ expenseDate, category, amount, memo, currency, department }] } | |
| expenseListFormat | No | Debug: A=array, B=expense.items, C=expenseList.items, D=expense.items like vendor bills (default). Use with dryRun to test. |