Actions43
- Earning Types Actions
- Email Templates Actions
- Employee Types Actions
- Employees Actions
- Entities Actions
- Classes Actions
- Contacts Actions
- Department Groups Actions
- Exchange Rate Lines Actions
- Exchange Rate Types Actions
- Exchange Rates Actions
- Attachment Folders Actions
- Get Next Value Actions
- Location Groups Actions
- Locations Actions
- Roles Actions
- User Groups Actions
- Users Actions
- Affiliate Entity Groups Actions
- Attachments Actions
- Departments Actions
- Document Sequences Actions
Overview
This node operation "Create Company Config Exchange Rate" under the "Exchange Rates" resource is designed to create a new exchange rate configuration for a company. It allows users to specify currency conversion details between two currencies along with the type of exchange rate and optional additional metadata.
Typical use cases include:
- Automating the setup of currency exchange rates in financial or accounting systems.
- Integrating with Sage Intacct or similar ERP systems to programmatically manage exchange rates.
- Maintaining up-to-date currency conversion configurations for multi-currency transactions.
For example, a user can create an exchange rate from USD to GBP with a specific exchange rate type and optionally provide detailed lines representing different effective dates and rates.
Properties
| Name | Meaning |
|---|---|
| From Currency | The transaction currency to convert from (e.g., "USD"). |
| To Currency | The transaction currency to convert to (e.g., "GBP"). |
| Exchange Rate Type | JSON object describing the exchange rate type, including key, id, name, and href URL endpoint. |
| Additional Body Fields | Optional collection of extra fields that can be added to the request body: |
| - Key | System-assigned key for the exchange rate. |
| - Id | Unique identifier for the exchange rate, typically same as key. |
| - Href | URL endpoint for the exchange rate. |
| - Lines | JSON array of exchange rate lines; each line includes keys, effective start date, rate, reciprocal rate, nested exchange rate info, and audit metadata. Each line represents a rate and its effective starting date. |
| - Audit | JSON object containing audit information such as created/modified timestamps and user IDs. |
Output
The node outputs JSON data representing the newly created company configuration exchange rate object as returned by the API. This will typically include all properties sent plus any additional metadata or identifiers assigned by the backend system.
There is no indication that this node outputs binary data.
Dependencies
- Requires an API key credential for authentication to the AvantGuard Sage Intacct Company Configuration API.
- The base URL for the API must be configured in the credentials.
- Uses JSON content-type headers and expects JSON responses.
- Depends on the external service provided by AvantGuard's Sage Intacct API endpoint
/ia/api/v1.
Troubleshooting
- Missing Required Fields: Ensure that "From Currency", "To Currency", and "Exchange Rate Type" are provided and correctly formatted JSON where applicable.
- Invalid JSON Format: The "Exchange Rate Type", "Lines", and "Audit" fields require valid JSON strings. Malformed JSON will cause errors.
- Authentication Errors: Verify that the API key credential is correctly set up and has permissions to create exchange rates.
- API Endpoint Issues: Confirm the base URL is correct and the API service is reachable.
- Data Validation Errors: The API may reject requests if currency codes or exchange rate types do not exist or are invalid.
Links and References
- Sage Intacct API Documentation
- AvantGuard Sage Intacct Integration
- n8n Documentation on Creating Custom Nodes