AvantGuard - Sage Intacct (Company Configuration)

Actions43

Earning Types Actions
- Patch Objects Company Config Earning Type Key
- Create Objects Company Config Earning Type Key
Email Templates Actions
- Create Company Config Email Template
- Update Company Config Email Template Key
Employee Types Actions
- Create Company Config Employee Type
- Update Company Config Employee Type Key
Employees Actions
- Create Company Config Employee
- Update Company Config Employee Key
Entities Actions
- Create Company Config Entity
- Update Company Config Entity Key
Classes Actions
- Update Company Config Class Key
- Create Company Config Class
Contacts Actions
- Create Company Config Contact
- Update Company Config Contact Key
Department Groups Actions
- Create Company Config Department Group
- Update Company Config Department Group Key
Exchange Rate Lines Actions
- Create Company Config Exchange Rate Line
- Update Company Config Exchange Rate Line Key
Exchange Rate Types Actions
- Create Company Config Exchange Rate Type
- Update Company Config Exchange Rate Type Key
Exchange Rates Actions
- Create Company Config Exchange Rate
- Update Company Config Exchange Rate Key
Attachment Folders Actions
- Create Company Config Folder
- Update Company Config Folder Key
Get Next Value Actions
- Get Next Sequence Value
Location Groups Actions
- Create Company Config Location Group
- Update Company Config Location Group Key
Locations Actions
- Create Company Config Location
- Update Company Config Location Key
Roles Actions
- Create Company Config Role
- Update Company Config Role Key
User Groups Actions
- Create Company Config User Group
- Update Company Config User Group Key
Users Actions
- Create Company Config User
- Update Company Config User Key
Affiliate Entity Groups Actions
- Create Company Config Affiliate Entity Group
- Update Company Config Affiliate Entity Group Key
Attachments Actions
- Create Company Config Attachment
- Update Company Config Attachment Key
Departments Actions
- Create Company Config Department
- Update Company Config Department Key
Document Sequences Actions
- Create Company Config Document Sequence
- Update Company Config Document Sequence Key

Overview

This node operation creates a new exchange rate line within a company configuration system. An exchange rate line defines the conversion rate between currencies effective from a specific start date, and it belongs to a particular exchange rate entity.

Typical use cases include:

Automating the setup of currency conversion rates in financial or accounting software.
Managing multiple exchange rates with different effective dates for accurate historical or future currency conversions.
Integrating with external systems that require up-to-date exchange rate configurations.

For example, a finance team could use this node to programmatically add a new exchange rate line effective from January 31, 2021, with a specified conversion rate, ensuring their accounting system reflects current currency values.

Properties

Name	Meaning
Effective Start Date	The date when the exchange rate becomes effective. This determines from which date the specified conversion rate applies.
Rate	The conversion rate to apply starting from the effective start date. For example, if converting USD to EUR, this might be 0.85.
Exchange Rate	A JSON reference object pointing to the parent exchange rate entity that this line belongs to. It includes keys like `key`, `id`, and `href` identifying the exchange rate.
Additional Body Fields	Optional additional fields to include in the request body. These can include: - Key: Unique system-assigned key for the exchange rate line. - Id: Unique identifier, same as key. - Href: URL endpoint for the exchange rate line. - Reciprocal Rate: The inverse of the conversion rate (e.g., if rate converts USD to EUR, reciprocalRate converts EUR to USD). - Audit: JSON object containing audit information such as creation and modification timestamps and user IDs.

Output

The node outputs JSON data representing the created exchange rate line object. This typically includes all properties sent in the request along with any additional metadata returned by the API, such as unique identifiers or confirmation details.

If the node supports binary data output, it is not indicated here; thus, the output is primarily structured JSON reflecting the newly created exchange rate line.

Dependencies

Requires an API key credential for authenticating requests to the AvantGuard Sage Intacct Company Configuration API.
The base URL for the API must be configured in the node credentials.
The node uses HTTP headers specifying JSON content type and expects JSON responses.
The node depends on the @avantguardllc/n8n-openapi-node package and an OpenAPI specification (openapi.json) bundled with the node for request building and validation.

Troubleshooting

Invalid or missing required fields: Ensure that Effective Start Date, Rate, and Exchange Rate are provided and correctly formatted. Dates should be ISO strings, and the exchange rate reference must be valid JSON.
Authentication errors: Verify that the API key credential is correctly set up and has sufficient permissions.
API endpoint issues: Confirm the base URL is correct and accessible from your environment.
JSON parsing errors: When providing JSON input for Exchange Rate or Audit, ensure the JSON is well-formed.
Reciprocal Rate mismatch: If using reciprocalRate, verify it correctly represents the inverse of rate to avoid inconsistent currency conversions.

Links and References

AvantGuard Sage Intacct API Documentation (hypothetical link, replace with actual if available)
n8n Documentation on Creating Custom Nodes
OpenAPI Specification