AvantGuard - Sage Intacct (Company Configuration)

Actions43

Location Groups Actions
- Update Company Config Location Group Key
- Create Company Config Location Group
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
Classes Actions
- Create Company Config Class
- Update Company Config Class Key
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
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
Earning Types Actions
- Create Objects Company Config Earning Type Key
- Patch 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
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

Overview

This node is designed to update a specific exchange rate line key within a company configuration in the Sage Intacct system via the AvantGuard API. It allows users to modify details such as the effective start date and the exchange rate value for a given exchange rate line. This functionality is useful in financial automation workflows where currency exchange rates need to be programmatically updated to reflect current or future values, ensuring accurate financial reporting and transaction processing.

Practical examples include:

Automatically updating exchange rates daily based on external currency data feeds.
Adjusting exchange rates for future periods as part of financial planning.
Integrating with ERP systems to keep currency conversion rates synchronized.

Properties

Name	Meaning
Additional Body Fields	Optional fields to include in the update request body. Available options:
	- Effective Start Date: The date from which the new exchange rate becomes effective.
	- Exchange Rate: The numeric value of the exchange rate to set for the specified line key.

Output

The node outputs JSON data representing the response from the AvantGuard Sage Intacct API after attempting to update the exchange rate line. This typically includes confirmation of the update, any updated resource details, or error information if the operation failed.

If binary data were involved (not indicated here), it would represent file contents or attachments related to the update, but this node focuses on JSON responses only.

Dependencies

Requires an API key credential for authenticating with the AvantGuard Sage Intacct API.
The base URL for the API must be configured in the node credentials.
The node depends on the @avantguardllc/n8n-openapi-node package for building request properties and handling API communication.
The OpenAPI specification (openapi.json) defines the available operations and parameters.

Troubleshooting

Authentication errors: Ensure that the API key credential is correctly configured and has sufficient permissions to update company configurations.
Invalid date or exchange rate format: Verify that the "Effective Start Date" is in a valid string format accepted by the API and that the "Exchange Rate" is a valid numeric string.
Network or API endpoint issues: Confirm that the base URL is correct and accessible from the n8n environment.
Missing required fields: Although additional fields are optional, the node may require certain identifiers (like the exchange rate line key) to be set elsewhere; ensure all necessary inputs are provided.
Error messages from API: Review the JSON output for error details returned by the API to guide corrective actions.

Links and References

AvantGuard Sage Intacct API Documentation (example placeholder link)
n8n Documentation on Creating Custom Nodes
OpenAPI Specification