Actions981
- Account Actions
- Accounting Period Actions
- Adv Intercompany Journal Entry Actions
- Assembly Build Actions
- Assembly Item Actions
- Assembly Unbuild Actions
- Billing Account Actions
- Billing Revenue Event Actions
- Billing Schedule Actions
- Bin Actions
- Bin Transfer Actions
- Blanket Purchase Order Actions
- Bom Actions
- Bom Revision Actions
- Calendar Event Actions
- Campaign Actions
- Campaign Response Actions
- Cash Refund Actions
- Cash Sale Actions
- Charge Actions
- Check Actions
- Classification Actions
- Commerce Category Actions
- Competitor Actions
- Consolidated Exchange Rate Actions
- Contact Actions
- Contact Category Actions
- Contact Role Actions
- Cost Category Actions
- Coupon Code Actions
- Credit Card Charge Actions
- Credit Card Refund Actions
- Credit Memo Actions
- Currency Actions
- Currency Rate Actions
- Customer Actions
- Customer Category Actions
- Customer Deposit Actions
- Customer Message Actions
- Customer Payment Actions
- Customer Refund Actions
- Customer Status Actions
- Customer Subsidiary Relationship Actions
- [Custom Record] Actions
- Department Actions
- Deposit Actions
- Deposit Application Actions
- Description Item Actions
- Discount Item Actions
- Download Item Actions
- Email Template Actions
- Employee Actions
- Estimate Actions
- Expense Category Actions
- Expense Report Actions
- Fair Value Price Actions
- Fulfillment Request Actions
- Gift Certificate Item Actions
- Inbound Shipment Actions
- Intercompany Journal Entry Actions
- Intercompany Transfer Order Actions
- Inventory Adjustment Actions
- Inventory Cost Revaluation Actions
- Inventory Count Actions
- Inventory Item Actions
- Inventory Number Actions
- Inventory Transfer Actions
- Invoice Actions
- Issue Actions
- Item Fulfillment Actions
- Item Group Actions
- Item Receipt Actions
- Item Revision Actions
- Job Actions
- Job Status Actions
- Job Type Actions
- Journal Entry Actions
- Kit Item Actions
- Location Actions
- Manufacturing Cost Template Actions
- Manufacturing Operation Task Actions
- Manufacturing Routing Actions
- Markup Item Actions
- Merchandise Hierarchy Level Actions
- Merchandise Hierarchy Node Actions
- Merchandise Hierarchy Version Actions
- Message Actions
- Nexus Actions
- Non Inventory Purchase Item Actions
- Non Inventory Resale Item Actions
- Non Inventory Sale Item Actions
- Note Type Actions
- Opportunity Actions
- Other Charge Purchase Item Actions
- Other Charge Resale Item Actions
- Other Charge Sale Item Actions
- Other Name Actions
- Other Name Category Actions
- Partner Actions
- Paycheck Actions
- Payment Item Actions
- Payment Method Actions
- Phone Call Actions
- Price Book Actions
- Price Level Actions
- Price Plan Actions
- Pricing Group Actions
- Project Task Actions
- Promotion Code Actions
- Purchase Contract Actions
- Purchase Order Actions
- Purchase Requisition Actions
- Resource Group Actions
- Return Authorization Actions
- Rev Rec Schedule Actions
- Rev Rec Template Actions
- Sales Order Actions
- Sales Role Actions
- Sales Tax Item Actions
- Service Purchase Item Actions
- Service Resale Item Actions
- Service Sale Item Actions
- Ship Item Actions
- Statistical Journal Entry Actions
- Subscription Actions
- Subscription Change Order Actions
- Subscription Line Actions
- Subscription Plan Actions
- Subscription Term Actions
- Subsidiary Actions
- Subtotal Item Actions
- [SuiteQL] Actions
- Support Case Actions
- Task Actions
- Tax Type Actions
- Term Actions
- Time Bill Actions
- Time Sheet Actions
- Topic Actions
- Transfer Order Actions
- Units Type Actions
- Usage Actions
- Vendor Actions
- Vendor Bill Actions
- Vendor Category Actions
- Vendor Credit Actions
- Vendor Payment Actions
- Vendor Prepayment Actions
- Vendor Prepayment Application Actions
- Vendor Return Authorization Actions
- Vendor Subsidiary Relationship Actions
- Web Site Actions
- Work Order Actions
- Work Order Close Actions
- Work Order Completion Actions
- Work Order Issue Actions
Consolidated Exchange Rate → Insert record
AI-generatedSummary
Create a new Consolidated Exchange Rate record.
Inputs
- isDebugMode — Whether to include full request and response info in the output
- authMethod — Authentication method to use for the request (OAuth1 or OAuth2)
- externalId — External identifier for the consolidated exchange rate record
- id — Internal identifier for the consolidated exchange rate record
- fromCurrency — Currency conversion from (select internal or external identifier)
- toCurrency — Currency conversion to (select internal or external identifier)
- fromSubsidiary — Subsidiary converting from (select internal or external identifier)
- toSubsidiary — Subsidiary converting to (select internal or external identifier)
- periodStartDate — Date on which the accounting period began
- postingPeriod — Posting period for the exchange rate (select internal or external identifier)
- averageRate — Average exchange rate calculated from weighted average of transactions for accounts with rate type Average; used for income statement and retained earnings
- currentRate — Current (ending) exchange rate effective at the end of the reported period; used for most asset and liability accounts in the balance sheet
- historicalRate — Historical exchange rate calculated from weighted average of transactions for accounts with rate type Historical; used for equity accounts and owner's investments in the balance sheet
- isDerived — If checked, the exchange rate is indirect (set between subsidiaries more than one hierarchical level removed); rates are system-set and cannot be edited or auto-calculated
- isEliminationSubsidiary — If checked, the subsidiary is an elimination subsidiary; rates for elimination subsidiaries cannot be edited
- isPeriodClosed — If checked, the accounting period is closed
- replace — Comma-delimited names of sublists on this record; all sublist lines will be replaced with lines specified in the request
- Prefer — Server behavior requested by the client; use 'respond-async' to execute the request asynchronously; if executed asynchronously, 'Preference-applied: respond-async' is returned in the response
- X-NetSuite-Idempotency-Key — User-defined unique idempotency key applied to every asynchronous request to ensure execution only once; use UUID in RFC 4122 string format; ignored for synchronous requests
- X-NetSuite-PropertyNameValidation — Sets strictness of property name validation (Error, Warning, or Ignore)
- X-NetSuite-PropertyValueValidation — Sets strictness of property value validation (Error, Warning, or Ignore)
- customFields — List of custom fields to add to the record; supports multiple values and various field types (boolean, dateTime, number, string, select, multiSelect)
Output shape
The operation inserts a new Consolidated Exchange Rate record into NetSuite. On success, the returned data typically includes the record's internal ID, external ID (if set), and other field values as confirmation of creation. Debug mode includes full request and response details when isDebugMode is enabled.
Authentication is configured per-node credentials; the authMethod parameter (OAuth1/OAuth2) selects the auth scheme. All parameters not explicitly set retain their NetSuite defaults. The Prefer header with value 'respond-async' enables asynchronous execution. The X-NetSuite-Idempotency-Key ensures unique execution for async requests.
Examples
Example 1: Create a consolidated exchange rate record with a current rate from USD to EUR for a specific subsidiary pair.
Set fromCurrency, toCurrency, fromSubsidiary, toSubsidiary, currentRate, and periodStartDate. Leave isDebugMode at default false. Use default authMethod (OAuth1).